2

I am running LibreOffice on Ubuntu 24.2.2. I am trying to open my four databases, one at a time, which are located in /home/<username>/<filename.odb>. When I attempt to open a new database in LibreOffice Base, two of them appear in the drop down box and two don’t.

When I try to USE each of the four of them in MySQL at the command line, I get the following message:

ERROR 1049 (42000): Unknown database 'filename.odb'.

In the Ubuntu 24.2.2 command line, the files are listed in the Home directory /home/<username>/.

I have spent a couple days trying to determine why the other two don’t open, but with no joy. What is happening?

Giacomo1968
  • 58,727
Chuck Hanson
  • 21
  • 1

1 Answers1

1

Compare the file permissions and ownership of the database files. A likely cause of the issue is that the two problematic databases files were transferred to you PC, but ownership of the files was not changed to you, or a group of which you're a member.

Change ownership using Terminal: sudo chown -R <your user name> <path to file>

Change permissions to allow read and write using a file manager (e.g., nautilus, dolphin, PCManFM), or from Terminal with chmod.

DrMoishe Pippik
  • 37,887