Upload Joomla website from localhost to webserver

Need help upgrading your Joomla! website or converting to Joomla! 1.5?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
dd1983
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sun Jun 21, 2009 2:05 pm

Upload Joomla website from localhost to webserver

Postby dd1983 » Sun Jun 21, 2009 2:21 pm

Hi,

Firstup, I am not a technical person and my knowledge of programming is not good enough. I have recently prepared my website on my localhost and now I want to migrate it to web server.

Until now I have followed the following procedure:
1. I have uploaded all the files and folders from 'C:\xampp\htdocs\Joomla15' to my host server using FileZilla

2. I have exported the local Joomla database from 'http://localhost/phpMyAdmin' and saved it to 'C:\xampp\htdocs' as a .sql file.

3. Now I have to import the file created in step 2 to hosting MySQL database and for that, I think I have to use phpMyadmin on my host. The problem is that when I go to phpMyadmin on my hosting server, I don't got any option for importing database to host server. instead I have an option to import database to my local host

4. I am also not sure of changes I need to made to configuration.php file. please help me with that as well.

Please help me out with steps 3 & 4. also let me know do I need to create a database on my hosting server as well. Let me know how to do it...at the time of installing joomla on my localhost, I have used the following details:
Database type: mysql
hostname: localhost
username: root
password: i have not entered any password and left it as blank
database name: joomla 15 (same as folder name created in xammp\htdocs)

Do I need to create a database with the above details on my hosting server as well (I tried but since I have not provided any password at the time of installation of joomla., i cannot create a user without password on my hosting server)

thanks
Dinesh

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Mon Jun 22, 2009 10:01 am

You need to create a mysql database on your web server, if you are using c-panel you will be able to name this database whatever you like, if so name it the same as your exported database. If your host won't allow you to choose the name (as is sometimes the case for security reasons), then there is no problem just change the name of the database in exported sql to match the new database.

Your exported database should look like this.

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 10, 2009 at 01:08 AM
-- Server version: 5.0.67
-- PHP Version: 4.3.10-200.schlund.1
--
-- Database: `dbXXXXXXXXX`
--
------------------------------
Now you need to open up PHPMyAdmin and you are ready to import your old backed-up database.
Select your database and click on the 'SQL' icon.

phpmyad3.jpg


Once in the SQL Query manager click 'import files'

phpmyad4.jpg


Navigate to the location of your database.sql and click go.

phpmyad5.jpg


Your configuration.php file should be updated to reflect the changes to the database:

var $dbtype = 'mysql';
var $host = 'localhost:/tmp/mysql5.sock'; // this depends on where your host keeps the databases
var $user = 'dboxxxxxxx'; // new database username
var $db = 'dbxxxxxxx'; // new database name
var $dbprefix = 'jos_';
var $mailer = 'mail';
var $mailfrom = 'admin@yoursite.com';
var $fromname = 'yoursite.com';
var $sendmail = '/usr/sbin/sendmail';
var $smtpauth = '0';
var $smtpuser = '';
var $smtppass = '';
var $smtphost = 'localhost';
var $MetaAuthor = '1';
var $MetaTitle = '1';
var $lifetime = '15';
var $session_handler = 'database';
var $password = 'newpassword'; // your new database password
var $sitename = 'YourSite.com';
You do not have the required permissions to view the files attached to this post.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

dd1983
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sun Jun 21, 2009 2:05 pm

Re: Upload Joomla website from localhost to webserver

Postby dd1983 » Mon Jun 22, 2009 10:19 am

Hi,

Thanks a lot for your reply.

I created the database as was mentioned in your reply and when I tried to import the earlier exported file (which I nameed 'my_export.sql') to the newly created database, the following error was displayed.

"SQL query:
Database: `joomla15`
CREATE DATABASE `joomla15` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said:
#1044 - Access denied for user 'quadview'@'localhost' to database 'joomla15'"

It seems that my user as mentioned above ('quadview'@'localhost') don't have access to database 'joomla15'.

Can you please help me with it?

Regards
Dinesh

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Mon Jun 22, 2009 11:02 am

Can you post the first 20 or so lines of your mysql export
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Mon Jun 22, 2009 11:12 am

1044 - Means - Access Denied for User to Database, Go back to the General Settings form and check your Database Name entry and try again.

Make sure the beginning of my_export.sql looks like this.

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost // this will be set by your host
-- Generation Time: Jun 10, 2009 at 01:08 AM
-- Server version: 5.0.67
-- PHP Version: 4.3.10-200.schlund.1
--
-- Database: `yourdatabasename` // this is the name of the actual database within phpmyadmin
--
------------------------------

