CiviCRM Community Forums (archive)

I use a dummy site to test my Joomla+CiviCRM site (say: http://100.100.100.100/test).
Now I need to migrate all data (and in particular I have worked with "contacts") to the production site (http://100.100.100.100/mysite), where I have already installed the same configuration of J+CiviCRM.
Which procedure?
AFAIK it is not enough to copy the db tables, because some details about the directory tree is saved in some record.
Thank you.

Michal,

I'm trying to follow the instructions listed on the page you specified, however when I execute the command,

$ mysqldump -u  -p  --ignore-table=joomla_dev.civicrm_domain \
--ignore-table=joomla_dev.civicrm_acl_cache \
--ignore-table=joomla_dev.civicrm_acl_contact_cache --ignore-table=joomla_dev.civicrm_cache  \
--ignore-table=joomla_dev.civicrm_group_contact_cache \
joomla_dev > ipcasql.sql

 I get a mysql syntax error starting on line 1:

#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 '$ mysqldump -u root -p --ignore-table=joomla_dev.civicrm_domain \ --ignore-tab' at line 1