| |

Moving mySQL DBs between servers

Moving mySQL DBs 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.


Discover more from WIREDGORILLA

Subscribe to get the latest posts sent to your email.

Similar Posts