Re: Database Backup
| From: | Jeff P | Date: | Mon, 08 Jan 2001 04:42:19 +0000 |
| Subject: | Re: Database Backup | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-33180@lists.php.net to get a copy of this message | ||
> We maintain a MySQL database. What is the
> best way to back this database up, such that
> if the machine crashed and needed a format and
> reinstall, I could easily restore the
> database?
look at mysqldump - dumps all the tables to a text
file, which can then be dumped back into mysql at
a later point.
best,
Jeff