ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Moving local database to remote server

January 27, 2011 5:27am

Subscribe [2]
  • #1 / Jan 27, 2011 5:27am

    gazaston

    128 posts

    Hi all,

    I’ve set up a custom config.php which so far is working (i.e. I can see the remote install of EE) but I’m having trouble replacing the remote database with my local one.

    The process I’ve used so far is:

    Export local database as a file
    Open phpMyadmin on the remote server
    Go to “structure”, select all, drop all
    Import local database file

    This all seems ok in phpMyAdmin but when I try to navigate to my control panel, I get a blank window.

    I am *stuck*!

    The two databases are named differently, and not knowing anything about mysql, I don’t know if that’s an issue? Is my process wrong?

    I attach the template from which I have created my custom config.php — maybe I’ve missed something in there?

    Gary

  • #2 / Jan 27, 2011 5:18pm

    Sue Crocker

    26054 posts

    Hi, Gary.

    Did you remember to change the db settings in the /system/expressionengine/config/database.php file?

    That’s the first step. 😊

  • #3 / Jan 27, 2011 5:21pm

    gazaston

    128 posts

    Hi Sue

    I got it working by performing a clean install of EE and double-checking some settings — once I’d done that it worked a treat. 😉

  • #4 / Jan 27, 2011 9:45pm

    Sue Crocker

    26054 posts

    That works too. 😊 Don’t hesitate to post again as needed.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases