I am new to MySQL, I have used MS SQL Server up to this point, so forgive my ignorance.
We are hosting on a Rackspace dedicated server and they can set up nightly backups on a directory. Currently, we are backing up all our SQL Server MDF and LDF files this way. I would like to do the same with MySQL, but I don't know enough about the file structure for MySQL databases. I would like to know where the important MySQL files that I need to backup are located.
Is there anything else I need to do in order to create good backups for MySQL. Do I need to set up some sort of regular DUMP process or something? Any help or advice would be appreciated. Thanks.