View Single Post
  #3  
Old 04-24-2014, 09:35 PM
Esildor
Hill Giant
 
Join Date: Feb 2010
Posts: 207
Default

OP,

In Navicat there is a 'backups' option when you open up your database. I have used this to revert to an earlier dump. Super easy, just click restore from backup then choose the backup file.

Another option:

open a command prompt somewhere, perhaps a 'backups' folder then type:

Code:
mysqldump -u root -ppassword peq > backup.sql
So, personally, on my C drive I have a folder called 'SQLDumps' this is where I dump my database files on backup. I navigate there, and then shift right click and select 'open command window here' then type the above.

'root' is your db username, and -ppassword is your password, so if your password is puppies put -ppuppies

You can then use that sqldump to backup your database as well.
Reply With Quote