I just figured this out and thought some others might benefit from it!
Here is how you dump database(s) on one server into a database on another
server!
mysqldump --opt -a LOCALDBNAME [LOCALTABLE1 [LOCALTABLE2]] -u USER -pPASSWORD
| mysql --host=REMOTEHOST REMOTEDBNAME -u USER -pPASSWORD
See
Nick Davis wrote:
I just figured this out and thought some others might benefit from it!
Here is how you dump database(s) on one server into a database on another
server!
mysqldump --opt -a LOCALDBNAME [LOCALTABLE1 [LOCALTABLE2]] -u USER -pPASSWORD
| mysql --host=REMOTEHOST REMOTEDBNAME
...which is also described on pp. 111-112 of the RADIUS book.
Replication is a lot easier to control and use.
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]]
Why not just backup the db using it's replication features:
http://www.mysql.com/doc/en/Replication.html
Pete
-
List
Yes, I am aware of doing Replication. Due to some system issues, I cannot do
that. That is why I am happy to use that nice long command I found in the
mysqldump man page.
Thanks for the idea though!
Nick
On Friday 31 January 2003 18:10, Jonathan Hassell wrote:
...which is also described on
