How can i backup my MySQL db?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ariseo
Forum Newbie
Posts: 8
Joined: Mon Aug 21, 2006 8:01 pm

How can i backup my MySQL db?

Post by ariseo »

I've successfully created a PHP program with MySQL db and the records are starting to get bigger. Now, how can i backup the db of MySQL since i can't see where it is located?

I am thinking as simple as copy the file then paste it in the dvd burner that's it. Is't that simple?

Have no idea! Pls. help!! Thanks a lot
jeva39
Forum Commoner
Posts: 45
Joined: Sun Aug 27, 2006 11:45 pm
Location: Panamá

Post by jeva39 »

The link in the post below explain all...
Last edited by jeva39 on Thu Sep 14, 2006 3:31 am, edited 1 time in total.
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

ariseo
Forum Newbie
Posts: 8
Joined: Mon Aug 21, 2006 8:01 pm

Post by ariseo »

got a zero knowledge about how to backup mysql db. I read the page of the above link but its too complicated for me. What is shell? waaaa

Can i just simply copy the "mysql" folder entirely then paste it in my backup drive or dvd burner? will it backup everything? or copy the "phpmyadmin" folder?

Im sure if i backup my harddrive i can preserve my sql db but thats biggy so i wanna pinpoint the folder exactly so that the size is not that big as my hard drive.

Thanks,
jeva39
Forum Commoner
Posts: 45
Joined: Sun Aug 27, 2006 11:45 pm
Location: Panamá

Post by jeva39 »

Download mySql Administrator from mySql site. With the option BACKUP you make your copy very easy.
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post by aaronhall »

If you're using phpMyAdmin already, it has a built-in backup facility under the "Export" tab
Post Reply