Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By kreon on
Hi, I managed to produce a website with drupal 5.7 installed on my PC locally and would like to move the code to my new dedicated webserver.
Unfortunately as a newbie I'm stuck since I do not know where to look for the right information on how to proceed from here.
The web hosting company says the domain is registered, a mySQL database has been set up together with all the logins and passwords for the server, mySQL database etc... So far so good. Except when I uploaded the drupal files and entered the name of the database, I got the message that Drupal was already installed, leaving me the option to start over, install to a different database or to proceed to the upgrade script.
Could anyone please advice me on the correct procedure to follow in order to be able to publish our site.
Many thanks in advance.
Comments
Do you mean that a "Drupal
Do you mean that a "Drupal is already installed" message appeared while you hadn't loaded your own database?
Actually in the install of
Actually in the install of drupal I filled in the database name setup by the hosting company, so I did not create a new database, in "advanced options" I left localhost as the database host since I did not know exactly what to put. So I guess the database was loaded - if that's what you mean.
In the meanwhile I copied a newer version of config.php and started over again.
I tried to put "https://ks358391.kimsufi.com/phpMyAdmin" as the database host but this gave me the following msg: Unknown MySQL server host 'https' (1).
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?
My way to do this
make your site ready at your PC.
Take a backup of MYSQL database. you can do this from phpmyadmin.
Then go the the drupal directory. copy it
Now upload this drupal directory to webserver
create a new mysql database and user with password,
remember here, if your user name and password is changed then you have to make the specific changes in /sites/default/settings.php ( just change the username and password there)
after this upload your database to your server.
If your site is just a fresh piece then its easy to upload it with phpmyadmin. If your database file is huge then use Bigdump (http://www.ozerov.de/bigdump.php) for this.
after doing this you can just call your site in browser.
what you are doing wrong is -
you have insatlled drupal at your hand and your wish to just move it from here to there.
and your installing new drupal for this. so there is all ready a new drupal installation so you are not able to move this. with same name.
Many thanks, I will try this
Many thanks, I will try this immediately, I stay with one question: when you say upload this drupal directory do you mean the locally installed version of drupal - the whole directory with all subdirectories and files in it?
--thanks for your time spent.
Your "way" solved my problem
Thanks a million times! I was having problem moving my localhost site to the web server. I followed your steps and I got it done. The only problem I encountered was "404 NOT FOUND error" for all my pages. After googling, I realized that my .htaccess file was an empty file, so i re-copied the file to the server and everything work fine.
Sure, you have to upload ALL
Sure, you have to upload ALL the Drupal files & folders on your PC - INTACT. If you are installing Drupal in a separate directory so your site is available e.g. at www.yoursite.com/yourdrupalfolder, then simply upload the whole folder eg using drag & drop if u have an ftp client into your root folder.
If you want your Drupal site to be at www.yoursite.com, then again using an ftp client, OPEN your Drupal folder, highlight all the contents & drag & drop them into the root folder of your site.
Whatever you do, though, remember to update your settings.php, so the DB name, DB user name & PWD & DB host match those of your online site, by replacing those from your PC based site.
Audio Segment On Moving Drupal
I recently produced an audio podcast on the subject of moving a Drupal site. This may be able to help if you have a few minutes to listen. http://learnbythedrop.com/drop/44
Rob Safuto
Learn By The Drop is a place to learn Drupal. If you're new to Drupal I recommend having a look at my Beginner's Guide To Drupal.
File permissions?
Hi all,
what about file permissions? I've been moving a drupal test site from my laptop to my desktop pc, both running ubuntu, and I have a few problems with the "files" folder owner and permisions... I "solved" them giving all access to other users but I'm not sure what will happens once the files are on the webserver... (dedicated, with root access... so I can change whatever I want).
Detailed information about that will be highly appreciated!
The requirement is that the
The requirement is that the files and temp directories must allow reading/writing/listing by the web server user account ("apache" or "nobody").
1. In a generic server configuration:
- If those directories are owned by apache (which happens for example if they were created automatically by Drupal or by any php script), then permissions 755 is fine because apache is the owner (the first 7).
- If those directories are owned by your own user account (which happens for example if they were created by you, directly or with FTP), then permissions 777 is needed because the server is in the third 7 (the "others" -- anyone who has a user account on the server).
2. If you set up a linux access group for the site, and include you own user account and apache's user account in it, then you can use a middle 7 (775) to make the directories writable by both yourself and apache, no matter who the owner is.
3. If you set up suexec (http://httpd.apache.org/docs/2.0/suexec.html) then apache can write "in your name". So, you keep ownership of the files and 755 is fine.
The files written by Drupal inside those directories will be owned by apache (except in case 3). So 644 will be fine for reading/writing them by apache in any case.
Thanks! Very good
Thanks!
Very good explanation.
My problem was exactly that, apache created the directories, but when I moved my site I created my directories by hand and I needed to change to 777, but I just want to be sure that this was correct!
Of course you could change
Of course you could change the ownership of those directories back to apache and leave their permissions at 755, using a command like
chown apache [some-path]I think in Ubuntu that would be
sudo chown apache [some-path]