Talk

Difference between revisions of "Copying a website from localhost to a remote host"

From Joomla! Documentation

(New section: [[Talk:How do you copy a site from localhost to a remote host?#Copy the contents of your local MySQL database to the host MySQL database - an alternate way|Copy the contents of your local MySQL database to the host MySQL database - an alterna)
Line 23: Line 23:
  
 
[[User:Zimpete|Zimpete]] 10:47, 19 October 2008 (EDT)
 
[[User:Zimpete|Zimpete]] 10:47, 19 October 2008 (EDT)
 +
 +
I find the title confusing: Create a Place on Your Remote Host '''to Install Joomla'''! I didn't think there was any installation involved on the remote server of the web hosting services provider, '''only transfer of copies of the files''' created on the local host '''to the remote host'''. Which is it?

Revision as of 13:34, 31 March 2011

In section #3. Copy custom files from your local site to your remote site:

In the sentence ...."configuration.php". No NOT replace this file on your host....... be ""configuration.php". Do NOT replace this file on your remote host...."

OnTheMarkDesign 02:50, 13 October 2008 (EDT)

Yes. Fixed now. Thanks for reporting it. Chris Davenport 06:28, 13 October 2008 (EDT)

Copy the contents of your local MySQL database to the host MySQL database - an alternate way[edit]

When running Linux as I, use a convienient and fast way with mysqldump command. Open a terminal/shell to export database to databasename_date file.

machine: mysqldump -u username -p databasename >databasename_date Give the username password. username is normally "root".

To import to a remote mysql server you use mysql command:

machine: mysql -u remoteusername -p -h removemysqlservername remotedatabasename <databasename_date

Note that when importing you overwrite all tables within export file in database remotedatabasename. If you want to have a special table prefix other that standard "jos", you have to edit the exported file before importing.

Zimpete 10:47, 19 October 2008 (EDT)

I find the title confusing: Create a Place on Your Remote Host to Install Joomla! I didn't think there was any installation involved on the remote server of the web hosting services provider, only transfer of copies of the files created on the local host to the remote host. Which is it?