What would be a propper way to back up a huge db while server is up
| From: | andy | 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