9 replies [Last post]
PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Was this information Helpful?

I'm apparently missing one very important piece of information for taking my site live -- I'm not sure which file contains all the configurations for my development site (Drupal 6.12). I'm putting the live site on a shared web host(Bluehost) and have done a fresh install of Drupal 6.12 using SimpleScripts. I've imported the SQL database, copied over a customized theme to sites/all/themes, copied non-core modules (including Ubercart) to sites/all/modules, and copied my entire sites/all/default/files folder. I also copied my settings.php after changing the base_url & database url.

My customized theme is working after I configured it. Only a few of the core and non-core modules were enabled, so I went through and enabled the ones I need. All the permissions need to be set again, so it's obvious I missed something critical. I'd really appreciate some help - thanks!

tcindie@drupal.org's picture
Offline
Getting busy with the Ubercode.
Joined: 05/15/2008
Juice: 440
Re: Trying to take my site live - - need to know which file cont

probably a stupid question, but when you did your database export did you include all the data or just the database structure?

Follow me on twitter.

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Re: Re: Trying to take my site live - - need to know which file

Hmmm... that may not be a stupid question. I'll have to look into that to confirm I exported correctly - thanks.

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Re: Re: Re: Trying to take my site live - - need to know which f

It looks like you sent me in the right direction. I somehow managed to get most of my data tables duplicated. The live database has the 115 tables (with the correct data) contained in the dev database, but it also has most of the same tables prefixed with drup_, so I have a total of 218 tables. I've had some training in SQL, but I'm basically a novice, so I'd appreciate any help. I'm assuming the drup_ tables were put there when I installed Drupal with SimpleScript, so can I simply drop them?

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Re: Re: Re: Re: Trying to take my site live - - need to know whi

I'm still looking for some guidance with this. Does anyone have a few minutes to help me out?

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
DB problems after importing to live site

In a closer look at my live site's settings.php, I noticed $db_prefix = 'drup_'. So now I changed it to match the database imported from my dev site $db_prefix = '', then ran update.php again.

Bigger problems now -- when I navigate to my live site's url in the browser, the web page shows me that my dev site is off-line for maintenance! If I try to get in to the live site from there using ?q=user, I getting redirected to my dev site's url!

Desperately need help. Wondering if I should start over on my live site's install.

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Re: DB problems after importing to live site
tcindie@drupal.org's picture
Offline
Getting busy with the Ubercode.
Joined: 05/15/2008
Juice: 440
Re: Re: DB problems after importing to live site

Sorry for the lack of response, a bunch of us were busy with the Drupalcamp / Ubercamp in Colorado all weekend.. so this is the first I'm seeing your updates. Glad to hear you got things sorted out though. Smiling

Follow me on twitter.

PatW's picture
Offline
Joined: 03/31/2009
Juice: 138
Re: Re: Re: DB problems after importing to live site

Thanks for getting back to me. I started following you on Twitter and saw that you were in Colorado and flying into MSP... I'm in Mankato Smiling

tcindie@drupal.org's picture
Offline
Getting busy with the Ubercode.
Joined: 05/15/2008
Juice: 440
Oh cool. Might have to meet

Oh cool. Smiling Might have to meet half way and grab coffee sometime. Smiling

Follow me on twitter.