I've been using Bullzip to export from Access as .sql files in the past, and it's been great, but I've just tried on a new server and it just won't import properly. The server guy suggests that
"A compressed file's name must end in .[format].[compression]. Example: .sql.zip . SQL compatibility mode should be in MYSQL 323 or MYSQL 40"
and that I need to sort it. There just doesn't seem to be the options available in Bullzip.
The MySQL database contains all the correct data, but the tables have somehow been renamed during import to 'test_prefixusers' instead of 'users' and 'test_prefixworks' instead of 'works'.
Anybody got any ideas?
"A compressed file's name must end in .[format].[compression]. Example: .sql.zip . SQL compatibility mode should be in MYSQL 323 or MYSQL 40"
and that I need to sort it. There just doesn't seem to be the options available in Bullzip.
The MySQL database contains all the correct data, but the tables have somehow been renamed during import to 'test_prefixusers' instead of 'users' and 'test_prefixworks' instead of 'works'.
Anybody got any ideas?
