Mysql Debian slow import

[Kama3a]

i have problem with the import of sql files.

let me explain :

when try import the sql file 300 mb... the import is rly slow it take up to 2-3hours.

i try with navicat and directly from the root machine.

it make 600 query per sec... and its rly slow

the export speed is normal .. i try almost everything

can u give any advice where to check ?

-different mysql versions.

-modified my.cnf

-operation sys Linux Debian x64

[DarkKnightCZ]

mysql -u root -p database_name < sql_file.sql

 

 

the quickest way

[nagudung]

When you import sql through navicat, navicat firstly reads data and then put them into database. Sql data - navicat - mysql. So it takes up longer time. You should use mysql command on dos prompt or linux shell to make it faster.