Difference between revisions of "Mysql backup"

From Hostek.com Wiki
Jump to: navigation, search
(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 and Restoring with PHPmyAdmin==
+
==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.

  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