mysqlscript.sql does not load with new MySQL GUI Tools
Brought to you by:
maz1980
MySQL has a new set of GUI tools and the recommended
MySQL Control Center is no longer supported, preferred,
distributed, etc. I tried to load the script in the
MySQL Query Browser (v1.2.3beta on Mac OS X 10.4.7
PPC), but it dies after the first table is created.
Complains it is not running in order or something.
I was able to get it to load (removed the create DB and
use DB lines) using PhpMyAdmin 2.9.0.1.
Once that worked, I performed a Backup using the new
MySQL Administrator tool (1.2.3rc - again on same Mac
OS X machine), which generated the attached SQL script.
This one *should* be able to be used with the new MySQL
GUI tools - specifically using it with the Restore
function in MySQL Administrator.
zCI DB Creation (Restore) for MySQL Administrator