Re: Differences between MySQL 4 and 5 for scripts

[Dan Buettner]

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.
> 
>