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

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