HostOnNet.com Forum Index HostOnNet.com
Private Label Reseller Plan
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to back up a MySQL database using phpMyAdmin:

 
Post new topic   Reply to topic    HostOnNet.com Forum Index -> FAQ
View previous topic :: View next topic  
Author Message
Annie
Site Admin


Joined: 19 Jun 2005
Posts: 23
PostPosted: Wed Feb 28, 2007 7:33 am    Post subject: How to back up a MySQL database using phpMyAdmin: Reply with quote
You can backup Mysql database using the phpMyAdmin feature in your control panel. In phpMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As..." and click on the "Go" button. Simply save the database that begins to download, on your local computer.

How to restore a MySQL database using phpMyAdmin:

Click on your database name shown on the upper left.

Locate your back up file for the database that you want to restore. Open it and copy the entire contents.

Paste into the field called "Run SQL query/queries on database yourdomain_com" and click the "Go" button.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    HostOnNet.com Forum Index -> FAQ All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group. Hosted by phpBB.BizHat.com

For Support - http://forums.BizHat.com

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!