RE: move database with Java

2013-09-17 Thread Mark A Kruger
8:14 AM To: cf-talk Subject: move database with Java Hey Guys, i know this is not necessarily a cf question. i know next to nothing about java, other then creating a scheduled job to copy a table. now my employer has tasked me with moving or backing up a MySQL DB from one server to another. to

Re: move database with Java

2013-09-17 Thread Matt Quackenbush
Super simple, as long as you don't try and reinvent the wheel (i.e. don't do it with CF). Use mysqldump to create a dump of the db, then put that file wherever you need it to be. There are a variety of data transfer options out there, but it'll depend upon your servers, etc. HTH On Tue, Sep 17,

move database with Java

2013-09-17 Thread morchella
Hey Guys, i know this is not necessarily a cf question. i know next to nothing about java, other then creating a scheduled job to copy a table. now my employer has tasked me with moving or backing up a MySQL DB from one server to another. to me this sounds crazy. but i am not supposed to use cf,