Import file sql larger size to mysql in ubuntu system


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

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

mysql -u <username> -p


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: 


Done. Thanks.