how to import a text file into the mysql database

2001-08-28 Thread Chakravarthy K Sannedhi 

hello all,

i am trying to install web calendar software on my machine, which is
available at sourceforge.net website. to run that software first of all
a textfile named tables-mysql.sql needs to imported into the mysql
database. for doing that i typed the following command at the shell
prompt

shell # mysqlimport -u root -p webcalendar tables-mysql.sql

where, 'webcalendar' is the database that i have created for this
purpose. after entering the password at the password prompt it is
displaying the following error:

mysqlimport: Error: You have an error in your SQL syntax near
'tables-mysql' at line 1, when using table: tables-mysql

how can i avoid this error?

TIA

=
Chakravarthy K Sannedhi
Research Assistant, CTER, UAB
Birmingham, AL-35205
Ph: (205) 821-6805 (M)
http://www.dpo.uab.edu/~kalyan

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to import a text file into the mysql database

2001-08-28 Thread Daniel Woods 

 shell # mysqlimport -u root -p webcalendar tables-mysql.sql
 
 where, 'webcalendar' is the database that i have created for this
 purpose. after entering the password at the password prompt it is
 displaying the following error:
 
 mysqlimport: Error: You have an error in your SQL syntax near
 'tables-mysql' at line 1, when using table: tables-mysql

Looks like there's nothing wrong with the command. Instead, you
have bad sql syntax on line 1, or first uncommented line in the
tables-mysql.sql file.

Thanks... Dan.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php