Import file sql larger size to mysql in ubuntu system

LANGUAGES TECHNOLOGY

Posted on 2014-12-12 10:42:24


1. You can access to mysql with command line in ubuntu with

mysql -u <username> -p

mysql_access 

Then you can type password of username for access. 2. You can type command line

Show databases;

This command line for show all databases of this username. Continue, you write command line

Use <name_databases>; name_databases : name of database you want to import file sql.

3. Continue you can type

source <url_name_file_sql.sql> url_name_file_sql.sql: It is url of file you want to import.

You can see image bellow for detail: 

  mysql_access 

Done. Thanks.