Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how can I backup my whole database periodically in Mysql?

 
Matt Taylor
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,

I have a server with 4 database. I would like to export 1 of the 4 database once a day.

I would like to export table creaion script as well as table data insert script once a day and either send the .sql file in my google drive or from my local directory. I really do not have an idea how to do this. Can this be done in mysql workbench?

Can someone please provide me what to search or guide? Noobie here. TIA
 
K. Tsang
Bartender
Posts: 3585
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the mysqldump command.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic