Hi, so the backup does need 2 hours? How big is our database?! Thats very, very long... A first idea would be mysqlhotcopy, which does the locking etc. for you - and copy the raw database files (instead of making sql-files which can take ages). Informations are under http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy.html . It can do things e.g. skipping the index files which can be rebuilt, flush the logs etc.
Another approach is using a lvm under the database-files. This way you get at least a consistent version which are on the HDDs. Yes, you loose all information which are only in the RAM, but that shouldn't be too much - und if you need to replay backups you loose always by average 12 hours - so 5-10 minutes more ore less aren't that important ;) Best regards, Michael Fritscher _______________________________________________ Ros-dev mailing list Ros-dev@reactos.org http://www.reactos.org/mailman/listinfo/ros-dev