Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

It depends on the database engine you are using (MySQL most frequently uses MyISAM or InnoDB). For the best information, you should start with the MySQL documentation for the version of MySQL you are running (MySQL 5.1 backup and recovery documentation). You should not be manually copying files that are in use as some databases will not flush changes to the disk without being explicitly told to do so.

share|improve this answer

We would recommend our backup tool MySql Backup And Ftp (MySqlBF). MySqlBF allows to schedule backups using a Windows Task Scheduler or a custom windows service for a complex backup scenarios.

It supports connecting securely over an SSH connection and has such a unique feature as creating a backup via phpMyAdmin. The tool allows to archive, encrypt and save backups to HDD, FTP, Network or most popular cloud storage services (Dropbox, Amazon S3, Google Drive, SkyDrive, Box) and sends email notifications on success or failure.

Hope that will help you.

share|improve this answer

there is a really easy way to backup mysql using mysqldump Run this once a night and back up the resultant file.

share|improve this answer

MYSQLIBF won't work with Windows server 2003

share|improve this answer
1  
Can you cite your source for this? – Dave M Dec 8 '15 at 15:28
    
MYSQLIBF compatibility MySql 5.0 and higher MySql 4.1 phpMyAdmin 3.3, phpMyAdmin 3.4 (if connecting through phpMyAdmin) Win2000, WinXP, Win2003, Windows Vista, Win2008, Windows 7 – pun Dec 8 '15 at 20:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .