1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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