How to handle permalink of sites when migrating a wordpress website

What i want to do: Develop a Wordpress-based website with a local Wordpress installation (and xampp). Migrate this developed website on my webserver.

What's the problem: After putting the website on the webserver each link in the navigation references to "127.0.0.1/wordpress/...". I'm not even able to login to the Wordpress Backend on the webserver, because the "login.php" (or something) is also referenced on the localhost"

My Question: Do any of you know how I can change this permalinks to the URL of the webserver the website is actually deployed on?

best regards matt

edit: Another thing that i noticed is, that although I changed the URL in the wp_posts table manually, this database entries are changed by wordpress, so next time, after opening the website, the URLs in the database contains the 127.0.0.1 part

Answers


When migrating the database from your local machine to a remote server, you should export your mysql database that is on your local machine to a file. Then perform a search and replace changing "127.0.0.1/wordpress/..." to "www.yourdomain.com/path/to/wordpress" and then import that file to your new mysql database.

Since you have already moved everything over, you can just export the database tables from your remote server to a file, do the search and replace on that, and reimport it. When exporting the database make sure to check "Add Drop Table / Drop View".


It's very simple, do everything you need in local, when you're ready to deploy, export your local database from phpMyAdmin, open the file and do "search and replace" your local path with your server path.

Chnage the connection string inside config.php and you're done.


Need Your Help

How to send files to other iPhones via Bluetooth

iphone objective-c ios ipad bluetooth

I'm doing a little app to allow users to edit and share text fast on the iPhone.

what is a data serialization system?

hadoop distributed-computing data-serialization

according to Apache AVRO project, "Avro is a serialization system". By saying data serialization system, does it mean that avro is a product or api?