PHP Mysql run script

[CassidyHunt]

I am trying to upload a sql file and run it to replace the database, tables, and data.

What is the easiest way to do this?

Thanks

Cassidy

 

[sleipnir214]

I would like to preface my post by saying what we are talking about is extraordinarily dangerous. If you don't have security airtight and if the server on which you can do this is exposed to hostile entities, you could find yourself in a world of hurt.


That said....

I would first have a script upload the file. See the PHP online manual chapter titled "Handling file uploads".

Then I would take the SQL script and pass it to the mysql command-line app by using PHP's Program execution functions.

Alternatively, you could write a PHP script to parse the SQL script query-by-query and execute each query in turn, but I figure why make yourself crazy?

Want the best answers? Ask the best questions!

TANSTAAFL!!