Move mysql database tables to another database.

Move mysql database tables to another database.

Back up your mysql database using SSH (to dumb a database)
 
use this command:

mysqldump -u username -p dbname >filename.sql

then the console will ask for password and enter the db password.
The sql file will generate and save into the current folder.
please check your folder whether the sql file generated or not using 'ls' command

load mysql to a database from a sql file

use this command:

mysql -u username -p dbname < filename.sql

then the console will ask for password and enter the db password.
the sql instructions from the sql file will loaded and generated in the database.
please check the database whether the sql is loaded or not.


enjoy mysql querying.........