I'm starting up a new project and I want to use a mysql system as a save file date base seeing as I heard that's the best choice. How do I set up a mysql database in order for my game to connect to it ?
| |
You can download MySQL at http://www.mysql.com/
You can use Cluster version either Community Server. Once you install it'll be self-explaining. For actual database and tables you could also get MySQL Workbench (GUI Tool). It's GUI editor for databases, table, table data and possibly other things. | |
The above option will only work if you host the MySQL server 24/7 or when the game is active.
Which is unnecessary since you can have a free host do it for you without worrying about installing opening ports no downtime etc... | |
That's true, however accessing external server has a delay (ping), depending on situation it might cause troubles.
| |
I would be inclined to start your development on a local MySQL database, following the route Zaoshi has outlined. The ability to have local table editing, many databases (say one stable database, one you just muck about with, one for a particular feature you're trying out etc) is definitely a big plus while developing.
This is also fine for testing where you are hosting the world, so for example early tests. The MySQL server is local to your world in that case, and no extra ports need opening, just the BYOND world port. When you get to a point where you are releasing your game, you must consider how you're going to provision the servers. If you just let people host their own, then you need to provide them with a guide or something on what they need to do to make MySQL and your game work together, a database SQL to create the tables for example, etc. If you are hosting on some VPS server or BYOND hosting service, then ATHK's comments become relevant, as one of a number of options open to you. But for getting started, Zaoshi probably has the best idea. | |
Thanks guys you've all been a lot of help.
| |
http://www.000webhost.com/free-cpanel-hosting
The website above will allow you to have 2 databases - databases hold tables you can have multiple tables in a database and it is free!
(note you may need a MySQL host that allows remote connections like the above does)
Also allows you to have webspace at the same time, it comes with a package called phpMyAdmin which allows you create/edit/delete your databases very easily.