Managing Databases with Command Line SSH
Posted by on 12 February 2019 11:36 AM
Using SSH can be a superior way to manage the files and databases on your account. Using a simple command you can import or export a MySQL database into an existing database on your account.
Please note that in the examples below the -p will prompt for your account's password. And that your database name needs to include your username, e.g. examplec_database.
Exporting MySQL Data
This example shows you how to export a database. It is a good idea to export your data often as a backup.
The file dbname.sql now holds a backup of your database and is ready for download to your computer.
To export a single table from your database you would use the following command:
Again you would need to replace the username, database and tableName with the correct information.
Once done the table specified would then be saved to your account as tableName.sql
Import A MySQL Database
The file must be in .sql format. It cannot be compressed in a .zip or .tar.gz file.
To import a single table into an existing database you would use the following command: