Do mysql databases remember?

  • Resolved nialldcrowley

    (@nialldcrowley)


    13 years, 8 months ago

    I’ve been developing a wordpress theme and uploading into in a folder on my server so my client could view it away from prying eyes and the old website could continue undisturbed for now. Now it’s ready to go, I’ve deleted the old folder, uploaded WordPress, my theme, plugins etc to the main domain folder (www.futurecities.org) but when I go to http://www.futurecities.org/wp-admin I am redirected to the old site (which is why I deleted it but it still redirects).

    The only thing I can think of is the wp-config file and the mysql database details. I had to use the same details because I don’t have full access to the server.

    Could this be the problem? Is the mysql database set now to look for the old version of my site?

    Any help appreciated.

    PS. There’s an index.html holding page there right now but that’s not the cause of the problem, I’m certain.

Viewing 12 replies - 1 through 12 (of 12 total)
  • esmi

    (@esmi)

    13 years, 8 months ago

    Is the mysql database set now to look for the old version of my site?

    almost certainly. Have you reviewed Moving_WordPress?

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    Thanks. I read it yesterday and it was pretty heavy going. As I’ve uploaded and set up a few WP sites before I thought I’d be okay. Thing is, before it’s been on my own server space so I’ve always created a new database. I have no idea how mysql databases work but I was a little worried this time that there might be a problem. If I get the server admin to create a new database, do you think that should work?

    esmi

    (@esmi)

    13 years, 8 months ago

    Yes. Are you just uploading the theme and perhaps some plugins? Or the site content as well?

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    I downloaded the latest version of wp, added my theme, my pluggins, and changed the config file so had same details I’d been given by the server administrator, but they were the same as the ones I’d used for the development site (the one you helped me with yesterday).

    esmi

    (@esmi)

    13 years, 8 months ago

    Ok – so what you need is details of the new database, db user, password and host from the server administrator. add them to the remote site’s wp-config.php file and you should then be able to install WordPress on the server. Right now, all you’re doing is picking up the dev site.

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    Right, he’s given me a new database and I’ve altered the config file accordingly.

    It’s no longer redirecting but I’m now getting an ‘Error establishing a database connection’ page. I’m fairly certain all my details are correct so I’m a bit stuck again. I’m wondering if the server needs a little time for the database to come online? Or maybe I should reinstall all the wp files?

    esmi

    (@esmi)

    13 years, 8 months ago

    Check the database details with the server admin.

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    Hi esmi,

    yes it WAS a typo error by the server admin guy (and I thought he was bullet-proof). It’s going pretty well now, apart from various broken image links. I think I got my knickers in a twist with images so it’s probably my fault but to be honest the problem started on the dev site when I changed the permalinks setting. I was hoping that a clean install would do the trick but I suspect I have to go through the code and sort each link/image individually.

    Thank you again for your help. I owe you another drink!

    Niall

    esmi

    (@esmi)

    13 years, 8 months ago

    Are the image links just pointing to the old dev site?

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    The strange thing is that on the front page (or the blog page) they work fine but on subsequent pages they are missing (all the images down the right side of the site). I’d presumed that was a database thing because they didn’t work on the dev site (once I’d uploaded it). Any thoughts appreciated.

    Have to pop out for a couple of hours so please excuse me if i don’t reply for a while.

    Thanks again

    esmi

    (@esmi)

    13 years, 8 months ago

    Check the urls on those “missing” images.

    Thread Starter nialldcrowley

    (@nialldcrowley)

    13 years, 8 months ago

    Hi esmi,

    sorted the links by rewriting them manually. The site is up and running though there are still bits of tidying up to do. I am extremely grateful for your help.

    Many many thanks.

    Niall

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Do mysql databases remember?’ is closed to new replies.