Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqldump --skip-opt --single-transaction --user=root --password=xxx --all-databases > "/root/drupal/mysqldump-all-databases-2010-04-27.txt"
- mysqldump --skip-opt --single-transaction --user=root --password=xxx --databases drupaldb01 > "/root/drupal/mysqldump-database-drupaldb01-2010-04-27.txt"
- mysqladmin --user=root --password=xxx drop drupaldb01 --force
- mysqladmin --user=root --password=xxx create drupaldb01
- mysql --user=root --password=xxx < /root/drupal/mysqldump-all-databases-2010-04-27.txt
- or
- mysql --user=root --password=xxx drupaldb01 < /root/drupal/mysqldump-database-drupaldb01-2010-04-27.txt
- # mysql --user=root --password=xx < /root/drupal/mysqldump-all-databases-2010-04-27.txt
- ERROR 1050 (42S01) at line 12443: Table 'columns_priv' already exists
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement