The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqlimport

Discussion in 'General Discussion' started by Finkinstein, Oct 19, 2003.

  1. Finkinstein

    Finkinstein Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    Mysql dump too large for phpmyadmin. Times out.

    So, how could I import the .sql file?

    I have tried using mysqlimport but it trys to put it in one table where as the .sql contains the entire database.
     
  2. ciphervendor

    ciphervendor Well-Known Member

    Joined:
    Aug 26, 2002
    Messages:
    1,052
    Likes Received:
    0
    Trophy Points:
    36
    Code:
    mysql -uUSER -pPASSWORD DATABASE < /path/to/dump-file.sql
     
  3. Finkinstein

    Finkinstein Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    Ahh... that simple.

    Thanks a lot!
     

Share This Page