Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to import large .sql file to mysql via terminal

    @dibya.lochan
    Recommendations Offline Message

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 734
    Comment on it

    If you want to import large sql file to mysql via terminal, here are the steps:

    First go to terminal, for Linux (UBNTU) user can go directly by pressing Ctrl-Alt-t key.
    Now write down the following commands in Terminal.

    mysql -u <username> -p <anydatabase_name>

    After writing the above command, terminal will ask for password, you have to enter the password of database .
    Enter Password:

    <Database_password>

    c. Now next command- Create a new database if database to which the sql file is to be imported does not exists.

    mysql>create database <database_name>;

    d. Specify the database name to which the .sql file is to be imported.

    mysql>use <databasename>;

    e. Specify the source of your sql file.

    mysql>set autocommit=0; source <file path in local directory>; commit;
    php mysql import large .sql file import via terminal ubuntu
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: