• Post Reply Bookmark Topic Watch Topic
  • New Topic

how can I backup my whole database periodically in Mysql?

 
Matt Taylor
Ranch Hand
Posts: 65
  • 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: 3610
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the mysqldump command.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!