Friday, August 14, 2009

Mysql Backup Commands

Taking Mysql Backup
With Field Value :
mysqldump -u root -p dbname >sqltextfilename.sql
Without Value :
mysqldump -u root - p --no-data dbname >sqltextfilename.sql
Restoring The sql file
mysql -u root -p dbname < sqltextfilename.sql
Note:
* The Database Name should be Excisting
* give the Correct poth (sqltextfilename.sql)