LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 10-13-2006, 11:58 AM   #1
canegames
Member
 
Registered: Mar 2006
Posts: 72

Rep: Reputation: 15
Howto: make "/var/lib/mysql " acessable as a samba share for WinXP Pro?


I am trying to setup a way where I can take the changes that I've made to my MySQL databases on my WinXP Pro box and upload them to my MySQL server running Debian. Is using Samaba the correct way to do this or is thair a more secure or efficient way of accomplishing this task?

My databases are stored in the /var/lib/mysql so I have elected to make that a samba share. If this is wrong please give me an alteerative.

Thanks in advance.
 
Old 10-13-2006, 12:00 PM   #2
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
I have chmoded the /var/lib/mysql to 444 if this was a mistake pleae tell me what setting the UMask should be on. Also, here is what I have in the /etc/samba/smb.conf file for this /var/lib/mysql directory share

[mysql]

comment = Databases on Gate Keeper
browseable = yes
writeable = yes
readable = yes
create mask = 777
path = /var/lib/mysql/
 
Old 10-13-2006, 12:38 PM   #3
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
Wait, MySQL running on Windows and you want to replicate to a Linux box? Transferring the files via Samba from one filesystem to the other seems like a really bad idea to me. Perhaps you should look into setting up the Linux MySQL server as a slave (replication) to the WinXP box..
 
Old 10-14-2006, 09:11 AM   #4
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
how would I make mysql on winxp pro a slave server to the linux based one?

So how is this done?
 
Old 10-14-2006, 09:50 AM   #5
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
Quote:
Originally Posted by canegames
So how is this done?
By reading the manual..

http://mysql.mirror.nedlinux.nl/doc/...plication.html
 
  


Reply


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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't locate object method "splitpath" via package "PACK001" at /usr/lib/perl5/5.8.8/ sajigeorge Linux - Software 1 01-11-2009 06:33 AM
Howto Transfer MySQL databases from WinXP Pro to Debian Linux ? canegames Linux - Server 7 09-12-2006 09:39 PM
Samba problem with "add share command" bit128_linux Linux - Software 0 05-23-2006 05:26 AM
Compromised? Files "/usr/lib.hwm", "/usr/lib.pwd", "/usr/lib.pwi" Klaus Pforte Linux - Security 4 09-28-2004 11:33 PM
Authenticating to Samba share using "Active Directory Server" hlslaughter Linux - Software 36 07-23-2004 10:59 AM


All times are GMT -5. The time now is 12:12 AM.

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