Tuesday, July 22, 2014

How to import sql file in MySQL console to database

Suppose the sql file is named as file.sql, the path to the sql file is path.
To import the sql file to a Mysql database from MySQL console,
mysql> use DATABASE_NAME;
mysql> source path/file.sql;

No comments:

Post a Comment