Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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


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?


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.
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 about the Monastery: (5)
As of 2014-07-13 23:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (252 votes), past polls