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
How can i backup my MySQL db?
Moderator: General Moderators
Heh, simply read the manual: http://dev.mysql.com/doc/refman/5.0/en/ ... ntion.html
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,
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,