Geeklog Forums

There is a backup function within GL's admin pages but why is there not a Restore mySQL database function within GL? I believe i can simply import the file back to restore provided the path/to/geeklog is the same etc, any way to make this restore script? and let it ask for the path/to/geeklog and update all files automatically, now that'll be a true restore function! There's always the problem of switching servers/ host or even domain and when we do that, GL has to be redone all over again. Or am i wrong on that?

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com

Yeah, it could be useful and would be easy to write. To do this we'd need to be sure to do a backup just before restoring just in case. Also, I'd personally make sure you can turn this feature off, I just don't like the potential security risk of allowing online restores.---The reason people blame things on previous generations is that there's only one other choice.

---

The reason people blame things on previous generations is that there's only one other choice.

Just use phpmyadmin (sourceforge.net) to restore the GL DB . With phpmyadmin select your DB then select the SQL tab and browse to your GL backup (i.e., glbackup.sql) and execute the query. Of course you should have used phpmyadmin to drop all of the tables in your GL DB prior to running the SQL query otherwise you could end up with a mess. phpmyadmin can also make backups of any of your DB's including GL, it saves them as plain, zip or tar files. GF

yes i know it can be done via phpmyadmin but the point is if there is a restore function via the web browser why not a restore on the same page?

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com

Hi Tony, thanks for replying, it's true on the potential hazards around when restore is implemented and a disable function will be nice. So when a GL owner want to do a restore, he'll enable the restore, retore his mySQLdb and immediately disable the restore function(s). Hope to see this function/ script soon.

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com

I would rather offer the restore as an option in the install script. bye, Dirk

How about added security such as restore is disabled until chosen by an Admin, password supplied for the db itself(which would only be known by a root admin anyway), and immediately disabled after use automatically. Of course, the restore feature would securely backup the current.db.sql before restoring any old .sql file. Then there is the occasional person who forgets to SET a root pass on mysql (which is installed with NO root pass as default), and leaves this feature WIDE open for anyone to install This_site_Has_been_Hacked_.sql Good luck.

---

--Ted(Ectropian)