What would be a propper way to back up a huge db while server is up

From: Date: Wed, 03 Apr 2002 17:28:16 +0000
Subject: What would be a propper way to back up a huge db while server is up
Groups: php.db 
Request: Send a blank email to php-db+get-18169@lists.php.net to get a copy of this message
Hi there, how would a backup procedure look like on a mysql server with root access to make a backup while the db is up and running. As fast as possible The db is more than 100 MB. Would this be: - lock all tables writing (how would I do this on the whole db containing lots of tables?) - flusch the tables (the whole db? How?) - copy the dirs with the dbs - unlock the db (how?) Thanx for any help, Andy

« previous php.db (#18169) next »