Author Topic: Problems with restoring MYSQL database  (Read 8986 times)

0 Members and 1 Guest are viewing this topic.

Offline darkcurves

  • Full Member
  • ***
  • Posts: 114
    • View Profile
    • KTM Railway Fan Club - Gallery
Problems with restoring MYSQL database
« on: May 31, 2009, 09:57:11 AM »
Been trying to move to a different host and i opted to manually move my database. I notice sometimes the records and file size are different. Is that ok? Also the overhead is missing when tables are restored. Please check the attachment. Any help would be appreciated. Thanks.

Offline HansBr

  • Pre-Newbie
  • Posts: 7
    • View Profile
Re: Problems with restoring MYSQL database
« Reply #1 on: May 31, 2009, 10:22:27 AM »
Seems fine to me.
Missing overhead is not a problem at all, since it is just overhead, leftover space when dates are deleted. You haven't deleted anything in the new database.

What method did you use? Mysqldump?
Other changed values could result from different settings in the database system.

Offline darkcurves

  • Full Member
  • ***
  • Posts: 114
    • View Profile
    • KTM Railway Fan Club - Gallery
Re: Problems with restoring MYSQL database
« Reply #2 on: June 01, 2009, 10:03:23 AM »
Thanks for the help!  :D

I just used Export in PHPMYADMIN. I restored the whole database but there were timeouts so i manually restored table by table.

Offline darkcurves

  • Full Member
  • ***
  • Posts: 114
    • View Profile
    • KTM Railway Fan Club - Gallery
Re: Problems with restoring MYSQL database
« Reply #3 on: August 28, 2009, 06:36:42 AM »
I think that's spam.  :evil:

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Problems with restoring MYSQL database
« Reply #4 on: August 28, 2009, 06:21:15 PM »
darkcurves,

you can look over 4images admin control panel for all 24141 comments.. it will takes a while to read them all.
but you can look if those are spam or not.
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline darkcurves

  • Full Member
  • ***
  • Posts: 114
    • View Profile
    • KTM Railway Fan Club - Gallery
Re: Problems with restoring MYSQL database
« Reply #5 on: August 28, 2009, 06:48:02 PM »
Oh, there was a spam post above mine, i think it has been deleted.