Akeeba Backup for Joomla!

Monday, 29 June 2015 10:37 CDT

NicoFaaij

See attached files.

Dear support,

Description of my issue:
Angie DB restore gives error "SQL=", see attached screen-print

I have backuped and restore these and other websites a lot. Never got a problem like this. do you have any clue?

With kind regards and thanks in advance,
Nic

Monday, 29 June 2015 11:03 CDT

nicholas

Are you by any chance using a database table prefix with uppercase letters such as "GC_" or "Gc_" or "gC_"? If so, please try using one in lowercase. Uppercase letters in table names (including the prefix) don't play well on Linux servers and generally any database server on a case-sensitive filesystem.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 29 June 2015 11:06 CDT

NicoFaaij

I saw that topic when I was searching for a solution myself. But no, my prefix is the good old joomla standard j6uyg_

Monday, 29 June 2015 11:18 CDT

nicholas

Please install the latest dev release from https://www.akeebabackup.com/download/developer-releases/akeebapro.html (the latest release is at the top of the page) and take a new backup. Then try restoring it. Do you get a different error? If so, what is it exactly?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 29 June 2015 12:05 CDT

NicoFaaij

Now I get the error: SQL=CREATE DATABASE `stophers_TST_123test_007` CHARACTER SET `utf8`

Monday, 29 June 2015 12:28 CDT

nicholas

OK, now we're up to something good. You have not given the restoration script the correct connection details to your database. Therefore it tries to create it afresh which is of course impossible on a commercial host (you can only create databases through cPanel). You just need to enter the correct database connection details before clicking the Next button in the database restoration page.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 29 June 2015 12:29 CDT

nicholas

I just noticed something else. Your database has uppercase letters. Even if you DID create it and give the correct connection information it will still not work because of what I said in my first reply. Try naming your database something like stophers_test007 instead.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 29 June 2015 12:43 CDT

NicoFaaij

Hi Nicholas,

I think uppercase in database name is not the issue as I get these on a new database:

SQL=CREATE DATABASE `stophers_tst_123test_008` CHARACTER SET `utf8`

Beside that I have always used this naming convention. But all right maybe your software or my service provider has changed something that affect Uppercase. I have checked but I am still on a Linux server.

I am pretty sure that I put in the right database values as I had already checked that with wrong credentials, which gave me errors like:

Unable to connect to the Database: Could not connect to MySQL

.

I will now contact my hosting-provider and keep you posted.

Regards, Nico

Monday, 29 June 2015 13:11 CDT

nicholas

Have you tried changing the database type to "MySQLi" or "MySQL (PDO)"?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 29 June 2015 13:45 CDT

NicoFaaij

There was a disk space issue. But now I have recreated a backup and restore environment completly and stil it gives the same error

When I change to PDO I get the message:
Could not connect to MySQL via PDO: SQLSTATE[42000] [1044] Access denied for user 'stophers_TSTv123'@'localhost' to database 'stophers_tst_123test_009'

So I changed my password to be sure that it is correct but that doesn't help and still I get another message if that is wrong.

So somewhere it looks like he cannot find the database. If I change that database name in a non existing name I also get the same error message. But together with my hosting provider we cannot find what is wrong on that database name call.

Monday, 29 June 2015 13:52 CDT

NicoFaaij

Hi Nicholas,

Pfff, case closed. User didn't got the right privileges :-( Giving the user all database privileges soved the case.

Thank you very much for all your help.

With kind regards,
Nico

Monday, 29 June 2015 16:02 CDT

nicholas

You're welcome! I'm glad it's resolved now :)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support