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?
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.
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
Dan
Graham Reeds wrote:
I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided to see what I can do to make the database creation scripts
MySQL4 compliant. The CHARSET was the easy one - just change it to
CHARACTER SET but the next one was more tricky:
The problem I am having is that version 4 fails giving a syntax error
for the single quotation marks. It appears the script (which was written
on a Mac using MySQL dump 10.9 if that is any help) uses ` and not ',
but doing a general search and replace doesn't fix it. I've searched
the online docs regarding quotes but came up short (too many hits with
too many unrelated items) so if anyone knows the exact url that would be
helpful too.
Here's a snippet of the code:
DROP TABLE IF EXISTS `Blog`;
CREATE TABLE `Blog` (
`blog_id` varchar(50) NOT NULL,
PRIMARY KEY (`blog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Thanks, G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]