dzogchen

Since you use Safari I assume you\'re running a Mac. My experience with this is on a Linux box. You might be able to do this with OSX if you aren\'t afraid of the command line...... and you have the software tools - I think openssh is available but don\'t know for sure. Call me paranoid but I try to do all my remote admin stuff through a secure connection sftp the dump to the web box, then ssh in to the web box and run mysql from the command line. Chances are it will be much more robust than running everything through phpmyadmin. I recently moved a relatively large database (500+ meg) this way, with no problems.

I have a rather large database that contains a few large tables and a large number of frequently changing very small tables i need to migrate to another server, and do it quickly so I minimize disrption of our site. mysqldump doesn\'t seem to take wildcards, so i wanted to write a php script to automate the execution of mysqldump. I can generate the table names and then i put them into a string something like: $dumpme = \"mysqldump --user=xxxx --password=xxxxx somedatabase $thistable > $thisdump n\"; and then use $file = exec(\"$dumpme\"); if (!$file) { echo \"Unable to dump file $thistable!<br> \"; }else{ echo \"dump of file $thisdump worked!<br>\"; } if I take the string generated by echo $dumpme; and run it in a terminal window, it works. If I run the php code, it fails. i have also tried it with : $file = exec($dumpme); and it still fails. also shell_exec and passthru Any ideas? I thought of using php for generating a long shell script, and running that from the command line. Any help appreciated