• Post Reply Bookmark Topic Watch Topic
  • New Topic

how can I backup my whole database periodically in Mysql?  RSS feed

 
Matt Taylor
Ranch Hand
Posts: 70
  • 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: 3639
16
Firefox Browser Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the mysqldump command.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!