Re: Connect to an existing database on specific path

[Barry Galbraith]

>Is it possible to put each database in it's own folder?
Yes, and no. A database goes in its own folder, but under the \data folder

The data folder is defined in the my.ini file the server uses.
By default on Win 10, for MySQL 5.7 the data folder will be in C:\ProgramData\MySQL\MySQL Server 5.7\data
There will be at least a \mysql folder there containing the mysql database that the server uses to run itself.
If you add your files to C:\ProgramData\MySQL\MySQL Server 5.7\data\yourdatabase and restart the mysql sserver then you might be lucky and your database will be there, as long as your tables weren't using innodb engine. If they were, then your data could be long gone with the server.
You will need to login as root as no other user will have privileges on your database.

>Do I need the ODBC connector to use the local data?
Only if you want an application to access the database and it doesn't have its own driver.

Good luck,
Barry.