There’s nothing worse than working on a document or project for a couple of hours, only to have something unexpected happen that causes you to lose the changes you just made. You lose time, productivity, and motivation.
As bad as that is, though, can you imagine if you lost your entire blog?
Talk about your horror story.
The bottom line here is that you absolutely cannot let this happen. Fortunately, WordPress now comes equipped with a very simple, very useful tool that you can use to back up your blog on a regular basis.
Take control of your content and get some peace of mind in the process by learning how to use the WordPress Database Backup Plugin.
Supercharge your blog’s earnings with Text Link Ads
Helpful links from this episode:
- Start your professional blog today with the 1-click WordPress installation from Colorteck.
- Got an FTP client? Try CoffeeCup for Windows (seen in this video) or Transmit for you Mac users out there.
- Check out our other Essential WordPress Hacks.
One can prepare for its online exams such as 220-301 or get complete guide on A+ certification through any web site of online learning. The sites of Microsoft certifications also offer reliable support and study guides on prominent online courses. The internet is also being used for businesses like affiliate marketing as well as for the search engine submission services. While the domain web hosting firms are also running huge business online and facilitating their customers through reliable data protection or some times with custom web design services too.
Share this page or bookmark it now!





85 Comments ↓
7 Essential WordPress Hacks | Tubetorial said:
[...] Back Up Your Blog or Risk Losing It All [...]
7 Essential WordPress Hacks Video Series | Copyblogger said:
[...] Back Up Your Blog or Risk Losing It All [...]
Masey said:
Great tute. My question has always been though, how does one restore the backed up file once something does go awry? Nobody ever seems to cover that?
LearningNerd said:
From what I’ve read, it isn’t too safe to leave your file permissions for a folder at 777. After doing the backup, I’d recommend changing it back to 755 right away.
I don’t know much about file permissions yet, though. What do you think? Is it safe? What are the risks?
Chris said:
Masey — In order to restore your backup file, you’ll need a version of phpMyAdmin that is capable of handling database imports.
Based on my own experience, phpMyAdmin on shared servers will typically accommodate imports of up to 2.5 MB (give or take, depending on the host), and that may or may not be large enough to handle your entire blog.
That said, every virtual dedicated hosting plan that I’ve ever come across allows for phpMyAdmin database imports upwards of 50 MB.
LearningNerd — While I was preparing information for this video, I was astonished to find out that so many people—including the plugin’s creator—were okay with the fact that a
chmod 777was necessary for this thing to work.The primary risks here hinge upon you actually having executable files within the affected directories. Your
themesfolder, for instance, won’t allow for direct file access, and as far as I know, the same holds true for thepluginsfolder.Of course, I’m sure there are folks out there who have executable files in their
wp-contentdirectories, and I think perhaps they might want to open and close access every time they back up their database.Kind of a pain, but how much is peace of mind worth?
Mike said:
ThemeBrother,
Is that a version of word you have open at the start of this tubetorial ? If so, what version ?
And, do you use Word to write your blog posts ?
If not, what editor dost thou useth and would you consider a tutorial on that on one of your blogs ?
Your layouts, subheads and etc always look so good it makes me jealous.
Chris said:
Mike,
You observant dawg, you! That’s the brand-spanking-new Office 2007, and although I’m primarily a Mac user, I gotta tell ya—it’s sweeeeeeeeet.
And no, I don’t use Word to write my blog posts. In fact, I really only included that in the video to have a little fun and see if anyone would notice!
Believe it or not, I use the basic text editor (not the WYSIWYG one) that comes with WordPress.
The secret (if you can call it that) to my special styles lies in the XHTML that I employ while constructing the post. Oh, and the CSS plays with the XHTML to produce the results of which you speak.
I talk about this very topic over at the Cutline support site, and I actually intend to do a much more detailed post at Pearsonified one of these days.
So I guess what I’m really saying here is this: you can look as good as I do if you just go grab a copy of Cutline!
Darren said:
Taking this one step further, I’ve installed wp-cron on my WordPress sites. This allows you to do a backup at a particular time every day.
I’ve then configured the backups to be emailed to a Gmail account (lots of space there!), giving me a long history of daily backups of all my blogs. Every couple of weeks I log into that Gmail account and download the latest backup of each blog to my computer.
So now I have my blog database, a backup on Google’s servers, and a separate copy of the backup on my own PC. And it’s all automatic!
Mike said:
Wll now, aside from running out to get my new Word 2007 Christmas gift for myself, I guess I’ll have to gift myself with a little bit o’ Cutline.
Thanks and go ahead and do that post about your stylin’ and profilin’ whenever you get the itchin’.
Guennersen.de | screencast: WordPress Backup said:
[...] Tubetorial bietet zur Zeit mehrere freie Screencasts zum Thema WordPress an. Unter dem Motto” 7 essential wordpress hacks” werden vor allem für Beginner Themen wie Spamschutz oder Suchmaschinenoptimierung erklärt. In der heutigen Folge geht es um das beliebte WordPress Database Plugin. bookmark:Diesen Artikel in deine del.icio.us bookmarks aufnehmen… [...]
7 modificações para seu blog com WP - Gulp - Desenvolvimento e diversão said:
[...] 7 – Faça um backup! [...]
world according to ack ~ adam karas » 7 Essential WordPress Hacks said:
[...] Back Up Your Blog or Risk Losing It All [...]
//celsojunior.net - Procurando por projetos e sonhos… » Blog Archive » 7 maneiras de melhorar, aprimorar e aperfeiçoar o seu Wordpress blog said:
[...] 1. Como ter mais tráfego utilizando permalinks; 2. Como ganhar mais dinheiro com o Google AdSense; 3. Adicione anúncios em seus feeds; 4. Tenha mais feedback, crie um formulário de contato; 5. Como aumentar o número de comentários e visitantes; 6. Como bloquear os comentários spams com o Askimet; 7. Faça backup do seu blog regularmente. Por celsojunior Tags: Posts, Publicidade, Marketing, Dinheiro, Tutoriais, Links, Tutorial, Apoio, Dicas, Blog, Blogosfera, Web, Web 2.0, Desenvolvimento, Feed, Tecnologia, Webstandards, Internet, Ajax, Java, API, RSS [...]
Ted said:
Is there a way to back up a blog created in Blogger?
» Wordpress: Backup der Datenbank erstellen :: sansegundo.de said:
[...] Link zum Tutorial [...]
AndyToo said:
I’m loving me some:
http://www.backupmyblog.com
Works a treat. Free at the moment.
Masey said:
Nice link there “AndyToo”. I’m going to give that a go for the moment… see what the service is like while it’s still FREE.
Kyle Eslick said:
Thanks for the tutorial!
Backing Up Your Wordpress Blog at Kyle’s Cove said:
[...] I’m fairly new to Wordpress, and so far I’m enjoying the experience. The first thing I did after coming over, was figure out how to make a backup of my blog. This was never an issue with Typepad or Blogger, so it was new to me. Luckily, I ran across a video post explaining how to backup your Wordpress Blog with a Wordpress Plugin. [...]
Ralph Dagza said:
Im really dumb at this, but where do i upload the backup when i need it to restore my database?
Video demonstration: Activate your WordPress backup « Share Feeds said:
[...] Video demonstration: Activate your WordPress backup Video demonstration: Activate your WordPress backup Video learning site Tubetorial.com has an easy to follow video on how to backup your WordPress blog with WP’s baked in backup plugin. I’ve never lost an *entire* blog – but I’ve come close, and with the WordPress backup plugin activated, you won’t ever have to go through this particular headache. Best of all, it’s relatively simple to activate this plugin – all you gotta do is point and click (however, if you do hit a snag, the Tubetorial walks you through the most common problems). — Wendy Boswell Back up your blog or risk losing it all [Tubetorial] [via Lifehacker] [...]
Bart said:
This is very useful, but please note that this plugin does NOT backup any files that you have uploaded, and it does NOT backup your configuration and plugin files. In short, it does not backup your entire blog (as the name indicates). If anything happens and all you have is the database backup, you’re still going to be crying…
Here’s the script I use to properly backup my installation.
#!/bin/sh
# archive all the files in my blog
tar cvf myBlog.tar /usr/local/apache/htdocs/myBlog/
gzip myBlog.tar
# archive the database
mysqldump –user=db_user –password=db_password db_name > wordpress.sql
gzip wordpress.sql
# wrap everything up in one file
tar cvf myBlog_full.tar *
# clean up
rm myBlog.tar.gz
rm wordpress.sql.gz
rm wordpress_mantis.sql.gz
Hope this helps,
Bart
Der Informatik Student » Blog Archive » Video-Tutorial zum Backup einer Wordpress-Datenbank said:
[...] Ein sehr nettes Wordpress-Backup-Tutorial habe ich bei Tubetorial in Form eines Videos gefunden. Hier wird erklärt, wie man in ca. 5 Minuten das Plugin einrichtet und die erste Sicherung seines Wordpress-Blog ziehen kann. Hierbei werden 3 Sicherungsziele angeboten: [...]
MarcNext » Blog Archive » WordPress DB backup tutorial said:
[...] Mede naar aanleiding van een recente discussie op TrendMatcher ben ik nog eens gaan rondkijken naar backup-mogelijkheden binnen WordPress. Stomtoevallig zie ik dat Lifehacker gisteren verwijst naar een nieuwe flash video op Tubetorial die op buitengewoon eenvoudige wijze uitlegt hoe je de database-backup-plugin die automatisch met WordPress wordt geïnstalleerd kunt activeren en gebruiken. [...]
Speedlinking 7 January 2007 said:
[...] Tubetorial does it again with another helpful video tutorial – Back Up Your Blog or Risk Losing It All [...]
gordonmclean.co.uk » Blog Archive » Backup Wordpress said:
[...] A nice video tutorial on how to backup your Wordpress blog. Timely considering I’ve been mucking about with mine quite a bit! [...]
maestroalberto » Backup del database di WordPress said:
[...] Un video tutorial su tubetutorial vi aiuterà ad utilizzalo (è l’ultimo di 7 riguardanti WP). [...]
Viewfinder Design » Blog Archive » WordPress Backups said:
[...] In WordPress backups are nice and easy, there’s a plugin installed by default in WordPress 2 and higher, although you still have to activate and use it. Tubetorial has a great tutorial video which runs you through activating the plugin, sorting out any errors and preforming a simple backup. It could save you a lot of hassle if the worst happens. [...]
Chris said:
Ralph,
You use the import function within phpMyAdmin. Every Web host worth its weight in bandwidth provides you with phpMyAdmin to control your database(s), and you ought to be able to import a database that is 2.5MB or smaller (larger sizes are allowed by some Web hosts; it just depends).
Ralph Dagza said:
Thank you =]
Netzbetrieb » Wordpress Datenbank - Backup Anleitung said:
[...] Wordpress Datenbank – Backup Anleitung Januar 07th, 2007 für alle die auf einem eigenen Webhost eine Wordpress Installation betreiben, ist dieses Tutorial dringend empfohlen. Es ist ein Flashfilm in Englischer Sprache. [...]
Edwin said:
You forgot to mention that almost every host company today backups your blog every week. My host provider backups my blog every Sunday.
Rodolfo Pilas » Blog Archive » 7 trucos esenciales para WordPress said:
[...] Respalde su blog o arriésguese a perderlo todo [...]
4seven8 » Blog Archive » Back Up Your Blog or Risk Losing It All said:
[...] Back Up Your Blog or Risk Losing It All [...]
End of Silence - Freedom hating on the internets since 2002 » links for 2007-01-08 said:
[...] Back Up Your Blog or Risk Losing It All | Tubetorial (tags: wordpress backup tutorial howto tubetorial) [...]
Behind the glasses » Blog Archive » Backup a WordPress database said:
[...] Following problems with the server I had last week, here is a link to a tutorial on one of the most important topics: backup. Video tutorial site Tubetorial.com provides an easy to follow video describing the steps needed to backup your entire WordPress database. The complete procedure is not at all complicated and few clicks and couple of minutes later you can have a backup ready either on your server or on your PC. Now you only need to remember to create your backup regularly or automate it in some way. [...]
SKLATRNET » Tutorial over WP back-up said:
[...] Wil je een Wordpress blog back-uppen, bekijk dan eerst even de video Back Up Your Blog op tubetorial. Lees er ook hoe je de back-up terugzet (restore met phpMyAdmin). [...]
50 things I didn’t know last year : All Things Bright by Kathleen Bright said:
[...] Tubetorial: Back Up Your Blog or Risk Losing It All. It happened to me, it could happen to you too… [...]
Myglobalblog » Blog Archive » life is about wordpress said:
[...] Url.Video.Online.Tutorials.how to backup your wordpress data? [...]
blork said:
Oh for… why do things never work the way they’re supposed to for me?
I’m on the lastest version of WP, and I have the plugin ACTIVATED. It does NOT give the warning messages that you see in the video. Yay me. (I even deactivated and reacativated it to be sure). So I go into manage, check it to download to my computer, click “Backup,” and I get the error: “The backup file could not be saved. Please check the permissions for writing to your backup directory and try again.”
I checked. It was 755, so I changed it to 777. Same problem. It won’t let me email the backup either.
So what am I missing???
Tinta Fantasma » Blog Archive » 7 trucos esenciales para WordPress said:
[...] Respalde su blog o arriésguese a perderlo todo [...]
links for 2007-01-09 at DeStructUred Blog said:
[...] Back Up Your Blog or Risk Losing It All | Tubetorial (tags: Wordpress Blog Tutorial Backup) [...]
Backup WordPress easy » DeSiOrSite.com said:
[...] E se avete qualche dubbio o timore sul, semplicissimo, funzionalemento, vi propongo questo video tutorial davvero ben fatto [via maestroalberto]. Stampa Invia ad un amico [...]
MEE SQA Blog » Blog Archive » Back Up Your Blog or Risk Losing It All | Tubetorial said:
[...] Being new to blogging, I am on the lookout for tips and tricks. I came across the following link which shows a video of how to use the backup plugin that comes with WordPress. Back Up Your Blog or Risk Losing It All | Tubetorial [...]
Austoon Daily » Back Up Your Blog or Risk Losing It All said:
[...] Back Up Your Blog or Risk Losing It All [...]
Medisozluk.Com » Blog Archive » Back Up Your Blog or Risk Losing It All | Tubetorial said:
[...] [...]
What you can do with Wordpress [Part 3 - Plugins] at zamwi.com said:
[...] If you want to see how to do it, check out this tutorial video. [...]
mblair said:
For those that may have Wordpress 2.1 and are wondering where the backup plugin is, it is no longer included in the default Wordpress installation.
You can get the new version of the plugin here:
http://www.ilfilosofo.com/blog/wp-db-backup
The latest version of the plugin is designed specifically to take advantage of new features in Wordpress 2.1 by enabling scheduled backups.
links for 2007-02-13 | The Last Minute Blog said:
[...] Back Up Your Blog or Risk Losing It All | Tubetorial super easy to do video tutorial (tags: wordpress backup tutorial blog howto video blogging security) [...]
Wordpress Tips: Backup Your Database at forgedeuphoria.com said:
[...] http://www.tubetorial.com/wordpress-database-backup/ [...]
kagunda » Blog Archive » del.icio.us Bookmarks vom 15.03.2007 said:
[...] Back Up Your Blog or Risk Losing It All – Tubetorial [...]
Tüttelkram | Blog Archive | del.icio.us Bookmarks 15.03.2007 said:
[...] Back Up Your Blog or Risk Losing It All – Tubetorial [...]
Speedlinking Saturday - Week 2 | Web Business Blog said:
[...] Back Up Your Blog or Risk Losing It All – Video Tutorial [...]
Adrian said:
I am still working on learning how to use WP features…
mblair said:
Also, I found that if you 777 wp-content temporarily, you can then put it back to 755 afterwards as long as you make sure that the backup directory within it that was created remains 777. As you shouldn’t have any files in there, I’d think that this at least minimizes the security concerns a bit.
Easy SEO Friday said:
[...] Back up your Wordpress Blog Bookmark to: Tags: blogging, broken links checker, SEO, seo tools, website code diagnostics [...]
Doc Ott’s Life Hack Blog » Blog Archive » Backup your blog ya dummy! said:
[...] Bck up your wordpress blog with the built in backup tool [...]
angelenic said:
[...] I suppose I owe previous readers an explanation as to why I stopped blogging in the first place. When I first started blogging, I was living in the Valley and using the blog as a way to get my ass Downtown as much as possible. I’ve wanted to live here for a few years now, since I started going to court reporting school in Westlake (Los Angeles’s Westlake district, not Westlake Village). I then made a hosting move from godaddy.com to dreamhost.com, but what I had forgotten to do was back up my blog. [...]
PodcastingInc » Blog Archive : test » test said:
[...] Back Up Your Blog or Risk Losing It All This entry was posted on Monday, June 4th, 2007 at 1:41 pm and is filed under Podcasting. Responses are currently closed, but you can trackback from your own site. [...]
shaz said:
yes but disabling wirite on the file mean you have to keep dipping in and out of your ftp
The Two Easiest Option for Backing Up Your Blog - | Jamdo Marketing Blog said:
[...] The first is the Wordpress Database Backup Plugin – this installs as like any normal plugin on your blog and is really intuitive to use. In fact, Tubetorial has a 5 minute video on installing and using this plugin that is well worth the time to watch. If you have a recent version of Wordpress installed, then it should already be in the plugins option – you just need to activate it. If not, then you can still download it from here. [...]
7 Essential Wordpress Hacks @ Tubetorial.com at The Monday Sessions said:
[...] Back Up Your Blog or Risk Losing It All [...]
幸福收藏夹 » 7hacks给你带来流量和Money said:
[...] Back Up Your Blog or Risk Losing It All [...]
AJ said:
Back Up Your Blog or Risk Losing It All ?!??!?!
Blogging Essentials "Backup Your Blog" said:
[...] July 15th, 2007 by Jared Blake in WordPress Tips plugim_url = “http://www.gojdhl.com/seo-blog/blogging-essentials-backup-your-blog/”; plugim_title = “Blogging+Essentials+%22Backup+Your+Blog%22″; Let’s face it, if you loose your entire blog, you will be kicking yourself to Kansas, because you didn’t take the time to backup your blog database. So take action now and go directly to http://www.ilfilosofo.com/blog/wp-db-backup and download and install the latest version of the WordPress Database Backup Plugin, currently version 2.1.2. Also, watch this awesome video “Essential WordPress Hacks – Database Backup” Don’t let your blog go up in smoke, back it up on a regular basis. Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
Clive said:
Nice Tutorial – is the video hosted anywhere else as I’d like to feature it on my blog?
spectre said:
definitly out of the ftp
Guide To Blogging » Blog Archive » Backing Up Your Blog said:
[...] Wordpress has a plugin that enables you to have a back up of your blog sent to your email or saved within your database files etc. If you’d like to know more about this there’s a video you can watch: Wordpress Backup Plugin [...]
Webi said:
also eine nützliche Erfindung
Wie sichere ich meinen WordPress-Blog richtig? : BloggersGalaxy said:
[...] Eine ausführliche Videoanleitung für das Plugin habe ich hier gefunden. [...]
AJ said:
thank you
sondan said:
I have only been on wordpress a few weeks. After the first week the system did some kind of hiccup and I lost all of my links but two. Now that they are restored I would like to back up my blog to prevent such a nightmare again. Problem is I understand that I cannot use plug-ins with my blog. For those of us that can’t how do we back up or Wordpress blogs please.
Thank you
Optimize, Repair And Backup Your Database Within Wordpress | Tubetorial said:
[...] One of our most popular tubetorials is the Backup Your Blog video, but the functions is the backup plugin are rather simple and limited.Actually you want more than just backup your blog, because what will you do with the backup once you need it? Do you know how to restore your database, how to import your backup? Did you know that you have to do this within PHPMyadmin, in your CPanel??? [...]
Moving Your WordPress Blog? Here’s How NOT To Do It » Silver CEO Cafe said:
[...] Not sure how to start? See this excellent video at Tubetorial, with step by step guidance on how to back up your blog using the WordPress Backup Plugin. [...]
Speedlinking 7 January 2007 | Malaysia Blog Tips For Blogger - Make Money Online Blogging said:
[...] Tubetorial does it again with another helpful video tutorial – Back Up Your Blog or Risk Losing It All [...]
Check Out These 7 Essential WordPress Hacks said:
[...] Back Up Your Blog or Risk Losing It All [...]
Wordpress Backup / Datensicherung Video Tutorial said:
[...] finden Sie das Video im Flash [...]
Speltips said:
When is this video from? I mean is it current? Cant see any date anywhere
phpMYadmin Backup Video Tutorials | 'Lær det via internet' said:
[...] bare for at lave en backup af min mysql database. Jeg fandt heldigvis nogle rigtigt gode videoguides du kan se dem [...]
7 trucos esenciales para WordPress « Blog’s CSoer said:
[...] Respalde su blog o arriésguese a perderlo todo [...]
MiniMarie’s Corner » Learning to Back It Up said:
[...] has a plug-in to help with backups. I watched a video that walked me through using the WP backup plugin. It took me through every step I needed, including the stupid error message that I couldn’t [...]
Tổng hợp về backup blog « Bolzano2910’s Weblog said:
[...] WordPress has a plugin that enables you to have a back up of your blog sent to your email or saved within your database files etc. If you’d like to know more about this there’s a video you can watch: WordPress Backup Plugin [...]
Mas Dhani said:
What different backup between Cpanel hosting and in Worpress export data?
Trackback - Cheap Internation Call >> How to make cheap international call said:
,[...] http://www.tubetorial.com is other nice source of tips on this topic,[...]
Alex said:
I sometimes forget to save files after hours of hard work. Then the computer hang suddently. I have force to re-boot the computer. All works are lost.
This is hard to imagine that the whole blog is lost!!