How to Automate your MySQL database backups

/* Posted May 5th, 2008 at 11:00am [Comments: none] */
/* Filed under PHP, Programming */

mysql

for automating backups, you can use this: http://www.mysqldumper.de/en/

\or you can run this automatic script

Here’s an essential automatic script and a cron job you will need in order to keep your backup automatic.

Yes, if you get a dedicated server, don’t get their stupid extra $15/month for backing up your database. (All they do is make scripts like this one and charge you for it)

You can follow this example and go spend that money on junk food.

So all you have to do is FTP your backup files.

This is way better than going into your phpMyAdmin and downloading from the web interface since the file is already ready for you to download.

Here’s how you do it:

1) Make a new file called backup.sh in your home directory. 2) Use the following syntax:

Read more »

  • Digg
  • del.icio.us
  • Propeller
  • Reddit
  • Slashdot
  • StumbleUpon
  • Technorati
  • Mixx
  • NewsVine
  • Blogsvine
  • Facebook
  • Google
  • TwitThis

Useful Quick References

/* Posted March 17th, 2008 at 10:12pm [Comments: none] */
/* Filed under C#, C/C++, CSS, HTML, Microsoft, PHP, Reference, Ruby */

Whether you program in C++ or code in HTML, you’ve probably encountered a quick reference (”quickref” for short) at some point in your career. These handy guides aren’t meant to teach newbies how to use the language, but are more like the index at the back of your textbook except condensed and consolidated in a few pages. Today’s post lists a few useful quickrefs that I’ve accumulated over the years. Read more »

  • Digg
  • del.icio.us
  • Propeller
  • Reddit
  • Slashdot
  • StumbleUpon
  • Technorati
  • Mixx
  • NewsVine
  • Blogsvine
  • Facebook
  • Google
  • TwitThis

Anything Geeky Goes!

Highlights

Featured Wii

Featured iPhone

Featured PSP/PS3

Featured A/V

Related Links

Archives

Products Highlight


Featured Sites

Categories

Subscribe

  • rss 1.0 feed
  • rss 2.0 feed
  • atom feed
  • atom feed
Email:

Recent Posts

Commentors

Other Links