By kabanda on

Hi all,

I have developed a website on my local PC using Acquia Dev Drupal Stack and uploaded to my remote site (image copy).
I now want to create a remote database and export from my local database to it. Unfortunately my hosting company does not allow me to name databases exactly as I want (it always pre-pends XXXX_MyChoice) Where XXXX is something they pre-pend.
Guess now my only choice is to re-name my local database to suit but I do not know how to do that.
Does anybody know how to re-name databases after they have been created and populated?
I would be grateful. Thanks.

⋅ Categories: Drupal 7.x

Comments

sjugge’s picture

sjugge commented

If you can access your phpmyadmin locally, I suggest you create a database with a name to fit the one on your host. Export the database you need and import it to the newly create one.

In your settings.php file you can adjust the database name to the newly created one. That should do the trick.

Make sure you have the same username/password set throughout your host and settings.php file though.

kabanda’s picture

kabanda commented

Yes I can access phpmyadmin locally , so I will start giving this solution a try.
Thanks a lot.

sjugge’s picture

sjugge commented

Snap. And easier way of doing this would be to use the backup and migrate module. Exporting your local database backup into your remote installation.

DaveSmall’s picture

DaveSmall commented

You can check out How to Migrate a Drupal Site. And if I understand your question clearly, you can just change the settings.php file in your production environment, where you can specify the name of your new database. Here is an example:

$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'dbname',
'username' => 'root',
'password' => '',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
),
),
);

kabanda’s picture

kabanda commented

Yes guys, thanks all for your help, I managed to get the front page showing up on the remote site but get
'Page Error 404b has occurred.' on each and every link I click.
Any Ideas anybody please?

Thanks.

sjugge’s picture

sjugge commented

How did you install/move the remote site? Did you install Drupal, dropped in all the files and the database dump? Or did you not install and just move everything over? Where are your URL's pointing to and is the domain right? Is there actual content on the URL destination?

you might want to check out the following;
- is the host set correctly in the settings.php file?
- settings of you path aliases?
- there might be something you need to adjust in you .htaccess file in the root of your drupal install or a difference in the clean url settings. Open up the .htaccess file and se if all is set according to your Drupal installation; is your drupal root in a sub-folder of your server root, is your install on a sub-domain.

kabanda’s picture

kabanda commented

How did you install/move the remote site?
Copied everything over however the first time at the main url I was automatically put into an install phase.

Where are your URL's pointing to and is the domain right?
I guess at least the main page is right as I can get to it at http://cpcabdrupal.kabs-software.com/

Is there actual content on the URL destination?
Yes, quite a bit

is the host set correctly in the settings.php file?
I think so, mainly because I can get at the front page.

settings of you path aliases?
Can you please remind me where those are?

something you need to adjust in you .htaccess file in the root of your drupal install or a difference in the clean url settings
In as much as I can understand them they seem to be ok, where is the settings for clean url?

is your install on a sub-domain?
yes.

sjugge’s picture

sjugge commented

seems like you got most of the things covered which I can think/guess what might be wrong. You can check the settings of your path aliases at /admin/config/search/path/patterns but I don't think you've set that up since all the links on your site are just /node/[node:id]

I think you might need to change the following in your .htaccess file

# Modify the RewriteBase if you are using Drupal in a subdirectory or in a
  # VirtualDocumentRoot and the rewrite rules are not working properly.
  # For example if your site is at http://example.com/drupal uncomment and
  # modify the following line:
  # RewriteBase /drupal

change it to:

# Modify the RewriteBase if you are using Drupal in a subdirectory or in a
  # VirtualDocumentRoot and the rewrite rules are not working properly.
  # For example if your site is at http://example.com/drupal uncomment and
  # modify the following line:
    RewriteBase /cpcabdrupal

hope that helps.

sjugge’s picture

sjugge commented

also, are you running drupal 6 or 7. I think 6, right? The path I gave you for the URL aliases is incorrect, should be /admin/build/path/pathauto for D6

kabanda’s picture

kabanda commented

Thanks for the advise but unfortunately no change.
I am running DP7

sjugge’s picture

sjugge commented

if you can access the admin pages and edit/save an existing node, could you check what URL you get after saving the node and whether or not you get the 404 as well?

DaveSmall’s picture

DaveSmall commented

This is should be Apache rewrite rule related.

It's either because of in your new sever, Apache rewrite .module has been installed or your .htaccess hasn't been configured correctly

kabanda’s picture

kabanda commented

I am using a Window hostin plan and have found out from my web hosters that mod_rewrite is not supported on our Windows based hosting plans.

My real use for this website is to help against my pending job interview so I do not have the money/will to pay for a new Linux hosting plan just for this. So I tried a free web hoster 000webhost.com but found out that Drupal 7 requires PDO which is not enabled on the free 000webhost servers and some other issues with PHP extensions.

Where I am at now is, Does anybody know of a free web hosting service that supports DP7?
I would be very grateful.
Thanks.

sjugge’s picture

sjugge commented

daim windows...

anyways, check out WebEnabled and their 30 day trial plan. Excellent development environment and Drupal support.

DaveSmall’s picture

DaveSmall commented

ok, then you can just disable "Enable clean URLs", after it your drupal site should work.