Web Hosting Forums

Results 1 to 13 of 13

This is a discussion on MySQL dump not working. :( in the Hosting Talk & Chit-chat forum
I am transferring a database from a different server to one on Aletia, and this is the error I am getting: Code: Database browdot_forums running ...

  1. #1
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181

    MySQL dump not working. :(

    I am transferring a database from a different server to one on Aletia, and this is the error I am getting:

    Code:
    Database browdot_forums running on localhost
    Error 
    SQL-query :  
    
    Database browdotcom_com - table word
    CREATE TABLE access (
       userid int(10) unsigned NOT NULL,
       forumid smallint(5) unsigned NOT NULL,
       accessmask smallint(5) unsigned NOT NULL,
       UNIQUE userid (userid, forumid)
    )
    
    MySQL said: 
    
    
    You have an error in your SQL syntax near 'Database browdotcom_com - table word
    CREATE TABLE access (
       userid int(10) u' at line 1
    
    Back
    -Matt

  2. #2
    alexodin
    Guest
    hmm... "Database browdotcom_com - table word" is not SQL statement

  3. #3
    young and idealistic clio's Avatar
    Join Date
    Oct 2002
    Location
    Tübingen, Germany
    Posts
    2,140
    the dump is fine. your MySQL code isn't. and that isn't the proper way to transfer a DB from 1 server to another anyhow....

    put "##" in line 1 in the beginning. i think you meant to make a comment...
    - Julie
    Student / Web Developer

  4. #4
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181
    i didnt write the code. PHP MyAdmin did, plus i got it to work finally. I checked all the boxes both "send" and whatever the other option was and that made it work.

    -Matt

  5. #5
    Chairman Still Shady's Avatar
    Join Date
    Sep 2001
    Location
    Redmond, WA-nnabe
    Posts
    1,184
    Are some headers commented?
    Where do you wanna go today?

  6. #6
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181
    headers commented?? what are you talking about?

    -Matt

  7. #7
    Chairman Still Shady's Avatar
    Join Date
    Sep 2001
    Location
    Redmond, WA-nnabe
    Posts
    1,184
    When phpmyadmin dumps a database... it adds comments at the top of the file but it doesn't mark it as comments in some version.
    Where do you wanna go today?

  8. #8
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181
    oh, that may have been the problem. because i was actually doing this for a friend, and his old hosting company was way behind on the current versions of PHP, and PHP MyAdmin.

    -Matt

  9. #9
    Chairman Still Shady's Avatar
    Join Date
    Sep 2001
    Location
    Redmond, WA-nnabe
    Posts
    1,184
    you have to comment them using #

    for example:

    # this is the comment
    # this is the comment 2
    Where do you wanna go today?

  10. #10
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181
    like i said, i didnt make it. php MyAdmin did.

    But the wierd thing was when I checked the two checkboxes the old version have which were send and something else, the newer version of php MyAdmin on aletia's servers understood the code just fine.

    That makes me think that it wasnt a problem with the code, but I could be wrong.

    -Matt

  11. #11
    Chairman Still Shady's Avatar
    Join Date
    Sep 2001
    Location
    Redmond, WA-nnabe
    Posts
    1,184
    The problem was with phpmyadmin!
    Where do you wanna go today?

  12. #12
    Loyal Client
    Join Date
    Aug 2001
    Posts
    181
    okay...whatever you say. Like I said, I have no idea. I do not have the source code to that version of phpMyAdmin so I cannot go and check to see.

    I wish I did, because then I could see what contributed to it.

    -Matt

  13. #13
    young and idealistic clio's Avatar
    Join Date
    Oct 2002
    Location
    Tübingen, Germany
    Posts
    2,140
    Just so you know, the problem IS that it wasn't commented. it's kinda obvious from the error message which is why I told you to put "#" in the beginning of the line.
    - Julie
    Student / Web Developer

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •