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!

Related Posts