Author Topic: SQL SYNTAX ISSUE COPYING DATABASE SO I CAN MOVE IT (Read 757 times)

MulderDSM · December 04, 2010, 03:29:36 pm

I'm running this statement on my existing database:

mysqldump -u dbo347926891 -p password11
--ignore-table=db347926891.civicrm_domain \
--ignore-table=db347926891.civicrm_acl_cache \
--ignore-table=db347926891.civicrm_acl_contact_cache
--ignore-table=db347926891.civicrm_cache \
--ignore-table=db347926891.civicrm_group_contact_cache \
db347926891 > mycivicrmexport.sql

and I keep getting this error:

#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 dbo347926891 -p password11
--ignore-table=db347926891.civicrm_do' at line 1

please help.

Kiran Jagtap · December 05, 2010, 09:50:51 pm

you might want to check this syntax

Code: [Select]

mysqldump -uusername -ppassword dbname --ignore-table=dbname.tablename --ignore-table=dbname.tablename --ignore-table=dbname.tablename > dbdumpFileName.mysql

kiran

CiviCRM Community Forums (archive)

News:

Author Topic: SQL SYNTAX ISSUE COPYING DATABASE SO I CAN MOVE IT (Read 757 times)

MulderDSM

SQL SYNTAX ISSUE COPYING DATABASE SO I CAN MOVE IT

Kiran Jagtap

Re: SQL SYNTAX ISSUE COPYING DATABASE SO I CAN MOVE IT