Make sure the host, and database name are correct and try again.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

dd1983
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sun Jun 21, 2009 2:05 pm

Re: Upload Joomla website from localhost to webserver

Postby dd1983 » Mon Jun 22, 2009 12:24 pm

Hi,

Attached is the file as required by you (it contains first 20 lines of mysql file)

Regards
Dinesh
You do not have the required permissions to view the files attached to this post.

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Mon Jun 22, 2009 12:42 pm

Try this:

mysql%20-%20export.txt


If you still have problems, look at the 'Host: localhost' part for my server it is

localhost:/tmp/mysql5.sock

But your host will be able to tell you this.

Also make sure the database you are importing it into is the name you have in:

Database: `joomla15`
You do not have the required permissions to view the files attached to this post.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

dd1983
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sun Jun 21, 2009 2:05 pm

Re: Upload Joomla website from localhost to webserver

Postby dd1983 » Tue Jun 23, 2009 5:33 am

Hi,

After making the changes suggested by you, my website has started working.

Many thanks for your help on this.

Regards
Dinesh

vienn19
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Jun 22, 2009 2:54 pm

Re: Upload Joomla website from localhost to webserver

Postby vienn19 » Tue Jun 23, 2009 5:55 am

Hi I'm also tryin to upload Joomla website from localhost to webserver and I'm getting snagged by this problem. Would deeply appreciate advice urgently!!

I've uploaded all the files and folders to my webserver and added the database and when I try to access my site it shows this error.

Fatal error: Class 'JDocumenthtml' not found in D:\Inetpub\vhosts\asiatravelgroup.com.sg\httpdocs\libraries\joomla\document\document.php on line 294

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Wed Jul 08, 2009 5:45 pm

Make sure your configuration.php file reflects the fact that your files are now on the server and not on your hard drive:

D:\Inetpub\vhosts\asiatravelgroup.com.sg\httpdocs\libraries\joomla\document\document.php on line 294 is located on your computer not the web.

It is much easier to do a fresh install, delete the database created and import your database, then install any extensions and templates your are using into the fresh install, all your setting etc are contained in the database.

If you don't know how to do this I can provide a link to a tutorial.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

Beans1085
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Jul 19, 2009 4:06 pm

Re: Upload Joomla website from localhost to webserver

Postby Beans1085 » Tue Jul 21, 2009 2:07 pm

I was having the same problem, and I changed the database name on the database backup. But when I try to upload the database, I now get this error:

#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 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

can anyone help?

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6028
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Upload Joomla website from localhost to webserver

Postby dpacadmin » Wed Jul 22, 2009 11:15 pm

If you edited your sql file it could just be a typo. Can you post the first few lines of your file? If your database name or host link is in there xxxxxxxxx it out.

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Thu Aug 20, 2009 11:43 pm

OK, Chaps, this appears to be the proverbial Rubicon of Joomla...
I am going to have a look at the different MySQL clients and produce a definitive instruction manual to follow....

If you are new to this topic I'd recommend following the 2nd post as this seems to work for most.
If that does not work I'll publish an in-depth tutorial.
Last edited by simianman on Fri Aug 21, 2009 11:16 am, edited 1 time in total.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Fri Aug 21, 2009 12:19 am

Before, I go ahead.. Make sure Config.php contains your actual db name, db user, host and db password...

http://www.techferno.com/joomla-tutorials/uploading-a-joomla-website-from-a-local-host-server-to-a-web-server

This covers what you need to do and why
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

bigmamy
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Jul 16, 2009 4:11 pm

Re: Upload Joomla website from localhost to webserver

Postby bigmamy » Fri Aug 21, 2009 1:35 pm

Hello! I'm learning Joomla from a guide Learn Joomla!1.5 Fast and now I'm stucked. Can you help me?
I came to the chapter Uploading the site on a web server. From my web host I received some information but they are not sorted like it's shown in my guide. They simply say:
- a file /serv/www/dddddd/xxxxx is opened for administrating information system on the public.carnet.hr and it is visible on basic adress http://public.carnet.hr/xxxx
- after domain activation it will be visilbe on a web adress http://www.xxxx.xx
They also defined a mysql database with:
- host: localhost
- database name: xxxx
- user: xxxx
- password: yyyy
They wrote that I can access this database thrue my php site or http://public.carnet.hr/phpmyadmin/ or directly starting mysql client on my public host by some order /usr/........
They also opened my user account for administrating information servis
- user name: zzzz
- password: gggg
Now I'm lost. Where are the information Learn Joomla!1.5 Fast is writting about?
- Control panel URL, user name, password
- FTP user name, password, host name, path
- MySQL user, password, host, port

