Mysql – How to change MySQL 8.0 data folder. Can I use OneDrive folders

my.inimysql-8.0

I'm trying to create a DataBase for a very little program that just I and 2 more friends use, so the database will be little.

What I want to do is to share this database with these 2 friends, so I thought about storing the data in a OneDrive shared folder.

At the moment, I'm using a txt file as a "database". Which is placed in a shared OneDrive folder, so when my friends execute the program, it can read the data from there and make it sort of real time "online".

The thing is that I can't find the my.ini file in my

C:\Program Files\MySQL\MySQL Server 8.0\

directory, so I can't change the data folder.

Another trouble I have is that I also don't have the Data folder in that directory, instead I've found it in this one:

C:\Program Files\MySQL\MySQL Workbench 8.0 CE

Is it possible to do what I want to do? And how should I proceed?

Do you think I should be using MySQL 5.x version?

Thanks

Best Answer

Even if you can use OneDrive (or similar product), I would expect it to be a disaster waiting to happen. Neither MySQL nor XyzDrive is designed to worry about fast, real-time, actions. So, I would expect any network hiccup, or drive hiccup, or long network delay, etc, to risk a serious "disk" error being returned to MySQL, necessitating a crash.

Also, MySQL is not prepared to have two instances talking to the same files. Will you really disconnect from one computer before connecting another?? The day you fail to do that is the day the data is corrupted beyond repair.

Even if XyzDrive and MySQL decide to make it a viable feature, performance would probably suck -- somewhere between 10x and 100x slower than a local drive, and somewhat slower than a remote drive.

(If I am wrong, please speak up.)

Related Solutions

MySQL – How to Restore Lost Data After Update from 5.7 to 8.0.11

I was finally successful restoring the data. My problem was, that I tried to restore the data with a docker-compose, which somehow didn't work.

So I took a different approach

1. Run a docker image of mysql:8 and mounted the "corrupt" folder to it

docker run -d -e MYSQL_ROOT_PASSWORD=root -v /path/to/corrupt/folder:/var/lib/mysql --name mrestore mysql:8

The mysql-server started without any problems and I was able to run mysql with

mysql -u root -p.

But when I run the command mysql>show databases; It gave me an error like:

The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

2. Fix user does not exist error

A quick google search led me to the answer of someone having the same problem: https://stackoverflow.com/questions/49992868/mysql-errorthe-user-specified-as-a-definer-mysql-infoschemalocalhost-doe

Which is:

mysql -u root -p
mysql> SET GLOBAL innodb_fast_shutdown = 1;
mysql_upgrade -u root -p

3. Dump databse

Finally I was able to start mysql and dump the database that I thought I've lost

mysqldump -u root -p databasename > databasename.sql

MYSQL 8.0 server not found in Workbench directory in Windows 10

MySQL server and MySQL Workbench both are installed in the default location ("Program Files" for 64bit apps or "Program Files x86" for 32bit apps). MySQL Workbench however only exists as a 64bit arch build.

Did you check the server path actually exists? If it does not you may have forgotten to install the new server. Simply run the MySQL Windows installer again and let it install the server.

About the left behind ProgramData content: that's probably a safety measure to avoid deleting your data unwantedly. If you don't need it anymore then just remove the 5.7 subfolder.

Best Answer

Related Solutions

MySQL – How to Restore Lost Data After Update from 5.7 to 8.0.11

MYSQL 8.0 server not found in Workbench directory in Windows 10

Related Question