Re: Database backup
| From: | David Robley | Date: | Thu, 28 Aug 2003 03:22:21 +0000 |
| Subject: | Re: Database backup | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30163@lists.php.net to get a copy of this message | ||
In article <000a01c36c1b$78962b10$0101a8c0@chrisu8knchy5g>,
chris@planetoxygene.com says...
> Hi there everyone,
>
> Is there a quick way I can backup all my databases on Linux so I can download them to my
> HD/Burn them onto CD?
>
> I've started a very large travel project and there is going to be over 100 DB's in
> the end, each with who knows how many tables and going through PHPMyADMIN and exporting 1 DB at a
> time is going to take forever.
>
> My Server is the Rehat Linux 8.0 with Apache and MySQL and PHP.
>
> Thanks, any help would be really appreciated (And save me alot of headaches).
>
> Chris
If you have command line access you can use mysqldump.
--
Quod subigo farinam
$email =~ s/oz$/au/o;
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?