[Resolved] [Resolved] [Resolved] Including a SQL File...

[tom_s]

I have a large .sql file I need to use in my PHP script. Manually transferring the SQL into PHP/mySQL queries would take a really long time. Would it work if I just used an include statement in my PHP script, and included the sql file in?

Or do they 'have' to be in php/mysql queries?- If so, how can I get around it, short of actually spending a really long time putting it into queries manually.

Could I just do something like?

 
mysql_query(include('sqlfile.sql')) or die("Query failed : " . mysql_error());

[bastien]

I am looking for a similar solution to a similar problem...

I think (though I am not sure) that using the [man]exec[/man] function to open the mysql shell and run the .sql file thru mysql is the proper solution to this.

Unfortunately, I don't have any code examples or anything beyonf a theory at this point

[tom_s]

Thanks for the help. How do you do a sql dump using the mysql console?

I'd:

exec('mysql');

?

Then what? I' pretty confused how to do this, never used exec before.

[bastien]

try soemthing like

exec('mysqldump mysql --host=server1 --port=3306 -u<username> -p<password> -C base2');