Results 1 to 7 of 7

Thread: Sync MySQL between Ubuntu and Windows?

  1. #1
    Join Date
    Dec 2006
    Beans
    29

    Question Sync MySQL between Ubuntu and Windows?

    Hey,
    I'm a dual booter of Windows XP and Ubuntu.
    I run a small home server for internal proposes on both OSes.
    Both use Apache, PHP and Mysql (Wamp and Lamp).
    Since I switch between the OSes quite often, I wonder if it is possible to have both OSes to use the same database (Or sync them in any way automatically).
    Note: Ubuntu got read and write support for the Windows XP partitions.

    Thanks in Advance!

  2. #2
    Join Date
    Jun 2007
    Location
    Houghton, MI
    Beans
    459
    Distro
    Lubuntu 14.04 Trusty Tahr

    Re: Sync MySQL between Ubuntu and Windows?

    I don't think so. If you want to share a mysql database between the 2 operating systems, I would suggest either getting a seperate db server.

    Personally, if you're running a server you should stick to one OS, less downtime. Since it's an internal home server, you can get an old box, throw on ubuntu server, and be on your way.

  3. #3
    Join Date
    Apr 2008
    Location
    Lima, Peru
    Beans
    32
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: Sync MySQL between Ubuntu and Windows?

    I understand what you're doing. I also dual boot because unfortunately there are some programs that doesn't run properly in ubuntu yet .

    I think you must create a symlink. That's what i did to share my php files between xampp and apache2.
    emancipate yourself from mental slavery
    Cesar Josue - Seo Copywriter

  4. #4
    Join Date
    Oct 2008
    Beans
    11

    Cool Re: Sync MySQL between Ubuntu and Windows?

    you could try the following:

    hosting the files in another machine. or

    maybe adding a partition both linux and windows can read. then putting the mysql databases on that partition, then setting both mysqls to read from that partition db files. if possible you could set the lamp to read from the ntfsorfat directly.

    or use a script both at boot and shutdown to copy the files to ntfs (bad idea if big files or crash).

    if you have the time maybe its worth a try. I'd go with one.

  5. #5
    Join Date
    May 2010
    Beans
    3

    Re: Sync MySQL between Ubuntu and Windows?

    What do you think about using virtual box. It can be installed on both Operating systems, you can load there some limited edition of ubuntu without desktop managers, only osme console version, and install there mysql, apache and setup phpmyadmin. You can boot the machine everytime you need mysql.

  6. #6
    Join Date
    Feb 2010
    Location
    Minneapolis, Minnesota US
    Beans
    166
    Distro
    Xubuntu 14.04 Trusty Tahr

    Lightbulb Re: Sync MySQL between Ubuntu and Windows?

    Dude,

    Amazon Ec2, greatest thing since sliced bread. I have a small instance running Lucid server that I do my dev work on. Costs me $.50 USD (50 cents US dollars) a month, and that's if I leave it on. Amazon only changes you for resources used, if you power down your instance and release your elastic IP you pay nothing until you fire it back up.

    DW

  7. #7
    Join Date
    Dec 2009
    Beans
    25
    Distro
    Ubuntu 11.04 Natty Narwhal

    Re: Sync MySQL between Ubuntu and Windows?

    If you use virtualbox to run another operating system you can sync between the two systems but in your case you can't do it dude as windows won't even recognize the ubuntu partition.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •