MySQL Import problem [very strange]

[tidou]

Hello all

I try yo import some data into a table.

I use Win Xp Home with Mysql 4

When I type this dos command :

c:/mysql/bin/mysqlimport.exe --ignore --password=XXX --user=root --verbose --fields-terminated-by='|' --lines-terminated-by='\n' toto --local=C:\Documents and Settings\stist\Mes documents\SharpDevelop Projects\test_ok\bin\Debug\Acces.txt

I get in return this message :

'c:' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.

It seems that there is too much caracter in this command. How to fix this problem please ?😕

[bad76]

Hi,
try to look atmysql.com...
there are some example that can be usefull...

bye bye

[mourisj]

Hints:

• What about using backslashes () in the first part of the query? It looks llike your Windows takes c: as the command and /mysql/bin etc as an argument??

• Shouldn't you quote your 'documents and Settings...' thing? It contains spaces, and it might not be recognized as a folder name if it is not quoted (i.e. your parameter would be local=C:\Documents ... and the rest will be ignored

HTH

JJ Mouris

[tidou]

Thanks for help.

I thinks you have right mourisj I will try that 😉