Talk:Copying a website from localhost to a remote host
(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)
