Trouble uploading/importing files to MySQL server 1

[MishaD]

I keep getting an error message that the file I'm trying to upload cannot be found. Could someone please reply with an example using the proper syntax for importing data using the LOAD DATA command? <br>
<br>
I tried:<br>
<br>
LOAD DATA LOCAL INFILE 'test_db.csv' INTO TABLE admintest<br>
FIELDS TERMINATED BY ',' ENCLOSED BY '"'<br>
LINES TERMINATED BY '\r';

 

[Damon]

Are you trying to get the data from a file on the local hard drive, or from another data source?

 

[MishaD]

I'm trying to get the file from one of my local drives and send it via telnet to a remote server where I have a MySQL database hosted. It may be to that the version of MySQL on the server isn't recent enough. The MySQL documentation says LOAD DATA LOCAL works with version 3.22.6, whereas the version on the server is MySQL 3.22.21.

 

[kuro5hin]

If you telnetted to the remote host where your mysql server lives, and ran "mysql" there, it will only find files on that machine (not the one you're telnetting from). Try ftp'ing the file up to the remote machine first, or try a client like XmySQL, which I've found useful for one-off type admin/access stuff (loading data, creating db's etc). You may also be able to run mysql monitor on your local machine and connect to the remote db. In fact, I'm sure you can, but I've never had to, so I don't really know how