Actions

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 6: Line 6:
  
 
Yes.  Fixed now.  Thanks for reporting it.  [[User:Chris Davenport|Chris Davenport]] 06:28, 13 October 2008 (EDT)
 
Yes.  Fixed now.  Thanks for reporting it.  [[User:Chris Davenport|Chris Davenport]] 06:28, 13 October 2008 (EDT)
 +
 +
== Copy the contents of your local MySQL database to the host MySQL database - an alternate way ==
 +
 +
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.
 +
 +
[[User:Zimpete|Zimpete]] 10:47, 19 October 2008 (EDT)

Revision as of 09:47, 19 October 2008

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

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)