mysql backup and restore
Sat, Jul 30, 2005Backing 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).