On 24/11/2011 11:24, Barry Samuels wrote:
On 24/11/11 10:35:01, Chris Green wrote:
I've been developing a simple web site for someone using WordPress (along with zillions of others I believe).
I've now discovered that it is horrendously awful to move it to another domain! Not only are links in WordPress absolute but there are also loads of database entries which have the absolute URL in them.
-- Chris Green
I have a web site that uses a Wordpress installation and when I want to change the path in the database I do a database dump which produces a mysql file in text form. It's easy then to do a search and replace within that text file and then clear the database and import the result.
Hi Chris,
I look after several WP sites, and yes, they have absolute URLS in the database. However, moving them is not a problem, as Barry has mentioned above. That's the best and safest method, and not too onerous.
That said, WP being WP, there's always a plug-in! Maybe this one would help:
http://wordpress.org/extend/plugins/wp-migrate-db/
"WP Migrate DB
Exports your database, does a find and replace on URLs and file paths, then allows you to save it to your computer."
and:
"WP Migrate DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, then allows you to save it to your computer. It is perfect for developers who develop locally and need to to move their WordPress site to a staging or production server.
It even takes into account serialized data and updates the string length values."
I found a couple more too, but as with the one above, I have never used them:
http://www.mertyazicioglu.com/projects/wordpress-move/ http://myeasywp.com/plugins/myeasybackup/
HtH!
Cheers, Laurie.