Re: mysql backup
| From: | Henrik Hansen | Date: | Thu, 22 Mar 2001 21:00:12 +0000 |
| Subject: | Re: mysql backup | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-45182@lists.php.net to get a copy of this message | ||
"McShen" <webmaster@celebritieszones.com> wrote:
> hi
>
> how do i back up a mysql DB table? Can you please write me the code?
i would just stop the database server and dump the table to a file
with mysqldump, just run it from the command line for example:
/path/to/mysqldump -h host -p password -u username databasename >
/path/to/file
then you have a comple dump of your database and database structure.
--
Henrik Hansen