[Tut]How to Back up your Database

[lols1996]

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

 

[gtxx911]

Re: [Guide]How to Back up your Database

Nice i guess

omg theres a boobie section

yes there is

i go on that section everyday

 

[Xulube]

Re: [Guide]How to Back up your Database

and how do you load that back up?

 

[xjimmy94]

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.

 

[lols1996]

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

 

[lols1996]

Re: [Guide]How to Back up your Database

Nice i guess

Thanks

 

[PeaTar]

Re: [Guide]How to Back up your Database

Cool I'm gonna go make one right now

 

[lols1996]

Re: [Guide]How to Back up your Database

cool i'm gonna go make one right now

np.

 

[xjimmy94]

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

 

[NMDanny]

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

 

[urtime59]

Re: [Guide]How to Back up your Database

how do you autobackup say every 3 days?

 

[lols1996]

Re: [Guide]How to Back up your Database

how do you autobackup say every 3 days?

Click on the backup.bat file every 3 day

 

[PeaTar]

Re: [Guide]How to Back up your Database

Okay so that automatically makes a backup every 3 days?

 

[johnnyman1]

Re: [Guide]How to Back up your Database

Thx Much Easier then how i used to do it

 

[Gmanpopinjay]

Re: [Guide]How to Back up your Database

i use navicat to back up lols =P

 

[lols1996]

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

 

[DaichiKokujo]

Re: [Guide]How to Back up your Database

i use navicat to back up lols =P

How do you backup with Navicat?

 

[tgf914520]

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

 

[kengwei91]

Re: [Guide]How to Back up your Database

can i other user MySql database?

 

[lols1996]

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.