MySQL Forums
Forum List  »  MySQL Workbench

Connecting to a database file
Posted by: Gerald Roston
Date: September 11, 2021 09:31AM

I have a Home Assistant system running in my house on a Raspberry Pi computer. I believe that the database application that was installed (was done as part of the HA installation) is MariaDB. The data is stored in a file whose extension is .db.

I copied this file to my Windows machine and tried to access it via MySQL Workbench. This didn't work because the encoding is other that UTF-8 (and I am not sure that I connected to it properly). However, I installed DB Browser for SQLite and this application was able to open and see the file's data.

My question is this: Can you please provide me with, or point me to, instructions that will show me how I can access the file with MySQL Workbench?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Connecting to a database file
502
September 11, 2021 09:31AM
281
September 11, 2021 10:58AM
195
September 11, 2021 04:16PM
188
September 11, 2021 04:29PM
184
September 11, 2021 08:45PM
185
September 12, 2021 10:55AM
175
September 12, 2021 02:18PM
155
September 12, 2021 02:32PM
185
September 13, 2021 07:58AM
186
September 13, 2021 11:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.