DB is corrupt. Please reformat and rebuild this drive

Engine DJ Hardware Media Players
, , ,
33

@tommyg

Who are you asking to DM you?

35

He was asking you to send him your DB files. His post seem to have vanished though.

36

I am not sure why my posts have disappeared but reposting.

Assuming you have a corrupted database message these steps will help you try to repair the databases. Please note that this worked for me and may not work for you and you must be tech savvy to do it as I will not take responsibility. This is at your own risk. You must have knowledge of how to use the terminal application.

It’s best to copy all the db files into a new directory to do this fix. The list of files are:

  • m.db
  • p.db
  • sm.db
  • sp.db
  • stm.db
  • stp.db

Step 1: Exporting the data

sqlite3 {NAME_OF_DB}
.mode insert
.output {NAME_OF_DB}_dump.sql
.dump
.exit

Step 2: Modify the {NAME_OF_DB}_dump.sql file

  1. Remove the 2nd line in the dump file. Look for the line that says BEGIN TRANSACTION
  2. Remove the last line in the dump file. Look for the line that says ROLLBACK

Step 3: Recreate the new database

sqlite3 {NAME_OF_DB}.db < {NAME_OF_DB}_dump.sql

Step 4: Integrity check

sqlite3 {NAME_OF_DB}.db "PRAGMA integrity_check"
37

Ehm you deleted the post yourself 21 hours ago.

38

That’s unfortunate. I am not sure how that could have happened.

39

I’ll keep an eye out also.

On that note, it’s usually better to edit a post then to delete and write a new similar one.

40

Wow. That got salty quick.

Again, not sure how that happened. It’s not like this was intentional. I only created a new post for people who come here after but now I see that the moderators love going against their own guidelines so I will just not use this forum.

41

That’s good advice

42

My comment was meant as a little suggestion in general. Nothing special, definitely not a judgement. :slight_smile: (I don’t understand why my reply was read as “salty” tbh, but okay)

Why that SQL post got deleted, I really don’t know. I only see your account as the last executioner; according to the forum-system. :sunglasses:

43

Bit weird how that ended, but perhaps the backend of the forum interpreted the sql tags as an injection - who knows!

44

No clue, curious if the last SQL reply will auto-vanish.

45

Hi Mate I cant find dump sql file can you help me with that ?

46

That’s a bit of a convoluted way of doing it. This way is easier (follow instructions in the pdf).

47

Would data base work if i downgrade to 1.5 ?

48

Don’t know, don’t care to know tbh. Unless told to by official Denon sources, you should never downgrade, only ever upgrade :slight_smile:

49

Thanks I done all and file size after repair is showing 0kb is it normal ?

50

hi I tried this fix file p when recovering it is getting bigger in kb and at the end is 0Kb file m is going very fast and it is same 0Kb after repair

51

  1. Don’t double ping/reply to me - I’m busy and don’t appreciate the additional email spam. I’ll get to your post when I’m not so busy.

  2. Not sure on your specific issue - it’s never happened to me so I would suggest Googling along the lines of “sqlite dump 0kb file”. E.g. sqlite dump 0kb file - Google Search

52

The sql file should be in the same directory as the sqlite file. If it is not, please follow my steps as they are posted.

53

Hi
Thanks for help but in my case not working to good It did recover last playlist and one history but not really real one I will rebuild drive and have to remember about backups more often

Thanks again