Re: howto run sql script with php?

On Sun, Jun 13, 2010 at 12:14:53PM +0100, Ashley Sheridan wrote: > On Sun, 2010-06-13 at 12:52 +0200, Stephan Ebelt wrote: > > On Sun, Jun 13, 2010 at 11:29:14AM +0200, Peter Lind wrote: > > On 13 June 2010 11:05, Stephan Ebelt <[1]ste@shared-files.de> wrote: > > > Hello, > > > > > > I am trying to run a .sql script produced with mysql-dump from a php script but > > > failed to find a rudimentary robust solution yet. > > > > > > mysql_query() can only run one query at a time. Thus its necessary to somehow > > > parse the input file and separate the queries... which is difficult since the > > > syntax can be quite complex. > > > > > > > Use mysqli - it supports running multiple queries at once. > > sometimes its as easy as that. I'll give it a try. > > thanks, > stephan > > > > Why do you have to use PHP at all to do this? You could run the query > directly at the MySQL console. > > Failing that, why not use a tool such as phpMyAdmin, which will do all the > hard work for you? I use it to deploy schema updates and run unittests. So there are many sql files running many times actually. Its been working fine for years until I came up with wanting a trigger recently... good point to check how phpMyAdmin does this. They must have faced the same problem. stephan > > Thanks, > Ash > [2]http://www.ashleysheridan.co.uk > > References > > Visible links > 1. mailto:ste@shared-files.de > 2. http://www.ashleysheridan.co.uk/