Please help me!

User avatar
simianman
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 150
Joined: Mon Jun 15, 2009 2:03 pm

Re: Upload Joomla website from localhost to webserver

Postby simianman » Fri Aug 21, 2009 2:01 pm

- FTP user name, password, host name, path
- MySQL user, password, host, port

Please help me!


All this information is what you put into the joomla installer and should match your database MySQL information - you need to set up a MySQL database through PHPMyAdmin first.

The FTP stuff is not essential for the migration as it can be configured later.
SimianMan - Life was a lot more simple back then!
http://www.twitter.com/techferno
http://www.whichdomainhost.com

cameraad
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Aug 23, 2009 1:59 pm

Re: Upload Joomla website from localhost to webserver

Postby cameraad » Sun Aug 23, 2009 2:05 pm

Hello,

I created a webiste, first localhost and now online. I uploaded everything according to the book or I atleast believe that I did it that way because I have the following problem.

http://www.chonjischilde.be

As you maybe see is the first page as i wnat it, but as soon as you start to navigate the complete layout is gone. Also I get double index/index on the top (from the moment that you navigate further).

Does somebody has an idea where my mistake can be? I searched the forum already an couldn't find anything regarding this.

Thanks in advance

User avatar
dpacadmin
Joomla! Champion
Joomla! Champion
Posts: 6028
Joined: Sat Aug 16, 2008 1:46 pm
Location: the Bat Cave
Contact:

Re: Upload Joomla website from localhost to webserver

Postby dpacadmin » Sun Aug 23, 2009 2:14 pm

Your local SEF settings do not work on your Hosted site. Turn off all SEF settings.

You most likely will need to use the htaccess file on your Host site for the SEF settings to work. If just renaming the htaccess file does not work search this forum for htaccess and your Host name to see if anyone has posted settings that work for your Host.

musicman22
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Jan 14, 2009 1:26 am

Re: Upload Joomla website from localhost to webserver

Postby musicman22 » Fri Aug 28, 2009 11:51 am

Hello, I have tried every thing possible to upload my joomla website localhost to my webserver and I am stuck.

I wanted to see if anyone is willing to help me with a one on one over the phone or email or skype.

I am willing to pay what ever it costs to get this resolved.
Could someone please help me with this.

You can email me at omar@iworksmedia.com

michxxx
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Dec 22, 2009 1:43 pm

Re: Upload Joomla website from localhost to webserver

Postby michxxx » Tue Dec 22, 2009 8:01 pm

As simianman mentioned (great thanks to you!) - you need to delete from your exported sql file lines:

"CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE information_schema;"

where 'information_schema" is the name of your datebase.

Then make sure that you assign to the 'information_schema' on localhost the name of user that you have on your web server from your provider

doobiegirl09
Joomla! Apprentice
Joomla! Apprentice
Posts: 25
Joined: Wed Jan 13, 2010 6:33 am

Re: Upload Joomla website from localhost to webserver

Postby doobiegirl09 » Fri Feb 19, 2010 2:50 am

hi simianman i know this is an old post but your tutorial helped me alot and saved my time

Thank you again :)
:)

rezaah78
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Apr 19, 2007 11:23 am

Re: Upload Joomla website from localhost to webserver

Postby rezaah78 » Wed Sep 15, 2010 11:32 am

I faced the same problem where I would get a message saying I do not have access to mysql like following:

MySQL said:
#1044 - Access denied for user 'xxxx'@'localhost' to database 'joomla22'"

I solved the problem by following the post from "simianman"
before you change anything make sure that you have exported the right database into sql file.
then open it in a text editor (wordpad) and change the database name at the top of the file to your new database name


--
-- Database: `YOUR DATABASE NAME`
--

then save and import the file to your new database.

next step is to change your configuration.php as to match the specification of your new server and database:

these are the parts you have to change in your configuration file:(make sure they match to the new server and database)

var $log_path = '/var/www/vhost/domain.com/home/html/logs';
var $tmp_path = '/var/www/vhost/domain.com/home/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';

to read more follow the link:

http://docs.joomla.org/How_do_you_copy_ ... te_host%3F


Return to “Migrating and Upgrading to Joomla! 1.5”

Who is online

Users browsing this forum: No registered users and 5 guests