mirroring/backing up data 1

[jimoblak]

I use a production MySQL database on a Linux box and develop with a MySQL database on a Windows box. Is there a simple way (a program or SQL command) to copy the data from the Linux box to the Windows box? ...preferably on a regular schedule?

My current method involves manually exporting the tables from the Linux database with MySQL-Front.

 

[KarveR]

you want a schedule or to replicate the data as changes occurr?

Replication is good if you have a permanent connection between the two, however recovery can be a pain if you replicate errors.

alternatively see mysqldump --help from your *nix command line. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[jimoblak]

Scheduled backups are best, although I have a constant connection that could support replication.

One additional problem: I do not have telnet access. The production server is maintained by a hosting provider.

 

[PCSAARON]

"I use a production MySQL database on a Linux box and develop with a MySQL database on a Windows box. "

- I have found that this is the most BACKWARDS way to develop! I used to develop all of my databases on windows and then transferred them to Linux. Bad news and too many head aches... BECAUSE; Windows does not care about case, and Linux will kill you if you don't have capitalization correct. If you develop on Linux FIRST, you can simply transfer to Windows and not have any problems with case... With the other way around, you would have to setup sym links to the same table to take care of the case problem! This is a pain, but works if you need to REPLICATE the database from a windows box as a master to a linux box as a slave. (which is your case)

Replication is your best bet... Easy to setup, and works well, the only problem is that Replication is new with MySQL. So there may be unexpected bugs. It doesnt hurt to try...

and,,, you don't need telnet access to replicate...


Aaron