Problem with mysqlimport

------=_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
Mysqldump Ver 9.07 Distrib 4.0.12. for Win95/Win98

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@novacontrol.ch
Internet: http://www.novacontrol.ch



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

Re: Problem with mysqlimport

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.
>=20
> 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
>=20
> Program versions:
> HostSystem: Microsoft Windows 2000 [Version 5.00.2195]
> Mysqlimport Ver 3.4 Distrib 4.0.12, for Win95/Win98
> Mysqldump Ver 9.07 Distrib 4.0.12. for Win95/Win98
>=20
> Sincerely
>=20
> Ferdi Kälin
>=20
> Novacontrol AG
> Industriestrasse 9
> CH-6036 Dierikon
> Tel.: 041 442 16 40
> Fax: 041 442 16 41
> E-mail: ferdi.kaelin@novacontrol.ch
> Internet: http://www.novacontrol.ch
=20
Hi!

mysqlimport can load only delimited data into existing tables.

You have most probably produced a script file with mysqldump .

--=20

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ 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@m.gmane.org

Re: Problem with mysqlimport

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@ 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
/ /|_/ / // /\ \/ /_/ / /__ 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@m.gmane.org