R-Ts NetWorks

Server the Best

How to take Database Backup using phpMyAdmin


How to take Database Backup using phpMyAdmin.

First you need phpMyAdmin which is a MySQL Database Administration Tool.

1 – Open phpMyAdmin

2 – Click on Export

3 – Under Export – Select the database you want to backup

4 – Select SQL

5 – Select Structure, Add DROP TABLE, Add IF NO EXISTS, Add AUTO_INCREMENT VALUE and Enclose table and field names with backquotes.

6 – Select Data, Complete inserts, Extended inserts and Use hexadecimal for binary fields.

7 – Select Save as file your data base. Here you can use any name you want.

9 – In Compression specify your choice.

10 – Click Go.

How to restore a Database using phpMyAdmin.

1 – Open phpMyAdmin

2 – On the far right hand side, click on the little SQL box and a window should open

3 – In this window click on Import Files

4 – Use the browse button to find the database file.

5 – In Compression Select the option you chose to export the database

6 – Click Go.

 

Advertisements

December 28, 2011 - Posted by | MySql, Uncategorized |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: