Dear Claudemir,
you can use
mysqldump --all-databases > my_dump_file.sql
which will make restore possible on *any* operating system. It creates
quite a big file (because of all the create / insert statements) - which
might be slow to transfer to / from an internet machine. It's a bit
faster if you use
cp /var/lib/mysql/* -R /some/safe/place
In this case, make sure you use MyISAM files as this table type is
interchangeable and runs on any operating system.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Claudemir F. Martins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 9:01 PM
Subject: Backup of all Databases
> Hello
>
> I took a look at the discussion of database backup, however I still
have a
> doubt:
>
> I have 30 databases and I'd like to backup all databases at a time
(including
> the mysql database).
>
> Is there a good way to backup all databases at a time ?
>
> To save the directory /var/lib/mysql which contain all databases, is
a good
> idea for a backup ?
>
>
> Regards
>
> Claudemir F. Martins
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php