Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of
MySQL
MySQL with MySQLi
PrestigeSQL

I have choosed MySQL now but i am willing to reinstall.

xxxx-jozh-xxxx

I guess that to access your databases phpbb3 uses for your MySql databases prior to ver 4.1.0 the MySql extension and for your MySql databases from ver. 4.1 -exactly with ver. 4.1.3- and above the MySqli php extension. This last one is an improved extension that allows to access all of the functionality provided by MySQL 4.1 and above. Also with this extension you can develop your php code to work with your databases in a procedural or an object oriented style.

For more information visit the following pages at the php website:

• PHP MySql Extension
• PHP MySqli Extension

Regarding the PrestigeSQL, well only to say that it is the first time i hear about it.

Best regards,

Maybe the OP means Postgre SQL or what ever it is in the cPanel.

I can't even remember the exact name but it is something like that (I think it has some elephant/mammoth icon or some such).

If it's icon is an elephant/mammoth as you say, well, in this case you are correct it is refering to a PostgreSQL database, if not, as i say in my previous post, i don't know anything about it.

Best regards,

MySQL is a good choice.
Simply, the menu you have seen states that PHPBB3 has detected three possible database systems effectively installed on your host. However, remember that you have to create a database and a database user before starting up your installation. For instance, if you choose to create a PostgreSQL database, you choose postre in the database type.
Because you seem more familiar with standard MySQL, simply choose MySQL the next time you install your database.
And, of course, perform a backup before destroying your current forum ; so, if you happen to change your mind, you will be able to restore your data and bring your old forum up again.
Regards
Yordan

Your phpBB3 installation want to know what PHP functions to use for your installation. This is puzzling since most systems that can use a variety of SQL functions have the ability to choose the correct set automatically!

For example, Joomla checks the version of PHP installed and if the mysqli functions are included, then that is what it uses since those are the better choice. If you have a server with PHP 5, then by default, the mysql functions are not supported and only the mysqli functions will work. Most hosts turn the mysql functions on to avoid problems with older script installations that are only able to use the older functions.

The only reason that the installer asks is because different versions of SQL software use different PHP functions and it needs to know which functions to use. For AstaHost, you can use mysql and mysqli for any MySQL database you setup!

Again, the program really should just check and use the proper functions automatically but then again, when did phpBB do what makes sense.

To explain, Postgre SQL, is just the name of the SQL software you could use like MySQL or MS-SQL. That's right Microsoft has their on SQL version as well...
The MS-SQL version isn't as popular as the other two mostly because Windows servers aren't quite as popular. MySQL is most popular since is is most easily supported by PHP. Since PHP is such a popular choice for web development, MySQL benefits from that relationship.

vujsa

Personnally, I like the way PHPBB3's installer works. It looks what is available, and then suggests you what it thinks is better, but lets you choose something different. This allows me to use phpbb3 with an Oracle database, just for fun.