CiviCRM Community Forums (archive)

I'm trying to follow the instructions listed in the Wiki regarding moving between sites, 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

When I tried to drop all the tables (except those listed above as ignore) and import my standard SQL dump of the Civi tables, I get an error that there's a Foreign Key issue and the tables can't be deleted.

Getting my CiviCRM data off my local dev machine and onto the server is the last thing I need to do before I can open up the site, and I can't seem to get there from here. 

Problem is, I can't even get the dump to happen using the mysqldump command.

Can I set FK on the incoming server to 0 so I can use a standard mysql export, then change it back to 1 after?

Sorry - I've never had this kind of problem before and am completely at a loss. I even tried shelling in to my localhost to do the dump at root level and get the same bloody errors.