Mysql... and its limits?

[truefusion 3]

I haven't been able to try out any mysql databases, but is more than one really required? I'm looking at most hosts and most offer unlimited mysql databases. Shouldn't one database be enough? I would guess one can hold several kinds of information in sub-databases, maybe?

[bjrn 0]

You can manage with just one, and just make sure all your tables have different names. You could for example add a few characters in front of each table name to show which "group" it belongs to. So you might have dev_table1dev_table2forum_table1forum_table2 and so onIn fact phpBB by default prefixes all its tables with a few characters so it doesn't clash with any existsing tables you may have.Something that _is_ important is the amount of space you get for your database(s). Some hosts have space for the databases independent from the rest of your hosting space. Make you that you have enough space for storage.Other than that, multiple databses is a convenience, and a bit of a security measure (both with regards to password and so on, but also data-corruption). But as I said, you will probably manage with just one.

[htmlmaster 0]

II would go with five, better safe than sorry. It really depends on the type of website you run. If you run an extremely dynamic website with submission forms, user log-ins, and other stuff that requires a MySQL database, then shoot for unlimited. Otherwise if your website is more static go for about 5, just in case you decide you want to use them.

[Dominic 0]

I would go with five, better safe than sorry.

I agree, If someone is using over 50 MySQL databases at a time, the server will go REALLY slow.

[sader 0]

I agree, If someone is using over 50 MySQL databases at a time, the server will go REALLY slow.

166011[/snapback]

Are you want to say Dominic that is much better use one database

with many tables instead many databases

I realy want to know that

[Nileshpatel 0]

HelloWehosting server is not simple server its handle more than 500 site at a time soi thing for webserver its not issue for fast/slow.But if you are use use diffrent database rather that table than it will take more time compare to one database.

[arboc7 0]

One database would be the fastest and likely the most efficient. But it's all up to you. There are some professionals out there who are database consultants, so that should give you an idea of how complex the issue could be. It's really up to you...Good Luck!

[sonorama 0]

I guess I'd use more than one... I just read something about tables and it said that tables can make unstable a site or a whole database.So, i think i will keep using my 3 MySQL and that should be enough for me :PCheers!!

[Saint_Michael 3]

so wait your telling me with-in the one mySQL table you could run everything would that mean you would have to do all the editing in myphpadmin or could you do that in cpanel?

[DreamCore 0]

I dont think peapole shuld use over 15 databases so I would add the limit to 15 databases beacuse may be some beginners dont know how to add tables.So thats my tought....

[galexcd 0]

How would you go about setting up these tables?

[michaelper22 0]

You can use phpMyAdmin, an open source tool that you can acces from cPanel. I use it occasionally, and find it easy to use.