How to backup database every hour or so.

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.

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.

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

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

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?

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.

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...