SQL for beginners! How do you backup and restore a db?

[eski2]

Thanks very much, I'll give it a go!

[trevius]

Also, if you use Navicat for managing your database, you can just right click on the database and select the "Dump to SQL" option. Then, chose a name to save it as and run it. That will back the DB up just like the command prompt way that Derision described.

Then, to restore your database, you can just right click on the database in Navicat and select the "Run Batch File" option (not sure if that is the exact name of the option, but it is something like that). Then, select the backup you wish to restore to and run it.

[Secrets]

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.

mysqldump -u root -p ykesha --opt

[Rogean]

http://lmgtfy.com/?q=mysqldump