|
Moving mySQL DBs between servers |
|
Saturday, 17 September 2005 |
This is one of those things that I found when perusing the Textpattern forums. It seems like a useful thing to know.
This was in answer to the question about moving a Textpattern weblog (which is stored in a mySQL database) from one server to another:
mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql
puts the entire thing in one nicely portable text file.
on a new server it takes
mysql -uUSER -pPASSWORD txp_database < txp_database.sql
to import it.
|
