Friday, March 26, 2010

Backup/Restore db using MySQL

Type on your command prompt (windows) or terminal (linux)

To Backup : mysqldump -v -uroot -ppassword -hlocalhost db_user > "db_user.sql"

To Restore : mysql -v -uroot -ppassword -Ddb_user < "db_user.sql"

No comments:

Post a Comment