How to Export a Database in SiteGround

Exporting via phpMyAdmin

To export your database using phpMyAdmin, navigate to Site Tools > Site > MySQL > phpMyAdmin. Select your database from the left panel and click on 'Export'. Choose between the 'Quick' or 'Custom' export methods. Select your desired backup format and click 'Go'. Save the dump file to your local computer for backup purposes.

Exporting via SSH for Large Databases

For databases exceeding 50MB, the SSH method is recommended. This method prevents timeouts and potential corruption of the backup file. Utilize an SSH connection to safely export larger databases without the risk of interruption.

Uploading and Importing Database Backup

After exporting your database, upload the backup to your SiteGround account. Place the file outside the public_html folder for security. To import, go to Site Tools > Site > MySQL tool, select the intended database, and click on 'Import Database Dump' from the kebab menu. Click 'Browse' to select your backup file and 'Import' to commence the database restoration process.

Frequently Asked Questions

How can I export a MySQL database from my SiteGround account?

You can export a MySQL database from your SiteGround account using the phpMyAdmin tool. Navigate to Site Tools > Site > MySQL > phpMyAdmin, select the database, and click on Export. Choose the Quick or Custom method, select the desired format, and click Go to export the database.

Is there an alternative method to export my database if it's larger than 50MB?

Yes, for databases larger than 50MB, it is recommended to use an SSH connection to export your database since this method avoids a time out during the export, which could result in a corrupted backup file.

How often does SiteGround automatically back up my database?

SiteGround automatically backs up your files and database every 24 hours.

Where should I upload my database backup copy on my SiteGround account?

Upload the database backup copy on your account and place the backup file outside the public_html folder to prevent access from a browser.

How can I restore a database backup on my SiteGround account?

To restore a database backup, click the kebab menu and select Import Database Dump. Use the Choose file button to select the backup file and click Import to import the backup.

Common Use Cases

• 
  Migrate a website to a new hosting provider
• 
  Create a backup of a website’s data for security purposes
• 
  Analyze website data offline or in a different environment
• 
  Synchronize a local development environment with the live site
• 
  Restore a previous version of the website in case of data loss or corruption

Sourcetable: A Streamlined Alternative to SiteGround Database Export

Seeking a more efficient way to handle your database information? Sourcetable provides a dynamic solution for real-time data management. Unlike the manual export process in SiteGround, Sourcetable streamlines data aggregation, offering a singular, spreadsheet-like platform for immediate querying and manipulation.

With Sourcetable, the complexities of traditional database handling are simplified. No more waiting for exports; access your data live, and utilize familiar spreadsheet operations to organize and analyze. This seamless interface reduces the need for specialized database knowledge, making it accessible for users of all skill levels.

Integrating multiple data sources becomes effortless with Sourcetable. It replaces the need for cumbersome export procedures from SiteGround, enhancing productivity by saving time and minimizing the potential for errors. Embrace the power of real-time data manipulation with Sourcetable, and transform the way you interact with your databases.