stupid LOCK TABLES MESSAGE. please help!!!

Discussion in 'MySQL' started by CircleOfLinks, Dec 28, 2007.

0
  1. #1
    Hi,

    im having a major problem with my site, as soon as it finally starts to take of and gets heaps of traffic i've had to change my site to a new server.

    I've transfered the whole site accross but im getting this following message:

    Error
    SQL query:

    --
    -- Dumping data for table `featured`
    --
    LOCK TABLES `featured` WRITE
    MySQL said:

    #1044 - Access denied for user 'w0010'@'localhost' to database 'aussiepages_com_au_database'

    Please if someone has any idea on what I can do I would really appreciate it. Im trying to upload my backup database by going to myphpadmin selecting the database and clicking on SQL then browse and upload...

    Please help really urgent.

    thanks heaps
     
    CircleOfLinks, Dec 28, 2007 IP
  2. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #2
    hi

    The two database names and user names should be same

    Regards

    Alex
     
    kmap, Dec 30, 2007 IP
  3. CircleOfLinks

    CircleOfLinks Active Member

    Messages:
    306
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #3
    hi thanks,

    All sorted now
     
    CircleOfLinks, Jan 1, 2008 IP