Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Importing MySQL dump file remotely

by igelkott (Priest)
on Aug 09, 2008 at 08:57 UTC ( [id://703247]=note: print w/replies, xml ) Need Help??


in reply to Importing MySQL dump file remotely

A simple, non-perl solution would be to use the local mysql client:

mysql -hserver -p < dump.sql
The password should be set in your .my.cnf (or equiv). Specify the database for loading single db dumps.

If the mysql client isn't available locally, install it; it's worth the small effort.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2024-03-29 09:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found