Thread Like Summary
JAISP
Total Likes: 5
Original Post (Thread Starter)
#41319 01/12/2007 2:16 AM
by Horus
Horus
hi, i had a question for anyone familiar with mysql. i run a dual-boot machine with windows and linux. on that machine i run a website which uses perl and mysql. i'd like to know if it's possible to share the mysql database between both the windows and linux setup depending on what i'm booted into. for example, windows: f:\MySQL Datafiles\ibdata1 i want to use that in linux. i have f: mounted to /files in linux. apache runs fine with the perl scripts and all, i just need to find a way to share the database. all the solutions i've seen so far require dumping the database from windows (the database was originally created in windows) and then using that to set up mysql under linux. the problem with this is that it wont' update the windows mysql datafiles. and so, if i wanted to switch back to windows with an up-to-date databse, i'd have to dump the linux mysql one, and bring that back over. i understand that there are more files than just ibdata1 that might be required. really, i would just like to know if it's possible to share the same database files. note: also, i'm pretty sure all the database and table names are lowercase and i don't THINK i've used any floating point numbers in the database...although, i dont' know for sure. but does anyone know if the floating-poitn number format in windows and linux differ? never had to worry about that before. and i do believe the database type is innodb.//
Liked Replies
#41320 Jan 12th a 02:21 AM
by Gremelin
Gremelin
I could definately see data collisions with that setup; why not just set mysql to allow each pc to connect to the username to utilize the database through the server itself vs trying to run two servers with one set of data?
1 member likes this
#41322 Jan 12th a 04:22 AM
by Gremelin
Gremelin
no, I'm saying, have the MySQL server run on one machine, and set the username to allow connections from the other machine; then you set the connection data on the one machine to connect to the server machien...

I'm trying to figure out why you want access to the mysql files in the first place; are you trying to use them to connecft with a seperate install and use that data or what? If you want both machines to use the same mysql data, then set machine A to be a server, and set machine B to use machine A's mysql server (using machineA's ip address on your network as the host, and the user account on machineA's user/password)

For example, I have 3 machines here. MySQL data is used on either Machine B or machineC (2 mysql instances because I do testing on multiple versions).
MachineA hosts final builds, so I use MachineB and MachineC to connect to it to use it as the server.
MachineB has my alpha work, just drawn out data, I do testing mainly just on that server to connect from php to its own sql server.

I also use SQLYog to connect from Laptop to Machine A and machineB to do some quick update work on them both.

It's all quite simple to do, just set the sql username to allow connections from ip's other than "localhost".
1 member likes this
#41324 Jan 12th a 05:30 AM
by Gremelin
Gremelin
Oh, so you're dual booting, check...

Humm, it may be kinda difficult; I know that when you install MySQL via linux from source you can specify your path, so you could mount your fat drive and install MySQL to there; I however am not sure if the W32 version allows you to specify locations of mysql data... Even if it would, you'd want to ensure you're running the EXACT same versions of the W32 and Linux versions of MySQL...

If the Windows install allows you to specify the datafile location it shouldn't be too difficult as I'm sure it stores the data the exact same way... The only problem would be if MySQL stores EVERYTHING in the data directory (program files included)...

You'd ultimately have to give it a go and try to customize it... I don't dual boot here since I had the spare hw for a seperate linux box.
1 member likes this
#41326 Jan 12th a 07:09 AM
by Gremelin
Gremelin
Probably issues with the windows data, I'm not sure how it stores data or if it stores it properly (windows is so wonky lol).

You could try running your linux in a vmware session (or vice versa)
1 member likes this
#41335 Jan 16th a 02:02 PM
by §intå×
§intå×
I would strongly advise against such a set up. At best you could install a version per OS and be sure to make one the primary and back up the other from that one.

Linux and windows use very different file systems and different hooks. The mysql version for windows and the version for Linux though they will act the same for the most part will be configured and have very different files that make them work.

The other alternative is to go out and buy a Pentium I or pentium II and install an OS it can handle (psst go linux or BSD) LAMP (Linux Apache MySQL Perl,Python,PHP).

Then your scripts on your local box can access a single data set on the cheapy MySQL box.
1 member likes this
Member Spotlight
jonconley
jonconley
Merrill, IA, USA
Posts: 955
Joined: October 2002
Forum Statistics
Forums41
Topics33,787
Posts68,803
Average Daily Posts1
Members2,175
Most Online3,253
Jan 13th, 2020
Latest Postings
Animation,
by JohanKaariainen - 08/15/19 01:18 AM
Blackbeard.....
by Gremelin - 10/03/18 07:02 PM
my old account still exists!
by Crime - 08/10/18 02:47 PM
Okay WTF?
by HenryMiring - 09/27/17 01:45 AM
The History Thread...
by Gremelin - 08/11/17 12:11 PM
My friend NEEDS your HELP!
by Lena01 - 07/21/17 12:06 AM
I'm having fun with this guy.
by gabithompson730 - 07/20/17 01:50 AM
I want to upgrade my phone
by gabithompson730 - 07/20/17 01:49 AM
Doom 3
by Cyrez - 09/11/14 08:58 PM
Amazon Gift Card Generator/KeyGen?te
by Gecko666 - 08/22/14 09:21 AM
AIM scene 99-03
by lavos - 09/02/13 08:06 AM
Planetside 2
by Crime - 03/04/13 07:10 AM
Beta Testers Wanted
by Crime - 03/04/13 06:55 AM
Hello Everyone
by Gremelin - 02/12/12 06:01 PM
Tracfone ESN Generator
by Zanvin Green - 01/18/12 01:31 PM
Python 3 issue
by Testing - 12/17/11 09:28 PM
tracfone airtime
by Drache86 - 07/30/11 03:37 AM
Backdoors and the Infinite
by ZeroCoolStar - 07/10/11 03:52 AM
Where and how do you torrent?
by ZeroCoolStar - 07/06/11 07:22 AM
HackThisZIne #12 Releaseed!
by Pipat2 - 04/28/11 09:20 PM
gang wars? l33t-wars?
by Gremelin - 04/28/11 05:56 AM
Consolidate Forums
by diggin2deep - 04/21/11 10:02 AM
LAN Hacking Noob
by Gremelin - 03/12/11 12:42 AM
Top Posters
UGN Security 41,392
Gremelin 7,203
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Likes Received
Ghost 2
unreal 1
Crime 1
Ice 1
Dartur 1
Powered by UBB.threads™ PHP Forum Software 7.7.5