Ok, I'm in the process of trying to put everything into mySQL. As I find my way through the process (good tutorials, etc...) I thought I'd document it here so that others may benefit and so I can find it again when something catastrophic happens and I have to start from scratch again, LOL.
Please understand, I’m a total novice, no real idea of what I’m doing. My only goal is to get certain features running on our server that require SQL, instead of flat files. AND I understand that using SQL instead of flat files makes the server much quicker!
So, first off, installation: http://www.howtoforge.com/ubuntu_lamp_for_newbies
Super well written, easyish to follow. Didn’t know what the hell I was doing, but heck, except for a few hiccups, it worked :wink.gif: (typo caused)
Use cont>F to find the lines of text to edit :wink.gif:
Unfortunately, the tutorial writer left out one more step, as explained in this forum post: http://ubuntuforums.org/showthread.php?t=1245522
Once that is finished, you can open your browser, point it to http://localhost/phpmyadmin and you should have a user interface.
Next, follow this youtube tutorial:
Unfortunately, this is where I’m having a hiccup, as I get an error when importing update2.sql…. but I have a ? out on this, it could be I forgot a setting somewhere… but in the meantime, maybe, with this guide to guides, more people will endeavor to try SQL :wink.gif:
Ok, I'm adding on to report what I've done since I last posted. Basically, I discovered that in some cases, it was easiest for me to just manually put in my information, such as group info and user info (as we are only 6 people)
But the warps! OMG! we already have 98 warps! So what to do? I tried importing using the phpmyadmin interface, but nothing worked right. Then I think I came across somewhere where someone said to import from a spreadsheet. Ok, so ... well, I opened up the open office spreadsheet and found that I could import a flat file, I could choose how the info was delineated "other" and insert ":" (forgot their word for it) and voilà, everything came out perfectly. All I had to do was add a row to the top and insert the column names "id", "name", x, y, z, Xrot, Yrot, whatever... (forgot)
Now I had a format I could import into phpmyadmin! In fact, it recognized that it was a spreadsheet even. It gave me the choice to set the first row as the column titles, and when I tried importing the information into the “warps” table, it instead it created a new table. Ok, so I couldn’t figure out how to import it or combine them, so what I did, I compared the structure of the warps table with the structure of the imported spreadsheet, adjusted / edited the new table to be exactly like the warps table, including, at the end, making a primary index (at the bottom of the page) To understand exactly how this looks, select edit in the warps table to see exactly how things are set, and match what you see there with what you have in the new table. Finally, you can rename the warps file, warps_old, and rename the new table, warps.
It takes a little playing with, but you’ll get it if you’re not afraid to poke around a bit. I know this wasn’t really a tutorial, but I hope it gives you an idea what to do. I’ll try to answer questions to the best of my novice abilities
Notes: I don’t think the NPC’s plugin or LWC plugin work in SQL, but I did import iConomy into the SQL Database. I’m having a lot of fun learning how all this goes together, hope some more of you will try it too. Just don’t forget to backup your old server first!
Have you done any profiling to see if the area of the game you are optimizing with SQL is actually a slow portion of the game? This guy has done some of this work and he has shown that a database system actually speeds loading a saving of chunk data quite a bit. You might want to focus your efforts in that area instead of small configuration type files you are current working with.
Oh, wow.... here we go again! LOL, thanks for that insight! But will this work with hmod I wonder, as I'm really liking these plugins...? Will read up more, but I'm about to go to bed, LOL. Tomorrow.....
I wanted to note, that I did port my server to bukkit, and the MineCabinet seems to be working well in it! So I was wrong as he wrote to integrate the files into minecraft.jar not minecraft_server.jar. At least for loading the server, it's super fast, I haven't run around the world or warpped places yet as I'm still having trouble with some pluggins and haven't had a chance.
I do want to ask again if anyone could tell me how to find the correct address for mysql? The server still can't hook up to it and I'm at my wits end :sad.gif:
Please understand, I’m a total novice, no real idea of what I’m doing. My only goal is to get certain features running on our server that require SQL, instead of flat files. AND I understand that using SQL instead of flat files makes the server much quicker!
So, first off, installation:
http://www.howtoforge.com/ubuntu_lamp_for_newbies
Super well written, easyish to follow. Didn’t know what the hell I was doing, but heck, except for a few hiccups, it worked :wink.gif: (typo caused)
Use cont>F to find the lines of text to edit :wink.gif:
Unfortunately, the tutorial writer left out one more step, as explained in this forum post:
http://ubuntuforums.org/showthread.php?t=1245522
Once that is finished, you can open your browser, point it to http://localhost/phpmyadmin and you should have a user interface.
Next, follow this youtube tutorial:
Unfortunately, this is where I’m having a hiccup, as I get an error when importing update2.sql…. but I have a ? out on this, it could be I forgot a setting somewhere… but in the meantime, maybe, with this guide to guides, more people will endeavor to try SQL :wink.gif:
But the warps! OMG! we already have 98 warps! So what to do? I tried importing using the phpmyadmin interface, but nothing worked right. Then I think I came across somewhere where someone said to import from a spreadsheet. Ok, so ... well, I opened up the open office spreadsheet and found that I could import a flat file, I could choose how the info was delineated "other" and insert ":" (forgot their word for it) and voilà, everything came out perfectly. All I had to do was add a row to the top and insert the column names "id", "name", x, y, z, Xrot, Yrot, whatever... (forgot)
Now I had a format I could import into phpmyadmin! In fact, it recognized that it was a spreadsheet even. It gave me the choice to set the first row as the column titles, and when I tried importing the information into the “warps” table, it instead it created a new table. Ok, so I couldn’t figure out how to import it or combine them, so what I did, I compared the structure of the warps table with the structure of the imported spreadsheet, adjusted / edited the new table to be exactly like the warps table, including, at the end, making a primary index (at the bottom of the page) To understand exactly how this looks, select edit in the warps table to see exactly how things are set, and match what you see there with what you have in the new table. Finally, you can rename the warps file, warps_old, and rename the new table, warps.
It takes a little playing with, but you’ll get it if you’re not afraid to poke around a bit. I know this wasn’t really a tutorial, but I hope it gives you an idea what to do. I’ll try to answer questions to the best of my novice abilities
Notes: I don’t think the NPC’s plugin or LWC plugin work in SQL, but I did import iConomy into the SQL Database. I’m having a lot of fun learning how all this goes together, hope some more of you will try it too. Just don’t forget to backup your old server first!
I do want to ask again if anyone could tell me how to find the correct address for mysql? The server still can't hook up to it and I'm at my wits end :sad.gif:
Thanks!!!