1

How can i take myasql data backup efficiently.

I am using Adminer Script to take backup manually. When it comes cron job or auto script i cant able to take backup. Please help me to resolve my problem.

When i am using the Following Query i am getting the error while import the file

SELECT * FROM my_table INTO OUTFILE '/tmp/my_table.csv'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;

Error in query (1064): Syntax error near '131 1 02/01/2016 1200 sales debit 43 223 6 31/12/2015 0 production debit 1 S' at line 1

Dinesh G
  • 1,325
  • 4
  • 17
  • 24
  • 2
    Possible duplicate of [PHP regular backup of mysql data](http://stackoverflow.com/questions/38916163/php-regular-backup-of-mysql-data) – e4c5 Dec 07 '16 at 07:16
  • When i am trying to import its show the error!. Error in query (1064): Syntax error near '131 1 02/01/2016 1200 sales debit 43 223 6 31/12/2015 0 production debit 1 S' at line 1 – Dinesh G Dec 07 '16 at 07:17
  • I don't think you can type 2 FROM clauses... – kscherrer Dec 07 '16 at 08:22

0 Answers0