Re: Problem when upgrading to MySql 5

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]