Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    166
    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:
    166
    Code:
    mysql -uUSER -pPASSWORD DATABASE < /path/to/dump-file.sql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Finkinstein

    Finkinstein Well-Known Member

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

    Thanks a lot!
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice