how to backup .sql dump to mysql database
How to backup mysql database
Backup dbname to dbname_backup.sql
joec@ubuntu~:$ mysqldump -u root -p dbname > /home/joec/dbname_backup.sql
先開一個新的Database
joec@ubuntu~:$ mysql -u root -p
mysql> create database dbname;
mysql> quit
Bye
joec@ubuntu~:$ ls
db_backup.sql
joec@ubuntu~:$ mysql -u root -p -h 192.168.1.8 dbname < db_backup.sql
沒有留言:
張貼留言