How to import sql file to server?

[Tia]

hello,
I have installed the MySql server on localhost and it is running smoothly. I have downloaded de SQL file to import into the server. the source file.sql command line returns me with failed to open file, error 2. i have stored the file in the data directory and i also tried to retrieve the file with c:\program files etc. does anyone have a answer to this? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

Hi,

To import a SQL file you need to launch mysql client program from mysql directory.

Mysql klient program is called mysql.exe and usualy it is in "Program files\Mysql\Bin" directory.

In case the SQL file is a datadump from some database, you will need to create a database first.

1 step: create database:

mysql.exe -u root

mysql> create database new_data;

mysql>quit

2 step: import data:

mysql.exe -u root new_data < your_file.sql -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --