Backup Whole Database in mysql

Question

I need to backup my whole database.I have seen shell scripting.But is it possible to backup whole database using event scheduler. I have check the follwing link- Automating Backups using Event scheduler

It contains table backup not the database bavkup Thanks in advance

where do you want to store the backup database? Same server or somewhere else? — Md. Mahmud Hasan, May 03 '18 at 08:45
@zerkms-event scheduer means mysql events for specific scheule — Kedar Limaye, May 03 '18 at 08:53
Check this out: https://stackoverflow.com/questions/9497869/export-and-import-all-mysql-databases-at-one-time — FreudianSlip, May 03 '18 at 08:56
@FreudianSlip- These are shell scripts,i want an sql query or is it possible to use it in sql query? — Kedar Limaye, May 03 '18 at 08:59
Creating a consistent backup requires lot more than just some basic sql script. Is there any particular reason why you cannot use a proper backup solution and you want to create your own version? Btw using mysqldump is not shell scripting. It is just simply invoking a program with the right parameters. — Shadow, May 03 '18 at 11:34
Possible duplicate of [Automating Backups using Event scheduler](https://stackoverflow.com/questions/17115078/automating-backups-using-event-scheduler) — Nico Haase, May 03 '18 at 11:53

Birat Bose · Answer 1 · 2018-05-03T11:49:52.950

0

use mysqldump to take backup. write a query to convert it into csv

  select * from table into outfile 'E:/path/' fields terminated by ',' lines terminated by '\n' ;

edited May 03 '18 at 11:49

answered May 03 '18 at 10:08

Birat Bose

1,954
1
9
11

This is shell scripting .I want query for database backup – Kedar Limaye May 03 '18 at 10:46
you want sql query? – Birat Bose May 03 '18 at 10:48
if possible yes because i will use it in event – Kedar Limaye May 03 '18 at 10:49

Backup Whole Database in mysql

1 Answers1