|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
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) |
|
#3
|
|||
|
|||
|
Super!
It works. My hoster have lost $100 which he wanted for this operation. ![]() Thank you very much, Alex. ------------------ The Russia Journal |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > We want to move database from one virtual server to the other. Need help... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|