I got this message when I try to export my database:
"Permission to perform action denied. Please enter your user name and password" after I enter the correct password, it directs me back to th export screen, and It repeats the same thing. Does anyone have any solution to this?
Thanks,

The problem could be with your directory permission where you are exporting the file. Try changing the permission of your export directory to 777 (drwxrwxrwx).

Regards,

Eliot Lee

The export uses the "SELECT * FROM TABLE INTO OUTFILE '/path/to/file'" SQL command. In order to use this, you need to have FILE permissions enabled in mysql. It sounds like your user you are using to connect to the database does not have FILE permissions.

You'll need to check with your ISP to enable this.

Cheers,

Alex

--
Gossamer Threads Inc.

Thank you Alex and Mr. Lee.

Now I know why? I check my virtual host and they have this as the LIMITATION. I guest I have to look for another host.

Dontacc

Alex,

Speaking of exporting data...I have noticed that fields with a lot of data wrap to the next line (I am using Text Pad and Edit Plus to edit the files) when they are exported. Do you know a fix for this???

I am using the default export settings in the Export function in MySQLMan.

Thanks.

Regards,

Eliot Lee

Only thing I can think of is:

a) you have Line Wrap turned on in your editor?
or
b) you have newlines in your data.

Mysql does not escape newlines when exporting data.

Cheers,

Alex

--
Gossamer Threads Inc.

Thanks for the reply, Alex.

Nope...I am using TextPad, which has line wrap turned off as default.

If you mean break line HTML codes (< br >), yes. Other than that, no.

Regards,

Eliot Lee