Page 1 of 1
How can i backup my MySQL db?
Posted: Wed Sep 13, 2006 7:09 pm
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
Posted: Thu Sep 14, 2006 2:02 am
by jeva39
The link in the post below explain all...
Posted: Thu Sep 14, 2006 3:22 am
by Weirdan
Posted: Thu Sep 14, 2006 9:49 pm
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,
Posted: Thu Sep 14, 2006 10:01 pm
by jeva39
Download mySql Administrator from mySql site. With the option BACKUP you make your copy very easy.
Posted: Fri Sep 15, 2006 4:01 am
by aaronhall
If you're using phpMyAdmin already, it has a built-in backup facility under the "Export" tab