How to Move/Transfer Your Database

By: Stephanie Vigil

I present to you a step-by-step tutorial on importing and exporting your database.


This ‘how to’ will come in handy if:



  1. You need to switch hosting without losing your data or,

  2. If you want to back up your database or,

  3. Both

Don’t worry, it’s really easy. You don’t need to know PHP or MySQL.


Step 1. Log into your phpMyAdmin. You could do this from the control panel in your hosting account.
phpAdmin.gif


Step 2. Select the database name on the left side.


Step 3. Once you select the database you’ll see all the tables with clickable tabs above them. Select the “Export” tab.


Step 4. leave all the default check marks in place. Just make sure everything is selected under “Export” (those are your tables, you need them) and also “SQL” is selected on the lower-left. For “Compression” select “zipped”. Press “GO” and wait for it to download onto your computer.


php-export1.gif


**At this point you can save the zipped file as backup. MySQL has it’s own backup programs – mysqldump and mysqlhotcopy – but I like to save all my stuff on a drive. It’s just a matter of preference.


–– Moving on to transferring your database onto another server––>


Step 1. Log into your new hosting account and create a new database. In HostMonster
<!– .hm { color:#DD0606;text-decoration:none; } .hm:hover { color: #A10606;text-decoration:none; } –>


you would select MySQL Datasases and then Create Database.


MySQL.gif


Step 2. Log into your phpMyAdmin from your new hosting account.


Step 3. Select the database you just created.


Step 4. From the tabs again select “Import”. Make sure file downloaded earlier is unzipped.


Step 5. Under “File to import” choose the unzipped file and press “Go”.


You’ll see a number in (parenthesis) next to your database name on the left. Those are your tables.


That’s it. You’re done.


Easier than you thought, right?


If you run into any problems or have a question leave a comment and I’ll get back to you soon.

About the Author

Stephanie Vigil is a professional website developer in Santa Fe NM and Taos. Browse her portfolio at web page design Taos.

(ArticlesBase SC #2880221)

Article Source: http://www.articlesbase.com/ – How to Move/Transfer Your Database