Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tut]How to Back up your Database

Junior Spellweaver
Joined
Jun 30, 2008
Messages
132
Reaction score
0
I know this was released, but I was bored so I'm releasing this now.
1.Go to Program Files
2.Search for MySQL
3.Open it and open MySQL
4.Then Open bin
5.Open MySQLInstanceConfig
6.Check Include Bin Directory
7.Once you executed open your notepad
8.Write mysqldump -u root -p databaseID>mybakup.sql
9.close it and save it as backup.bat
10.Once you have done that click on backup.bat.
11.Wait till the bat file goes away and there you got your backup.
Credit:
To me and my freind Chaos
 
Newbie Spellweaver
Joined
Jul 29, 2008
Messages
23
Reaction score
0
Re: [Guide]How to Back up your Database

and how do you load that back up?
 
Newbie Spellweaver
Joined
Apr 4, 2008
Messages
27
Reaction score
0
Re: [Guide]How to Back up your Database

lol well you can all ways use the MYSQL administrator tool to back it up.

much easier.
 
Junior Spellweaver
Joined
Jun 30, 2008
Messages
132
Reaction score
0
Re: [Guide]How to Back up your Database

lol well you can all ways use the MYSQL administrator tool to back it up.

much easier.

I think this way is easier because once you have done this and needa backup again all you have to do it press backup.bat
 
Junior Spellweaver
Joined
May 20, 2008
Messages
153
Reaction score
0
Re: [Guide]How to Back up your Database

Cool I'm gonna go make one right now :)
 
Newbie Spellweaver
Joined
Apr 4, 2008
Messages
27
Reaction score
0
Re: [Guide]How to Back up your Database

I think this way is easier because once you have done this and needa backup again all you have to do it press backup.bat


o really? i though u had to do this every time to back it up . sorry i misunderstood im going to test it out then. thx
 
Junior Spellweaver
Joined
Apr 23, 2008
Messages
161
Reaction score
0
Re: [Guide]How to Back up your Database

There much ways to backup i think..
Copying Tables
Dumping/Exporting The Database To SQL File..
Anyway nice guide
 
Junior Spellweaver
Joined
Apr 18, 2008
Messages
109
Reaction score
0
Re: [Guide]How to Back up your Database

how do you autobackup say every 3 days?
 
Junior Spellweaver
Joined
May 20, 2008
Messages
153
Reaction score
0
Re: [Guide]How to Back up your Database

Okay so that automatically makes a backup every 3 days?
 
Junior Spellweaver
Joined
May 22, 2008
Messages
118
Reaction score
0
Re: [Guide]How to Back up your Database

Thx Much Easier then how i used to do it
 
Legendary Battlemage
Loyal Member
Joined
Dec 7, 2007
Messages
622
Reaction score
11
Re: [Guide]How to Back up your Database

i use navicat to back up lols =P
 
Junior Spellweaver
Joined
Jun 30, 2008
Messages
132
Reaction score
0
Re: [Guide]How to Back up your Database

Once you set this uo all you have to do next is click on backup.bat and ait till the .bat file goes away then there you got our backup file very simple
 
Newbie Spellweaver
Joined
Jul 25, 2008
Messages
26
Reaction score
0
Re: [Guide]How to Back up your Database

how do i change pack with out wipe? like i want to create a new database ,how do i back up the acc and items ?'
oh yeah , if ppl got my back up file , can they do the host? can we have two hoster? diffrent computer
 
Newbie Spellweaver
Joined
Apr 24, 2008
Messages
93
Reaction score
0
Re: [Guide]How to Back up your Database

can i other user MySql database?
 
Junior Spellweaver
Joined
Jun 30, 2008
Messages
132
Reaction score
0
Re: [Guide]How to Back up your Database

how do i change pack with out wipe? like i want to create a new database ,how do i back up the acc and items ?'
oh yeah , if ppl got my back up file , can they do the host? can we have two hoster? diffrent computer

When you backup it backs up everything like account item character etc. Once you bak up just gib your hoster the sql file you get from the backup.bat.
 
Back
Top