Advertisement
Guest User

Untitled

a guest
May 22nd, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. mysqldump --skip-opt --single-transaction --user=root --password=xxx --all-databases > "/root/drupal/mysqldump-all-databases-2010-04-27.txt"
  2. mysqldump --skip-opt --single-transaction --user=root --password=xxx --databases drupaldb01 > "/root/drupal/mysqldump-database-drupaldb01-2010-04-27.txt"
  3.  
  4. mysqladmin --user=root --password=xxx drop drupaldb01 --force
  5. mysqladmin --user=root --password=xxx create drupaldb01
  6.  
  7. mysql --user=root --password=xxx < /root/drupal/mysqldump-all-databases-2010-04-27.txt
  8. or
  9. mysql --user=root --password=xxx drupaldb01 < /root/drupal/mysqldump-database-drupaldb01-2010-04-27.txt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement