sigh...more mysql trouble...help please?

Discussion in 'MySQL' started by j_p, Nov 6, 2006.

  1. #1
    basically im trying to import a sql file. Howver my myphpadmin wont allow any privlegdes and when i try to import i get a 1044# error telling me i can't do it.

    any other way to import mysql?
    Any suggestions?
     
    j_p, Nov 6, 2006 IP
  2. disgust

    disgust Guest

    Messages:
    2,417
    Likes Received:
    133
    Best Answers:
    0
    Trophy Points:
    0
    #2
    do it via the shell?
     
    disgust, Nov 6, 2006 IP
  3. hanji

    hanji Peon

    Messages:
    612
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I wonder if your mysql user has limited permissions. Is the problem with the upload via phpmyadmin or the actual SQL commands?

    hanji
     
    hanji, Nov 6, 2006 IP
  4. The Critic

    The Critic Peon

    Messages:
    392
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Have you tried copy/pasting the SQL directly into phpmyadmin rather than importing the file?
     
    The Critic, Nov 6, 2006 IP
  5. dddougal

    dddougal Well-Known Member

    Messages:
    676
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    #5
    set the privelidges of the user in cpanel before you reach phpmyadmin.

    Another problem could be that the imports is trying to create another database and you have already reached your limit.
     
    dddougal, Nov 7, 2006 IP