Backup & Restore (WordPress) Database with phpMyAdmin
Video How-to: Backup & Restore a Database with phpMyAdmin
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.
the_guv's sistasite: Setup The Ultimate VPS
"Blank box to top-notch web server"
- plain English copy/paste tutorials with video
- written for VPS beginners and Linux newbies
- perfect for multiple sites, blogs & more
- Fast. Secure. Future-proofed. Cheap-as-chips!
- "Wow!!" "godsend!!" "GREAT!!!" "awesome"
Ubuntu & Debian, Nginx (beats Apache), MySQL, PHP-FPM, Xcache, WordPress, WP MU, Drupal etccccc
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 [...] -
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 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 [...] -
Wordpress Suicide Plugin: Clean a WP Database
How do you clean a Wordpress database of unwanted data, while retaining user or other select information? Strip out the database using phpMyAdmin? Sure. But a lazier option? WordPress Suicide. Suicide allows [...] -
Video How-to: Install WordPress - Nice 'n Simple
So you wanna blog, huh? And you've looked at the options, and like WordPress. Me too! And you like the expandability and personalisation that a WordPress standalone install gives, but are put off by the [...]
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.