Mysql console slow on import of huge sql files
- by Kennethvr
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?