BACKUP/RESTORE TABLE Access denied?

[Anon]

Trying to use the BACKUP TABLE and RESTORE TABLE commands with mySQL and I get an access denied error...

SQL-query :

RESTORE TABLE table FROM '/home/myweb/public_html/phpa/data'

MySQL said:

Access denied for user: 'myuser@localhost' (Using password: YES)

I'm using phpMyAdmin to do that. Please don't come with things like why you don't use the ASCII reload option, the database I want to restore is big enough to do not use it... limitations on the PHP file upload on a server I don't have full control).

[Anon]

Actually, this error comes from your authentication. The password you entered is incorrect or the user is.

phpMyAdmin has a file name config.inc.php. You have to set up your username and password there for it to work. I had the same problem and this was the issue.

Hope this helps

fLIPIS

[Anon]

Nope.

If the passwor I enter is not correct as you state can you tell me how I'm able to even reques the execution of the command?... If the password configured at the config file is not correct you cannot even browse the table because you cannot login into the database.

Or... am I missing something? :-)