mysql dump

>mysql -u root -p password

How to backup MySQL database? - using mysqldump -


>mysqldump -u [user] -p [database_name] > [backupfile].dump



dump restore

>mysql [database_name] < [backup_file].dump


drop the schema

>mysqladmin -u root -p drop schema_name


> mv rt3newdump.sql /home/karthik/temp
>mysqladmin -u root -p create rt3
>mysql -u root -p rt3 < rt3newdump.sql


How do I quickly rename a mysql database (change schema name)?

mysqldump -u username -p -v olddatabase > olddbdump.sql
mysqladmin -u username -p create newdatabase
mysql -u username -p newdatabase < olddbdump.sql