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)
Subscribe to:
Post Comments (Atom)
u shud b startin wid basic cmnds like "mkdir" rather than cmnds 4 takin backups of mysql ... ;)
ReplyDelete