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.
]]>