Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Executing a file of SQL commands against MySQL server

by Gangabass (Vicar)
on Aug 18, 2011 at 02:50 UTC ( #920838=note: print w/ replies, xml ) Need Help??


in reply to 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?

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.
Re^2: Executing a file of SQL commands against MySQL server
by metaperl (Curate) on Aug 18, 2011 at 17:50 UTC

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://920838]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (5)
As of 2016-08-28 13:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (393 votes). Check out past polls.