Where is file name in sqlite3 db?

Tomladams · 11-11-2012, 11:37 PM

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?

kovidgoyal · 11-11-2012, 11:40 PM

Look in the data table

BetterRed · 11-11-2012, 11:45 PM

irrelevant

BR

Tomladams · 11-12-2012, 02:31 PM

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.

11-11-2012, 11:37 PM	#1
Tomladams Junior Member 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?

11-11-2012, 11:45 PM	#3
BetterRed null operator (he/him) Posts: 20,553 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	irrelevant BR Last edited by BetterRed; 11-12-2012 at 01:10 AM. Reason: xposted with kg

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

11-11-2012, 11:40 PM	#2
kovidgoyal creator of calibre Posts: 43,843 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Look in the data table

11-12-2012, 02:31 PM	#4
Tomladams Junior Member 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.

Advert