4.8.5 mysqldump, Dumping Table Structure and Data
Utility to dump a database or a collection of database for backup or for
transferring the data to another SQL server (not necessarily a MySQL
server). The dump will contain SQL statements to create the table and/or
populate the table.
If you are doing a backup on the server, you should consider using the
mysqlhotcopy instead. See section 4.8.6 mysqlhotcopy, Copying MySQL
Databases and Tables.
...
However, it's also very useful to populate another MySQL server with
information from a database:
mysqldump --opt database | mysql --host=remote-host -C database
http://www.mysql.com/doc/m/y/mysqldump.html
C:~
-----Original Message-----
From: erich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 7:22 AM
To: [EMAIL PROTECTED]
Subject: Select data from local database into another host over
Does anybody have an idea how to select data from a local database into
another
host server ?
For information, I'm currently using mySQL 3.23.
Eric Huwaert
Kind regards - Bien cordialement - Vriendelijke groeten - Mit freundlichen
Gr��en ,
---------------------------------------------------------------------
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
