Copying a Joomla website

From Joomla! Documentation
(Difference between revisions)
Jump to: navigation, search
m
(Copying the database)
Line 5: Line 5:
  
 
==Copying the database==
 
==Copying the database==
 +
There a multiple methods to copying your Joomla database and moving it to live server environment.
 +
 +
'''MySQL COMMAND LINE METHOD'''
 +
 +
Usually you run mysqldump to create database copy:
 +
$ mysqldump -u user -p db-name > db-name.out
 +
 +
Copy db-name.out file using sftp/ssh to remote MySQL server:
 +
$ scp db-name.out user@remote.box.com:/backup
 +
 +
Restore database at remote server (login over ssh):
 +
$ mysql -u user -p db-name < db-name.out
 +
 +
 +
'''PHPMYADMIN METHOD'''

Revision as of 11:11, 19 January 2008

Copying a Joomla! website is a two-part process: you must copy the files and you must copy the database (which is where the content is stored). Copying the files and copying the database are separate operations. Which you carry out first will depend on your particular circumstances but in most cases it does not really matter. If your website is being updated frequently and you need to take your website offline while the copy takes place then you will probably want to perform the database copy last so as to minimize downtime.

Copying the files

Copying the database

There a multiple methods to copying your Joomla database and moving it to live server environment.

MySQL COMMAND LINE METHOD

Usually you run mysqldump to create database copy: $ mysqldump -u user -p db-name > db-name.out

Copy db-name.out file using sftp/ssh to remote MySQL server: $ scp db-name.out user@remote.box.com:/backup

Restore database at remote server (login over ssh): $ mysql -u user -p db-name < db-name.out


PHPMYADMIN METHOD

Personal tools
Namespaces

Variants
Actions
Navigation
Joomla! Sites
Toolbox