Friday, January 14, 2011

How to backup and restore database in mysql

Backup and restore database from mysql:
From Dos Command Prompt(First Go Inside-C:\Program Files\MySQL\MySQL Server 5.0\bin)
Then Fire command as like--
mysqldump -u root -psa1234 databasename > c:/databasename.sql

REstore:
mysql -u [uname] -p[pass] [db_to_restore] < c:/databasename.sql
mysql -u root -pSa1234 -D photochat < c:/photochat.sql