I've read a few threads about moving Drupal and I'm still unclear.
local test site is: c:\\easyphp\www\drupal
dbname - localhost/drupal
dbuser - drupal_admin
After moving, the details will be:
live site: /public_html/website
dbname - localhost/username_drupal
dbuser - username_admin
If I edit the settings.php line:
$db_url = 'mysql://drupal_admin:*****@localhost/drupal';
to read:
$db_url = 'mysql://username_admin:*****@localhost/username_drupal';
Will that be it? Are there any settings in the Administer section that I need to change?
I am also worried about the relative internal links in content and nav menus; how does Drupal handle all that stuff? The last thing I want is to develop a site locally and then have to change all the internal links in the content and menus because of a location change.
Thanks.
Comments
couldn't see this
couldn't see this listed
*bump*
=-=
yep, Drupal is extremely modular that way. The only thing I suggest is to empty sessions table and all cache tables to prevent trash from transferring from dev to live.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
Cheers.
Cheers.
have the same issues
I have the same concerns. I use a mac/MAMP and my concerns are the database names, passwords, URL_rewrite (have issues with it on MAMP), as well as the .htaccess.
Is there any documentations where there is a step by step procude to move from Dev site (local) to live site (hosted)?
I guess my question is... since the LIVE site is being used (additions to Database), how do i update it via the DEVELOPMENT (local) site without overwriting the databases?
thanks.
=-=
I think you miss the idea here a little.
Ideally the entire site should be dev'd on a local machine then you move it. A theme can continue to be developed on the local machine , then the files moved. A new module can be tested on a local machine then if chosen as a feature uploaded and enabled in a production environment.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
syncronisation
Syncronisation of 'local' and 'live' is a problem if your site is being used while you are also still developing locally.
The easiest thing to do would be to use your local installation for testing new features. Then when you've accumulated several changes that you'd like to implement (and you're sure they work), shut the site for a day, download the entire live site (inc database), apply the changes, and upload it all again.
However, I'm personally very surprised that in 2007 we still do not have the tools to be able to compare, preview and sync a remote directory/database with local copies. The company that creates an all-in-one file/database syncing solution for web developers will probably become rich and famous, but at the moment this software does not appear to exist.
On Windows, I've looked at a large range of ftp clients; only one had collision rules complex enough to be used to sync two directory structures, but it kept crashing constantly. I might take a look at http://www.ftpsynchronizer.com/, a tool specially created for this job. Though it seems too simplistic - I'm not sure I trust something which doesn't have lots of options and settings, as ftp clients usually do.
For databases, the nearest I got was the excellent MySQLYog, but it's syncing capability fell short of what is required (still a great program though - much better than the much hyped 'Navicat'). 'Database Comparer', a tool specifically designed for the job, also fell short of being able to safely sync two databases, and I didn't feel as though I could trust it much.
Obviously you're using a Mac though, so this discussion of Windows software won't help you at all. Generally speaking, I don't think there is a way around having to shut the site down or having to implement changes twice (once on the local for testing, and repeated again on the live site).
rsync
Actually, there is. Rsync (http://en.wikipedia.org/wiki/Rsync) is a unix tool that allows for exactly this. It compares files on two different machines and inly copies the changes. I use it to push files to live servers all the time.
Check it out.
There are some GUIs out there for it, too (http://www.opbyte.it/grsync/)
files only
I think Rsync just does files synchronization, which is very easy to do with any FTP app. My need is the Database Sync., which I still have not been able to find an easy solution for.
Well, the database just sits
Well, the database just sits in flat files, ultimately, I'm pretty sure. Also, you could do a SQL sync between DB servers (database replication). You could also use this for DB backups. Something like this http://www.databasejournal.com/features/mysql/article.php/1584401 ?
moving local to live site
I guess my question is even more basic. I've developed my site on my local pc and know to ftp it to my server but exactly what do I ftp? all directories under drupal? and to where on the server?
=-=
all directories and files
your public root if you want your site accessed in this fashion : www.yoursite.com
otherwise in a subdirectory if you want your site accessed like www.yoursite.com/subdirectory.
DO NOT FORGET .... to alter your settings.php file to connect to the servers DB.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
close but no cigar
Well I've made progress. My site is built locally and drupal is installed on my live server.
I managed to use mysqldump to export then import the db from my local pc to the server.
Question: Does the directory name need to be druapl on the server or can it be drupal-5.4?
I ftp'd the modules I added and unzipped them on the server. I'm confused where to put them.
Question: Do they go in sites/all/modules/ or just all module files go under sites/all/modules ? I tried both ways but when I go to admin/modules they don't show up to be enabled.
=-=
if in a subdirectory it can be named anything, drupal can also run in the public root of your server as well.
the entire folder that a module comes in goes into sites/all/modules
If the modules did not show up, insure you are using the correct version of modules. 4.7.x modules will not show in the administer -> modules screen, because 4.7.x did not include .info files for the modules.
if using Drupal 5, you must install modules written for drupal 5.x
I also suggest installing Drupal 5.5 as bug with taxonomy was fixed. See the release node on the front of drupal.org
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
adding modules
I just upgraded to 5.5 on your suggestion. I have the modules (all 5.x) in the sites/all/modules directory . They are not showing up under admin/modules.
=-=
what modules are you trying to install please ?
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
First, i want to thank you
First, i want to thank you very much for helping.
Modules: nice-menus, image, image_filter, image_gallery_access, image_menu and now i can't remember the name of the printer friendly version module.
=-=
you extracted the mdoules from their archive before uploading them yes ?
there is a .info file in each of the modules folders yes ?
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
uploading
I downloaded the .gz file to my local pc and had no trouble unpacking them and getting them to work on my local pc. Then I ftp'd the .gz file to my server and unpacked them there into a /drupal-5.5/sites/all/modules directory. And yes, they all have a .info file in each module's directory ex: /drupal-5.5/sites/all/modules/nice_menus/nice_menus.info.
=-=
I didn't upack on my server, I just FTP'd the entire folder after it was unpacked.
I can't duplicate your problem. Every module I upload that you've listed shows in administer -> modules
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
recursive ftp
i deleted everything i have on my server for drupal (the entire /drupal.5-5 directory and everything in it.) Question: why does my site still come up when i type in http://mysite.com/drupal ?? What drupal is it accessing? if i can figure out where it is picking up the drupal from maybe i can figure out why the module thing didn't show up.
=-=
and you are sure there is no "drupal" folder on your server ?
have you trired clearing your browser cache ?
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
i think i found it
i think i may have found the "other" copy of drupal that was causing all the problem. i'll try everything over again now.
from remote to local
i have a site live working fine in all respects i backed up the database and files and dumped then on my local server also edited settings.php for the new username and password but i get an error saying 500 Internal Server Error when i open this on local machine i have tries this 3-4 times but it never worked.
=-=
did you clear the cache tables in the db ?
and site specific changes to your .htaccess file ?