wow, bye bye gallery..it's gone

[dani3d]

I did a backup before installing the new RC2 and just for fun I tried doing a restore...well...it's all gone. Nothing is left and I have to reinstall I guess. Idon't think I will back this thing up anymore. but here is the page:

http://www.shutterdream.com/gallery/list.php

I used the Exhibit backup feature and did the restore with "slow restore" or something like that...can't get access to it as this is also bye bye.

what did I do wrong?

[tommykjensen]

How did You perform the backup? To another db or to a file?

If You choose file then have a look in the file and see if not Your data are in there. Then You can try executing those sql statements via phpMyadmin.

[Pekka]

I did a backup before installing the new RC2 and just for fun I tried doing a restore...well...it's all gone. Nothing is left and I have to reinstall I guess. Idon't think I will back this thing up anymore. but here is the page:

http://www.shutterdream.com/gallery/list.php

I used the Exhibit backup feature and did the restore with "slow restore" or something like that...can't get access to it as this is also bye bye.

what did I do wrong?

First of all you should not restore older version database over new version. If you want to restore old version database, then you should also replace php files.

You did a backup to a file, right? Was it a full backup?

If your PHP timeout is 30s or so, it is possible that the restore was not fully executed - you will see a confirmation after successfull restore on EE Backup info panel. Did you see it (green text saying dump was successfull)?

It's not clear to me why you can't access slow restore. can you explain?

EE Backup (and restore) works - I use it daily on developement and on several web servers, this forum included. If there is a problem in restore you will see error messages and often verbose explanations too (i.e. when e.g. MySQL versions don't match). Did you see any error messages?

[dani3d]

I backed up the database with the provided utility in EE using file only, then just to do a little test I restored it right away. It was only older from a fiew second :) I restored this using the slow button. When I did the backup to file, I don't think I got a confirmation after, but can't remember.

I selected the backup from the list and clicked on the slow restore button. it is still there BTW. It has 197kb and yet I did the full backup.

I did this again and this time I used the to database only and it worked fine.

"First of all you should not restore older version database over new version."

Oh but how to backup a database before upgrading the software then? A backup will always be older..so what's the point of doing a backup if you can't use it if it's too old?

"It's not clear to me why you can't access slow restore. can you explain?"

I could accesss it and I did, but doing so damaged my EE gallery. I had the error right after. I wish I could remember but I don't think I saw an error message when I did it. Only when I tried the page the next time, nothing worked.

what is the difference between the restore and restore in slow mode?

[Pekka]

I backed up the database with the provided utility in EE using file only, then just to do a little test I restored it right away. It was only older from a fiew second :) I restored this using the slow button. When I did the backup to file, I don't think I got a confirmation after, but can't remember.

I selected the backup from the list and clicked on the slow restore button. it is still there BTW. It has 197kb and yet I did the full backup.

I did this again and this time I used the to database only and it worked fine.

Maybe you can mail me pekka at photography-on-the.net file backup which did not work so I can see if there is some technical bug in there.

"First of all you should not restore older version database over new version."

Oh but how to backup a database before upgrading the software then? A backup will always be older..so what's the point of doing a backup if you can't use it if it's too old?

I mean, if:

1. you have installed EE 1.22 and do a backup
2. you install 1.5 RC 2 and do a backup.

... you can not restore backup done from 1.22 over 1.5 - this will give errors in EE.

You can of course make and restore backups from version 1.5RC2 to 1.5RC2.

what is the difference between the restore and restore in slow mode?

Slow restore does one restore command per "page" in order to fight SQL server connect dropouts, browser timeout limit and php timeout limit - and it has progress display. It is safe but also very slow.

Normal restore works technically identically but it does all in one go without any progress info (this is very fast) - so with normal restore you will have to have PHP max time set to larger amount of seconds the restore will take, and your SQL server should be ready to communicate all the time during restore.