Mysql console slow on import of huge sql files

Posted by Kennethvr on Stack Overflow See other posts from Stack Overflow or by Kennethvr
Published on 2010-06-02T09:30:58Z Indexed on 2010/06/02 9:33 UTC
Read the original article Hit count: 157

Filed under:
|
|
|

My import of sql via the mysql console is rather slow and as our sql file is increasing every day I would like to know if there are any alternatives on how to import a sql file faster.

Changing to oracle or other systems is no option, the configuration has to stay the same.

Currently the sql file is: 1.5 Gb I'm on Wamp with Apache 2.2.14, PHP 5.2.11 and MySQL 5.1.41.

Any suggestions?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql