Odd Bits - Oh C**k I deleted my site Print E-mail
Written by Richard Smith   
Monday, 01 June 2009

Oh c**k, I accidently deleted the database for my website.

Sort of luckily I have a backup a few days old but it is missing the latest content.

Will try to sort the missing content asap.

I can't stress the importance of backups!


Add this page to your favorite Social Bookmarking websites
Reddit! Del.icio.us! Mixx! Free and Open Source Software News Google! Live! Facebook! StumbleUpon! Yahoo! Free Joomla PHP extensions, software, information and tutorials.

Add as favourites (90) | Quote this article on your site | Views: 263

  Comments (3)
RSS comments
 1 Backup to gmail
Written by Ade website, on 20-06-2009 11:13
Hi,  
 
just wanted to mention a technique I use, and thats an outomated daily backup to my gmail account. I originally got this from an article someone else had done, and adapted it.  
 
It dumps two databases, compresses them, encrypts them and sends it to my gmail account 
 
#!/bin/sh 
DATE=`date +%F-%R`; 
BZFILE=/$DATE.sql.bz2; 
GPGFILE=/$BZFILE.gpg; 
mysqldump db_wiki --password="password" -u wikiusername > /tmp/wiki.sql; 
mysqldump db_wordpress --password="password" -u wpusername > /tmp/blog.sql; 
tar -cjf $BZFILE /tmp/*.sql; 
gpg --always-trust --encrypt -r This e-mail address is being protected from spam bots, you need JavaScript enabled to view it $BZFILE; 
echo 'MySQL backup is attached ' | mutt -a $GPGFILE -s 'Server backup' This e-mail address is being protected from spam bots, you need JavaScript enabled to view it  
rm $GPGFILE; 
rm $BZFILE; 
rm /tmp/*.sql;
 2 Written by Richard website, on 02-06-2009 19:11
No mate it wasn't. To justify the site and the server it's hosted on existence I use it for testing. I accidently deleted the database whilst deleting a few test ones :-( 
 
It looks like I lost some photos, an article and your last comment from the site. Could have been worse.
 3 Yikes
Written by Ade website, on 02-06-2009 10:06
Darn, thats not good !

Write Comment
  • Please keep the topic of messages relevant to the subject of the article.
  • Personal verbal attacks will be deleted.
  • Please don't use comments to plug your web site. Such material will be removed.
  • Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button.
  • Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
Title:
BBCode:Web AddressEmail AddressBold TextItalic TextUnderlined TextQuoteCodeOpen ListList ItemClose List
Comment:



Code:* Code

 
< Prev   Next >