in which for mat we should take databas ebackup in phpmyadmin
- Thread starter remember
- Start date
[align=center]MySQL Export: How to backup your MySQL database?
You can easily create a database dump (export/backup) of a databases used by your account. In order to do so you should access the phpMyAdmin interface available in the cPanel for your account:
You will be brought through a redirect screen stating that the phpMyAdmin tool will be loaded shortly then the new page will be automatically loaded in your browser.
Once the phpMyAdmin tool loads, you can select the database that you would like to backup from the drop-down menu called Database (located in the upper left corner of your web browser).
A new page will be loaded in phpMyAdmin for the database selected from the drop-down menu. In order to proceed with the backup click on the [Export tab]:
The options that is advisable to select apart from the default ones are Save as file (which will save the file locally to your computer in a .sql format) and Add DROP TABLE (which will add the drop if table already exists statement in the database backup) as shown below:
This is all that needs to be done and you can click the [Go] button to start the export/backup of your database:
A download window will popup prompting for the exact place where you would like to save the file on your local computer or automatically start the download depending on your local settings.
A download window will popup prompting for the exact place where you would like to save the file on your local computer or automatically start the download depending on your local settings.
