mysql backup and restore
July 29th, 2005
Backing up and restoring a mysql (or any) database is pretty easy as there are mulitple methods. Amongst those methods is the outright copying for the datafiles for the database. The datafile method is pretty simple, but requires the database to be shutdown to work. As a note this method also works with most database systems I've run into, though some require a bit more effort. For instance mssql requires the database to be attached using sp_attach. The other method involves using database dump utilities (mysqldump, pgdump) to export the data.
Todays javascript tidbit of the day is the for/in loop, which has just recently found its way into java (though it has been in C# since its inception).
November 8th, 2006 at 06:00 PM Hyesco is my company, focusing on Embedded System design. Hope to see some opportunity for cooperation.
ARM Processor application
http://www.hyesco.com
http://www.hyesco.com/products/atmel_arm.html
November 8th, 2006 at 06:00 PM i use mysqldump & crontab to make a hot replica of our web database. it's a hack since the data could be as old as 30 minutes, but till i have the time to setup a cluster it'll have to do.