Difference between revisions of "Mysql backup"
From Hostek.com Wiki
(→Creating a MySQL Backup with PHPmyAdmin) |
|||
Line 4: | Line 4: | ||
# Select the database you are wanting to backup from the left hand side. | # Select the database you are wanting to backup from the left hand side. | ||
− | ## If you are wanting to backup a specific folder you can place a check in the box next to it and follow the rest of the instructions. | + | ## 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. |
# Click the Export tab at the top of the page. | # Click the Export tab at the top of the page. | ||
# Click Go and you will be prompted to download an SQL file that is your MySQL backup | # Click Go and you will be prompted to download an SQL file that is your MySQL backup |
Latest revision as of 18:57, 31 August 2012
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.
- Select the database you are wanting to backup from the left hand side.
- 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.
- Click the Export tab at the top of the page.
- Click Go and you will be prompted to download an SQL file that is your MySQL backup