Skip to main content
Question

Moving MYSQL DB

  • May 20, 2011
  • 4 replies
  • 18 views
A
  • Anonymous

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

    J
    Forum|alt.badge.img+24
    • jarednichols
    • Valued Contributor
    • May 23, 2011

    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

    A
    • Anonymous
    • May 23, 2011

    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
    Forum|alt.badge.img+28
    • RobertHammen
    • Esteemed Contributor
    • May 23, 2011

    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

    A
    • Anonymous
    • May 23, 2011

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

    Terms & ConditionsCookie settingsAccessibility statement