PHP / MySQL

  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

Build Your Own Website

Step-by-step advice on how to do everything from choosing a Web host to promoting your content. More >

Connect Your Home Computers

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

PHP / MySQL

  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.