zappy244
12-31-2007, 05:10 PM
Database backup is an extremely valuable thing. It saves you time and aggravation plus promises for maximum server uptime!
You see every time you update your database you run that possibility chance of an error through the roof! Every so often it will happen to your server and it will get loads of errors as some as you already know. Only ways of fixing this if you have no backups is to MANUALLY DELETE IT ALL, or Trash your current database and reload the original witch means anything custom you added is out the window!
So lets get started!
1: Open up Navicat to your data base:
http://i243.photobucket.com/albums/ff167/dman244/test-1.jpg
2: Right click your database you want to backup and chose dump SQL file.
Don't worry this WON'T delete the database
I chose my ascent database
http://i243.photobucket.com/albums/ff167/dman244/done.jpg
3: Now chose a place you want to save the file and click save.
I picked my desktop, but I recommend you chose a separate folder for only backups
http://i243.photobucket.com/albums/ff167/dman244/test3.jpg
4: Now once you click save Navicat will start to save the database and once it is done click closehttp://i243.photobucket.com/albums/ff167/dman244/test4.jpg
Your done you successfully backed up your database!
To use this data base you simply drop the database that needs to be downgraded and then make the database WITH THE EXACT SAME NAME and execute the backed up SQL file!
5: Optional-name the backup <(your databases name) (date)> This is to simply help you to be more organized
http://i243.photobucket.com/albums/ff167/dman244/test5.jpg
Ps: if done correctly you can see the sizes of the backup databases to grow larger
You see every time you update your database you run that possibility chance of an error through the roof! Every so often it will happen to your server and it will get loads of errors as some as you already know. Only ways of fixing this if you have no backups is to MANUALLY DELETE IT ALL, or Trash your current database and reload the original witch means anything custom you added is out the window!
So lets get started!
1: Open up Navicat to your data base:
http://i243.photobucket.com/albums/ff167/dman244/test-1.jpg
2: Right click your database you want to backup and chose dump SQL file.
Don't worry this WON'T delete the database
I chose my ascent database
http://i243.photobucket.com/albums/ff167/dman244/done.jpg
3: Now chose a place you want to save the file and click save.
I picked my desktop, but I recommend you chose a separate folder for only backups
http://i243.photobucket.com/albums/ff167/dman244/test3.jpg
4: Now once you click save Navicat will start to save the database and once it is done click closehttp://i243.photobucket.com/albums/ff167/dman244/test4.jpg
Your done you successfully backed up your database!
To use this data base you simply drop the database that needs to be downgraded and then make the database WITH THE EXACT SAME NAME and execute the backed up SQL file!
5: Optional-name the backup <(your databases name) (date)> This is to simply help you to be more organized
http://i243.photobucket.com/albums/ff167/dman244/test5.jpg
Ps: if done correctly you can see the sizes of the backup databases to grow larger