MySqlLoader problems

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
vikramka
Posts: 2
Joined: Sat 10 Sep 2005 04:15

MySqlLoader problems

Post by vikramka » Sat 10 Sep 2005 04:25

Can someone please help me with this problem...

I am using MySqlLoader to try and load some data into the tables and I get this error

Mesg: Table storage engine for 'tablename' doesn't have this option
InnerExeption:
Source: CoreLab.MySql
StackTrace: at CoreLab.MySql.MySqlLoader.b()
at CoreLab.MySql.MySqlLoader.a(Boolean A_0)
at CoreLab.MySql.MySqlLoader.Close()
at MyProj.BL.DataLoadManager2.LoadPData(Int32 start, Int32 end, MySqlCon
nection conn) in c:\projects\new\myproj.bl\dataloadmanager2.cs:line
59

My tables are running on InnoDb engine.
Help will be much appreciated.

REgards

Serious

Post by Serious » Mon 12 Sep 2005 07:09

You have to set MySqlLoader.Delayed = false.
For more information see MySqlLoader.Delayed property reference.

vikramka
Posts: 2
Joined: Sat 10 Sep 2005 04:15

Post by vikramka » Tue 13 Sep 2005 13:27

Thanks for the info. I will try it out.
Just for info. what does MySqlLoader use under the covers to load the data. I mean why is it faster than using mysqlCommand.

Serious

Post by Serious » Tue 13 Sep 2005 13:45

MySqlLoader is faster due to optimized query data storage and using low internal levels of MySQLDirect .NET.

Post Reply