Originally Posted by
stoneharry
Using SQLyog you can right click on the database, export as SQL dump. This will backup the database into a .sql file. You can do it in navicat I believe but it's slower and I don't know how.
No, it means to shutdown your MySQL server (a temporary solution if you don't know how is to go into task manager, procceses and find mysql.exe or mysqld.exe).
Once you have done that you can start up the one I provide and right click -> create database, name, right click on new database -> restore from sql dump -> target the .sql file and bring all your stuff back in.
The reason I tell you to use mine is that it is already configured to allow any size file.