Comments for How to Move Your Joomla! 1.5 Site to a New Server at http://www.howtojoomla.net , comment 1 to 36 out of 20 comments http://www.howtojoomla.net Wed, 08 Feb 2012 17:23:21 +0100 FeedCreator 1.7.3 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-2080 Hi, First website, first post. Thanks for this article. After a lot of help from my hosting company my Joomla15 site and database are uploaded. However I still need to change the configuration.php to change settings apparently. I think this is step 4 in the article. How to I find/get into configuration.php? Thanks in advance for your help Regards - Paul V de Lacy Wed, 12 May 2010 10:35:55 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-2056 Thanks a lot for this tutorial. I was surprised on how easy it was. - Mathieu Bordeleau Fri, 09 Apr 2010 21:45:26 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-2054 Hello Cory i need to move my joomla site from one host to another host provider. The domain name will remain, and i will migrate the database and original content through phpmyadmin and ftp. What i need to know is if by doing that this way, i will loose what google and other search engines have already indexed in my site? Thanks in advance! - Maka Mon, 05 Apr 2010 14:57:33 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1935 Ok, this my first time using Joomla. As a newbie there are a few things not spell out that well maybe I did wrong. Reason why this is not working for me. I site up a site with Xampp and Joomla, the folder was default Joomla15 (dont know if I can put whatever name I want. suppose i have 2 sites). I already have a website w yahoo so I want to test this one out live. I tried to follow the, "How do you copy a site from localhost to a remote host?" First off I Activated Mysql on yahoo and installed into www.domain.com/phpMyAdmin (its not specified where to install this so I place in its own folder) Is this a mistake? Does this affect my next step? here goes the steps from site: 1. Created a Subdomain -Folder name - www.domian.com/Sub - (refer to question above. should this be install under the phpMyAdmin folder since that is where i install Mysql?) 2. Copied all the files in the Crogram Filesxampphtdocsjoomla15 folder to 'Sub' folder via Filezilla 3.Log into phpMyAdmin (local) and EXPORT to my_export.sql 4.Log into phpMyAdmin (host - yahoo) import my_export.sql Ok everything looks fine so far..... 5. here is where I sort of lost it My changes: var $log_path = '/var/www/vhost/domainname.com/Sub/log'; var $tmp_path = '/var/www/vhost/domainname.com/Sub/tmp'; var $live_site = 'http://www.Sub.domainname.com'; /* Database Settings */ var $dbtype = 'mysql'; (this was already set) var $host = 'mysql'; (I search yahoo and it says the host is mysql) var $user = 'admin'; (is this username my host yahoo or the local - I assume yahoo) var $password = 'password'; (is this pw my host yahoo or the local - I assume yahoo) var $db = 'mysql'; (again yahoo db name mysql) var $dbprefix = 'jos_'; Example: var $log_path = '/var/www/vhost/domain.com/subdirectory/html/logs'; var $tmp_path = '/var/www/vhost/domain.com/subdirectory/html/tmp'; var $live_site = ''; var $host = 'name your remote host'; var $user = 'your_user_db_name'; var $db = 'your_db_name'; var $password = 'your_db_password'; RESULTS: jtablesession::Store Failed DB function failed with error number 1146 Table 'mysql.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id ` ) VALUES ( '5c3dea9a99ad460af6d7f4ca8787efb6','1260415479','','0', '1','0' ) Can someone please please point me in the right direction. Thanks, Carl - Carl Diaz Wed, 09 Dec 2009 22:29:49 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1928 On some shared hosting, you can compress files using the cpanel. If you do that, then you can move a single file down and up to move your files, then uncompress the files on the target server. I've found that on some shared hosting servers, if you use a zip file for compression, file permissions may not be preserved. Using .tar compression seems to work, though. Just be sure you are in the same (relative) place in your directories where you compress and uncompress. Thanks for the step-by-step! - Susan Zakar Tue, 01 Dec 2009 16:12:15 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1923 Hi Robert! Try to contact your older hosting provider support service in order to ask them for a backup of your Joomla database. If you don't have access to that account it could be the only way to recover it. If you can't have access just try the support request with them. Have good luck! Bye, JPicon - Jose Picon Thu, 19 Nov 2009 13:34:51 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1916 Hi! I tried to move Joomla site using this guide, but I only can have access to administrator mode. When I try to open index.php on the site's root it shows me the source code as plain text. What would be the cause of this problem? Thanks! - Jose Picon Tue, 17 Nov 2009 14:38:42 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1915 Hi, I wanted to ask one thing about the Joomla database. I had a site (Joomla 1.0) a few years. When expired our hosting package, we took a new one (this month). Before that we save all that was found on the FTP, all our files, but we didn't save our dabasase (step 3) (via MyPHPAdmin because we didn't know) and now when we hung our new hosting site via FTP with all uur data files there is no site only an database error. Would it be somehow to return to be like the old site? I know that we should preserve the old database (step 3) (via the MyPHPAdmin for example) but we didn't know that and is it all over for our old website or is there a solution for that? Thanks in advance and all the best! - Robert Sun, 15 Nov 2009 19:24:16 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1914 Hi Cory, Great post! Everything worked first try... except getting the new site to load properly. My old site is domainname.com and on a non-GoDaddy host. My new site is domainname.net and is on GoDaddy hosting. After copying all the files to the new webhost and importing the database to the new DB, I load the .net website to see if it worked. The first error I got was cannot connect to the MySQL DB. The username and pw were correct, so I decided to change localhost to the MySQL DB's IP and the error went away but it redirected me to the .com site. Is there a step that I am missing or a value in one of the DB tables that is preventing it from loading as .net? I changed the $live_site value to the .net site and don't see anywhere else in the config file this needs to be changed. Thanks! - Rob Thu, 12 Nov 2009 08:44:33 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1720 now I have everything downlaoded (my database is in two parts, that may be the problem) two databases in local and the identical databases in remote when i type my website dommain name i have Tex of sitejoomla when I click on sitejoomla I have Database Error: Unable to connect to the database:Could not connect to MySQL DO YOU THINK THAT IT IS DUE TO MY TWO DATABASES FOR ONE SINGLE WEBSITE? It would mean that it is not a problem in local but it becomes a problem in remote? - veronique Sat, 12 Sep 2009 05:14:37 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1719 I want to upload joomla localhost.sql.gz file to ebhost php myadmin I followed all the steps 1-click database restore says everything worked BUT when I check webhost phpmyadmin the database is empty (0) - veronique Sat, 12 Sep 2009 01:57:07 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1685 Finally! just changed the prefix in configuration.php then viola.. problem solved! thanks!!! - reuelc Sun, 30 Aug 2009 06:01:46 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1684 I think i found a clue.. I discovered that the prefix in 'jos' now has 'joom'.... - reuelc Sun, 30 Aug 2009 05:46:35 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1683 hi, first i want to thank the author of the article on how to move your joomla site.. it's really very easy. i have a problem however when i change the values in the configaration.php... im getting this error: [b]jtablesession::Store Failed DB function failed with error number 1146[/b] Table 'scuelloc_jo152.joom_session' doesn't exist SQL=INSERT INTO `joom_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ... when i revert back to the old db user and password the site is ok.. but when i put the imported db im getting this error. i checked in phpmyadmin i think the database is ok. any help would be appreciated. thanks - reuelc Sun, 30 Aug 2009 03:12:29 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1682 Nigel, When I rename the database and user name in the Joomla control panel, under the Servers option, when I rename either the user or the database, I get the following error: "Database Error: Unable to connect to the database:Could not connect to MySQL" When I exported the database from the first site, that worked fine and when I went to the next site to import it, I received an error that the user was not on the database. Even creating the user in phpMyAdmin didn't help when I went to import it. Next, I created the database with a different name in phpMyAdmin and then only exported the tables from the first site and imported the tables into the new site. After that, it seems to have worked but it was still pointing to the first database apparently because changes in either site were affecting both sites exactly the same. After importing the database and getting into second site fine, then I went to change the database name and user name and that's when the error occurred that I posted previously in this post. Any ideas as to what I'm missing here? Is there a specific order to work this through. I'm in urgent need of direction on this. Thanks in advance everyone and sorry for the lengthy description of the problem. - John Wed, 26 Aug 2009 14:58:27 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1681 John, It sounds like you are sharing the same SQL database on both sites. (Are they on the same server?) If the answer is yes then you need to copy the SQL database to a new name and then edit the configuration and change the database name in there. That should give you two independant and unlinked sites. - Nigel S Aves Wed, 26 Aug 2009 11:00:46 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1680 Hey All, I loved the article. The two sites above I tried it with and had mixed results. On my first attempt everything went smooth and then I had a duplicate site at superioryouth.com and featurewinner.info. (these two domains are test domains for me. I use featurewinner.info to build sites, then move them to superioryouth.com for testing and then finally to a client's site when going live. I have plans for these two domains down the road but that's immaterial to what's happening here.) I used Dreamweaver to build sites in the past but thought I'd give Joomla a try. After building the site at featurewinner.info, I moved the site to superioryouth.com to test the things in this article. Everything worked fine with a couple of minor issues (or at least I thought). The problem is I went into superioryouth.com and changed a few things like the Front Page welcome and removed the footer, etc. What I thought was great turned out horrible in that even though I made the changes on superioryouth.com the changes were also made to featurewinner.info and, essentially, I had duplicate websites and I was horrified. Changes in featurewinner.info were also made to superioryouth.com. Hence utter confusion, etc. I tried manipulating the global settings in superioryouth.com and then broke it's link to the database and, therefore, I need to copy the site over again to superioryouth.com. Any ideas what went wrong and why changes are being duplicated in both places. I should add that I'm a reseller of hosting and, therefore, I have several accounts on my hosting service with similar home directories and I'm wondering if that has something to do with it. All ideas are welcome. Thanks in advance for your help. - John Wed, 26 Aug 2009 08:31:16 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1670 Hi Lee, The way I see it, there are a couple of ways to solve this, both of which require a bit of programming skill: One is to write a script that goes through each record in your database and replaces your server address with your client's address. The other is to write a Joomla plugin that runs before a page is rendered. It would take the contents of the buffer and replace your server address with your client's server address. Good luck! - Cory Fri, 14 Aug 2009 08:15:26 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1669 In the above comment I put relative links. What I meant to say was absolute links....Doh...I'm so stressed...Hope someone can help. - Lee White Fri, 14 Aug 2009 08:09:40 +0100 http://www.howtojoomla.net/20090208101/how-tos/installation/how-to-move-your-joomla-15-site-to-a-new-server#comment-1668 I love this tutorial, everything works a treat, apart from one area. I moved a site to a clients server, and left a copy on my server. After a short while I removed the site from my server and all the images,pdf.s etc on the clients server ceased to function. It was only after a bit of exploring I discovered that all the images, .pdf's etc all had a relative link to my server, hence the fact that they didnt work.The site has hundreds of articles which would take me an age to go into each article and change all the links to relative. Is there an easy way of doing this, I really would appreciate some help with this as I'm at the end of my tether. - Lee White Fri, 14 Aug 2009 07:53:42 +0100