Hijacking this thread: Any tutorial on how to do this on Linux with SSH? More specifically Debian 5.0 x64.
What you're looking for is LAMP. Google "LAMP ssh install tutorial debian" and you should find a number of resources. One nice thing with Debian is you can choose to install the LAMP packages during the installation process. I assume, however, since you're using ssh, that you don't have direct access to installing the OS.
Well, for the longest time, I've been trying to set up a way for my admins to access the files directly instead of asking me to change it. I'm not sure, but people kept telling me the way to do it was through MySQL, which I have limited knowledge in(knowing it's name). If this isn't a good route to go, could you point me in a better one? I'm just trying to improve the server.
Another problem is a lot of newer bukkit mods are leaning towards MySQL and SQlite or w/e it is. Some of us don't feel like paying an arm and a leg to have someone set it up. Its forcing us to use this although some of you say the flatfile is good enough, which its not. If I didn't have to use MySQL I wouldn't but I would like to keep my options open on what mods I can add.
Well this topic is getting surprising amounts of responses. Anyhow, what is the difference between SQLLite And MySQL?
SQLite is like flatfile. If SQLite would would be used for a whitelist, it has to go through all those names in the list. MySQL will search the name from database quicker and so on.
No, I've spent more time on Google looking it up so far than here. This is fine as a second option and all, but don't just assume someone didn't already search google.
Well this topic is getting surprising amounts of responses. Anyhow, what is the difference between SQLLite And MySQL?
SQLite is like flatfile. If SQLite would would be used for a whitelist, it has to go through all those names in the list. MySQL will search the name from database quicker and so on.
MySQL is also more organized?
That is not quite correct. Both are relational databases, both use Structured Query Language to retrieve and update data, and both perform well for their intended purpose.
The difference is that SQLite directly reads from a local database file, where MySQL is a separate program that can be accessed over the network. SQLite does NOT use a "flat file" format. It uses indexes and tables just like MySQL does. The only difference is that you don't access SQLite over the network.
SQLite is certainly NOT a flat file format. A flat file would be something like a CSV file, where the data isn't indexed, and you can't go to a specific record or store different types of data in the same file.
SQLite does include indexes, and it is relational, so you really get all the same basic features as a real SQL server. The only difference is that you're not going to see advanced locking and multi-threading logic. That's where having a networked DBMS helps performance: a network DBMS can handle multiple writes at once, and it's capable of locking records while writing, so one user's changes don't mess up another user.
You'll also find SQLite in the iPhone (it's used for all app data storage) and Android (it's one of the options for storing data. The other is to directly read and write to disk.)
I would not recommend WAMP if WAN access is intended. If you need help with setting it up, once you've installed it, just post here. It can take 5 minutes to install (once you're use to the process, of course), another 5 setting up the account, access rights and database. Just make sure it listens on localhost only when you're finalizing the install. Create a complicated password for the root account, first thing when you fire it up.
So I take it that SQLite is like a simple version of MySQL? And are all things that work with MySQL compatible with SQLite?
FFS... this is why you need to do your own research...
You say you used google, but maybe you just don't have the capacity to learn new information?
To answer your questions..
NO and NO....
No, I've spent more time on Google looking it up so far than here. This is fine as a second option and all, but don't just assume someone didn't already search google.
Ok, for a first timer that I am, can you give me a SUGGESTION(<---Something that CAN'T be looked up)on which is better for someone like me which is someone new and without skill?
Ok, for a first timer that I am, can you give me a SUGGESTION(<---Something that CAN'T be looked up)on which is better for someone like me which is someone new and without skill?
the solution is bypass databases entirely. the only benefit for minecraft is that it's slightly easier for different things to access the data at the same time e.g. you could have minecraft read the data and also have a web interface that lets you change/view things. But that would require you to write the web interface :wink.gif:
if you're dealing with a plugin that MUST use a database, sqlite is easier from your point of view - it's just means the plugin is storing its data in a random binary file, instead of a random text file. Mysql, on the other hand, would involve you administering the mysql server, keeping it updated etc.
Thank you, finally one of my questions has been answered well. SQLite, is it a download? Or web based?
Ok, for a first timer that I am, can you give me a SUGGESTION(<---Something that CAN'T be looked up)on which is better for someone like me which is someone new and without skill?
the solution is bypass databases entirely. the only benefit for minecraft is that it's slightly easier for different things to access the data at the same time e.g. you could have minecraft read the data and also have a web interface that lets you change/view things. But that would require you to write the web interface :wink.gif:
if you're dealing with a plugin that MUST use a database, sqlite is easier from your point of view - it's just means the plugin is storing its data in a random binary file, instead of a random text file. Mysql, on the other hand, would involve you administering the mysql server, keeping it updated etc.
What you're looking for is LAMP. Google "LAMP ssh install tutorial debian" and you should find a number of resources. One nice thing with Debian is you can choose to install the LAMP packages during the installation process. I assume, however, since you're using ssh, that you don't have direct access to installing the OS.
AngelCraft 64 Texture Pack v2.0.2 (Beta 1.8.1)
Nerd, geek, server admin, guy wearing a rainbow skin (with an office suit of epicness)? That's me.
Google is your friend.. :smile.gif:
http://www.google.com/#sclient=psy&hl=e ... debian+5.0
w: minecraft.cm | e: [email protected] | t: @minecraft_cm | reviews
http://lmgtfy.com/?q=what+is+the+differ ... +And+MySQL
Lulz
SQLite is like flatfile. If SQLite would would be used for a whitelist, it has to go through all those names in the list. MySQL will search the name from database quicker and so on.
MySQL is also more organized?
AngelCraft 64 Texture Pack v2.0.2 (Beta 1.8.1)
Nerd, geek, server admin, guy wearing a rainbow skin (with an office suit of epicness)? That's me.
FFS... this is why you need to do your own research...
You say you used google, but maybe you just don't have the capacity to learn new information?
To answer your questions..
NO and NO....
Lulz
That is not quite correct. Both are relational databases, both use Structured Query Language to retrieve and update data, and both perform well for their intended purpose.
The difference is that SQLite directly reads from a local database file, where MySQL is a separate program that can be accessed over the network. SQLite does NOT use a "flat file" format. It uses indexes and tables just like MySQL does. The only difference is that you don't access SQLite over the network.
SQLite is certainly NOT a flat file format. A flat file would be something like a CSV file, where the data isn't indexed, and you can't go to a specific record or store different types of data in the same file.
SQLite does include indexes, and it is relational, so you really get all the same basic features as a real SQL server. The only difference is that you're not going to see advanced locking and multi-threading logic. That's where having a networked DBMS helps performance: a network DBMS can handle multiple writes at once, and it's capable of locking records while writing, so one user's changes don't mess up another user.
You'll also find SQLite in the iPhone (it's used for all app data storage) and Android (it's one of the options for storing data. The other is to directly read and write to disk.)
http://dev.mysql.com/doc/refman/5.1/en/installing.html
I would not recommend WAMP if WAN access is intended. If you need help with setting it up, once you've installed it, just post here. It can take 5 minutes to install (once you're use to the process, of course), another 5 setting up the account, access rights and database. Just make sure it listens on localhost only when you're finalizing the install. Create a complicated password for the root account, first thing when you fire it up.
The installer is very straightforward.
Thank you, finally one of my questions has been answered well. SQLite, is it a download? Or web based?
MySQL is fairly easy to maintain.