Backup & Restore (WordPress) Database with phpMyAdmin
Video How-to: Backup & Restore a Database with phpMyAdmin
17 Feb
Phpwhatnot? Aargh! Scary? It's not.
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.
Plus, for WordPressers, how to use its little brother, wp-phpmyadmin, to secure your WordPress db.
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.
If you liked that ...
-
Easy-as-you-like! Adapt Square Boxes with Hassle-Free Curves
Give your site a design lift with this simple CSS code snippet. Simply choose a radius and drop it in a div for a real easy way to add curves without any images or javascript. This is super-fast to do and works for [...] -
Maintain Unmanaged VPS - Part 6: Backup a MySQL Database from the Terminal
This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure. Just replace the db name, username and password and paste the code into your [...] -
Video How-to: Add a Favicon
If I had a Big Mac for every favicon tutorial out there, I'd be dead. But hey, I needed a favicon, and I figured a video illustrating the process may come in handy for some folks, so here goes. What is a [...] -
Maintain Unmanaged VPS - Part 5: Get phpMyAdmin Working with Nginx
How to install PMA with Nginx, to administer multiple MySQL dbs from anywhere. View table structure, browse data, run queries, backup and more. Adding phpMyAdmin to the Nginx web server is very like adding a [...] -
Video: We Are Living in Exponential Times
By 2013, a super-computer will be built exceeding the computational capability of the human brain. By 2049, a $1000 computer will likely exceed the computational capabilities of the entire human species. If [...] -
Video How-to: 10 Tips To Make WordPress Hack-Proof
UPDATE: June 2011.Inspired by this popular post, guv's WordPress 3 Ultimate Security, the first-ever book explaining in detail how to secure the popular blogging and content management platform, has been released. [...]
10 Tips To Make WordPress Hack-Proof February 24th, 2009 at 12:12 pm
[...] the answers are “not often enough,… More Categories: blogging, web [...]
10 Steps to Secure WordPress | Tutorials On Web March 20th, 2009 at 3:06 pm
[...] ii. Backup the database, as explained in Guvnr’s video tutorial. [...]
10 Tips To Make WordPress Hack-Proof. The Ultimate Guide. - GUVNR June 4th, 2009 at 9:48 am
[...] This post: Video How-to: Backup & Restore a Database with phpMyAdmin [...]
cagecraft June 25th, 2009 at 10:31 pm
Hi, this is all i need...
Great tutorial and i have booked mark it
Many thanks
the_guv June 26th, 2009 at 6:17 am
cheers cagecraft, splendid.
Blake Imeson *Innovatrepreneur » Blog Archive » Backup WordPress = 2 Plugins + Gmail July 9th, 2009 at 7:22 am
[...] is useless if you don’t know how to restore your site if it fails. Use PHPMyAdmin to restore the database. (or use the wp-phpmyadmin plugin) The WordPress files reside in the [...]
carlos August 4th, 2009 at 9:18 am
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".
the_guv August 4th, 2009 at 12:08 pm
@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.
@THN_Nick November 5th, 2009 at 1:14 pm
Totally, exactly what I needed, being a complete newbie.
Clear, brief, easy.
Thanks!
Nick
the_guv November 11th, 2009 at 3:42 pm
@Nick, crackin to hear, thank you.
10 Tips de seguridad para WordPress - Alberto Rodriguez Molina March 2nd, 2011 at 7:16 pm
[...] respalda tu base de datos usando wp-phpmyadmin. Si no sabes como hacer esto, revisa este tutorial. [...]
10 Steps To Keep Your Wordpress Blog Free From Hackers 2011 | Business Software System Reviews | Types Of Business Softwares | Top Business softwares | Open Source Business softwares May 29th, 2011 at 7:07 am
[...] ii. Backup the database, as explained in Guvnr’s video tutorial. [...]