SQL import

Discussion in 'MySQL' started by anon190000, Jul 4, 2009.

0
  1. #1
    i do a very stupid thing and i import all database at same time localhost.tar.gz it have about 8 sql 500mb include information_schema

    what shall i do i add 8 database then import dont work i dont add it say access deny for user xxxx and i cant enter host again as my host is finish so hope some one can help me thanks
     
    anon190000, Jul 4, 2009 IP
  2. EastsideHosting

    EastsideHosting Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you have SSH Access;

    mysql -u USERNAME –p PASSWORD DATABASE < FILENAME.sql
     
    EastsideHosting, Jul 4, 2009 IP
  3. bluebenz

    bluebenz Well-Known Member

    Messages:
    876
    Likes Received:
    9
    Best Answers:
    2
    Trophy Points:
    138
    #3
    I don't know how an automatic solution solve your problem, because each database have single username and password (maybe ?)

    But I will try to split the imported database, make 1 .sql per database, and import them one by one.
     
    bluebenz, Jul 4, 2009 IP
  4. alfa_375

    alfa_375 Active Member

    Messages:
    445
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #4
    I think better you create new database and username and then just import the data only. I gues so.
     
    alfa_375, Jul 5, 2009 IP