Thanks to all the people that follow mytweets and blog posts. 2010 hasn't been the greatest of years for me personally but here is to 2011 being a lot better! (with more posts)
This isn't rocket science but probably something good to share for anyone making the move to Linux for web hosting. Below is a quick script that I run daily to back up all MySQL DB's which then have placed somewhere safe.
Open Nano/Vi/Gedit and create a file called mysql_backup.sh then add the following lines:
At the moment this is just a text file which cannot be executed via the terminal, so to fix this run the following:
Then you can run this as any normal shell script
There is a lot more you can do with this like moving the file to another location, delete the dump behind you etc, but this should give you a good starting ground.
Please update your bookmarks and feeds for my site.
I now have a Mango Blog at:
http://www.andyjarrett.com/blog
Feed URL: http://feeds.feedburner.com/andyjarrett
You always find these things out after the fact, but VMWare do provide an image of Ubuntu 8.04 Jeos with VMware Tools and a OpenSSH Server pre-installed.
Once you go through a simple registration process you are offered a couple of options to download i.e. via Torrent, HTTP
Find out more at http://www.vmware.com/appliances/directory/1363
As a side note, Virtual Appliance Marketplace actually offers a range of pre-compiled images for download which is worth looking into if you want to try out an OS etc. There is even an Open BlueDragon image there, pre-built and ready to deploy.