Tag Archives: import

MySQL Source

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!