Go Back
  • Backing up MySQL data

    Here are a couple of resources that I used for research:

     

    http://kb.liquidweb.com/how-to-back-up-mysql-databases-from-the-command-line/

     

    Restoring data can be done with the MySQL Workbench tool.

     

    For MySQL running on Windows servers, you can manage the server if WMI is available.

     

    http://www.poweradmin.com/help/enableWMI.aspx

     

    http://msdn.microsoft.com/en-us/library/aa822854%28v=vs.85%29.aspx

     

    In order to avoid the giant ibdata file and have one file per database, please see:

    http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql