Welcome to Geeklog, Anonymous Monday, April 15 2024 @ 09:31 am EDT

Geeklog Forums

Backup is there, now what about restore function?


Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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
 Quote

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
Location:Urbandale, Iowa
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.
 Quote

Anonymous

Anonymous
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
 Quote

Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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
 Quote

Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
I would rather offer the restore as an option in the install script. bye, Dirk
 Quote

Status: offline

Ectropian

Forum User
Chatty
Registered: 06/19/02
Posts: 61
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 Smile Good luck.
--Ted(Ectropian)
 Quote

All times are EDT. The time is now 09:31 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content