Child pages
  • Importing Large MySQL Databases In SSH
Skip to end of metadata
Go to start of metadata

If you have a large database dump ( .sql ) that you cannot upload through phpMyAdmin due to it’s size, the alternative is to upload it to your ftp root and use the command line to import it. You can request SSH access for your domains in the Reseller Support Queue here:

support.uk2.net.

Before importing the database, make sure you have created it in CPanel and assigned the user all privileges. The command to import the database is:

 mysql -u user_name -p database_name < dump_file.sql 

After you hit the Enter key, you will be asked for the user’s password. Type this in and press Enter again, the database will be imported. You can go in to phpMyAdmin to check it has been imported correctly.