Until the script is debugged such that the import and export features work without being returned to the login page, what portions of the script can I hard-code to enable me to import and export? I'm slowly replacing everything I can think of with my actual host, login, user and password (just in case the data is not transferring to each page), but some guidance would be greatly appreciated.
Thank you.

Import and export are just frontends for mysql's LOAD DATA INFILE and SELECT INTO OUTFILE commands and to use both comments on server files, you must have the file privilege on the server host. You can see the docs at:

http://www.mysql.com/Manual_chapter/manual_Reference.html#LOAD_DATA

--
Gossamer Threads, Inc.

Because I am able to successfully add data to the mysql databuase using DBMan-SQL, I believe I have privileges to import and export data. I think Jack is going to have a programmer look into the situation today, and Jack has all of the password information, etc. The script locations are listed below. Thanks for working on my problem - your help is greatly appreciated.

http://lawlist.com/cgi-bin/dbman-sql/db.cgi

http://lawlist.com/cgi-bin/mysqlman/mysql.cgi

Keith D. Bershatsky
LAWLIST.COM
esq@pacbell.net

My web-host has advised me that I do indeed have import and export privileges. Copies of the communications between myself and the web-host are enclosed herein. Thank you for your continued assistance. Keith.

Communication from my web-host: Dear Keith, Thank you for your inquiry concerning your problem with your mySQL database. You do have import and export privileges with your database. Can you send us in the error message that you are receiving so that we may better troubleshoot your problem. Thank you again for your inquiry. Should you have any other questions or issues, please do not hesitate to contact us. [In response to Keith's letter: Do I have import and export privileges to LAWLIST.COM mysql database? I am having trouble importing data from a pipe delimited text file. This is what a programmer sent to me: Import and export are just frontends for mysql's LOAD DATA INFILE and SELECT INTO OUTFILE commands and to use both comments on server files, you must have the file privilege on the server host. You can see the docs at: http://www.mysql.com/Manual_chapter/manual_Reference.html#LOAD_DATA]

steven_chen,
Any news on this? I also have proper permissions yet I get kicked out to the login screen when I try to export to a file.

To verify you have proper permissions, can you enter into the SQL monitor:

SELECT * FROM tablename INTO OUTFILE '/path/to/somewhere'

where tablename is an existing table. Does this work? If not, then you don't have FILE permission in Mysql and should ask your ISP to make sure you have FILE permission enabled.

If it does work, then there is something with the code we will have to look at, but from our tests I can't see anything obviously wrong.

Cheers,

Alex

--
Gossamer Threads Inc.