I am having a ton of problems and I hope someone here can help me.
First. I am new to mysql so bear with me.
My web server host is cihost running on Red Hat Linux 4.2,
Server Software Apache 1.3.4,
I had them set up a database on their server to use. I installed the
myodbc driver and tried to connect and it failed. I contacted my host about
my problems. They stated that they did not allow remote access to the sql
server. They than told be that there was no ODBC support and I would have
to move to an NT server( of course doubling my fees ).
Now since I don't want to go through the ordeal of finding another host who
could provide what I am getting at the same price, I thought I would just
use telnet to do my import/export.
When I try to use LOAD DATA INFILE 'RWTest.txt' INTO TABLE testaa
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';
I get an error that ./test/RWTest.txt does not exist.
I do not have root access to the server and infact I am unable to even
telnet directly to the mysql server( I have been set up as Local Host
through a UNIX socket). I can only load the files into my virtural server (
www.sbenterprise.com/hold ) directories. How can I use this command?
The other concern is when trying to export the data it saves the file to
the mysql server and I can't get it to save it to my directory.
CIHost has not been helpful with this problem and I was hoping someone who
may have a similar setup would be able to help me out.