SO CLOSE!

[Black People Online]

I'm using coldfusion and the MYSQL Migration toolkit to create my web
application but when I'm trying to convert my access database to mysql
everything goes through the wizard fine but in the detailed report towards the
end it states:



--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report
--
--
--
-- Title: Summary Of The Migration Process
--
-- Date: 2005-06-25 11:25
--

--------------------------------------------------------------------------------


1. Schema Migration
-------------------

Number of migrated schemata: 1

Schema Name: userdata
- Tables: 8
- Views: 0
- Procedures: 0
- Triggers: 0
- Structured Types: 0

Details:

- Tables
`userdata`.`Comments`
---------------------
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
'ENGINE = INNODB' at line 9

`userdata`.`Contacts`
---------------------
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
'ENGINE = INNODB' at line 22

`userdata`.`Guestbook`
----------------------
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
'ENGINE = INNODB' at line 11

`userdata`.`Newsletter`
-----------------------
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
'ENGINE = INNODB' at line 16

`userdata`.`Orders`
-------------------
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
'ENGINE = INNODB' at line 18

`userdata`.`Subscribers`
------------------------
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
'ENGINE = INNODB' at line 20

`userdata`.`Tools_content`
--------------------------
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
'ENGINE = INNODB' at line 23

`userdata`.`UserRoles`
----------------------
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
'ENGINE = INNODB' at line 8

- Views
- Procedures
- Triggers
- Structured Types


2. Data Bulk Transfer
---------------------

`userdata`.`Comments`
---------------------
0 row(s) transfered.

`userdata`.`Contacts`
---------------------
Table 'userdata.Contacts' doesn't exist
8 row(s) transfered.

`userdata`.`Guestbook`
----------------------
Table 'userdata.Guestbook' doesn't exist
10 row(s) transfered.

`userdata`.`Newsletter`
-----------------------
0 row(s) transfered.

`userdata`.`Orders`
-------------------
0 row(s) transfered.

`userdata`.`Subscribers`
------------------------
0 row(s) transfered.

`userdata`.`Tools_content`
--------------------------
Table 'userdata.Tools_content' doesn't exist
2 row(s) transfered.

`userdata`.`UserRoles`
----------------------
Table 'userdata.UserRoles' doesn't exist
5 row(s) transfered.


End of report.

--------------------------------------------------------------------------------

I have not generated any SQL code the migration kit did it all for me, so I'm
unsure how to correct this, any help would be truly appreciated.


Thanks,

Leon ;)

[Neculai Macarie]

> I'm using coldfusion and the MYSQL Migration toolkit to create my web

> application but when I'm trying to convert my access database to mysql
> everything goes through the wizard fine but in the detailed report towards

the

> end it states:
>
>
>
> --------------------------------------------------------------------------

------

> -- MySQL Migration Toolkit Report
> --
> --
> --
> -- Title: Summary Of The Migration Process
> --
> -- Date: 2005-06-25 11:25
> --
>
> --------------------------------------------------------------------------

------

>
>
> 1. Schema Migration
> -------------------
>
> Number of migrated schemata: 1
>
> Schema Name: userdata
> - Tables: 8
> - Views: 0
> - Procedures: 0
> - Triggers: 0
> - Structured Types: 0
>
> Details:
>
> - Tables
> `userdata`.`Comments`
> ---------------------
> 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
> 'ENGINE = INNODB' at line 9

Do you have the INNODB engine active in MySQL ? If no, then make it active.
You can also try to choose a different Engine (e.g. MyISAM) in the
conversion wizard.

--
<mack />