LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 09-11-2007, 07:33 PM   #1
aktar
LQ Newbie
 
Registered: Jun 2007
Posts: 13

Rep: Reputation: 0
Lightbulb Sharing MySQL DB with muliple OS


I was just wondering how bloody efficient it would be if the same data can utilised by MySQL on Windows and on Linux.

I haven't tried it yet because.. well I dont know where the data is stored in Linux.
The other thing thats going through my mind is whether or not MySQL uses the exact same storage method on both systems, ie is it portable?

can anyone shed any light on this matter?
 
Old 09-11-2007, 07:43 PM   #2
bryantrv
Member
 
Registered: Jan 2005
Location: DeLand, Florida US
Distribution: Debian Etch
Posts: 91

Rep: Reputation: 15
I don't know about Windows, but AFAIK (take it with a grain of salt), a MySql server doesn't care who gets the info- just like a web server or ftp server, so a Windows MySql application would be given the server name or IP address, port, username and password (etc.) and wouldn't know it was talking to a Linux or Windows server.
 
Old 09-12-2007, 12:11 PM   #3
aktar
LQ Newbie
 
Registered: Jun 2007
Posts: 13

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by bryantrv View Post
I don't know about Windows, but AFAIK (take it with a grain of salt), a MySql server doesn't care who gets the info- just like a web server or ftp server, so a Windows MySql application would be given the server name or IP address, port, username and password (etc.) and wouldn't know it was talking to a Linux or Windows server.
It wouldn't surprise me at all. But what I really want to know is if the same data can be shared by Mysql running on two different systems.

The reason I ask is because I'm running dual boot with XP and Debian. And I do my web stuff on both, so when I add data into the DB in using, say Debian, I want the same data to be available for extraction on XP
 
Old 09-12-2007, 12:39 PM   #4
bryantrv
Member
 
Registered: Jan 2005
Location: DeLand, Florida US
Distribution: Debian Etch
Posts: 91

Rep: Reputation: 15
Ah- so you want to use 2 different MySql servers to access the same database (though not at the same time)?
Good question
I would bet it would be fine, but until I tried it for a while (or got an authoritative answer), I wouldn't want to try it with mission critical data .
 
Old 09-12-2007, 02:06 PM   #5
farslayer
Guru
 
Registered: Oct 2005
Location: Willoughby, Ohio
Distribution: linuxdebian
Posts: 7,231
Blog Entries: 5

Rep: Reputation: 189Reputation: 189
Might want to be aware of the differences between MySQL on Windows and Linux when designing your initial database structure..
http://dev.mysql.com/doc/refman/5.0/...s-vs-unix.html

one issue may be the installation layouts between windows and Linux..
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html


it appears though that the databases themselves are identical under windows and Linux so that's half the battle..
http://dev.mysql.com/doc/refman/5.0/en/moving.html
 
Old 09-13-2007, 11:08 AM   #6
aktar
LQ Newbie
 
Registered: Jun 2007
Posts: 13

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by farslayer View Post
Might want to be aware of the differences between MySQL on Windows and Linux when designing your initial database structure..
http://dev.mysql.com/doc/refman/5.0/...s-vs-unix.html

one issue may be the installation layouts between windows and Linux..
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html


it appears though that the databases themselves are identical under windows and Linux so that's half the battle..
http://dev.mysql.com/doc/refman/5.0/en/moving.html
Thanks farslayer for your bit of research, very much appriciated, Ok the next thing I need to know is where the data is stored under Linux


Get ready for this, I sence a big breakthrough
 
Old 09-13-2007, 12:48 PM   #7
farslayer
Guru
 
Registered: Oct 2005
Location: Willoughby, Ohio
Distribution: linuxdebian
Posts: 7,231
Blog Entries: 5

Rep: Reputation: 189Reputation: 189
The 2nd link, the one about the layouts, answers that question. it shows the file and data location for Linux and Windows installs........
 
Old 09-14-2007, 04:02 PM   #8
aktar
LQ Newbie
 
Registered: Jun 2007
Posts: 13

Original Poster
Rep: Reputation: 0
Yes guys, it is possible to share MySQL data between two systems.
However I've only managed to share MyISM databases, but no luck with InnoDB, mysql just doesnt recognise it on Linux.

I wonder if I missed anything; I've changed the file names to lowe case as suggested by the documentation but mysql isnt having any it

Any ideas?

Last edited by aktar; 09-14-2007 at 04:05 PM.
 
  


Reply

Tags
linux, mysql, sharing, windows


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to rename muliple files manishsingh4u Linux - General 6 05-21-2006 07:59 AM
script to rename muliple files cranium2004 Programming 3 02-21-2006 10:59 PM
MULIPLE domains?! WorldBuilder Linux - Networking 1 07-17-2003 12:26 PM
IPTABLES --to-destination muliple ip:port hawk4eye Linux - Networking 4 02-07-2003 04:59 AM
Muliple Servers Nezar Linux - Networking 3 06-13-2001 09:05 AM


All times are GMT -5. The time now is 06:35 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration