Knowledgebase

Exporting produces a .sql file containing your entire database. Importing loads one back in.

EXPORTING

1. cPanel > phpMyAdmin.
2. Select the database in the left column.
3. Click the Export tab.
4. Leave the method as Quick and the format as SQL.
5. Click Go, and the file downloads.

For a large database, choose Custom and set Compression to gzip. This produces a much smaller file and is more likely to complete.

IMPORTING

1. Create an empty database and user first if you do not already have one.
2. Select the database in phpMyAdmin.
3. If the database already has tables from an old install, tick them all and choose Drop first, otherwise the import will collide with existing data.
4. Click the Import tab.
5. Choose the .sql or .sql.gz file and click Go.

IF THE IMPORT FAILS OR TIMES OUT

Large files frequently exceed the upload limit. Upload the .sql file to your home directory with File Manager and open a ticket asking us to import it from the command line, which has no such limit. Check the file is a database export and not a full cPanel backup archive.