Creation of database

In Mysql Prompt > create database <databasename>;

 Drop Dtabase>

Im mysql prompt > Drop database <database name>;

Dump ALL MySQL Databases:

mysqldump –user=XXXXXXXX –password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL

Dump Individual or Multiple MySQL Databases:

mysqldump –user=XXXXXXXX –password=XXXXXXX –databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL

Database dump and restore

mysqldump -u admin -p`cat /etc/psa/.psa.shadow` <database name> > <file name.sql>

mysql -u admin -p`cat /etc/psa/.psa.shadow` database name < dump file

—-

mysql backup:

var/lib/mysql#mysqldump abc > abc.sql

mysql restore:

var/lib/mysql#mysql abc < abc.sql