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 Cartika MySQL username, e.g. examplec_database.
mysqldump -p -u username database_name > dbname.sql
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.
mysqldump -p --user=username database_name tableName > tableName.sql
Once done the table specified would then be saved to your account as tableName.sql
mysql -p -u username database_name < file.sql
To import a single table into an existing database you would use the following command:
mysql -u username -p -D database_name < tableName.sql