Mysql backup

From Hostek.com Wiki
Jump to: navigation, search

Creating a MySQL Backup with PHPmyAdmin

The first step is to log into your database through PHPmyAdmin. If you are on a windows server you would do this through WCP by clicking on the link that says PHPmyAdmin and then choosing the database from the dropdown. If you are on a linux server you will just click on PHPmyAdmin and it will load it.

  1. Select the database you are wanting to backup from the left hand side.
    1. If you are wanting to backup a specific folder (table) you can place a check in the box next to it and follow the rest of the instructions.
  2. Click the Export tab at the top of the page.
  3. Click Go and you will be prompted to download an SQL file that is your MySQL backup