1

i am trying to take dump of database using CLI mariaDb i am executing following query.

mysql -u root -p --database = byx_prod_db < dumpfile.sql;

i am getting this error

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysqldump --add-drop-database  byx_prod_db > dump.SQL' at line 1
Panup Pong
  • 1,871
  • 2
  • 22
  • 44
noobie-php
  • 6,817
  • 15
  • 54
  • 101
  • Examine your dump file with a text editor. It was not created correctly, and seems to somehow contain the command line you used when trying to make a backup rather than the backup itself. – Michael - sqlbot Nov 07 '16 at 15:55

0 Answers0