Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel) do not have phpMyAdmin installed. To manage databases without a control panel, you need to use the SSH command line to import .SQL backup files.
- Connect to your server or shared hosting account with SSH
- Locate your database information:
- Find your database hostname
- Now that you have your database hostname you can get your database name, username, and password by viewing your database details (cPanel / Web Hosting)
- Connect to MySQL using the following command:
mysqldump -p -h hostname -u username database > dbname.sql- Enter the database information for your database:
-p : Password
-h : Hostname
-u : Username
database : Database name
dbname.sql : Name you want for the backup file
- Enter the database information for your database:
- When you see Enter password:, enter your password for that MySQL user
- Your database is now exported to the file dbname.sql and is ready for your to download to your local computer