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.
Threaded Mode
