Moving MYSQL DB

Not applicable

OK...

We recently discovered that our Casper Server is under powered and the JSS is continually locking up. Our JSS currently is running on Mac OS X 10.6.7 Mac Mini. We are moving it to a Server 2008 R2 Standard. I have the JSS installed on the Windows server, but I am having problems moving the DB from the Mac to windows machine. Is there anyone that can put me on to a good procedure?

Thanks,

Shannon L Rico
Sr. Network Engineer
GISD
d: 972-487-3663
c: 214-882-3621

4 REPLIES 4

jarednichols
Honored Contributor

Where's your trip up?

j
--
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436

Not applicable

Well basically...

I exported the jamfsoftware .sql out of the JSS utility, and tied the new MySQL on WIndows to that file per the Setup instruction. when I logon to the webapp, nothing is in there. I tried the mysql dump and no luck. I have sql.gz file created by the backups on the MAC server. Truth be told, it is likely I am putting the DB in the wrong place. Any guidance would be appreciated?

Thanks,

Shannon L Rico
Sr. Network Engineer
GISD
d: 972-487-3663
c: 214-882-3621

RobertHammen
Valued Contributor II

Just confirming the version of Casper that you installed on 2008R2 is the same as what you're currently running (i.e. you can't import a 7.3 DB into MySQL if you're running Casper 8.1, without running the upgrade scripts first).
On May 23, 2011, at 9:24 AM, Shannon Rico wrote:

I've done this, with the assistance of JAMF Support (since I'm no SQL wiz), and this is one of my criticisms of the cross-platform guide - that this step's not documented...

--Robert

Not applicable

Yep...we found the issue for whatever reason we had some corrupt dumps finally got a good one and it is up and running