Re: Problem when upgrading to MySql 5

Ok, when I try it from the command line, I get:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql.exe -uroot -ppass Sereni
ty < Serenity.sql
ERROR 1064 (42000) at line 13: You have an error in your SQL syntax; check 
the m
anual that corresponds to your MySQL server version for the right syntax to 
use
near '"test" (
  "OrderID" smallint(5) unsigned NOT NULL default '0',
  "ModelID" smal' at line 1

I have filled in the passworrd for root, by the way..... :)

Steve

C:\Program Files\MySQL\MySQL Server 5.0\bin>
"Todd Farmer" <[email protected]> wrote in message 
news:[email protected]...
> Hi Steve,
>
> Steve Grosz wrote:
> > Ok, I had several databases on v4.1.17 that were working fine.  I wanted
> > to upgrade to v5 to work with stored procedures and triggers a little.
> >
> > I removed the instance of 4.1.17, and installed v5.
> >
> > I backed up my tables using the MySql administrator.  When I tried to
> > import the back up, it failed.
>
> It would be interesting to see the error message you receive during the 
> import.  You might also try it directly from the command-line:
>
> C:\Program Files\MySQL\MySQL Server 5.0 >  bin\mysql.exe -uroot -ppass 
> db_name < backup.sql
>
> > I tried recreating one of the smaller tables as shown below:
> >
> >
> > CREATE TABLE `class_review` (
> ...
> >   `Rev_Class_Knowledge` int(10) unsigned NOT NULL default '0',
>
> > <cfquery name="AddReview" datasource="SalleBoise">
> > insert into class_review
> > (Rev_Class_Date, Rev_Class_Instructor, Rev_Knowledge, Rev_Part,
> > Rev_Friend, Rev_Prep, Rev_Expect, Rev_Cont, Rev_Enjoy, Rev_Comments)
> > values
> ...
> > Error Executing Database Query.
> > Unknown column &apos;Rev_Knowledge&apos; in &apos;field list&apos;
>
> Are you sure that the manually created table is identical to the 4.1 
> instance?  It seems as though you are referring to a column 
> (Rev_Knowledge) in your INSERT statement that does not exist in the table 
> definition (although there is one named Rev_Class_Knowledge).
>
>
> -- 
> Todd Farmer, Support Engineer, Americas
> MySQL Inc., www.mysql.com
>
> Discover new MySQL Monitoring & Advisory features at:
> http://www.mysql.com/products/enterprise/whats_new.html
> 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]