Web Hosting Talk







View Full Version : Cygwin - mysqldump, mysql prompt


TJ111
03-06-2008, 01:41 PM
I am on a windows machine (WAMP) to do my development work locally on my machine, and post changes to a remote testing server (linux) for others to test (I'm currently the only developer on the project). Anyway I have cygwin installed on my machine and can SSH into the remote server, so I was going to write a little bash script to update the remote database. Basically a mysqldump, an ssh connection and then a mysqlimport.

Long story short I just want to install the mysql command line utilities on cygwin without having to compile and install the mysql server itself. Is this possible?

MageUK
03-06-2008, 01:44 PM
I'm sure that the Cygwin installer comes with options for packages, one of which is MySQL.

Otherwise no, you'll have to compile/install it.

TJ111
03-06-2008, 05:31 PM
I've searched through all the packages in the installer and there are no mysql packages. After thinking about it I think I', just going to write a little PHP script to connect and update the other database.

foobic
03-06-2008, 05:39 PM
If you're running everything else on Windows why not the mysql utils as well, and make it a Windows .bat file? Your mysql install should have given you the mysql and mysqldump binaries already, PuTTY will give you ssh and scp.