| > |
PHPFAQ - Is it possible to move my mysql database to another server? |
[Bookmark it] |
|
|
| PHPFAQ - Is it possible to move my mysql database to another server? |
|
Question : Is it possible to move my mysql database to another server?Answer :Yes it is possible using two common know mysql utilities know as mysql and mysqldump you need access to those, if you dont have access to those you can use phpmyadmin or mysqlfront.
Here is what to do:
First you need to dump your database from the old server using mysqldump as follows from a prompt:
mysqldump -h host -u user -p database > dump_file
Second you need to import the sql and data to the database using mysql as follows from a prompt:
mysql -h host -u user -p database < dump_file
After that it should be transfered correctly.
|
|
|
|
|
|
|
