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
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