Thread: SQL for beginners! How do you backup and restore a db?
View Single Post
  #5  
Old 01-04-2010, 06:52 PM
Secrets's Avatar
Secrets
Demi-God
  
Join Date: May 2007
Location: b
Posts: 1,449
Default
Something else to note is the --opt flag in MySQL. It makes sourcing a lot faster with MySQLDump as it does more than one entry per line, amongst other things.

Code:
mysqldump -u root -p ykesha --opt
Reply With Quote