Mar

5

Exporting Your MySql Database via PhpMyAdmin

Posted by admin

March 5, 2007 |

If you have access to PhpMyAdmin, you have an easy way to backup your MySql database. At first, this can seem a little confusing. Don’t be scared off by the screen or the process. If you need a quick backup of your database, this is a super quick and easy way to do it. This isn’t good for a long term backup solution - you need something automated like a plugin, script, or cron job for that.


Ok, first, go to your database in your hosting account. Then, go to your hosting manager. I’m going to assume that if you’re using Cpanel or Plesk that you know what you’re doing. Maybe that’s a bad assumption since I use those. ;)

Ok, once you’re into PhpMyAdmin, you will see a screen like this. Click on the export link to go into the export manager.

mysql-export.jpg

Now, once you are at the export screen, you want to make sure that sql, structure, data, and save as file are all checked. Once they are, click on the Go button and it will download the sql file.

mysql-export2.jpg

Now, restoring a sql file can be a little trickier, but we’ll tackle that another time.


Comments

Name (required)

Email (required)

Website

Speak your mind

<< Post Navigation >>

« « Free Joomla Backup | Restoring a MySql Database » »