Re: Executing a file of SQL commands against MySQL server

by Gangabass (Priest)

on Aug 18, 2011 at 02:50 UTC ( #920838=note: print w/ replies, xml )

Need Help??

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
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]

Node Status^?

node history
Node Type: note [id://920838]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others browsing the Monastery: (3)

As of 2013-05-26 03:06 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?