Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

Backup or Restore your Mysql Database using phpMyAdmin

Taking a Backup or Export of your MySQL database using phpMyAdmin :-
--------------------------------------------------------------------------------------------------

Step 1: Login into phpMyAdmin. (Either via the control panel or by using http://databasehostname/phpMyAdmin/index.php)
Step 2: Click on your database name in the left pane options.
Step 3: Click on the tab labeled EXPORT at the top.
Step 4: Select the Export Method as Quick or Custom and select the format as SQL, CSV etc.
Step 5: Hit GO
Step 6: After this, it'll show the .sql file (if SQL was selected in the previous step) and copy that file and save it at your end using notepad with the .sql extension.


Restore or Import your .sql file using phpMyAdmin :-
-----------------------------------------------------------------------

Step 1: Login into phpMyAdmin. (Either via the control panel or by using http://databasehostname/phpMyAdmin/index.php)
Step 2: Click on your database name in the left pane options.
Step 3: Click on the tab labeled IMPORT at the top.
Step 4: Select the file using the Browse option from your local computer (the file limit is 2 MB maximum but compressed files are supported as well with gzip, bzip2, zip).
Step 5: Hit GO and it'll import the .sql file into your database.

Sachin Tuesday 25 June 2013 - 8:43 pm | | Default

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.