Our JSS crashed after we upgraded to 10.8.3 and we had to restore it. Now I can't restore my DB. I get an error saying importing from command line is unsecure. We need this up ASAP!!!! Thanks for the help.
Question
Unable to Restore DB
+20
+36We ran into a similar problem where MySQL 5.6 was installed on an Xserve (instead of 5.5) and we had to take MySQL out of Strict Mode.
NOTE: The JAMF docs say to install MySQL 5.5 or later but in recent discussions, we've been told that 5.5 is the "last stable" version and 5.6 has some issues:
Can you post your /etc/my.cnf?
PS, the environment was inherited, not sure why MySQL 5.6 was installed if OS X Server already has MySQL.
<shrug>
HTH
Don
+27That warning is just that, a warning. Does the error say something like 'MySQL server has gone away'
Also are you trying to use a mysqldump by any chance? If you're trying to restore from a mysql dump you probably need to either increase your maxpacketsize or your timeout.
+36+27That one is a good thread. Someone will need it here at some point!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.