Quote:
Originally Posted by Bookripper
I have no experience with databases, but how hard can it be? I softmodded my Xbox, and my tablet is rooted, overclocked and running a ROM from another brand. :-)
so I download something like SQLite Database browser and start from there?
|
I'm using Sqlite Studio. That's not a recommendation, it just happens to be the first one I downloaded, and does the job. I do find it annoying sometimes, but then I'm an experienced database person.
First, do what I suggested: add a few books, create a few shelves, add books to shelves (in all cases more than 2).
Second, copy the Sqlite database from the Kobo to your hard drive. Make another copy as backup.
Next open up the database, on your hard drive with the Sqlite program. Look at all the tables. Look at your books in the Content (or Contents) table. Look that the other tables. See how the data in the various tables are cross linked.
Manually create the entries to add an existing book to a shelf that it is not currently part of. And commit the change.
Do this with another book.
That covers the mechanics.
At this point, you can either copy you changed database over the database file on the Kobo, or you can open the database on the Kobo and do the data change again.
If you are going to copy the database back to the Kobo, it is very important that WiFi is turned OFF, and that the Kobo remains plugged into the USB port during the entire time from when you take the copy of the database from the Kobo to when you copy the changed database back to the Kobo disk. This prevents the Kobo from changing the database and then you wiping out the changes when you copy the database back.
And of course, let me repeat the caveat: Manually changing the database is dangerous and may lead to a factory reset.