run mysql dump code via a form

raamay

I want to run the mysql generated dump values of a database through a textarea in php. I am copying the whole dump code in a textarea and then let the php run the entire code. But here the problem is that the unwanted tags or lines like the mysql comments needs to be ignored and only the actual sql queries should run. How do i do it?

May be this is not very clear. Well, i have a database which needs to be updated in every 3 or 6 months for which the actual data is collected from another source in excel format. I convert this excel data into mysql format in my local machine and then the data needs to be updated in my ISP's server for which i am creating a form through which the updates can be done. I want the updates to be done online without myself having to go to my ISP. So in this case phpmyadmin generates me the mysqldump sql file but when i copy and run the whole contents of the file, it has commented tags which php donot ignore. It runs along with the commented tags as a result the database is never updated. I want a solution to ignore the commented tags so that php runs only the genuine sql queries.

Atli

You could save the entire thing to a temporary file on the server and import it through exec.

Like:

Expand|Select|Wrap|Line Numbers

 if(file_put_contents($tempFile, $_POST['dump'])) 

{

    exec("mysql --user={$mysqlUser} --password={$mysqlPass} {$targetDatabase} < {$tempFile}", $out, $failed);
 
    if($failed) {

        echo "Import failed!";

    }

    else {

        echo "Your backup has been successfully imported!";

    }
 
    // Delete the dump file

    unlink($tempFile);

}

Some hosts might not allow the use of exec, but it's worth a try.

run mysql dump code via a form

re: run mysql dump code via a form

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about