|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
When I move my site which uses a MySQL database, how would I move the whole database from the old MySQL server to the new one? URL
|
|
#2
|
|||
|
|||
|
You could use mysqldump to export the current db to textfile format, and import the output from mysqldump on your new server using the following:
mysqldump -p mydb --add-drop-table > mydb.sql (on your current server) then upload the file mydb.sql to your new server (you could use gzip to compress it) mysql -p mydb < mydb.sql (on your new server) |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > moving database from 1 server to another |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|