upload backup of sql database - pictures don't show

Discussion in 'Databases' started by jasonvan, Dec 5, 2009.

  1. #1
    I just moved my social networking script to a different host.

    I made a backup of my MySQL database. I then created a new database on new server, and uploaded the backup to this.

    All profiles and profile information work perfect. The only problem is that the profile pictures no longer show up.

    Does anybody have a clue to what went wrong?

    I've already contacted the hosting companies and the seller of this script, and nobody has an answer.
     
    jasonvan, Dec 5, 2009 IP
  2. Big0ne

    Big0ne Well-Known Member

    Messages:
    2,614
    Likes Received:
    81
    Best Answers:
    0
    Trophy Points:
    165
    #2
    Check full picture path, including cpanel username if exists.
     
    Big0ne, Dec 5, 2009 IP
  3. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #3
    Were the pictures in the database? Or did it only contain the link to the pictures?
     
    Colbyt, Dec 5, 2009 IP
  4. jasonvan

    jasonvan Member

    Messages:
    363
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    35
    #4
    They were in the database. Exactly how I'm not sure.
     
    jasonvan, Dec 5, 2009 IP
  5. Big0ne

    Big0ne Well-Known Member

    Messages:
    2,614
    Likes Received:
    81
    Best Answers:
    0
    Trophy Points:
    165
    #5
    This has nothing to do with the database itself, but path to the pictures. As pictures cannot be stored in a database.

    Check again full path of pictures.
     
    Big0ne, Dec 5, 2009 IP
  6. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #6
    What?

    Maybe you should read this: http://forums.mysql.com/read.php?20,17671,27914
     
    Colbyt, Dec 6, 2009 IP
  7. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #7
    It is possible that they were corrupted as a part of the import export process. Are you getting any error messages? Or just no display?
     
    Colbyt, Dec 6, 2009 IP
  8. jasonvan

    jasonvan Member

    Messages:
    363
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    35
    #8
    All the rest of the info. in the database is working perfectly.

    Members, passwords, mail, profile info., etc. all showed up perfectly after the transfer.

    Only profile images did not make the transfer.
     
    jasonvan, Dec 6, 2009 IP
  9. jasonvan

    jasonvan Member

    Messages:
    363
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    35
    #9
    Do you think it has something to do with file/folder permissions?
     
    jasonvan, Dec 6, 2009 IP
  10. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #10
    jason

    Either post your url here or pm it to me and I will take a look. What I fear happened is that the binary images were corrupted in the process of export/import. I am really not exactly sure how mysql stores them. I just know it can be done that way because I was as surprised as bigone is going to be the next time he reads this thread.
     
    Colbyt, Dec 6, 2009 IP
  11. nashhull

    nashhull Peon

    Messages:
    141
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    As pictures cannot be stored in a database.
     
    nashhull, Dec 7, 2009 IP