http://snippets.dzone.com/posts Mon, 06 Oct 2008 17:06:49 GMT DZone Snippets: transfer code http://snippets.dzone.com/posts/show/5361 // Transfer Wordpress MySQL database to new webhost in 3 steps (assumes: A. files have already been copied over, B. database created on new server, C. database user created on new server, D. wp-config.php updated on new server) <br />// 1. login to old host via ssh, run this command: <br /><code> <br />mysqldump -h DB_HOST -u DB_USER -p DB_NAME > dump.sql <br /></code> <br />// replace DB_HOST, DB_USER, & DB_NAME with info from the local wp-config.php file <br />// when asked for password, enter DB_PASSWORD from the local wp-config.php file <br /> <br />// 2. copy dump.sql to your new host using sftp <br /> <br />// 3. login go new host via ssh, run this command: <br /><code> <br />mysql -h DB_HOST -u DB_USER -p DB_NAME < dump.sql <br /></code> <br />// replace DB_HOST, DB_USER, & DB_NAME with info from the local wp-config.php file <br />// when asked for password, enter DB_PASSWORD from the local wp-config.php file <br /> <br />// adopted from this page: http://technosailor.com/2007/04/06/wordpress-faq-how-do-i-move-my-blog-to-a-new-host/ Mon, 14 Apr 2008 07:54:58 GMT http://snippets.dzone.com/posts/show/5361 SimonDorfman (Simon Dorfman)