I just downloaded the free version of Valentina Studio. I'm taking a programming course and trying to find a good mySql manager to help with my homework. I am on Windows 7. I've checked the Valentina documentation and cannot find something addressing my question.
I created a database, burgers_db, using the mySql command line and added a small table, burgers. I went to Valentina to open that database, navigated to the data location (C:\ProgramData\MySQL\MySQL Server 5.7\Data\burgers_db\) and looked for a .db, .vdb, or .sqlite extension file, the three file extensions Valentina is expecting. There are none. There are three files in the burgers_db directory:
burgers.frm
burgers.ibd
db.opt
so obviously these are referring to the table I made (burgers) and not the full database. After searching my computer, I can find no burgers_db.db, burgers_db.sqlite.
I have a few questions I hope this forum might be able to answer:
Does Valentina use/operate on mySql files? It seemed from the website that it did but I'm now questioning this because the Valentina installation only has two tabe, Valentina database and Sqlite database.
If so then how can I open the database, burgers_db, that I just created? If the location of the db is incorrect then how can I find this? I've looked at the my.ini file for mySql and the only data dir location is the one I referenced above.