How to Move Your Joomla! Site to a New Server
Written by Cory |
September 22, 2006
| 
(0)
Update February 7, 2009: I have now written an an article on how to move your Joomla! 1.5 site to a new server.
Things happen. Plans change. Websites outgrow current servers and need new servers. Hosting companies provide poor service, prompting a web master to decide to change servers. Whatever the reason, you might need to move your Joomla! installation from one server to another.
If you've been running a website for a while, you have probably already accumulated quite a bit of content and several 3rd party components and/or modules, and you do not want to start fresh with a new Joomla! installation. This article explains what I did to move HowToJoomla from my test server (howtojoomla.corywebb.com) to the server that it is on now.
Why not use a fresh install?
In my case, I probably could have. I only had about 4 or 5 articles on the test site, and I am using relatively few 3rd party CMT's (JomComment, TagBot, and JoomlaXplorer). But, I decided it would be easier just to move the installation I had to the new server, so I did.
You will want to move your Joomla! installation rather than re-install if you fit one or all of the following parameters:
- Your site has accumulated a large amount of data in the database over time (sections, categories, content items, contacts, newsfeeds, etc.).
- Your site uses multiple 3rd-part extensions already configured and/or customized for your site.
- You just feel like trying it out to see if you can do it.
Step 1: Backup everything!
The first thing you want to do is backup all files within your Joomla! installation. Create a folder on your local system, and download all files to that folder using your ftp client application. I used FileZilla as my ftp client application to download all of my files to a folder on my desktop I named "howtojoomla".
Step 2: Export your database
Note: For this step, it really helps if you have phpMyAdmin installed on your server. Most hosting companies have phpMyAdmin already installed. If you are unsure, ask your hosting provider.
The second thing you need to do is export your Joomla! database. The best thing to do is to export it into an SQL file, which makes importing it easier in a later step. An SQL file will contain all of the necessary SQL commands for creating your database tables and filling them with your data. Be sure you export the entire database.
Step 3: Modify configuration.php
This step is very important. Go to the folder on your local system to which you downloaded all of your Joomla! files. In the first level folder, you will find the file named "configuration.php". Open this file with a text editor and make the necessary changes. At the very least, you will probably need to change the following parameters:
- $mosConfig_absolute_path: This is the absolute server path to your new Joomla! installation. It will probably look something like "/path/to/joomla/installation".
- $mosConfig_cachepath: This is the absolute server path to the cache for your Joomla! installation. It will probably look something like "/path/to/joomla/installation/cache".
- $mosConfig_live_site: This is your website's url. It will be something like "http://www.yoursite.com".
- $mosConfig_host: This is the location of the server that hosts your MySQL database. For most instances, this value will be "localhost". If you are unsure, ask your hosting provider.
- $mosConfig_db: This is the name of your MySQL database.
- $mosConfig_user: This is the database user name. Make sure this user has all privileges on your database.
- $mosConfig_password: This is the password for your MySQL database user.
Step 4: Upload all of your files to your new server
Using an ftp client application (like FileZilla), upload all of your files to the location on your new server where you want to install Joomla!.
Step 5: Import your database to your new MySQL server
Using phpMyAdmin (or console commands if you are an advanced database administrator) and the SQL file you generated in step 2, import your old database into your new database.
Step 6: Test your new installation
Your move should now be complete, but please don't take my word for it. Test your site to make sure that everything is in it's proper place and working the way you expect it to. For example, if you did not use relative url's for your links on your old site, they will not work properly on your new site.
If you are uneasy or uncomfortable with this process, I strongly recommend that you hire a professional to do this for you.
Update: Another Resource
I just came across a resource called JoomlaCloner which automates much of this process for you. It has a commercial license, so unfortunately it is not free. The base price is $49.95 for 1 year support and upgrades. I have never used it, so I cannot speak for whether or not it is a good component. I just wanted to make you aware of it.
Trackback(0)
TrackBack URI for this entry
Comments (150)
Subscribe to this comment's feed
written by Cory, September 25, 2006
@Andrew: Thanks for the comment. I'll work on more detailed instructions for dealing with the database. Do you have phpMyAdmin on your servers?
-
- +5
-
-
written by MastaChu, September 25, 2006
Hy there!
At least i found you! Mine guestins have answers atleast!!!!
Thank you for your sacrifice, ( time )
Im wondering how could i do that but problem is bandwith that is slow and small in Croatia
.
Thank again,
PS if you could provide some images or something... that will rock the joomla world!!!
Making joomla website on home computer, localhost...
finishing the website and just upload it on server!
That will be nice!
At least i found you! Mine guestins have answers atleast!!!!
Thank you for your sacrifice, ( time )
Im wondering how could i do that but problem is bandwith that is slow and small in Croatia
. Thank again,
PS if you could provide some images or something... that will rock the joomla world!!!
Making joomla website on home computer, localhost...
finishing the website and just upload it on server!
That will be nice!
-
- +0
-
-
written by Cory, September 25, 2006
@MastaChu: I'm glad you found this useful! 
What kind of images would you like to see for this? I can think of a few places where I need to add a screenshot, but if you have any suggestions, I'd like to hear them.
What kind of images would you like to see for this? I can think of a few places where I need to add a screenshot, but if you have any suggestions, I'd like to hear them.
-
- +0
-
-
written by Nikos, October 02, 2006
I think you've forgoten that when you move to another server from Windows lets say to Linux, you also need to change the permissions of the folders to the new installation.
-
- +2
-
-
written by Cory, October 02, 2006
You're absolutely right. That is an important step that I have left off. Thank you for pointing that out.
-
- +3
-
-
written by Huner, October 02, 2006
thnx man, good helping.
but my database SQL file is 5 mb- can I import it ?
thank you very much for the lesson.
but my database SQL file is 5 mb- can I import it ?
thank you very much for the lesson.
-
- +1
-
-
written by Huner, October 02, 2006
I will try to my website: Than I can tell you thank you again
have a nice time
sorry for my bad english
i love Joomla..
have a nice time
sorry for my bad english
i love Joomla..
-
- +1
-
-
written by Cory, October 02, 2006
but my database SQL file is 5 mb- can I import it ?
You should still be able to import it. You might want to try splitting your SQL file into separate SQL files. If you have any questions, please let me know.
-
- +1
-
-
written by huner, October 03, 2006
thank u very much Cory. I found a little program, I can splitt my SQl.
that is SQLsplitter.
if any one need it can find it from gooegle.. thanks again
that is SQLsplitter.
if any one need it can find it from gooegle.. thanks again
-
- +2
-
-
written by huner, October 03, 2006
hi again, sorry for many questions.
but in the new server what can I do? do IPORT the SQL file or install a as news SQL ?
but in the new server what can I do? do IPORT the SQL file or install a as news SQL ?
-
- +1
-
-
written by Cory, October 03, 2006
@huner: You need to create a new SQL database on your new server, and import your old database tables into your new database using the SQL files you created.
-
- +0
-
-
written by huner, October 03, 2006
I know that, I mean, there are to diffirent stepst, in my Phpmyadmin
-
- +0
-
-
written by Alex Pasieka, October 14, 2006
Hi Cory,
I'm new to Joomla so as I'm learning I have intalled it on a subdirectory of my website. So I still need to follow these steps? or do I just need to update the $mosConfig_live_site file?
Thanks for your answer
I'm new to Joomla so as I'm learning I have intalled it on a subdirectory of my website. So I still need to follow these steps? or do I just need to update the $mosConfig_live_site file?
Thanks for your answer
-
- +1
-
-
written by Cory, October 15, 2006
@Alex Pasieka: You would just need to updated your configuration.php file. You need to change $mosConfig_live_site, $mosConfig_absolute_path, $mosConfig_cachepath.
-
- -1
-
-
written by Bert, October 20, 2006
Hi,
I guess that moving to a subdomain would be the same as moving to another directory, but this does not work for me.
I setup the site at http://newsite.domain.com to test is. Now I want to move the site to http//www.domain.com.
I copied all files, with the same file permissions, ... I modified configuration.php ($mosConfig_live_site, $mosConfig_absolute_path, $mosConfig_cachepath) but when I browse to the site I et a blank page. What am I doing wrong ?
In the server logs I can find some references to open_basedit not being set correctly, but I can't find this setting in within my Joomla config.
I guess that moving to a subdomain would be the same as moving to another directory, but this does not work for me.
I setup the site at http://newsite.domain.com to test is. Now I want to move the site to http//www.domain.com.
I copied all files, with the same file permissions, ... I modified configuration.php ($mosConfig_live_site, $mosConfig_absolute_path, $mosConfig_cachepath) but when I browse to the site I et a blank page. What am I doing wrong ?
In the server logs I can find some references to open_basedit not being set correctly, but I can't find this setting in within my Joomla config.
-
- -1
-
-
written by Cory, October 20, 2006
@Bert: I'm not sure what is wrong with your installation. Have you checked your db settings to make sure they are set properly?
-
- +0
-
-
written by Bert, October 20, 2006
Seems like I jumped to conclusions too soon. I guess I did something wrong. I just tried again and now it works without any problem.
I'm sure that the problem was not related to the DB settings, because these didn't change. I think something went wrong with the copy.
Most imporant thing to remember is that it actually works by just copying the files ang changing the 3 parameteres mentioned in the previous post.
I'm sure that the problem was not related to the DB settings, because these didn't change. I think something went wrong with the copy.
Most imporant thing to remember is that it actually works by just copying the files ang changing the 3 parameteres mentioned in the previous post.
-
- +0
-
-
written by Rob, January 11, 2007
Thank you for that how-to. It worked beautifully when I had to move one of my sites from one machine to another. It was so easy I thought I'd done something wrong!
I don't suppose you have any tips or guides from getting sites using Mambo across to Joomla? I'm struggling to get two sites using Mambo and Community Builder across to Joomla without loosing everything. It's the components that seem to complicate the issues!
I don't suppose you have any tips or guides from getting sites using Mambo across to Joomla? I'm struggling to get two sites using Mambo and Community Builder across to Joomla without loosing everything. It's the components that seem to complicate the issues!
-
- +0
-
-
written by Cory, January 11, 2007
Hi Rob...I'm glad you found this useful! The problem with a Mambo-to-Joomla how-to is just what you said...the components really complicate the issue. Not knowing what components everyone has installed, and not knowing the differences between the Mambo versions and Joomla versions of the components, it is next to impossible for me to right a good generalized how-to on that topic.
Thanks for the suggestion.
Thanks for the suggestion.
-
- +0
-
-
written by Veena, February 28, 2007
Hi,
I want to move my site from local server to the main server.....the $mosConfig_absolute_path = 'D:/PHP/xampp/htdocs/Trial'; and so is the cache path.....will it be fine if i just follow the instructions above....or do i neeed to do any extra changes.....please do reply.....
Thanks in advance
I want to move my site from local server to the main server.....the $mosConfig_absolute_path = 'D:/PHP/xampp/htdocs/Trial'; and so is the cache path.....will it be fine if i just follow the instructions above....or do i neeed to do any extra changes.....please do reply.....
Thanks in advance
-
- -1
-
-
written by Veena, February 28, 2007
Are U talking about the settings in configuration.php-dist???
-
- +0
-
-
written by Cory, February 28, 2007
Hi Veena,
The instructions are still the same. You just need to figure out what the absolute path and the cache path are on your main server.
The file "configuration.php-dist" is not the file you need to be changing. You need to change "configuration.php".
Cory
The instructions are still the same. You just need to figure out what the absolute path and the cache path are on your main server.
The file "configuration.php-dist" is not the file you need to be changing. You need to change "configuration.php".
Cory
-
- +0
-
-
written by Veena, March 02, 2007
Hi Cory,
Thanks for the information.......is there anything like OS compatibility issues in Joomla???
Thanks for the information.......is there anything like OS compatibility issues in Joomla???
-
- +0
-
-
written by Cory, March 02, 2007
From Joomla.org (http://help.joomla.org/content/view/34/132/)...
You can run Joomla on a Windows server or a Linux server as long as it meets the requirements listed above. One thing to consider when moving between Windows and Linux is the way absolute paths are listed. Windows paths start with the drive letter like this "C:", and Linux paths exclude the drive letter from the beginning like this "".
Here are the minimum requirements for Joomla 1.0
* PHP 4.2.x or above - http://www.php.net
* MySQL 3.23.x or above - http://www.mysql.com
* Apache 1.13.19 or above - http://www.apache.org
You must ensure that you have MySQL, XML and Zlib support built into your PHP.
You can run Joomla on a Windows server or a Linux server as long as it meets the requirements listed above. One thing to consider when moving between Windows and Linux is the way absolute paths are listed. Windows paths start with the drive letter like this "C:", and Linux paths exclude the drive letter from the beginning like this "".
-
- +1
-
-
written by Vince Patron, March 11, 2007
Hi Cory,
Just FYI on some additional problems I ran into.
1) I had to also make changes to table in the SQL database called "jos_preferences" which had paths to the cache, public and private folders (3 entries).
The first two are obvious when you browse the jos_preferences table, but the third one wasn't because I forgot browse only shows 30 rows at a time. You have to click on the ">" (Next page) to see the third row that needs updating.
2) We had to change the permissions for all the folders Joomla accessed to CHMOD 755, instead of the 644 which was my provider's default. The owner of my service provider said this was OK since access was controlled by .htaccess (which I'm still learning about).
Anyway, these are some additional comments that you might want to add to your excellent tutorial. Thanks!
-Vince
Just FYI on some additional problems I ran into.
1) I had to also make changes to table in the SQL database called "jos_preferences" which had paths to the cache, public and private folders (3 entries).
The first two are obvious when you browse the jos_preferences table, but the third one wasn't because I forgot browse only shows 30 rows at a time. You have to click on the ">" (Next page) to see the third row that needs updating.
2) We had to change the permissions for all the folders Joomla accessed to CHMOD 755, instead of the 644 which was my provider's default. The owner of my service provider said this was OK since access was controlled by .htaccess (which I'm still learning about).
Anyway, these are some additional comments that you might want to add to your excellent tutorial. Thanks!
-Vince
-
- +0
-
-
written by Cory, March 11, 2007
Vince,
Thanks for that information. I figured there would be some nuances that would affect the process differently for different people. I'm glad you were able to get it resolved, and thank you for posting it here.
Cory
Thanks for that information. I figured there would be some nuances that would affect the process differently for different people. I'm glad you were able to get it resolved, and thank you for posting it here.
Cory
-
- +0
-
-
written by oneoflk, April 14, 2007
hi
i need put my site updated data base file in local server to live server. Can i have solution that mater
thanks
Ranil
i need put my site updated data base file in local server to live server. Can i have solution that mater
thanks
Ranil
-
- +0
-
-
written by MastaChu, April 16, 2007
Hy! Me again!
Im planning to make joomla local and then put it on server when is ready!
So, mine question is, if there is anyone that have make something like that and maybe if he/she cann make some pics screenshots with some inportant moves or maybe small tutorial on how to make that transfer! Maybe it isnt so hard but for beginners or small country like mine its hard to get some books that can explain this!
I will be gratefull for that!
BTW: @Cory
I mean images that are make understand easier the whole transfer!
Im not Newbie! But im not that far away!
Im planning to make joomla local and then put it on server when is ready!
So, mine question is, if there is anyone that have make something like that and maybe if he/she cann make some pics screenshots with some inportant moves or maybe small tutorial on how to make that transfer! Maybe it isnt so hard but for beginners or small country like mine its hard to get some books that can explain this!
I will be gratefull for that!
BTW: @Cory
I mean images that are make understand easier the whole transfer!
Im not Newbie! But im not that far away!
-
- +0
-
-
written by Tamas, April 25, 2007
Hello Cory!
I really appreciate what you put together here. Thanks. Nice and useful.
I went through the steps, and got error msg.
Well, I am using at DreamHost a hosting for several domains. (They allow unlimited number of domains! I really like them! If you are interested I gladly write more about them!)
I have a site with Joomla. I would like to copy this site to another site, as it will be very similar to the first one. (After copying the site, I would make some small modifications.)
So, I have to make a new mySQL database, with different name (not to overwrite the first one.)
How should I do this?
Thanks,
Tamas
I really appreciate what you put together here. Thanks. Nice and useful.
I went through the steps, and got error msg.
Well, I am using at DreamHost a hosting for several domains. (They allow unlimited number of domains! I really like them! If you are interested I gladly write more about them!)
I have a site with Joomla. I would like to copy this site to another site, as it will be very similar to the first one. (After copying the site, I would make some small modifications.)
So, I have to make a new mySQL database, with different name (not to overwrite the first one.)
How should I do this?
Thanks,
Tamas
-
- +2
-
-
written by Cory, April 25, 2007
Hi Tamas,
I would manually create the database (without the tables) first, then export the tables from the old database and import them into the new one. The easiest way to do that is with phpMyAdmin if you have access to it.
Cory
I would manually create the database (without the tables) first, then export the tables from the old database and import them into the new one. The easiest way to do that is with phpMyAdmin if you have access to it.
Cory
-
- +0
-
-
written by megsani, April 29, 2007
Hi Cory,
I am a new to Joomla. Currently I have installed Joomla on my pc for development purpose. When I am ready to transfer to a live site, do the procedures apply? Also I am not sure on exporting the database into SQL file. How do I do it?
Thanks.
I am a new to Joomla. Currently I have installed Joomla on my pc for development purpose. When I am ready to transfer to a live site, do the procedures apply? Also I am not sure on exporting the database into SQL file. How do I do it?
Thanks.
-
- +1
-
-
written by Cory, April 29, 2007
Hi megsani,
The same procedures do apply when moving your Jooml installation from one place to another. The easiest way to export your database to an SQL file is with phpMyAdmin.
Cory
The same procedures do apply when moving your Jooml installation from one place to another. The easiest way to export your database to an SQL file is with phpMyAdmin.
Cory
-
- +1
-
-
written by Stephan, May 11, 2007
Hi Cory!
Thanks for the information. How would one export their database from a localhost? I'd like to test everything on my local machine and then upload the same to a web server. I used WOS from www.chsoftware.net to install on a localmachine. It's very much like php triad in which it installs apache, mysql and php4 on a local machine. Any insight is most appreciated. Thanks very much.
Thanks for the information. How would one export their database from a localhost? I'd like to test everything on my local machine and then upload the same to a web server. I used WOS from www.chsoftware.net to install on a localmachine. It's very much like php triad in which it installs apache, mysql and php4 on a local machine. Any insight is most appreciated. Thanks very much.
-
- +0
-
-
written by Cory, May 11, 2007
Hi Stephan,
The easiest way I know how to export a database is using a tool like phpMyAdmin. You could download a copy of it from phpmyadmin.net and install it on your localhost.
There are also GUI tools for dealing with MySQL databases. You can download them here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Good luck,
Cory
The easiest way I know how to export a database is using a tool like phpMyAdmin. You could download a copy of it from phpmyadmin.net and install it on your localhost.
There are also GUI tools for dealing with MySQL databases. You can download them here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Good luck,
Cory
-
- +0
-
-
written by Stephan, May 12, 2007
Thank you Cory! I will look into your suggestions right away! Thank you for making such a wonderful site.
-
- +0
-
-
written by kaizen, May 23, 2007
When I'm switching from one server to another, so I end up with two instances of the same site?
How do i ensure the new site gets hit instead of the old one?
Thanks for the great guide
How do i ensure the new site gets hit instead of the old one?
Thanks for the great guide
-
- +0
-
-
written by labp, May 25, 2007
hi, thanks a lot for this guide!!!
where is the location of table sql???
ty!
where is the location of table sql???
ty!
-
- +0
-
-
written by Martina, May 26, 2007
Hi!
I have a problem. I was trying to move joomla from one local machine to another (home to work for evaluation), but when I open pages on new machine I get a ''You are not authorised to view this resource. You need to login. '' message. But I got everything set on Public.
When I login with any user I get a ''There are no items to display. '' massage on menu links made with ''Blog - Content Category''. But if I go to administration window everything is there and same as on the first computer.
What could be wrong? What did I do wrong? As i said, page is still local on both computers, export and import of the database was made with phpMyAdmin (same version on both computers), copied all files of joomla. I didn't make any changes to configuration.php because everything stayed same (the path is identical on both computers). I just can't find the problem. Any idea what the problem could be? Thank you for help.
I have a problem. I was trying to move joomla from one local machine to another (home to work for evaluation), but when I open pages on new machine I get a ''You are not authorised to view this resource. You need to login. '' message. But I got everything set on Public.
When I login with any user I get a ''There are no items to display. '' massage on menu links made with ''Blog - Content Category''. But if I go to administration window everything is there and same as on the first computer.
What could be wrong? What did I do wrong? As i said, page is still local on both computers, export and import of the database was made with phpMyAdmin (same version on both computers), copied all files of joomla. I didn't make any changes to configuration.php because everything stayed same (the path is identical on both computers). I just can't find the problem. Any idea what the problem could be? Thank you for help.
-
- +0
-
-
written by roctx, June 01, 2007
Cory, for those that have access to their server or a shell account, the following bash script will change permissions to the directory structure of a new install so that you can install Joomla! without having to manually set permissions. This is for *nix* systems only! Run this script inside the "Joomla!" directory/folder after uploading your Joomla! site and "before" you run your initial install. This will help your installation wizard go much more smoothly. Copy the contents between *** Begin *** and *** End *** into a "text" file (call it whatever you like, I call mine chmod775), then save it (no extension is required). Upload it to your server/isp and make it executable using your isp's filemanager or command line command "chmod x filename". If you have a shell account with your isp then just type the command "chmod775" or whatever name you chose. This will immediately change the permission in the directory structure as Joomla! needs them to be. Remember to change the permissions on your configuration.php file back to a more secure level when you are done (chmod 755 configuration.php). This is the only file that is not done through the script because the install wizard needs to be able to write to it first before it's changed back to a more secure level. If you install several website on occasions, this becomes a handy tool.
************ Begin ****************
#!/bin/bash
# Create the "configuration.php file, change group to "apache" and make it 775
touch configuration.php
chgrp apache configuration.php
chmod 775 configuration.php
# Change group to "apache" so apache user has RWX access
chgrp apache administrator/backups/
chgrp apache administrator/components/
chgrp apache administrator/modules/
chgrp apache administrator/templates/
chgrp apache cache/
chgrp apache components/
chgrp apache images/
chgrp apache images/banners/
chgrp apache images/stories/
chgrp apache language/
chgrp apache mambots/
chgrp apache mambots/content/
chgrp apache mambots/editors
chgrp apache mambots/editors-xtd/
chgrp apache mambots/search/
chgrp apache mambots/system/
chgrp apache media/
chgrp apache modules/
chgrp apache templates/
# Change permission to allow "apache" group RWX
chmod 775 administrator/backups/
chmod 775 administrator/components/
chmod 775 administrator/modules/
chmod 775 administrator/templates/
chmod 775 cache/
chmod 775 components/
chmod 775 images/
chmod 775 images/banners/
chmod 775 images/stories/
chmod 775 language/
chmod 775 mambots/
chmod 775 mambots/content/
chmod 775 mambots/editors
chmod 775 mambots/editors-xtd/
chmod 775 mambots/search/
chmod 775 mambots/system/
chmod 775 media/
chmod 775 modules/
chmod 775 templates/
# Change permission on configuration.php to 755
************ End ************
************ Begin ****************
#!/bin/bash
# Create the "configuration.php file, change group to "apache" and make it 775
touch configuration.php
chgrp apache configuration.php
chmod 775 configuration.php
# Change group to "apache" so apache user has RWX access
chgrp apache administrator/backups/
chgrp apache administrator/components/
chgrp apache administrator/modules/
chgrp apache administrator/templates/
chgrp apache cache/
chgrp apache components/
chgrp apache images/
chgrp apache images/banners/
chgrp apache images/stories/
chgrp apache language/
chgrp apache mambots/
chgrp apache mambots/content/
chgrp apache mambots/editors
chgrp apache mambots/editors-xtd/
chgrp apache mambots/search/
chgrp apache mambots/system/
chgrp apache media/
chgrp apache modules/
chgrp apache templates/
# Change permission to allow "apache" group RWX
chmod 775 administrator/backups/
chmod 775 administrator/components/
chmod 775 administrator/modules/
chmod 775 administrator/templates/
chmod 775 cache/
chmod 775 components/
chmod 775 images/
chmod 775 images/banners/
chmod 775 images/stories/
chmod 775 language/
chmod 775 mambots/
chmod 775 mambots/content/
chmod 775 mambots/editors
chmod 775 mambots/editors-xtd/
chmod 775 mambots/search/
chmod 775 mambots/system/
chmod 775 media/
chmod 775 modules/
chmod 775 templates/
# Change permission on configuration.php to 755
************ End ************
-
- +1
-
-
written by roctx, June 01, 2007
A few points and correction.
Correction:
The chmod command make the file executable is:
"chmod x filename". I mistyped the command in the previous post.
System used with this command:
Fedora Core 6
Ubuntu 7.0.4
Note** not all apache server run as user/group "apache:apache".
Example:
Fedora - Apache user/group is apache:apache
Ubuntu - www-data:www-data
Be sure to check and find out what user the apache service runs as and make those changes in the script.
roctx
Correction:
The chmod command make the file executable is:
"chmod x filename". I mistyped the command in the previous post.
System used with this command:
Fedora Core 6
Ubuntu 7.0.4
Note** not all apache server run as user/group "apache:apache".
Example:
Fedora - Apache user/group is apache:apache
Ubuntu - www-data:www-data
Be sure to check and find out what user the apache service runs as and make those changes in the script.
roctx
-
- +0
-
-
written by Sidharth, June 16, 2007
I am new to Joomla . How to load it and use it ? Can we have some chat session for the begineers in yahoo or Skype ?
-
- +0
-
-
written by Kizzer, June 21, 2007
I get this error after making the full transfer:
[Fatal error: require_once() [function.require]: Failed opening required '/includes/version.php' (include_path='.:/usr/share/php') in /www/freehyperspace.com/c/d/n/cdnytest/htdocs/joomla/includes/joomla.php on line 71]
I checked the joomla.php file and it seemed fine. Anyone know exactly what the script for the variable is so I can match it against mine? Or any other suggestions?
[Fatal error: require_once() [function.require]: Failed opening required '/includes/version.php' (include_path='.:/usr/share/php') in /www/freehyperspace.com/c/d/n/cdnytest/htdocs/joomla/includes/joomla.php on line 71]
I checked the joomla.php file and it seemed fine. Anyone know exactly what the script for the variable is so I can match it against mine? Or any other suggestions?
-
- +1
-
-
written by Cory, June 25, 2007
Hi Kizzer,
It looks like you need to change $mosConfig_absolute_path in your configuration.php file.
Cory
It looks like you need to change $mosConfig_absolute_path in your configuration.php file.
Cory
-
- +1
-
-
written by Phlea Phleadom, July 05, 2007
I did the transfer of servers like this, it worked 100% and all pictures, info and links worked 100%
1. Install New installation of Joomal on new server.
2. Open the database with myphpadmin and drop all the tables.
3. Import all the tables from your database of the Joomla site you want to move.
4. Zip all the files from your existing Joomla you want to move but leave out the configuration.php file
5. Now overwrite all the files in the new Joomla installation (NOT THE CONFIGURATION.PHP)
6. Done......
Let me know if it works for you guys....
1. Install New installation of Joomal on new server.
2. Open the database with myphpadmin and drop all the tables.
3. Import all the tables from your database of the Joomla site you want to move.
4. Zip all the files from your existing Joomla you want to move but leave out the configuration.php file
5. Now overwrite all the files in the new Joomla installation (NOT THE CONFIGURATION.PHP)
6. Done......
Let me know if it works for you guys....
-
- +0
-
-
written by Wim, July 09, 2007
Great post. I prefer using joomlacloner to move sites to another host.
-
- +0
-
-
written by Haris, July 10, 2007
Hi Cory,
Nice tutorial. but at the step 5, when i import fresh Joomla file using phpMyAdmin, i've got error message...
and i dont know what does it mean.
so up to know my site only look like this; www.joycore.eu
Any suggestions?
Thanks before
Nice tutorial. but at the step 5, when i import fresh Joomla file using phpMyAdmin, i've got error message...
MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK
' at line 1
and i dont know what does it mean.
so up to know my site only look like this; www.joycore.eu
Any suggestions?
Thanks before
-
- +0
-
-
written by Chris J, August 07, 2007
I wish I had seen this yesterday when I was installing Joomla on my new host! There should be a link to this article in the Joomla 1.5 install tutorial, or with the link to that tutorial on joomla.org!
-
- +0
-
-
written by Cory, August 07, 2007
Hi Chris,
I'm glad you found this useful. The article was written with Joomla 1.0.x in mind, but the same concepts could apply to Joomla 1.5.
Cory
I'm glad you found this useful. The article was written with Joomla 1.0.x in mind, but the same concepts could apply to Joomla 1.5.
Cory
-
- +0
-
-
written by Joel & Mandy, August 25, 2007
Thanks so much, Cory! Our site is now officially switched to a new server thanks to your Step 3 advice. Our configuration.php was wrong when using JoomlaPack and we wouldn't have known to check it if not for this article. You're awesome.
-
- +0
-
-
written by Cory, August 26, 2007
Hi Joel & Mandy,
Thank for your comment. I'm glad you found this article useful. Your site looks very interesting. I'm a relatively new parent myself. My daughter is 20 months old, and she's quite a handful!
Good luck!
Cory
Thank for your comment. I'm glad you found this article useful. Your site looks very interesting. I'm a relatively new parent myself. My daughter is 20 months old, and she's quite a handful!
Good luck!
Cory
-
- +0
-
-
written by Ken, September 08, 2007
I am trying to move a Mambo website to a new server and have followed your directions for a Joomla site. After uploading to the new site I am getting the following error message:
Warning: main(/htdocs/includes/version.php) [function.main]: failed to open stream: No such file or directory in /data/14/1/157/80/1320569/user/1414736/htdocs/includes/mambo.php on line 37
Fatal error: main() [function.require]: Failed opening required '/htdocs/includes/version.php' (include_path='.:/usr/services/vux/lib/php') in /data/14/1/157/80/1320569/user/1414736/htdocs/includes/mambo.php on line 37
Any idea what is wrong?
Ken
Warning: main(/htdocs/includes/version.php) [function.main]: failed to open stream: No such file or directory in /data/14/1/157/80/1320569/user/1414736/htdocs/includes/mambo.php on line 37
Fatal error: main() [function.require]: Failed opening required '/htdocs/includes/version.php' (include_path='.:/usr/services/vux/lib/php') in /data/14/1/157/80/1320569/user/1414736/htdocs/includes/mambo.php on line 37
Any idea what is wrong?
Ken
-
- +0
-
-
written by Cory, September 08, 2007
It looks like you did your configuration wrong. Your $mosConfig_absolute_path and $mosConfig_cache_path seem to be incorrect.
Instead of
you should have
Instead of
you should have
Let me know if that works.
Good luck!
Instead of
/htdocs
you should have
/data/14/1/157/80/1320569/user/1414736/htdocs
Instead of
/htdocs/cache
you should have
/data/14/1/157/80/1320569/user/1414736/htdocs/cache
Let me know if that works.
Good luck!
-
- +0
-
-
written by Ken, September 08, 2007
Cory, Thanks for that suggestion.
Now I get to a screen that says :
This site is temporarily unavailable.
Please notify the System Administrator
2
I would appreciate any futher help you may have or pointing me to any online docs
Thanks,
Keh
Now I get to a screen that says :
This site is temporarily unavailable.
Please notify the System Administrator
2
I would appreciate any futher help you may have or pointing me to any online docs
Thanks,
Keh
-
- +0
-
-
written by Doc, October 05, 2007
Thanks Cory, this is a real time saver.
I am not sure that I did it absolutely by the book however, it is working.
I downloaded the old files as you suggested, did a fresh install of Joomla first on the new server, changed the config file and uploaded the old site to the new server, overwriting the fresh install. In thinking about it, I didn't need to do the fresh install did I?
For those that do you need to empty the DB files that you created during the fresh install of Joomla on the new server. Then just import the old DB files into the empty DB
I am not sure that I did it absolutely by the book however, it is working.
I downloaded the old files as you suggested, did a fresh install of Joomla first on the new server, changed the config file and uploaded the old site to the new server, overwriting the fresh install. In thinking about it, I didn't need to do the fresh install did I?
For those that do you need to empty the DB files that you created during the fresh install of Joomla on the new server. Then just import the old DB files into the empty DB
-
- +0
-
-
written by Trevor M., October 12, 2007
Hey Cory,
I'm currently creating 2 Joomla sites to convert old sites to joomla. So, I'm keeping up the old sites until I get the Joomla site design done. Now, Joomla site is in a sub directory.
When I'm ready to go live and move my Joomla installation to the main directory... what will have to be done?
I'd almost rather just pay someone to do it for both sites... how much would that run per site when each site does not have a ton of content?
Cheers
Trevor Mauch
I'm currently creating 2 Joomla sites to convert old sites to joomla. So, I'm keeping up the old sites until I get the Joomla site design done. Now, Joomla site is in a sub directory.
When I'm ready to go live and move my Joomla installation to the main directory... what will have to be done?
I'd almost rather just pay someone to do it for both sites... how much would that run per site when each site does not have a ton of content?
Cheers
Trevor Mauch
-
- +0
-
-
written by Cory, October 13, 2007
Hi Trevor,
You might find this article helpful...
http://www.howtojoomla.net/content/view/28/2/
It talks about moving your site from a sub directory to the root directory. It is a pretty simple procedure, so you should not have to pay much for that if you hire someone to do it.
Good luck!
You might find this article helpful...
http://www.howtojoomla.net/content/view/28/2/
It talks about moving your site from a sub directory to the root directory. It is a pretty simple procedure, so you should not have to pay much for that if you hire someone to do it.
Good luck!
-
- +0
-
-
written by Nick, October 18, 2007
Thank you!
Apart from the permissions, it went like a dream.
Apart from the permissions, it went like a dream.
-
- +0
-
-
written by Matt D, November 10, 2007
Hey Cory, thanks for the help! I ran into some issues using phpMyAdmin to do the import; it was giving me access-denied errors. To get around it, I just copied all of the SQL out of the exported file, and pasted it right into the "SQL" tab in phpMyAdmin. Worked like a charm. Thanks again.
-
- +0
-
-
written by Will, November 19, 2007
Works great!
Much better if there's a little instructions on backup-restore database part.
Much better if there's a little instructions on backup-restore database part.
-
- +0
-
-
written by Marcus Harun, December 06, 2007
I would absolutely like to thank you for exact instructions. i have used these instruction multiple times. And I'm soo glad I was able to do it on my own...with your help.
I appreciate it very much.
Thanks
I appreciate it very much.
Thanks
-
- +0
-
-
written by JoshBond007, December 12, 2007
i installed an old joomla in a sub domain of my site. now i have a running joomla site on a sub directory...my question is...how can i import just the articles from the old database to the new one?
-
- +0
-
-
written by Cory, December 12, 2007
Hi Josh,
You need to export jos_content, jos_categories, and jos_sections from the old site and import them to the new one. Be careful that you do not have any id conflicts with the jos_content, jos_categories, and jos_sections on the new site.
Good luck!
Cory
You need to export jos_content, jos_categories, and jos_sections from the old site and import them to the new one. Be careful that you do not have any id conflicts with the jos_content, jos_categories, and jos_sections on the new site.
Good luck!
Cory
-
- +0
-
-
written by shonda, December 13, 2007
Hello, I am trying to install Joomla and finally thought I was done until I got this error below....I changed the name of the configuration.dst.php to configuration.php and copied all of the new files over. Is there something else I can do to get joomla working?
Warning: main(/path/to/joomla/install/includes/version.php) [function.main]: failed to open stream: No such file or directory in /home/youngcom/public_html/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required '/path/to/joomla/install/includes/version.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/youngcom/public_html/includes/joomla.php on line 71
Warning: main(/path/to/joomla/install/includes/version.php) [function.main]: failed to open stream: No such file or directory in /home/youngcom/public_html/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required '/path/to/joomla/install/includes/version.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/youngcom/public_html/includes/joomla.php on line 71
-
- +0
-
-
written by Nick, December 13, 2007
Looks like the path for $mosConfig_absolute_path in the configuration.php is wrong. From what you say it should be set to:
$mosConfig_absolute_path = '/home/youngcom/public_html';
$mosConfig_absolute_path = '/home/youngcom/public_html';
-
- +0
-
-
written by Nick, December 13, 2007
Hi Cory
Sorry, I am using your comments as if it was a forum!
Sorry, I am using your comments as if it was a forum!
-
- +0
-
-
written by Cory, December 13, 2007
No problem, Nick! Thanks for answering that. You said exactly what I was going to say.
-
- +0
-
-
written by shonda, December 13, 2007
Thanks for your quick response, I really appreciate it!!!
That change worked. BUT....now it says that it could not connect to the database server. I set all of that up in installation but I did notice in the config file that none of that information was in that file, it appears that all defaults are still there.
Should I attempt to go in and change it in the config file to change the mysql infomation. I already deleted the installation folder per the instructions so now I feel like I am stuck to do this manually (or I could ftp over the installation file again), only thing is I with manually updating this is that I dont know what lines of code to update. Let me know your thoughts.
That change worked. BUT....now it says that it could not connect to the database server. I set all of that up in installation but I did notice in the config file that none of that information was in that file, it appears that all defaults are still there.
Should I attempt to go in and change it in the config file to change the mysql infomation. I already deleted the installation folder per the instructions so now I feel like I am stuck to do this manually (or I could ftp over the installation file again), only thing is I with manually updating this is that I dont know what lines of code to update. Let me know your thoughts.
-
- +0
-
-
written by shonda, December 13, 2007
never mind, I changed the info in the config and it worked!!! I just changed the obvious from the default (sql and website name), if you guys know of something else that I should of changed let me know.
-
- +0
-
-
written by Reece, December 30, 2007
Hi Cory,
Thanks for writing this, however i get these errors
faultCode0faultStringWarning:require_once() [function.require-once]:
Unable to access /home/vol2/webhosting4free.info/habboduluxe/htdocs/htdocs/includes/version.php
in /home/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on line
71
faultCode0faultStringWarning:require_once(/home/vol2/webhosting4free.info
/habboduluxe/htdocs/htdocs/includes/version.php) [function.require-once]:
failed to open stream: No such file or directory in
/home/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on
line 71faultCode0faultStringFatal error:require_once() [function.require]:
Failed opening required '/home/vol2/webhosting4free.info/habboduluxe/htdocs
/htdocs/includes/version.php' (include_path='.:/usr/share/php:/tmp') in /home
/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on line 71
How do i fix it?
Thanks
Thanks for writing this, however i get these errors
faultCode0faultStringWarning:require_once() [function.require-once]:
Unable to access /home/vol2/webhosting4free.info/habboduluxe/htdocs/htdocs/includes/version.php
in /home/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on line
71
faultCode0faultStringWarning:require_once(/home/vol2/webhosting4free.info
/habboduluxe/htdocs/htdocs/includes/version.php) [function.require-once]:
failed to open stream: No such file or directory in
/home/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on
line 71faultCode0faultStringFatal error:require_once() [function.require]:
Failed opening required '/home/vol2/webhosting4free.info/habboduluxe/htdocs
/htdocs/includes/version.php' (include_path='.:/usr/share/php:/tmp') in /home
/vol2/webhosting4free.info/habboduluxe/htdocs/includes/joomla.php on line 71
How do i fix it?
Thanks
-
- -1
-
-
written by Reece, December 30, 2007
This has now been fixed. i had 2 htdocs
Have a great new Year
Have a great new Year
-
- +0
-
-
written by admin12, January 03, 2008
Cory... you rock!!!
instructions worked perfect!!
many thanks!
instructions worked perfect!!
many thanks!
-
- +0
-
-
written by Tamas, January 29, 2008
Thanks a lot! It was easy, and worked fine! I am glad to have found your script!
:-)
Greetings from Budapest,
Tamas
:-)
Greetings from Budapest,
Tamas
-
- +0
-
-
written by sayeed, February 15, 2008
I just installed joomla with apache, mysql and php, it works fine for a single website.
I got three different websites and would like to have separate joomla
for each website.
Can someone please help or redirect me to some online tutorial.
Regards,
I got three different websites and would like to have separate joomla
for each website.
Can someone please help or redirect me to some online tutorial.
Regards,
-
- +0
-
-
written by Cory, February 15, 2008
Hi sayeed,
To install multiple instances of Joomla on the same server, you simply upload your Joomla files to separate folders and install them like normal. If you are using the same database for each site, you will need to use a different table prefix for each. You should see that option when you are installing.
Good luck!
To install multiple instances of Joomla on the same server, you simply upload your Joomla files to separate folders and install them like normal. If you are using the same database for each site, you will need to use a different table prefix for each. You should see that option when you are installing.
Good luck!
-
- +0
-
-
written by M, March 10, 2008
Well this looks useful but one problem Im getting is in regards to servage. No one at Joomla forums seems to have an answer:
http://forum.joomla.org/viewtopic.php?f=430&t=272408
http://forum.joomla.org/viewtopic.php?f=430&t=272408
-
- +0
-
-
written by Shawn, March 24, 2008
I know my issue is username/password related. But could you also do a tutorial like this for Joomla 1.5.1 Stable? The config.php file structure is different than 1.0.
-
- +0
-
-
written by williee, April 11, 2008
How would one add a marker or link to a content item so that when a user clicks on that item the page scrolls down the page to the apporpriate item? I am aware how to create a link but I am not sure that is what I am looking for. Thanks
-
- +0
-
-
written by Makis77, April 13, 2008
Thank you!
There is a more detailed tutorial over here:
http://www.joomlaspots.com/Tutorials/Smart-and-Fast/Joomla-Tutorial.html
There is a more detailed tutorial over here:
http://www.joomlaspots.com/Tutorials/Smart-and-Fast/Joomla-Tutorial.html
-
- -2
-
-
written by Sakeenah, April 19, 2008
this is a great tutorial thank you but its hard to read since the text has to be reduced very small to read all of it,.
-
- +0
-
-
written by Haris, April 19, 2008
Hi, just let you know.
I used mac and firefox 2.0.0.14 as browser. the right side of your site is cutted off,
i mean, your content not really floated to the right side, so i couldn't read every line completly. at least it make difficult to understand your tutorial. just like cut off on the right side. maybe template case.
Regards,
Haris
I used mac and firefox 2.0.0.14 as browser. the right side of your site is cutted off,
i mean, your content not really floated to the right side, so i couldn't read every line completly. at least it make difficult to understand your tutorial. just like cut off on the right side. maybe template case.
Regards,
Haris
-
- +0
-
-
written by Cory, April 20, 2008
Thanks for the tip, Haris. Someone had written a comment with a string that was too long for the width of the box. I have now fixed this.
-
- +0
-
-
written by maddy, April 24, 2008
Hello pal....
Can u tell me how it works for Joomla 1.5 version
Can u tell me how it works for Joomla 1.5 version
-
- +0
-
-
written by Paul Davies, May 13, 2008
Thanks very much for this. It made something I had expected to be very difficult turn out actually to relatively easy. I didn't follow precisely all of the steps and there were some bits I got stuck but there was enough info to allow me to work it out. Thanks.
I am new to Joomla but have in last month created a localhost site. I wanted to test whether I could back it up and move it to another machine (my laptop) before going live on the hosted server.
My variation was that I found that I didn't need to use SQL/PHP tools at all to export/import the database. All's I did was to copy the db directory from the main PC to the laptop. I am using wampserver so for both machines structure was same. I found the database was in (this took a little looking for):
C:wampinmysqlmysql5.0.51adataMySiteDatabaseDirectroy
I had also copied over the main Joomla directory under:
C:wampwwwMyJoomla15Files
Also had to remember to install wampserver on the laptop.
I was so suprised when the site just came up first time. I expect problems!
Thanks for your guide.
Paul.
I am new to Joomla but have in last month created a localhost site. I wanted to test whether I could back it up and move it to another machine (my laptop) before going live on the hosted server.
My variation was that I found that I didn't need to use SQL/PHP tools at all to export/import the database. All's I did was to copy the db directory from the main PC to the laptop. I am using wampserver so for both machines structure was same. I found the database was in (this took a little looking for):
C:wampinmysqlmysql5.0.51adataMySiteDatabaseDirectroy
I had also copied over the main Joomla directory under:
C:wampwwwMyJoomla15Files
Also had to remember to install wampserver on the laptop.
I was so suprised when the site just came up first time. I expect problems!
Thanks for your guide.
Paul.
-
- +0
-
-
written by yuva, June 23, 2008
Warning: main(home/web/htdocs/www.exitus.org.uk/public_html /includes/version.php) [function.main]: failed to open stream: No such file or directory in /web/htdocs/www.exitus.org.uk/home/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required 'home/web/htdocs/www.exitus.org.uk/public_html /includes/version.php' (include_path='.:/php/lib/php/') in /web/htdocs/www.exitus.org.uk/home/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required 'home/web/htdocs/www.exitus.org.uk/public_html /includes/version.php' (include_path='.:/php/lib/php/') in /web/htdocs/www.exitus.org.uk/home/includes/joomla.php on line 71
-
- -1
-
-
written by yuva, June 23, 2008
this is my error ,can u just help me in solving this,i hav designed a joomla website thats in my local drive,i need to upload to web,can u say the procedure
-
- +0
-
-
written by Lohita, July 09, 2008
Hey Cory, I've been using your guide faithfully and it's really worked well. Thanks! I recently however came across a Joomla backup component called "JoomlaPack". Automates everything and makes it so easy to clone sites. You may find more details of it here: http://extensions.joomla.org/c...temid,35/. The best part is that it's free and open source!
-
- +1
-
-
written by YE is Here, July 10, 2008
Hi,
Had 2 give some props for this most useful and concise info. Thanks a zillion. . .
YE is Here!
Had 2 give some props for this most useful and concise info. Thanks a zillion. . .
YE is Here!
-
- +1
-
-
written by Webmory, July 19, 2008
Dear Cory,
I really find your tutorial detailled as compared to what the hosting company says...But despite about 3 days trying to make it work , I keep getting error messages.
The one I have right now is :
" Warning: Unexpected character in input: '' (ASCII=92) state=1 in /home/ishango/public_html/configuration.php on line 2
Parse error: syntax error, unexpected T_STRING in /home/ishango/public_html/configuration.php on line 2 "
With the import of the database, I get :
Error
SQL query:
-- -- Dumping data for table `jos_banner` -- INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES (1, 1, 'banner', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 62, '2008-06-07 22:00:03', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (2, 1, 'banner', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (3, 1, '', 'Joomla!', 'joomla', 0, 17, 0, '', 'http://www.joomla.org', '2006-05-29 14:21:28', 1, 0, '0000-00-00 00:00:00', '', '{NAME}
[...]
MySQL said:
#1062 - Duplicate entry '1' for key 1
What did I do wrong and how do I go about to have the joy of moving the site?
Thanks in advnace and best regards.
I really find your tutorial detailled as compared to what the hosting company says...But despite about 3 days trying to make it work , I keep getting error messages.
The one I have right now is :
" Warning: Unexpected character in input: '' (ASCII=92) state=1 in /home/ishango/public_html/configuration.php on line 2
Parse error: syntax error, unexpected T_STRING in /home/ishango/public_html/configuration.php on line 2 "
With the import of the database, I get :
Error
SQL query:
-- -- Dumping data for table `jos_banner` -- INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES (1, 1, 'banner', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 62, '2008-06-07 22:00:03', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (2, 1, 'banner', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (3, 1, '', 'Joomla!', 'joomla', 0, 17, 0, '', 'http://www.joomla.org', '2006-05-29 14:21:28', 1, 0, '0000-00-00 00:00:00', '', '{NAME}
[...]
MySQL said:
#1062 - Duplicate entry '1' for key 1
What did I do wrong and how do I go about to have the joy of moving the site?
Thanks in advnace and best regards.
-
- +1
-
-
written by Linda, August 05, 2008
Thanks for the great tips! I will be moving a client's website from my subdomain to their servers - and I was a little worried about how to go about it. I do hope they have Linux servers, though.
-
- +1
-
-
written by Spencer Karnovski, November 24, 2008
Hello there. I would like to do the opposite. We have a company website that I want to download to a working localhost server (my PC) to test.
I have Ftp/Exported all the files, made up an local mySQL Database with the same name as the website's. I have changed the configuration files like expressed above (although not sure if I have the right settings> //localhost/websiteDirectory/
But I keep getting a 500 Internal Server error. So, firstly, does this helpful tutorial apply to transferring from a server on the internet to a localhost set-up? And secondly, do I have to change the same files?
Thanks
I have Ftp/Exported all the files, made up an local mySQL Database with the same name as the website's. I have changed the configuration files like expressed above (although not sure if I have the right settings> //localhost/websiteDirectory/
But I keep getting a 500 Internal Server error. So, firstly, does this helpful tutorial apply to transferring from a server on the internet to a localhost set-up? And secondly, do I have to change the same files?
Thanks
-
- +0
-
-
written by Cory Webb, November 24, 2008
Hi Spencer,
This tutorial only applies to Joomla 1.0. If you are moving a Joomla 1.5 site, the changes you make to configuration.php are slightly different. This should work with moving a site from the internet to a localhost set-up.
Cory
This tutorial only applies to Joomla 1.0. If you are moving a Joomla 1.5 site, the changes you make to configuration.php are slightly different. This should work with moving a site from the internet to a localhost set-up.
Cory
-
- +0
-
-
written by Alan S, November 25, 2008
Many thanks for this article, which I hope scales to Joomla 1.5? I've checked several books on Joomla, but none that I've seen so far have covered the 'develop locally, then upload' route.
Is there any particular reason for this? They all seem to suggest either installing and developing remotely, which always makes me nervous from a security point of view - I don't want users to see my experiments, particularly when I'm trying to implement e.g. a shopping basket and payment system. Or they suggest XAMPP with no idea of how to make the site live on the internet!
Just putting together my first Joomla site, so I'm on a learning curve!
Is there any particular reason for this? They all seem to suggest either installing and developing remotely, which always makes me nervous from a security point of view - I don't want users to see my experiments, particularly when I'm trying to implement e.g. a shopping basket and payment system. Or they suggest XAMPP with no idea of how to make the site live on the internet!
Just putting together my first Joomla site, so I'm on a learning curve!
-
- +0
-
-
written by Chris Klinger, December 28, 2008
Great article. I'm doing all of my setup on my local server, and plan to meove everything when done. I installed Joomla on the remote server, just to see if everything was compatible, and it's up and running, so my move should be relatively painless when I'm ready.
As I already have Joomla online externally, I plan to overwrite only what's necessary (I'm keeping my fingers crossed, though i'm sure I have a few more gray hairs coming
Might be interesting to add to your article the importance of file/directory permissions when moving things about.
Thanks again for a great article. I've bookmarked it.
Rgds,
Chris
As I already have Joomla online externally, I plan to overwrite only what's necessary (I'm keeping my fingers crossed, though i'm sure I have a few more gray hairs coming
Might be interesting to add to your article the importance of file/directory permissions when moving things about.
Thanks again for a great article. I've bookmarked it.
Rgds,
Chris
-
- +0
-
-
written by Larry Dearing, December 30, 2008
Corey, your article here for 1.0.x allowed me to move sites at will with no fear and with considerable confidence. Thank you. I am not a developer/designer, but find Joomla like "paint by numbers"... you don't have to know about colors, shading, perspective and such... you just follow the numbers.
Sooooo... its now time to do this formally for 1.5.x if you please. i know some of the variables are different, some no longer there, and they "look" different..... Many, Many would be gratful.
Thanks for all your work
-Larry
Sooooo... its now time to do this formally for 1.5.x if you please. i know some of the variables are different, some no longer there, and they "look" different..... Many, Many would be gratful.
Thanks for all your work
-Larry
-
- +0
-
-
written by Cory Webb, December 30, 2008
Hi Larry... Thanks for your kind words. I would love to write this for 1.5, but I have not had the time. My schedule will be freeing up in the next couple of weeks, and I can start putting more time into this site for things like that.
-
- +0
-
-
written by Pop_and_Rock, January 21, 2009
In case anyone else is running into the "Duplicate entry X for key X" error, like Webmory above, here's a little detail on the mySql part of the instructions.
When exporting your Joomla db from phpMyAdmin, check the box for "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" in the Structure options.
Before importing, delete the "Create Database" command from the sql dump file and the db should import painlessly.
Great tutorials, Cory, looking forward to the 1.5 updates!
When exporting your Joomla db from phpMyAdmin, check the box for "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION" in the Structure options.
Before importing, delete the "Create Database" command from the sql dump file and the db should import painlessly.
Great tutorials, Cory, looking forward to the 1.5 updates!
-
- +1
-
-
written by Mombo-Joomla, January 21, 2009
Take extra care with the data base part and back it up twice. I lost mine once and oh boy that was bad.
-
- +0
-
-
written by Rob, January 27, 2009
I need help! Whenever I try to backup my site it pops up an error (
Invalid AJAX Response:var res = { 0: 'step', 1: '' }; res
can you help me?
Invalid AJAX Response:var res = { 0: 'step', 1: '' }; res
can you help me?
-
- +1
-
-
written by Nathalie, February 04, 2009
Hi Cory,
I have been at this for four days now!
I have copied my Joomla files to my new server , created a SQL database and then imported the database from my existing Joomla site, changed my configuration on my conifguration.php page and yet I get this message when I Google my site and click on my file:
Warning: require_once(/home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php) [function.require-once]: failed to open stream: No such file or directory in /home/nathfise/public_html/weddingyap/includes/framework.php on line 66
Fatal error: require_once() [function.require]: Failed opening required '/home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nathfise/public_html/weddingyap/includes/framework.php on line 66
Please answer me in the most basic- talk slower and do not use any unecessary jargon terms as I am non-techie.
Thank you for your time,
Nathalie
I have been at this for four days now!
I have copied my Joomla files to my new server , created a SQL database and then imported the database from my existing Joomla site, changed my configuration on my conifguration.php page and yet I get this message when I Google my site and click on my file:
Warning: require_once(/home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php) [function.require-once]: failed to open stream: No such file or directory in /home/nathfise/public_html/weddingyap/includes/framework.php on line 66
Fatal error: require_once() [function.require]: Failed opening required '/home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nathfise/public_html/weddingyap/includes/framework.php on line 66
Please answer me in the most basic- talk slower and do not use any unecessary jargon terms as I am non-techie.
Thank you for your time,
Nathalie
-
- +0
-
-
written by Cory, February 04, 2009
Hi Nathalie,
It looks like the file at /home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php is missing. You may need to check and make sure you copied all of the files over correctly.
I hope that helps!
It looks like the file at /home/nathfise/public_html/weddingyap/libraries/joomla/utilities/compat/compat.php is missing. You may need to check and make sure you copied all of the files over correctly.
I hope that helps!
-
- +0
-
-
written by Nathalie, February 05, 2009
Hi Cori and Rob,
Thank you for the precious help
Indeed the files were missing! I reloaded the entire Joomla site files. I do my uploading via FTP commander as I tried Joomlapack and many files could not be transferred.
Wish me luck!
Nathalie
P.s. I saw in Reader,s Digest: How many tech support people does it take to change a lightbulb? Have you tried turning it off and then turning it on again?
Thank you for the precious help
Indeed the files were missing! I reloaded the entire Joomla site files. I do my uploading via FTP commander as I tried Joomlapack and many files could not be transferred.
Wish me luck!
Nathalie
P.s. I saw in Reader,s Digest: How many tech support people does it take to change a lightbulb? Have you tried turning it off and then turning it on again?
-
- +0
-
-
written by Nathalie, February 06, 2009
Hi again!
I have erased and re-loaded the files and database and now I get this message: Unable to load session storage class: database.
I have created a database and changed the user name and database name in the php config file. I have no clue what is not working. help please!
Thank you
Nathalie
I have erased and re-loaded the files and database and now I get this message: Unable to load session storage class: database.
I have created a database and changed the user name and database name in the php config file. I have no clue what is not working. help please!
Thank you
Nathalie
-
- +0
-
-
written by Joe Snider, February 12, 2009
Hi,
I seem to be parralleling Nathatalie's experience exactly. Tried to migrate to root directory. Got the compat error - files were missing. I recreated them. Now I am getting the "Unable to load session storage class: database" In fact, I am guessing this was a factor of FTP Commander, because I used that also! It must have dropped these files out or something??
Desperate for help.
Thanks!
Everything was working great until I tried the migrate. In fact, I
I seem to be parralleling Nathatalie's experience exactly. Tried to migrate to root directory. Got the compat error - files were missing. I recreated them. Now I am getting the "Unable to load session storage class: database" In fact, I am guessing this was a factor of FTP Commander, because I used that also! It must have dropped these files out or something??
Desperate for help.
Thanks!
Everything was working great until I tried the migrate. In fact, I
-
- +0
-
-
written by Nathalie, February 13, 2009
hi,
My migration actually worked. What I was doing wrong was not putting my Joomla files in my main folder as i was confusing putting the files for my add-ons domains. Next, I did not connect the user I created to the database.
My site is online but I still am experiencing some issues. I think the best would be to zip the files before uploading them which I cannot do with FTP commander.
Anyway, what worked for me what to do the entire procedure again.
Nathalie
My migration actually worked. What I was doing wrong was not putting my Joomla files in my main folder as i was confusing putting the files for my add-ons domains. Next, I did not connect the user I created to the database.
My site is online but I still am experiencing some issues. I think the best would be to zip the files before uploading them which I cannot do with FTP commander.
Anyway, what worked for me what to do the entire procedure again.
Nathalie
-
- +0
-
-
written by Ecommerce Consultant, February 24, 2009
Hi Cory,
Thanks for this great guide, everything worked perfectly and has saved me a big job of redoing the whole lot, the only difference I made was that I couldnt have the same database name twice so had to export the tables only from the db and into the new one.
Spot on with the guide.
Many thanks,
Liam
Thanks for this great guide, everything worked perfectly and has saved me a big job of redoing the whole lot, the only difference I made was that I couldnt have the same database name twice so had to export the tables only from the db and into the new one.
Spot on with the guide.
Many thanks,
Liam
-
- +0
-
-
written by Terry Brooks, March 14, 2009
Okay, here's the deal. I moved my site (J1.0) to the new server. How did you test your move? I set up my destination site with the same domain name as the source site, moved the backups and database, then pointed the domain at the new server. It's been 12 hours and I still can not access the destination site to test the move. How long should I expect the domain name propagation to take? Is there another way to test the destination site?
-
- +0
-
-
written by Cory, March 14, 2009
Hi Terry,
Domain name propagation can take up to 48 hours. I've seen it happen within just a few minutes, and I've seen it take a couple of days. It varies. You could test your move if you have a temporary URL at your new server. You would have to change the URL in the configuration.php file, though.
Good luck!
Domain name propagation can take up to 48 hours. I've seen it happen within just a few minutes, and I've seen it take a couple of days. It varies. You could test your move if you have a temporary URL at your new server. You would have to change the URL in the configuration.php file, though.
Good luck!
-
- +0
-
-
written by Just Me, March 27, 2009
Article seems outdated as I see no such fields in config file. Can you update it for 1.5? I am struggling with a migration
-
- +1
-
-
written by yone, April 08, 2009
hi...i finished my joomla site in local base then i uploaded it and made the required modifications..like db name user and pass and i imported the database but it still is telling me Unable to load session storage class: database...please give me ur advice what can i do this is so in a hurry
-
- +0
-
-
written by Malc, April 24, 2009
I have followed the instructions but nothing showing on IE7? I have imported my data and uploaded the files changed the configuration.php, but mine is a little bit different tems to the $mosConfig_absolute_path I have "var $tmp_path = '/customers/rodway-hill-golf-course.co.uk/rodway-hill-golf-course.co.uk/httpd.www/tmp" etc
Is this mean I have to change var to mos? also editing the configuration.php file within the root directory.
If any one has ideas on how to get over this problem
Is this mean I have to change var to mos? also editing the configuration.php file within the root directory.
If any one has ideas on how to get over this problem
-
- +0
-
-
written by Cory, April 24, 2009
Hi Malc,nnIf your site is built in Joomla 1.5, you may want to check out this article: How to move your Joomla! 1.5 site to a new server.nnGood luck!
-
- +0
-
-
written by Malc, April 24, 2009
The guys at the ISP state I should do a fresh installation of Joomla and then upload a csv file? Is there no other way moving from one isp to another?
-
- +0
-
-
written by Malc, April 24, 2009
Joomla 1.5.6
additional info, the two server it was hosted Windows NT IIS650 5.2 build 3790 - Microsoft IIS/6.0 and the new server is a Linux srv102 2.6.18-6-vserver based using Apache the php versions are 5.2.6 and 5.2.8 does this make any difference
additional info, the two server it was hosted Windows NT IIS650 5.2 build 3790 - Microsoft IIS/6.0 and the new server is a Linux srv102 2.6.18-6-vserver based using Apache the php versions are 5.2.6 and 5.2.8 does this make any difference
-
- +0
-
-
written by Cory, April 24, 2009
Ok, you really should be looking at this article:
How to move your Joomla! 1.5 site to a new server
The server shouldn't matter, as Joomla! runs the same on both.
How to move your Joomla! 1.5 site to a new server
The server shouldn't matter, as Joomla! runs the same on both.
-
- +0
-
-
written by Malc, April 24, 2009
Cory,
I have checked the pages and not all are being pulled across from the database. visit http://www.rodway-hill-golf-co...&Itemid=61 the contact us and the contact form work but none of the other pages, do you have any idea
Malc
I have checked the pages and not all are being pulled across from the database. visit http://www.rodway-hill-golf-co...&Itemid=61 the contact us and the contact form work but none of the other pages, do you have any idea
Malc
-
- +0
-
-
written by Cory, April 24, 2009
It's tough to say without actually looking at the files and the database what is wrong with it.
-
- +0
-
-
written by Cory, April 24, 2009
At the moment, I am swamped doing work for my clients. If you would like to hire me, you can visit my company website at http://www.corywebbmedia.com
-
- +0
-
-
written by Tamara, April 24, 2009
Is it possible to point to an ip address instead of a url? I want to be able to make sure this transfer works before the DNS is changed
-
- +0
-
-
written by Shine Rankin, May 12, 2009
Cory:
I have a pretty beefy 1.0 site built with godaddy hosting. I'm finally ready to move 1.5 but I need a way to get my 1.0 content to 1.5. I've got joomlapack installed on the 1.0 install, and have packed my site.
I tried export content but it gives me a 500 error every time. If i was on 1.5 already i'd use the core migrator. Any Ideas?
Great site and a wonderful resource btw...
I have a pretty beefy 1.0 site built with godaddy hosting. I'm finally ready to move 1.5 but I need a way to get my 1.0 content to 1.5. I've got joomlapack installed on the 1.0 install, and have packed my site.
I tried export content but it gives me a 500 error every time. If i was on 1.5 already i'd use the core migrator. Any Ideas?
Great site and a wonderful resource btw...
-
- +0
-
-
written by Cory, May 12, 2009
Hi Shine,
Migrating from 1.0 to 1.5 can be a really tricky process. There's not really a good explanation anywhere on how to do it because the process varies from site to site. One complicating factor is all of the different components on a site. You have to make sure there is an upgrade path for each component, or decide how best to deal with the data in that component. It can get really complicated really quickly. The best advice I can give (and I know it's not really good advice) is to find a professional who has experience performing this type of migration.
Best of luck!
Cory
Migrating from 1.0 to 1.5 can be a really tricky process. There's not really a good explanation anywhere on how to do it because the process varies from site to site. One complicating factor is all of the different components on a site. You have to make sure there is an upgrade path for each component, or decide how best to deal with the data in that component. It can get really complicated really quickly. The best advice I can give (and I know it's not really good advice) is to find a professional who has experience performing this type of migration.
Best of luck!
Cory
-
- +0
-
-
written by Shine Rankin, May 12, 2009
Cory: I would agree. That why I only want the articles/categories/sections. I can install the components and modules/templates after I get the content. I just dont want to lose the articles themselves.
-
- +0
-
-
written by Cory, May 12, 2009
The migrator component should work for that. You install the component on your 1.0 site, and it generates a migration file for you. Then, when you install your 1.5 site, you use the migration file in one of the steps in the installation process.
-
- +0
-
-
written by dunxnud, May 15, 2009
Visit http://www.joomlapack.net/ and download the component as well as their kickstart.php file
- Go to your Joomla administrator section and install the Joomlapack component
- Once it has been installed go to the Joomlapack component screen from
components>>Joomlapack and click 'Configuration'
- In the configuration screen go to 'Advanced' and change the compression from .ZIP to JPA Joomlapack Archive
- Click 'Save'
- Click 'Backup Now'
- Once the backup has completed go to 'Manage Backups'
- Download the new backup and save it to your local machine
- Connect to our server via FTP and then upload the backup JPA file as well as kickstart.php
- Once this has been done visit www.yoursite.XXX/kickstart.php
- Select 'Use FTP' and enter your FTP details
- Click 'Start'
- Once the restore has completed visit your site
- Complete the installation procedure
- Delete the /httpdocs/installation directory
- Go to your Joomla administrator section and install the Joomlapack component
- Once it has been installed go to the Joomlapack component screen from
components>>Joomlapack and click 'Configuration'
- In the configuration screen go to 'Advanced' and change the compression from .ZIP to JPA Joomlapack Archive
- Click 'Save'
- Click 'Backup Now'
- Once the backup has completed go to 'Manage Backups'
- Download the new backup and save it to your local machine
- Connect to our server via FTP and then upload the backup JPA file as well as kickstart.php
- Once this has been done visit www.yoursite.XXX/kickstart.php
- Select 'Use FTP' and enter your FTP details
- Click 'Start'
- Once the restore has completed visit your site
- Complete the installation procedure
- Delete the /httpdocs/installation directory
-
- +0
-
-
written by Cory, May 15, 2009
Hi dunxnud... You're right, that's probably the best way to do it. But this tutorial was just meant to show you how to do it manually.
-
- +0
-
-
written by parisa, May 21, 2009
i just moved my server and tryin to figure it out, its doing my head in i have it working but its not showing my article : (
http://investinmyidea.com/
anypointers?
http://investinmyidea.com/
anypointers?
-
- +0
-
-
written by pbasch, May 21, 2009
Maybe you pop too. I don't know. But thanks for the tip, it totally worked at copying my Joomla setup from one PC to another. Wish I knew why.
-
- +0
-
-
written by Ayurveda, May 23, 2009
I've seen once that it is possible to have a testing site and a production one. How can you do that?
thanks
thanks
-
- +0
-
-
Write comment
Join the HowToJoomla Community!
- Create a profile
- Connect with other members
of the community - All for FREE
Already a member? Login here.
HowToJoomla is proudly hosted by Eleven2
Andrew