4images Forum & Community

General / Allgemeines => Programming => Topic started by: darkcurves on May 31, 2009, 09:57:11 AM

Title: Problems with restoring MYSQL database
Post by: darkcurves 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.

Title: Re: Problems with restoring MYSQL database
Post by: HansBr 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.

Title: Re: Problems with restoring MYSQL database
Post by: darkcurves 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.

Title: Re: Problems with restoring MYSQL database
Post by: darkcurves on August 28, 2009, 06:36:42 AM

I think that's spam.  :evil:

Title: Re: Problems with restoring MYSQL database
Post by: Nicky 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.

Title: Re: Problems with restoring MYSQL database
Post by: darkcurves on August 28, 2009, 06:48:02 PM

Oh, there was a spam post above mine, i think it has been deleted.