0

I am trying to backup and restore the cleardb database. I was trying to backup to my local computer first and then restore it. However, I am not able to create a backup

   mysqldump -h us-csdr-fern-sds-03.cleardb.net -u sdloremipsum5 -p ipsum <my_dev_dump.sql

I am trying this from mysql shell but I get

Syntax Error: Unexpected Identifier

jedu
  • 1,211
  • 2
  • 25
  • 57

1 Answers1

0

use

mysqldump -u username -p databasename > filename.sql

to export and

mysql -u username -p databasename < filename.sql

to import

Please refer: http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

Duplicate: Syntax error in mysqldump command Answer: https://stackoverflow.com/a/18502626/10368530

Karma Blackshaw
  • 880
  • 8
  • 20
  • I got the same error. I think I have to enter the host name though because my mysql database is not in my computer and is hosted in cleardb – jedu Sep 17 '19 at 04:18