MySQL dump in IIS

[jyrkipie]

Hi!

Can anybody tell me if I can do a MySQL dump on an IIS server (win 2000 server).

I have been able to do it on a linux-server as a command line command like: mysqldump mydb -p > /home/myfolder/mydb.sql

Now I would like to get out the databases from the IIS-server and re-create them on a linux-server.

Is this possible?

[Dynasty]

If you go to the folder where you installed mysql, in the bin subfolder you will find a console program called mysqldump.exe I think that will do what you want, and I would assume it would use similar syntax.

[jyrkipie]

But the problem is that I'm not the administrator on that IIS-server, I only use mytool connection to the server and only have rights to my own databases.

If there is a way to do the dump without actually working on the server-machine (which is possible on unix-machines) it would be great.

One of the reasons why I am doing this change is that I'm tired of always bothering the administrator. I'm setting up a linux-server of my own.

[Dynasty]

If the IIS server you are on has access to php ability, then I would suggest using phpmyadmin to make the sql dump. It is a php script that does the job you want. You can find it here: http://www.phpwizard.net/projects/phpMyAdmin/

[jyrkipie]

But the problem is that I'm not the administrator on that IIS-server, I only use mytool connection to the server and only have rights to my own databases.

If there is a way to do the dump without actually working on the server-machine (which is possible on unix-machines) it would be great.

One of the reasons why I am doing this change is that I'm tired of always bothering the administrator. I'm setting up a linux-server of my own.

[Dynasty]

PHPMyAdmin doesn't require you to be at the server, it is just an installable php script, basically like a web forum. It requires nothing changing on the server end provided the server has php installed.

In fact as long as you have the ip and user and pass for the server you can install phpmyadmin on any webspace that supports php and access the database to make the dump.

[jyrkipie]

Thank You!

It worked. Isn't this a great forum. It took less than 2 hours to solve the problem.

ps. sorry about the doble posting above (admin please remove the latter one).

[Dynasty]

Heh no problem.