Why does this happen when I restore database with cpanel?

[ApplianceJunk]

I used cpanel to back up my database for our appliancejunk.com site.

When I take the current database backup file and use cpanel to restore it to another .com that I use for a test site to play with it shows a size of 0.0MB when the original files size was 10MB.

I run the database 'check' and 'repair' in cpanel on the test site and everything checked ok.
I also run repair_setting.php on the test site.

The funny thing is I can connect the forum to the uploaded database on the test site, but it only shows post up to 2008, why?

Original site that I backed up database from: http://appliancejunk.com

Site that I uploaded backed up database file to: http://johnpahl.com/smftest

Why don't all my members and topics show up when I uploaded a current database?

[ZerK]

that happened to me once, it happens when the database s too big to download it using phpmyadmin/smf.

i had to backup it using ssh mysqldump command.

[ApplianceJunk]

How big is to big?

I back up the database daily and can see our database file grow over time as our site grows.

When I back up the database using the tools through the forum admin panel the file is about the same size as when I use cpanel to back up the database file.

[ZerK]

i cant remember very well but thats because php have a size and time limit, it appears in the phpinfo, you can set it higher or just backup through another method.

[ApplianceJunk]

it happens when the database s too big to download it using phpmyadmin/smf.

I'm using cpanel to backup and restore the database.

[ZerK]

then i dont know whats the problem but answering your question, that happens because the backup is not complete.

[Christian A. Herrnboeck]

Try deleting all of the error log entries... When your DB becomes too large Mysqldump will timeout to prevent a server overload from adversely affecting other clients on that server.

[ApplianceJunk]

Thanks for the reply.

When I try to log into my test site johnpahl.com/smftest to clear the error log I can't log in.


I get a message of 'You were unable to login. Please check your cookie settings.'

Hmm...

[ApplianceJunk]

Now that I think about it I believe when I run repair_settings.php I used it to change the cookie name: (don't remember what it was set to) to the, Recommended value: "SMFCookie11".

Wonder if that is my problem now trying to log in and if it is how I find out what the cookie name should be now.

[Illori]

there is no set value the cookie should be, so you cant really look it up somewhere and find a definite answer

[ApplianceJunk]

I was able to look up the cookie name setting in admin panel on the appliancejunk.com site that I got the database from to start with.

I then used repair_settings.php on my test site at johnpahl.com/smftest to check and change the cookie name. This let me log into my test site now and clear the errors.

I still don't see all my topics and members from the database though.

[ApplianceJunk]

Still looking for answers as to why when I backup my database using cpanel and then restore it to a test site using cpanel I get less then half the members info, post, topics, etc.. Like it don't get the last two years or so...

[Illori]

no idea on that, maybe your host has some restriction on the backup. you can try to backup with phpmyadmin. How do I backup my database?

[ZerK]

it ll be the same because phpmyadmin use php to upload/download the files.

post your phpinfo.