Timeline for Sharing MySQL data between Windows and Linux?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 22, 2018 at 3:44 | comment | added | Elliptical view | @mike rodent, Then you're doing pretty good! I am still pretty green at Linux, but I was really much more in a fog when I was trying to get this to work. re: "LABEL="Shared" /home/username/Shared/ ntfs rw,nosuid,nodev,relatime,user_id=username,group_id=groupname,permissions,allow_other,noatime 0 2". I call my ntfs shared partition 'Shared'. You might have to adjust this. Also you have to change 'username' and 'groupname' with your user name? I had to do a lot of reading about mounting and the like to get this to work, but it will be very valuable to you later as mounting is basic. gLuck | |
| May 21, 2018 at 15:34 | comment | added | mike rodent | Yes, got that, Tx. ... BTW your answer has been very valuable to me... I'm eventually going to put my own answer here on the basis of what I've learnt (I have now managed to get this sharing working). Incidentally, when I include your fstab line my Linux (Mint Cinnamon 18.3) fails to boot, so mounting manually. As a Linux newb I'm still trying to understand this and a couple of other slight snags. | |
| May 21, 2018 at 4:27 | comment | added | Elliptical view | @mike rodent, With MySQL this was in C/Users/All Users/MySQL Server 5.6/. But by now I've also moved to MaridDB 10.2, so checkout C/Program Files/MariaDB 10.2/data/*.ini | |
| May 20, 2018 at 17:08 | comment | added | mike rodent | Ha ... have got Linux installing and using a dbase on the Shared partition. But when I go back to W10 there is absolutely no file called "*.cnf" under the MySQL directory. BTW am using MariaDB (close fork of MySQL). | |
| May 20, 2018 at 10:00 | comment | added | mike rodent | Managing now to mount the partition "manually" with all those options "mount -o rw,nosuid... " ... but I'm still getting "ERROR 2002 (HY000) : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" when I go "mysql -u root -p" as root or as a user (with sudo). | |
| May 19, 2018 at 18:10 | comment | added | mike rodent | Hi, thanks for this... I've got to stage 2) of make Linux changes. After making the change to fstab this stopped Linux rebooting. Fortunately I had done a disk image of the Linux partition. After restoring I tried again, and did "mount -a": I got "mount: can't find LABEL="Shared"". Maybe this "New Volume" as called by Linux needs to be renamed "Shared"? | |
| Sep 20, 2016 at 14:40 | history | edited | Elliptical view | CC BY-SA 3.0 | added how to move data from ms access |
| Sep 19, 2016 at 4:22 | history | edited | Elliptical view | CC BY-SA 3.0 | patched in full fstab line I use with all options |
| Sep 18, 2016 at 21:18 | history | edited | Elliptical view | CC BY-SA 3.0 | added 192 characters in body |
| Sep 18, 2016 at 21:07 | history | answered | Elliptical view | CC BY-SA 3.0 |