MySQL Import running out of memory with "mysql" command
I'm running mysql -u root -p 'databasename' < /path/to/file.sql and am
getting the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '<br />
<b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tr'
at line 90
mysql> Aborted
I'm trying to find out how to work around this temporarily... one of the
things I've tried is adding --max_allowed_packet=512M to the command.
The .sql file is 120MB. Any suggestions?
No comments:
Post a Comment