Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2016-12-05 04:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (72 votes). Check out past polls.