Thread: Glo Glo help please!
View Single Post
Old 03-13-2013, 08:45 PM   #54
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by jackastor View Post
Curious, can the sql be deleted and rebuilt in the Glo?
I'm not sure what you mean. If you do a logout, the device will create a new database for you. The database is empty and the device asks you to login again. Taking a copy of that is probably the best backup and restart from scratch database there is.

You can load the database on the PC and extract the DDL. I have done this with the betas and then compare the extracts as a quick way to see the changes. The DDL could be used to create a new empty database if you wanted to. And you could export all the data and reimport it into an empty database. That might give better performance.

You can also rebuild the indexes. That might be a good idea for someone who has done a big import of files. Rebuilding the indexes might clean up the organisation and speed things up.
davidfor is offline   Reply With Quote