Restoring Database

[MackieRocks]

Last night, just prior to a show, I indexed some new songs and rebuilt the database. To my horror, a bunch of my songs disappeared. What did I do wrong and how do I go about restoring the database to the previous version prior to my indexing new songs? All my KMA files are on a 1Tb external harddrive. I'm freaking out!!!

[admin]

Which database Song (sounds like this one) or Singers?

Which version of Hoster?

Have you checked the Import Songs menu > Build Database dialog's "Indexed Folders" list? Some of our Beta testers reported their list was gone (during a Beta version).

[MackieRocks]

Songs database.

V5.05

I don't understand the last question.

[Roy Dennis]

First off did you have your external hard drive attached when you rebuilt the database ? if not then this is why you lost the songs.
Rebuild database with it attached.
If you did have it attached then check the following:

From the "Import Songs" Tab select "Build Database"
In the list of folders window below the Add Folders button, check that all the folders containing your music are listed especially look for the folder that contains these missing files.
If it has gone missing use the Add folder button to replace it, if you find a missing folder it should Add the files to the existing database automatically if on checking it hasn't rebuild the database.

[Roy Dennis]

An alternative thing you can try is to restore the previous database by opening your C:/MTU/Hoster folder, find the songs.mdb and delete it, next find the songs_backup.mdb right click it and select rename, then rename it songs.mdb
This should restore to what you had before your last rebuild point providing you have not rebuilt the database a second time since this problem happened.

[MackieRocks]

I noticed that when I plug my external harddrive to my backup laptop, all the songs are there. Should I copy the songs database (songs.mdb) from my backup machine to my primary? Will that fix my problem? H-E-L-P!!!!

[Roy Dennis]

Originally Posted by MackieRocks

Should I copy the songs database (songs.mdb) from my backup machine to my primary? Will that fix my problem? H-E-L-P!!!!

That will only work if you are using the same hard drive to run Hoster and it has the same drive volume letter when plugged in to each computer.
The other problem with that is unless your index folders list is complete you will have this problem every time you rebuild.

It seems you ask questions but don't properly answer them

1. Did you have the hard drive attached when you first rebuilt the database ?

2. Have you checked the list of folders are all present in the Indexed folders list that is accessed from the Tools/Songs Database/Build Database dialog ?
I attach a sample screen shot of what you should see, as yours are on an external drive your drive letter will not be C:\ as in the screen shot but whatever your external drive is.
If your list is not showing the files you want then use the Add Folders button to brows to the folder, open the folders so you can see all the files there then select.

When you build the database it builds it from the files in this list, if the files are on an external drive then it must be attached throughout this process.

3. Are you having problems getting the folders in the list ?

[MackieRocks]

Sorry about the confusion, Roy. I've got 10 things going on at the same time. Yes. The external harddrive was attached during the rebuild process. I selected all the folders shown in the list. After the build, I double-checked the results by calling up a song from MY singers list and it shows status 'Ready', Dur '0' and no name in the song name field. I also noticed that the songs that are dropping are random numbers. By that I mean a complete CD+G that was loaded and working in the past, now has 1, 2 or sometimes 3 songs missing from the list. I am really confused. Did I fully confuse you?

[Roy Dennis]

Try this first: open your C:/MTU/Hoster folder, find the file singers.mdb, copy it and paste the copy somewhere safe, your desk top will do just as a backup.
Then click the singers button on the main Hoster screen and press the Refresh DB button. Close Hoster, restart Hoster, let us know if it's still the same.

If no different open your edit dialog and enter * wild card in the find box with the karaoke button highlighted, does it fill the results window with all your music files ?

If it does, do both the Title and Artist fields show correct or is one blank or unknown ?
Also check the Book Id of a song and see if it matches the book id in your singers list.

Before you originally rebuilt this database were all the songs on this same 1TB drive or were they on the C:/ drive or a different drive ?

[MackieRocks]

By refreshing the database, the songs that had no link dropped off the singers list. It is random. I lost maybe 2 or 3 songs off a particular CD+G and some songs have re-numbered and now don’t match my books (which I just replaced)! The randomness of it all is what I don’t understand. All of my songs are on a 1Tb external and everything was running smoothly until I indexed 13 songs and re-built the database. It's got to be something I'm doing.chemas-microsoft-com:office:office" />

[Roy Dennis]

You state in your first post "All my KMA files are on a 1Tb external hard drive"
Are you sure there are no kma files in your C:/MTU/KMA files folder or any other folder on your C:/ drive ?

Please check this properly, if you click the windows start button and enter.kma in the search box and see if it finds any on your C:/Drive.

I'm wondering if when you rebuilt the database it mixed files from your C:/drive with files on your external that were duplicates causing it to renumber disc id's.

Also check again in the list of folders in the build database dialog that there are no files listed in the C:/ drive, especially C:/MTU/KMA files.
If it is use the Exclude folders button to remove them then rebuild the database.