We want to move database from one virtual server to the other. Need help...

On the old server we have only user rights access to our database. So we cann't use such command as mysqldump. Could you suggest a way to move the database?

Of course we can use the command SELECT FROM * table into OUTFILE 'foo.txt'; but unfortunately we don't know where will be created the output file. And our hoster does not want to tell us this information ;-(.



------------------
The Russia Journal

If you have telnet access you can still use mysqldump.

mysqldump -u yourusername -ppassword databasename > /path/to/your/root/sql.txt

If not, you can install phpMyAdmin to your site and use it (if you have PHP support)

Super!

It works. My hoster have lost $100 which he wanted for this operation.

Thank you very much,
Alex.

------------------
The Russia Journal