...

Moving mySQL DBs between servers

gorilla-chimp

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 now to keep reading and get access to the full archive.

Continue reading