I just fell in love with mysql “source”-command … just wanted to mention that ;-)!
Having trouble importing a large file into a mysql database? Simply open the prompt, connect to the server (on my local machine I didn’t need to specify a host) so something like:
mysql -u [user] -p
And as soon as mysql lets you in, you can select the database to import your file into with the command:
use [database]
After the database is selected, you can import your file with this little nugget:
source [file]
All commands without brackets 😉 … and mysql will start importing the data into your database. No more workbench messages like “unable to allocate sufficient bytes to read the file”. Live can be so easy!