• I have been following the instructions to moving my locally designed site from my local site to the live site. I am stumped on this:

    “Login on your server and go to phpmyadmin and export as file and save your database (but keep the old one just in case), upload this new database and the copy of the wordpress core files with the edited wp-config.php to your new server. That’s it!”

    The “upload your new database” is where I get lost — upload it to what? Why is this omitted from the instructions?

    Thanks,
    Karen

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter karenmjudge

    (@karenmjudge)

    I should be more specific — WHERE on the live server do the new files go?

    Moderator cubecolour

    (@numeeja)

    Create a new database in your hosting control panel. Then you can import the database backup into that.

    Since you are working locally all the urls that saved are in database for your images so you will need to change them urls by using a Search and replace plugin and export that database from your local phpmyadmin and save as file on your computer.

    You will find some plugins you can use here http://wordpress.org/extend/plugins/search.php?q=search+and+replace&sort=

    On your host account phpmyadmin you can import that sql file

    Hi Karen,

    Depending on your host, the method to create a new database and import an exported database file will differ.

    1) who are you hosting with?
    – most hosts use the hosting admin panel called ‘cPanel’, a brand name, and the steps to create and import a database are well documented online
    – Go Daddy, on it’s shared Linux accounts, uses it’s own “home-rolled” admin panel and the steps there, while similar to cPanel, are not in the same place.

    2) have you managed to use the phpMyAdmin on your local server for your local site to export the local database?

    3) which local server are you using (or do you know? – XAMPP, WAMP, MAMP (Mac), Instant WordPress, etc.) and which operating system – Windows or Mac?

    Answers to these questions will help us help you get “un-lost” 🙂

    Cheers!
    Lyle

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Migrating from local server (MAMP) to live’ is closed to new replies.