Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them entirely.
Could you post the exact error message you're getting please?
"You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near ''Blog'' at line 1"
when line one is "DROP
TABLE IF EXISTS 'Blog';"
Two thoughts -
1) You may have a bogus hidden character in your SQL file. If you look
at it with a text editor (BBEdit, TextWrangler, etc), with the "show
invivisbles" feature on, do you see unusual stuff? Sounds strange but
I've seen stranger.
Took a brief look over it but didn't see anything that I thought looked
untoward. Nor did side by side comparison show up anything.
2) You could work around this problem a different way ...
- create a 5.0 database yourself using the standard supplied scripts,
perhaps on your own workstation
- dump your new database structure using mysqldump with the flag
--compatible=mysql40
which should create a file suitable for piping into a MySQL 4.0 server
That worked.
The gotchas:
* CHARSET wasn't exported as CHARACTER SET - it wasn't exported at all.
* TYPE is now ENGINE (ie TYPE=InnoDB is now ENGINE=InnoDB)
* The tables have gone from having an initial capital letter to all
lower caps (I thought v5 was all lower caps anyway?)
* Also an error occurred regarding varchar size (it appears v5 can hold
4096 while v4 max is 255).
Can you load a v5 server with a v4 script?
Thanks for your help!
Graham.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
