Page 1 of 1

Posted: Wed Aug 14, 2002 2:52 am
by Jay
You can't execute a file as it stands, but you can read the file, split it down into the appropriate sentences and execute them individually.

Posted: Wed Aug 14, 2002 3:10 am
by DoppyNL
you can take a look at phpmyadmin, because it is possible to execute the query's in an sql-file with phpmyadmin.
So you can take a look at how they did it.

Greetz Daan

Posted: Wed Aug 14, 2002 3:44 am
by Jay
dvdbinternet wrote:you can take a look at phpmyadmin, because it is possible to execute the query's in an sql-file with phpmyadmin.
So you can take a look at how they did it.

Greetz Daan

I already deciphered it, they spilt the query up into single commands and execute them individually.

You'll notice once you execute a file in PHPMyAdmin it'll tell you how many commands were executed.

Posted: Fri Sep 20, 2002 7:59 am
by serge
For instance, sql script is "script.sql."
U can use:

exec('mysql < script.sql') in local variant

or specify command line parameters (for help: 'mysql --h') - sever, username, password, etc in case of remote mysql server.

------------------------
With best regards,
Serge Bulanov
AlarIT Web developer,
http://www.AlarIT.com