Lectori Salutem,
as Stefan states here (und natürlich ganz richtig, Stefan) mysqldump is
*the* way to backup, and it will create large files. However, since you get
clear-text human readable text in the outfile -being all the mySQL commands
needed to recreate the database(s)- they're easy to compress with a pretty
good ratio.
Under linux, it's as easy as:
mysqldump --all-databases | gzip -c > my_dump_archive.sql.gz
To get the SQL-commands back, unzip the archive:
gzip -d my_dump_archive.sql.gz
To restore the databases, run the console output of gzip through mysql:
gzip -cd | mysql -u root -p<mypassword>
Of course, most of this could have been found in the list-archives on
http://lists.mysql.com
Regards,
Sebastiaan J.A. Kamp
General Manager
VOF Post Zero
Hoogstraat 98a
3011 PT Rotterdam
tel. +31 1 04199140
fax. +31 1 04111335
@to: [EMAIL PROTECTED]
Erasmus University Rotterdam
L Information & Automation
Room L5-040, Woudestein
Burgemeester Oudlaan 50
3062 PA Rotterdam
tel. 010-4088638
@to: [EMAIL PROTECTED]
Executive Officer
Safenet BV
van Galenstraat 35
2518 EN Den Haag
tel. 070-3642968
fax. 070-3454537
@to: [EMAIL PROTECTED]
=>-----Original Message-----
=>From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
=>Sent: maandag 30 juli 2001 20:51
=>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
=>Subject: Re: Backup of all Databases
=>
=>
=>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
---------------------------------------------------------------------
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