By farald on

Hello.

I have an installation of drupal completed as a localhost project. When uploading it, I noticed that my host doesnt have Mysqli installed. And, they won't install it either, it seems from communications with support. So, how do I port the database from localhost where mysqli is installed, to the live-site?

Here is what I get when accessing the site:

Site down. (....) The mysqli error was: Unable to use the MySQLi database because the MySQLi extension for PHP is not installed. Check your php.ini to see how you can enable it.

When I edit drupal settings.php from

$db_url = 'mysqli://

to this

$db_url = 'mysql://

I get tons of errors, the site comes up but there are so many errors that I cant even start counting. What should I do?

Thanks in advance for all help:)

⋅ Categories: Drupal 6.x

Comments

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented

Hi

You can try to enable mysqli extension in your php.ini, if your provider lets you to do so, and allows mysqli, or you can try to start from a clean installation with mysql

If you get more errors, then post here (at least the first ones!)

Regards
Pedro

farald’s picture

farald commented

Thanks for reply:)

I have done weeks on weeks of work on the install, so clean install is really not an option.
They wont edit php.ini (shared host).
The obvious option is probably to get myself a new host, unless there is a way to port a mysqli DB back to regular mysql.

Googled and found nothing on the subject, so looking for a new host now.

capmex’s picture

capmex commented

I had the same problem with a site, but with drupal 6.3 I changed $db_url = 'mysqli:// to $db_url = 'mysql:// and it worked without errors.

shunshifu’s picture

shunshifu commented

That worked for me too! Thanks