MySQL or MySQLi ?

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
User avatar
free-rebel
I've been banned!
Posts: 602
Joined: Sun Dec 19, 2010 1:26 am
Location: Slovakia, Bratislava

MySQL or MySQLi ?

Post by free-rebel » Tue Jan 11, 2011 7:01 pm

Hi, what is different between use MySQL and MySQLi ?
What use for joomla 1.6 ?
:pop
I m Rebel ...
Top
realityking
Joomla! Explorer
Joomla! Explorer
Posts: 428
Joined: Fri May 21, 2010 11:43 am
Location: Aachen, Germany
Contact:
Contact realityking

Re: MySQL or MySQLi ?

Post by realityking » Tue Jan 11, 2011 11:34 pm

Both are interfaces for PHP to access a MySQL database. MySQLi is faster and potentially more secure, you should use it when available.
Top
User avatar
free-rebel
I've been banned!
Posts: 602
Joined: Sun Dec 19, 2010 1:26 am
Location: Slovakia, Bratislava

Re: MySQL or MySQLi ?

Post by free-rebel » Tue Jan 11, 2011 11:47 pm

Many thanks :pop
I m Rebel ...
Top
shoulders
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 221
Joined: Fri Oct 10, 2008 9:03 pm
Contact:
Contact shoulders

Re: MySQL or MySQLi ?

Post by shoulders » Wed Jan 12, 2011 8:43 pm

very useful, cheers
Top
macgig
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Fri Oct 08, 2010 4:47 am

Re: MySQL or MySQLi ?

Post by macgig » Wed Aug 10, 2011 2:31 pm

good to know I wondered about this.
Top
waarnemer
Joomla! Hero
Joomla! Hero
Posts: 2954
Joined: Sun May 04, 2008 12:37 pm

Re: MySQL or MySQLi ?

Post by waarnemer » Mon Aug 15, 2011 9:06 am

Thanks I'll opt for SQLi in the future..... but how'bout projects from the past?

If I see the .ini files in the PHP info, can I simply change the databasetype from MySQL to MySQLi in the backend?

Regards,
Top
shadowstep0705
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 197
Joined: Sat Dec 11, 2010 6:57 pm

Re: MySQL or MySQLi ?

Post by shadowstep0705 » Tue Aug 16, 2011 4:50 pm

waarnemer wrote:Thanks I'll opt for SQLi in the future..... but how'bout projects from the past?

If I see the .ini files in the PHP info, can I simply change the databasetype from MySQL to MySQLi in the backend?

Regards,
Go in configuration.php change dbtype from 'mysql' to 'mysqli'


cheers
Top
dunio
Joomla! Apprentice
Joomla! Apprentice
Posts: 39
Joined: Wed Dec 14, 2011 3:59 pm

Re: MySQL or MySQLi ?

Post by dunio » Fri Jan 20, 2012 2:28 am

is it really safe do just change it in global config or configuration.php? It's the same actually!?
Top
Investor1
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Wed Aug 27, 2008 7:19 am

Re: MySQL or MySQLi ?

Post by Investor1 » Thu Feb 16, 2012 7:13 pm

Hi there.

Am setting up a site i got a while ago and getting:
Database Error: Unable to connect to the database:The MySQL adapter "mysqli" is not available.

How can i change the server so it accept this mysqli ?
I have a VPS

Kent
Top
dunio
Joomla! Apprentice
Joomla! Apprentice
Posts: 39
Joined: Wed Dec 14, 2011 3:59 pm

Re: MySQL or MySQLi ?

Post by dunio » Thu Feb 16, 2012 8:13 pm

well... the mysqli driver is not installed, install it or ask yer hosting provider to do it for you
Top
User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:
Contact leolam

Re: MySQL or MySQLi ?

Post by leolam » Fri Feb 17, 2012 5:04 pm

Investor1 wrote: How can i change the server so it accept this mysqli ?
I have a VPSKent
Do you have WHM (cPanel) and/or root access?

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
Top
Investor1
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Wed Aug 27, 2008 7:19 am

Re: MySQL or MySQLi ?

Post by Investor1 » Fri Feb 17, 2012 5:10 pm

Hi.
Yes, but my hosting support fixed it.
but thanks for the reply!

I1
Top
User avatar
erickaps
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 106
Joined: Thu Aug 17, 2006 9:27 am
Location: United Kingdom
Contact:
Contact erickaps

Re: MySQL or MySQLi ?

Post by erickaps » Tue Apr 03, 2012 2:00 pm

This is a good starting point for an expanation of MySQLi

http://en.wikipedia.org/wiki/MySQLi ;)
Top
Locked

Return to “Installation Joomla! 2.5”