Skip to content

How to insert the dump file into the database?

uncompressed¬† dump file “file.sql”¬† into the example database

mysql -u root -p example < /home/mysql/file.sql

or for a small files

mysql> use example database;

mysql> source file.sql (file.sql must be  exist in the current directory)