Quote:
Originally Posted by Huppy
Hey Zandig, I tried out that SQLyog and it works a hell of lot better, lol.
I backed up the db with it and sourced it in on another puter, just to
see how it would go and its awesome. Even the backup sql is a normal
size (148 mb) compared to the 324 mb that Navicat produced.
I even sourced the backup in using dos, or cmd as we call it now,
through mysql. only took 3 minutes. Thanks again for the info 
|
mysqldump -uusername -ppassword databasename
Will dump it into the directory in which you run the command from in prompt. Or you could run it this way
mysqldump -uusername -ppassword databasename > "c:\Directory\To\Dump\to\database.sql"