mysql dump on windows

BigBadKev

Hi All,

I am building a manual system that uploads a sql file for a user to work on and at the end of the working day the user will dump a sql file and e-mail it so it can be re-built at my end.
Although this seems like the stone age in action, it is a great solution to fix my problem, both users are on windows, both will have identical mysql and php versions but the other user dosnt understand DB’s or how to work them with phpmyadmin so my problem is the other user needs these two actions to be performed by clicking a button for each and I am a little stumped.
For the upload sql file I am assuming I can do this with $_FILE and the usual upload functions, but how will I get the sql dump into the DB without using phpmyadmin? should I use file_get_contents() and then use a exec command? And how do I run a command from windows to create a mysqldump? is this a command wrapped inside a exec or system command.

Thanks for any pointers here as I have looked on the net and its not that clear on this when working on a windows system.

BBK

barand

You can rum mysqldump from the command prompt. Just create a .BAT file for your user with the mysqldump command in it.

All they have to then is double-click a desktop icon.

BigBadKev

i am trying to use this bit of code to execute on windows

passthru("C:\\Program Files\\MySQL\\MySQL Server bin\\mysqldump --user=$user --password=$password --host=$host $dbase > $filename", $result);

But it chokes at C:\Program so I am assuming its the white space in the dir path.

If this fails I guess I will have to use a bat file I just wanted something that looks simple for a simple user.

BBK

Drakla

I had similar gripes, but got it to work with backticks like this - I'll simplify to a batch file called foo.bat in program files

$cmd = 'c:\"program files"\foo.bat';

echo $cmd;

I'll leave out the php tags in case it strips the backslashes.