Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-11-2012, 11:37 PM   #1
Tomladams
Junior Member
Tomladams began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Nov 2012
Device: None
Where is file name in sqlite3 db?

I've stupidly run a find command that I use for other purposes from inside the calibre library directory. The net result of this was to move all the individual files from where they were in the library to one new directory. I was hoping to write a script that used information from metadata.db to put the files back where they belonged. I can find the pathname in the books table, but I can't find the file names anywhere in the database. Are the filenames there?
Tomladams is offline   Reply With Quote
Old 11-11-2012, 11:40 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 24,803
Karma: 4369673
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Look in the data table
kovidgoyal is offline   Reply With Quote
 
Enthusiast
Old 11-11-2012, 11:45 PM   #3
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 2,312
Karma: 1664976
Join Date: Mar 2012
Location: NSW Australia
Device: none
irrelevant

BR

Last edited by BetterRed; 11-12-2012 at 01:10 AM. Reason: xposted with kg
BetterRed is offline   Reply With Quote
Old 11-12-2012, 02:31 PM   #4
Tomladams
Junior Member
Tomladams began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Nov 2012
Device: None
Thanks. That worked great. I installed Sqlite3, ran "sqlite3 metadata.db 'select name,path from books, data where data.book = books.id'" and got a list of where all the files should have been. I got confused last night because the file type isn't in the name value in the data table. I appreciate the help.
Tomladams is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot Read .htm file auto-imported as zip file Jimbo724 Conversion 2 07-24-2012 06:08 AM
Book Extras .be file vs. X-Ray file format Doitsu Kindle Formats 0 04-22-2012 07:07 AM
Android How to open PDF file directly in ES File Explorer? thinredline enTourage eDGe 4 06-26-2011 03:10 PM
Opus Updating EPUB file won't change publisher data on file listing spaze Bookeen 1 03-08-2011 01:34 AM
Firstname as author - metadata.db and SQLite3 Starson17 Calibre 11 12-20-2009 02:01 PM


All times are GMT -4. The time now is 02:53 AM.


MobileRead.com is a privately owned, operated and funded community.