Difference between revisions of "Mysql backup"
From Hostek.com Wiki
(Created page with "==Creating a MySQL Backup and Restoring with PHPmyAdmin== The first step is to log into your database through PHPmyAdmin. If you are on a windows server you would do this thr...") |
(→Creating a MySQL Backup with PHPmyAdmin) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | ==Creating a MySQL Backup | + | ==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. | 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. | # 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