i'm currently running MySQL as my database. i want to know how do you backup all the data that has been added. is there a folder associated with MySQL database? if so where can i find it?
read the mysql manual about the mysqldump program. You can backup the datafiles, but that is tricky and will only let you restore the entire database at once, not table-by-table or a part of a table.
Mysqldump is the best idea to prevent data inconsistancies from backing up the binary table files while the server is running.
