Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

How to backup database every hour or so.

JamesSmith's profile image JamesSmith posted 2 years ago in Import/Export Permalink

As the title says, how do I backup my database every hour or so.

And if there is a way to make it automatically import into a Excel file or something.

ansgar's profile image ansgar posted 2 years ago Permalink

There is no schedule functionality in HeidiSQL, so you can only export data manually.

Using the MySQL ODBC driver, you can provide a datasource which you can connect in Excel and Access, without the need to export first.

JamesSmith's profile image JamesSmith posted 2 years ago Permalink

Can you explain the steps to achieve this? (Sorry, I am a newb at all this)

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 2 years ago Permalink

To be a newbie is never a problem, but you should at least ask more specific questions.

JamesSmith's profile image JamesSmith posted 2 years ago Permalink

Like how to set it up so it transfers my SQL database to an Excel file. Is there any documentation or a tutorial on it?

Gene's profile image Gene posted 2 years ago Permalink

You aren't providing enough information for others to be able to adequately help you. You need to be specific.

  • What kind of database are you trying to back up? (HeidiSQL supports more than one type of database server)
  • How much information do you need to back up?
  • What scripting languages are you familiar with?
  • Are you looking for a purpose built utility for backups?
  • What research have you done on your own so far to come up with a solution?

At this point it seems like you want to do something without putting in any effort into figuring it out. Don't expect others to do your job for you, show that you're trying and explain what you've tried so far.

It'll be beneficial when trying to solicit help from others if you can show you at least tried to figure things out.

Misha v.3's profile image Misha v.3 posted 2 years ago Permalink

Scheduled backups: Read about task scheduler/cron & mysqldump CLI

Excel (not sure why would you like to import it into Excel):

  1. https://www.mysql.com/why-mysql/windows/excel/ (I've never tried this)
  2. Download & Install MySQL ODBC driver. Open Excel. Data | From Other Sources | From Data Connection Wizard...

Please login to leave a reply, or register at first.