Valentina Studio ... importing data from MySQL

[Keith Hutchison]

> >> select * from preferences works ... from within Valentina Studio
> >> running against the mysql odbc dsn

> >
> > SELECT  `idpreference`,`ip`,`field`,`type`,`value` FROM `preferences`
> > works from the SQL editor so it looks like a bug within the import
> > routine.

ran
C:\analyser\data\base>mysql bms < "queries\select preferences.sql" >
preferences.txt
from command line to output text file using mysql client ... works fine.

IMported via Valentina Studio from text file .. fine.
>

> I do not understand where from comes this SELECT ???
>
> It is issued by Valentina ODBC plugin against some mySQL-ODBC source ?

>
> -------
> Jochen?
>
> It sounds to me like Keith have start big import of some mySQL db,
> Vstudio have import SEVERAL tables, and did stop near to end.
>
> May be problem in the number of tables during import.
> I self know that unlikely :-)
49 tables ... 46 imported OK
3 failed

1 recovered using text export / import
checing the other two.

-- 
Keith Hutchison
http://balance-infosystems.com http://realopen.org
http://www.kasamba.com/Keith-Hutchison