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

canegames · 10-13-2006, 11:58 AM

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.

canegames · 10-13-2006, 12:00 PM

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/

trickykid · 10-13-2006, 12:38 PM

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..

canegames · 10-14-2006, 09:11 AM

So how is this done?

trickykid · 10-14-2006, 09:50 AM

Quote:

Originally Posted by canegames

So how is this done?

By reading the manual..

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