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.