[alex11]

I need help to execute myfile.sql directly from a php web page in order to update a database.

The sql file is stored in the same server as the web page. Is it possible to be done with a php script?

Thanks
Alex

[nova912]

phpMyAdmin should make this easy for you.

[alex11]

I know phpMyAdmin can do it but I need a web page were the user ( who knows nothing about mysql or databases) just need to press ok and the script must execute de query.

i.e.: Populate databaseX with file somefile.sql which is saved in the same server.

[alex11]

Hi Nova912

Found this script that I think it does what I was looking for.

http://homework.nwsnet.de/products/46

Many thanks for your help

[fyrestrtr]

Assuming you have the proper rights to run commands on the system, you can use the following:

PHP Code:

exec('/path/to/mysql -u username -pPassword databasename < /path/to/filename.sql'); 

Note the following:

1. Anyone that has access to view the process list will be able to see your database password.

2. You need exec privileges enabled for PHP on your server to make this work.