1. Home
  2. Computing & Technology
  3. PHP / MySQL

Backup and Restore MySQL Databases

By Angela Bradley, About.com

3 of 4

Backup Database From the phpMyAdmin

backup mysql database with phpmyadmin
  1. Login to phpMyAdmin
  2. Click on your database name
  3. Click on the tab labeled EXPORT
  4. Select all tables you want to backup (usually all)
  5. Default settings usually work, just make sure SQL is checked
  6. Check the SAVE FILE AS box
  7. Hit GO
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. Learn MySQL
  5. Backup Database phpMyAdmin - Backup MySQL phpMyAdmin - Backup MySQL Database

©2009 About.com, a part of The New York Times Company.

All rights reserved.