[Tutorial] [Backup database]with Screenshots

[SpiderOT]

Hello all this is my first Tutorial in forum hope it help you and you like it
i have searched a lot for tutorial to make backup for my server
but most of them hard and didn't help me so i decided to search in googel and i found a program called MySQL Administrator
and here i will explain how to use it :thumbup:
so lets start
First part
after you setup the program and start it you will get this screen

put the detail as you see in the pic
and press the ok button then you will get this screen

click on the backup and make new project

after you make the new project you will see your all the data of the mysql
click on your server database here my server database name (tfs)
then click the [>] button , after you do it you will see all the data in your server (account-bans-global-....)

Now click on save project then click on execute backup now and select the place you want your backup file save in

after you click save the program will start to make the backup file

Now we done withe the first part
now the second part how to restore the your backup?
click on the restore button

the click on open backup file

Now select the date you want your server to backup to it
then click on open

after your back up end you will get this msg

now your backup restored successfully
with this program you can also make schedule every day or w/e

Now the Important thing the download link
or you can googel it (MySQL Administrator)
it is a freeware software
Download
Now we are done hope this help you and learned you something
any question or comment? :thumbup:
Yours
The Hulk

 

[Deleted member 50858]

-

 

[SpiderOT]

make sure you enter the correct info

store connection : (any name)
server host : (must be localhost)       port: (Must be 3306) 
user name: (Must be root)
password: (your sqlPass you can get it from config)

VVVVVVVVVVVVVVVV

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "pass"<<<<<this one
	sqlDatabase = "tfs"

 

[Saj]

Great tutorial, this will help many!

 

[drax skylon]

Nice Tutorial, but if you want to make a backup of your db you can just stop the apache and mysql in XAMPP Control Panel and backup the folders htdocs and mysql xP

But this program is good to make schedule.

Thanks I'll use ;]

 

[Dennis888]

Thanks for it great tutorial

 

[Fragdonut]

Great but I prefer Zislys server manager

 

[Johanz]

added rep

 

[kito2]

Something that I would add: when restoring, check that the database is empty.
And also adding that server should be offline.

Repped.

 

[kosan100]

REALLY Nice Tutorial ill Rep you!^_^


Forgot to ask, i need to create like a account to using that because i dont have a username or password for that. Can you send me link to Register please?

 

[Keshoo]

Yeaa you are very good and pro thank you very much maaaaaan

 

[Gomgom]

Good job

 

[djtuca]

Repp for you for tutorial

but i use Navicat Mysql and good program

xD