Re: What would be a propper way to back up a huge db while server is up
| From: | andy | Date: | Wed, 03 Apr 2002 17:29:17 +0000 |
| Subject: | Re: What would be a propper way to back up a huge db while server is up | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18170@lists.php.net to get a copy of this message | ||
oh ... on MySQL
"Andy" <news.letters@gmx.de> schrieb im Newsbeitrag
news:20020403172710.66625.qmail@pb1.pair.com...
> 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
>
>