wipersonal

Backup và Restore Database MYSQL dùng mysqldump + gzip cho d

Jul 4th, 2017
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. Backup và Restore Database MYSQL dùng mysqldump + gzip cho database lớn
  2.  
  3. // Backup
  4. mysqldump -u root -p databasename | gzip > databasename.sql.gz
  5.  
  6. // Restore
  7. zcat databasename.sql.gz | mysql -u root -p databasename
Add Comment
Please, Sign In to add comment