Re: Executing a file of SQL commands against MySQL server

Why don't you want just make a system() with this command mysql -u username -p password database < sql_file?

Comment on Re: Executing a file of SQL commands against MySQL server Select or Download Code

Replies are listed 'Best First'.
Re^2: Executing a file of SQL commands against MySQL server by Neighbour (Friar) on Aug 18, 2011 at 08:35 UTC
Or, alternatively, use the -e option of the mysql client to parse the sql_file: `mysql -u username -p password -e 'source sql_file' database` This will make the mysql-client read the file instead of piping it in.	[reply] [d/l]
Re^2: Executing a file of SQL commands against MySQL server by metaperl (Curate) on Aug 18, 2011 at 17:50 UTC
Yes, that worked. Thanks. The mantra of every experienced web application developer is the same: thou shalt separate business logic from display. Ironically, almost all template engines allow violation of this separation principle, which is the very impetus for HTML template engine development. -- Terence Parr, "Enforcing Strict Model View Separation in Template Engines"	[reply]