How to manually import or export a MySQL database via command line (Plesk - Linux)
Exporting
If you use the Plesk control panel and are having issue exporting via PHPMyADMIN (Due to errors or too large a SQL file) then you can do the following to export the database
1. Log in to the server via SSH
2. Type the following:
- mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` NAME_OF_DB > NAME_OF_DB.sql
This will output the database to a file named NAME_OF_DB.sql
You can also output this to a websites root folder by changing the NAME_OF_DB.sql to /var/www/vhosts/example.co.uk/NAME_OF_DB.sql
Once done, the database will be backed up to the specified SQL file.
Importing
Once you have a SQL file you can import it using the following steps:
1. Log into the server via SSH
2. Type the following:
- mysql -uadmin -p`cat /etc/psa/.psa.shadow` NAME_OF_DB < /path/to/NAME_OF_DB.sql
Please note that the database must have already been created via Plesk and must be empty for this to work.
1. Log in to the server via SSH
2. Type the following:
- mysql -uadmin -p`cat /etc/psa/.psa.shadow` NAME_OF_DB > NAME_OF_DB.sql
