Guest User

Untitled

a guest
Jun 28th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. mysqldump -u username -p databasename > dumpfile.sql
  2.  
  3. mysql -u username -p databasename < dumpfile.sql
  4.  
  5. mysqldump --opt --compress --user=username database | mysql --user=username2 --password=p2 --host=hostB -D database -C database
  6.  
  7. mysqldump -u username -p --all-databases > c:alldbs.sql
Add Comment
Please, Sign In to add comment