LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Networking (https://www.linuxquestions.org/questions/linux-networking-3/)
-   -   Database Problem, File Structure Help (https://www.linuxquestions.org/questions/linux-networking-3/database-problem-file-structure-help-422560/)

Kazul 03-07-2006 01:25 PM

Database Problem, File Structure Help
 
Here's the problem:

My brother and I had a database of music files when we were living in the same house. When I moved out, I copied all the files from the server, locally to my machine.

Now that we've dived into the Linux world, we've decided that we want to "Mirror" each other databases of our music files.

The first major problem we have consists of file structure. Since we've split from our databases, my brother has created a different file structure of his files. Instead of Music/Genre/Artist/files, he has condensed it into Music/A-D/Artist/files, Music/E-I/Artist/files, etc.

On top of this problem is another. We both have added files to our databases which we may or may not share. He has obtained different music from what I may have. So not only do we have differing file structures, but also differing files in some cases.

So we are trying to figure out a way to reorganize my side of the structure to mirror his. Some way to move files around on my database to match the structure he has on his side, and with the files/folders left over that do not have a place to go, drop them into an "Upload" folder or some sort to be pushed across to his side. Then after he has what files I have added to mine, we can push whatever files I'm lacking on his database.

The second problem after this first one is solved is how to continually mirror the databases from this point on.
We've been looking into the Wget application. This is a program that is used to update databases through FTP, HTTP services. You can customize how it updates, and when, etc. We would normally run this during the night off peak hours. That way anytime there was a change in our databases (which are now theatrically mirrored) the change would be uploaded to either end of the required database.

We're trying to set this up so that we can consolidate space, and don't have to individual acquire music on each side of the database.

Any help would be greatly appreciated with this project of ours! Feel free to contact me on the forums, or mail kazul33@gmail.com

-Kazul

acidzebra 03-08-2006 07:38 AM

My two cents: make sure the directories are similar. Seriously, you will keep having many problems if you don't do that. Agree on a common layout and stick to it.

When that is hammered out, look into rsync. that should solve your remaining issues.


All times are GMT -5. The time now is 11:29 PM.