How to backup your Mysql database with phpMyAdmin

[innovative2001]

Hello,

A lot of web applications use MySql for storing the content, to backup my sql database from Php MyAdmin:

Backup of Mysql database
It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.

0. Open phpMyAdmin.
1. Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu.
2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
3. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
4. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

Restoring a backup of a MySql database
1. To restore a database, you click the SQL tab.
2. On the "SQL"-page , unclick the show query here again.
3. Browse to your backup of the database.
4. Click Go.

[chusoon]

possible run in auto mode???

[ASP-Hosting.ca]

You can backup MySQL database using a cron job or scheduled task, depending if you are on Linux or Windows...

[MXHUB]

Using cronjob to execute sql command at specific time will make whole thing run in autopilot mode.

You will make sure you download your backup to your desktop regularly for safe copy.

[ASP-Hosting.ca]

You can automate the backup download too :).

[ReactHosting]

cpanel has a nice "download mysql database" section under the backup icon.

[Jazzy Host]

good info, also a good way to migrate from a non cpanel host with phpmyadmin to a cpanel host.....the posts about cpanel backup util, its also a great and easy to way to back/move your dbs/sites...

[D-host]

thanks for the info

[rubia126]

hi

i was also having same sort of issues with my database on a frends recomonmdation i contact to www.oracleplace.com they really help me out hope this will help u too

good luck

[viphost]

Very usefull Tips guys, keep those comming more and more. :)