How to transfer from localHost to live but use the already existing database on the server?

by Kieran   Last Updated June 12, 2015 23:03 PM

I have been developing a WordPress website for a client, working from my own machine utilizing WAMP to create a local environment on which to work.

Now, the problem is that the website needs to go live. I understand how to use an FTP client, and that's not a problem. I have the details for the domain etc. There is an existing website already there, and I would like to know if it's possible to upload the new website while keeping the old one running, but that is not the main issue.

I have been having trouble transferring the website from one machine to another, and I believe that this has to do with properly exporting/importing the database. This is the area that I am struggling with. To make things even more difficult, I wish to upload the new website to the server but use the database that is already in place with the existing website, for the client's benefit. Is this possible? How would I achieve this? If it is not, what are my alternatives?

Apologies for the short essay, but I thought it best to paint as clear a picture of my situation as possible. Thanks in advance for time taken to read/respond to this.



Answers 2


If your client's existing site is a wordpress site and you just want to use your new theme then you can just upload the theme from your local PC to the remote server and change the theme out in the remote backend.

Either way, how you run both sites simultaneously will differ depending on your exact setup.

As far as transferring your database goes, I assume you're exporting it as a .sql file? After you export it from your local database, open the file in a text editor (Notepad++ works well), do a search/replace on the file to replace http://localhost to http://yourdomain.com. Then upload the modified sql file to the remote database. You'll also have to open the config.php file in the root of your wordpress directory and change out the database credentials to be those of the remote database.

GentlemanMax
GentlemanMax
June 12, 2015 17:34 PM

You can easy plugin transfer to other host https://wordpress.org/plugins/wp-clone-by-wp-academy/

localhost 1: first install plugin your localhost wordpress. 2: goto wp clone create local backup. 3: copy backup .zip upload any host/server.

host/server 1: first install plugin your host/server wordpress. 2: goto wp clone select restore backup. 3: localhost backup link paste.

enjoy

Jbbhatti
Jbbhatti
June 13, 2015 13:44 PM

Related Questions



WAMP to XAMPP WordPress transfer

Updated June 19, 2015 23:03 PM




Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-9-191310-how-to-transfer-from-localhost-to-live-but-use-the-already-existing-database-on-the-server- could not be written