[OT] Re: mysql neat trick
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 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 -- Nick Davis Associate Systems Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 Web Development-Web Marketing-ISP Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: mysql neat trick
...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 info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql neat trick
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 -u USER -pPASSWORD > > See man mysqldump and man mysql for further options! > > I am going to use this for periodic updates from the main mysql server to the > backup mysql server. Much simpler than dumping the database on the main > server, ftp/scping it to the backup server, then inserting it into the backup > db. Why not just backup the db using it's replication features: http://www.mysql.com/doc/en/Replication.html Pete - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql neat trick
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 man mysqldump and man mysql for further options! I am going to use this for periodic updates from the main mysql server to the backup mysql server. Much simpler than dumping the database on the main server, ftp/scping it to the backup server, then inserting it into the backup db. Enjoy! Nick -- Nick Davis Associate Systems Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 Web Development-Web Marketing-ISP Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html