Best way to make local backup of odbc mysql tables (1 Viewer)

[ellenr]

I need to backup mysql tables on local computer, and how to recover from this backup if necessary. Thanks!

 

[CJ_London]

Not clear whether you are saying mySQL is on your local computer, or elsewhere and you want the backup to backup to your local computer. If the latter, don't believe you can easily - it's a security issue.

If the former, plenty of links out there - here is one https://www.ubackup.com/enterprise-backup/mysql-backup-database-5740.html

 

[sonic8]

I need to backup mysql tables on local computer, and how to recover from this backup if necessary. Thanks!

"Backing up" server tables to a local file is fairly easy. You can just use an append query into a local Access database for each table.

However, this is not a backup to recover from! A real database backup must adhere to consistency as any other database transaction. With the above approach you would only get a consistent backup if you would backup all tables in a single transaction in repeatable read mode. This is probably not possible with linked ODBC tables in Access.

I would instead suggest, you rather use MySQL backup tools, which may also work on the local computer. The linked text also has lots of information on how to recover from the created backups.

 

[ellenr]

"Backing up" server tables to a local file is fairly easy. You can just use an append query into a local Access database for each table.

However, this is not a backup to recover from! A real database backup must adhere to consistency as any other database transaction. With the above approach you would only get a consistent backup if you would backup all tables in a single transaction in repeatable read mode. This is probably not possible with linked ODBC tables in Access.

I would instead suggest, you rather use MySQL backup tools, which may also work on the local computer. The linked text also has lots of information on how to recover from the created backups.

Thank you! I will follow up using the MySql link.