Server_Backup
I just got my server up and running but Im not sure how to back it up. It was hard to get it up and running took about 3 hours and been trying to years now that its working I want to make sure I can get it back. I may make a image of my whole computer for a main backup but what about my chars I cant make an image daily. What should I do?
|
|
Go Run -> Command
Go to C:\mysql\bin Type: mysqldump databasename > something.sql And if you just want to dump a certain table within your database (lets say the characters table), type: mysqldump databasename characters > something.sql |
If you are using MySQL 5.0 or greater you can use the admin tool off the MySQL site to back up your database. It supports timed backups and such and its useful for managing stuff.
MySQL Admin Tool for 5.x This is the tool I use personally. :) I also use the query browser utility there too they all work nicely. MySQL Query Browser for 5.x |
All times are GMT -4. The time now is 08:39 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.