Specify database path for QMYSQL

Question

Qt 6.2.0, Ubuntu 21.10. Usually MariaDb stores database under /var/lib/mysql/ directory.

I can connect to my own database using this working code:

_db = QSqlDatabase::addDatabase("QMYSQL", "machines");
_db.setHostName("localhost");
_db.setDatabaseName("mydb");
_db.setUserName("user");
_db.setPassword("password");

qDebug() << _db.open(); // true

I copied the database to another location:

$ sudo cp -r /var/lib/mysql/mydb /home/mark/mydir/

Changing the database name to:

_db.setDatabaseName("/home/mark/mydir/mydb");

leads to fail when open() is called. The error is:

QMYSQL: Unable to connect", "Unknown database 'home/mark/mydir/mydb'

What is the correct syntax do specify a different path?

@Mark: No - If you want the database files lying on another directory then you have to specify it in the mysql config, not when you're doing a connection to a db (not matter if it is Qt or anything other) — chehrlic
– chehrlic, Commented Mar 5, 2022 at 11:46
in the database name is not possible to9 define the location, yyou can only change the my.cnf to redirect the location. try it pleas — nbk
– nbk, Commented Mar 5, 2022 at 13:21

Yanis600 · Accepted Answer · 2022-03-05 17:13:04Z

1

mysql does not locate database using path, you have to specify the database name instead

answered Mar 5, 2022 at 17:13

Yanis600

911 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Specify database path for QMYSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related