distal-attribute
distal-attribute
distal-attribute
distal-attribute

Importing a dump

User, date Message
Written by mnjn
8 months ago
Category: General
2 posts since Mon, 03 Feb 14
Hi,
Can some one please help in importing a file (.dump) in to DB.
Written by justpusherMoney, Euro
8 months ago
28 posts since Wed, 31 Mar 10
Hello,

What DB do you use?
What is the file format?
Written by mnjn
8 months ago
2 posts since Mon, 03 Feb 14
Got the solution,

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

Thanks.
Written by jfalchMoney, Euro
8 months ago
407 posts since Sat, 17 Oct 09
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").
Written by kalvaro
8 months ago
595 posts since Thu, 29 Nov 07
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.