In which folder are MySQL Database files actually kept? Which files should I backup? Is there a good tool for backing these up and restoring them if nessesary?

Sil, March 2004

Try this command:
mysqldump --user= | bzip2 -zc > bzipfile.bz2

The zipping is optional etc. the raw output is an SQL query that would rebuild and repopulate a database.

There are loads of options so try:
mysqldump --help

These are command line (sh or bsh etc.) which work on Unix/Linux, there is probably the same for Windows CMD.

Paul, February 2005