Skip to content

mysql import big *.sql files using the cli

If you need to import big \*.sql files into your mysql dbms, just log in using the cli support on your shell.

mysql - u -p
After that, change to your database ("show databases;" and "use mydatabase") and use the following command to insert the *.sql file.
>mysql source /path/to/source.sql