Video How-to: Backup & Restore a Database with phpMyAdmin

phpMyAdmin logo image

How often do you backup your mySQL database? Does the idea fill you with horror? Or do you think the “full backup” option at your ISP covers the database too?

If the answers are “not often enough, pretty much, and not so sure” then here's some help.

Watch this video to see just how fast ‘n easy it is to backup & restore a database with phpMyAdmin, and as a general introduction to this handy admin tool.

Setup Unmanaged VPS (4 Noobs!) ... with vpsBible
Secure WordPress. Properly. ... with wpCop, the platform's dedicated security website
Olly 'the_guv' Connelly's site and 'WordPress 3 Ultimate Security' book.

Plus, for WordPressers, how to use its little brother, wp-phpmyadmin, to secure your WordPress db.

Video: Backup & Restore a DB + phpMyAdmin

Watch the video for a better idea of how to do this.

Guv's on YouTube at

To manage your databases, any decent ISP will have phpMyAdmin available in your admin area. For the wp-phpmyadmin WordPress plugin, go here.

OK, no excuses! Not so scary after all? Now secure that db.


About the Author:

Olly Connelly (yeah, that's me) blogs at, polices WordPress security at and helps noobs build web servers at, so if you've got sleeping problems you know where to come.


  1. the_guv  November 11, 2009

    @Nick, crackin to hear, thank you.

  2. @THN_Nick  November 5, 2009

    Totally, exactly what I needed, being a complete newbie.

    Clear, brief, easy.


  3. the_guv  August 4, 2009

    @Carlos .. muchas gracias, tio .. pues, me gusto su pagina web .. muy claro, un ejemplo estupendo de una pagina con, er, ‘usability’ .. lo siento, mi espanol es mal.

  4. carlos  August 4, 2009

    thanks a lot!…so clear, so breaf, so useful!
    I loved the demonstration for unfaithfull people like me: “I killed the cat, now is back alive”.

  5. the_guv  June 26, 2009

    cheers cagecraft, splendid.

  6. cagecraft  June 25, 2009

    Hi, this is all i need…

    Great tutorial and i have booked mark it

    Many thanks

Add a Comment