------=_NextPart_000_0004_01C30EF3.35147200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello
I=92m evaluating MySQL and I get an error (version problem), if I try to
import a table with mysqlimport. The table, which I wanted to import,
was generated before with mysqldump.

Shell>mysqlimport =96user=3Droot =96password=3Dproper =96delete =
=96verbose proper45
d:/MySQL_Backup/proper45/grdcel
Connecting to localhost
Selecting database proper45
Deleting the old data from table grdcel
Loading data from LOCAL file: d:/MySQL_Backup/proper45/grdcel into
grdcel
Mysqlimport: Error: The used command is not allowed with this MySQL
version when using table: grdcel

Program versions:
HostSystem: Microsoft Windows 2000 [Version 5.00.2195]
Mysqlimport Ver 3.4 Distrib 4.0.12, for Win95/Win98 <i32>
Mysqldump Ver 9.07 Distrib 4.0.12. for Win95/Win98 <i32>

Sincerely

Ferdi Kälin

Novacontrol AG
Industriestrasse 9
CH-6036 Dierikon
Tel.: 041 442 16 40
Fax: 041 442 16 41
E-mail: ferdi.kaelin [at] novacontrol.ch
Internet: http://www.novacontrol.ch



------=_NextPart_000_0004_01C30EF3.35147200--

Ferdi Kälin writes:
> Hello
> I=92m evaluating MySQL and I get an error (version problem), if I try=
to
> import a table with mysqlimport. The table, which I wanted to import,=

> was generated before with mysqldump.
>
> Shell>mysqlimport =96user=3Droot =96password=3Dproper =96delete =96ve=
rbose proper45
> d:/MySQL_Backup/proper45/grdcel
> Connecting to localhost
> Selecting database proper45
> Deleting the old data from table grdcel
> Loading data from LOCAL file: d:/MySQL_Backup/proper45/grdcel into
> grdcel
> Mysqlimport: Error: The used command is not allowed with this MySQL
> version when using table: grdcel
>
> Program versions:
> HostSystem: Microsoft Windows 2000 [Version 5.00.2195]
> Mysqlimport Ver 3.4 Distrib 4.0.12, for Win95/Win98 <i32>
> Mysqldump Ver 9.07 Distrib 4.0.12. for Win95/Win98 <i32>
>
> Sincerely
>
> Ferdi Kälin
>
> Novacontrol AG
> Industriestrasse 9
> CH-6036 Dierikon
> Tel.: 041 442 16 40
> Fax: 041 442 16 41
> E-mail: ferdi.kaelin [at] novacontrol.ch
> Internet: http://www.novacontrol.ch

Hi!

mysqlimport can load only delimited data into existing tables.

You have most probably produced a script file with mysqldump .

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa [at] mysql.com=
>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org

Hello,

Ferdi Kälin wrote:
> Hello
> I’m evaluating MySQL and I get an error (version problem), if I try to
> import a table with mysqlimport. The table, which I wanted to import,
> was generated before with mysqldump.

Dump files created with mysqldump are usually imported with mysql command line client.

mysql -u user -p < dumpfile


By the way bugs [at] is not proper list for such type of questions as it is dedicated
for bugs reports with repeatable test case.

Best regards

--
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <salle [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org