[HowTo] Database broken : Import old settings

Tutorials, tips and tricks.

Moderator: moderators

Re: [HowTo] Database broken : Import old settings

Postby pabohoney1 » Wed Dec 26, 2012 9:50 pm

So I recently had to recover from a DB corruption. Found this post on how to reimport users and settings. The problem I was running into is the same as above, it says a duplicate value is found. Normally with a SQL query, you can use REPLACE if the value is found, but that doesn't seem to work with the subsonic db query page. Any ideas from anyone?
pabohoney1
 
Posts: 6
Joined: Wed Dec 26, 2012 9:47 pm

Re: [HowTo] Database broken : Import old settings

Postby hakko » Wed Dec 26, 2012 10:01 pm

Do you mean UPDATE?
MusicCabinet developer
hakko
 
Posts: 1416
Joined: Tue Apr 17, 2012 7:05 pm
Location: Sweden

Re: [HowTo] Database broken : Import old settings

Postby Pessoa » Sat Dec 29, 2012 5:30 am

Thanks a lot for your help! I've got it working again perfectly and understand the system a lot better too.
Pessoa
 
Posts: 26
Joined: Sat Dec 22, 2012 6:50 pm

Re: [HowTo] Database broken : Import old settings

Postby Pessoa » Sat Dec 29, 2012 5:31 am

thanks for your help!
Pessoa
 
Posts: 26
Joined: Sat Dec 22, 2012 6:50 pm

Previous

Return to Tutorials

Who is online

Users browsing this forum: No registered users and 5 guests