Importing a dump

2 posts
[expired user #7713]'s profile image [expired user #7713] posted 10 years ago in General Permalink
Hi,
Can some one please help in importing a file (.dump) in to DB.
33 posts
justpusher's profile image justpusher posted 10 years ago Permalink
Hello,

What DB do you use?
What is the file format?
2 posts
[expired user #7713]'s profile image [expired user #7713] posted 10 years ago Permalink
Got the solution,

$ mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

Thanks.
560 posts
jfalch's profile image jfalch posted 10 years ago Permalink
you can also load data.sql into one of heidisql´s query tabs (using right mouse click then "Load SQL file..."), and then press F9 (or click rightMouse / "Run").
959 posts
kalvaro's profile image kalvaro posted 10 years ago Permalink
In other words, you're asking how to run SQL queries from a file, and the answer is "File/ Load SQL File".

Please login to leave a reply, or register at first.