Automated database backup using PHP event

Question

I'm assigned with a task of creating an automated backup for a database. I used a php event and I want to save my all my backups by a unique name. So I used a date_format and following is my code.

SELECT * FROM redcap_data ;
OUTFILE ' ", DATE_FORMAT(now(),'%Y%m%d_%H%i'),".csv';
FIELDS TERMINATED BY ',' ;
OPTIONALLY ENCLOSED BY '"';
LINES TERMINATED BY "\n";

But it gives an error saying that there is an error in your SQL syntax; near 'OUTFILE ', DATE_FORMAT(now(),'%Y%m%d_%H%i'), .csv''

please help me to find where my error is.

you need to use cron for this please check the following answer http://stackoverflow.com/a/3341381/2191252 — Shridhar, Aug 13 '15 at 06:45

score 0 · Accepted Answer · edited May 23 '17 at 12:01

0

Try as below

    SET @sql_text = 
   CONCAT (
       "SELECT * FROM `tbl_user` into outfile '/xampp/htdocs/mysite/reports-"
       , DATE_FORMAT( NOW(), '%Y%m%d')
       , ".csv'"
    );

PREPARE s1 FROM @sql_text;
EXECUTE s1;
DROP PREPARE s1;

Refer from Rename outfile with date in mysql

edited May 23 '17 at 12:01

Community

1
1

answered Aug 13 '15 at 06:52

AnkiiG

3,468
1
17
28

Automated database backup using PHP event

1 Answers1