Sunday, November 13, 2011

How to restore or backup database mysql by cmd (command)


Restore
mysql -u user_name -p your_password database_name < file_name.sql
 gzip -dc <database.sql.gz |mysql -u root -p databasename

Backup
mysqldump -u user_name -p your_password databasename > file_name.sql
mysqldump -u user_name -p databasename | gzip > database.sql.gz

Nguyen Si Nhan

No comments:

Post a Comment

Thanks for your join,we will be reply to you asap.