Support

Hello,


To make it simple, I am not able to create a back up with akeeba for my joomla website.
I suspect that the restrictions are coming from my hosting server.
As they are unhelpful, Iam trying to pinpoint the origin of the problem (See screenshot).

I tried your documentation on https://www.akeebabackup.com/documentation/troubleshooter/abbackup.html?utm_source=akeeba_backup&utm_campaign=backuperrorlink without success.


Thank you in advance
Regards
Mansour

It looks like your host is innocent this time.

Please check that your MySQL database user has the SHOW TABLES permission.

It looks like you are backing up tables from multiple sites. While this may work for the backup, restoring a multi-site backup is a nightmare. If you have multiple sites, you should make a backup for each and exclude the other sites' files and tables from each backup.

Thank you for looking into the issue.

I am kind of novice. Any link to give me how to check that my MySQL database user has the SHOW TABLES permission. Google it but nothing relevant.

I am only allowed to 1 database for my hosting. How come that akeeba, which runs on the backend of my joomla website, will backup other websites. Kind of lost here...


Thank you in advance for your support.

Mansour

The permissions are attached to the database user, not the database itself. If you have multiple users, it could still be a permissions issue even though other sites back up using the same database.

If your host uses the Cpanel web host interface, you need to create the database, then create the database user. That user should have all rights to the database. If you are using the same database user for all your sites, then I'm on the wrong track.

Hi Dale

I have apparently '2 databases:
information_schema utf8_general_ci
Mansour_books utf8_general_ci


The name of my database is 'Mansour_books'.
The prefix is 'books'.
At the line 'books_users'.
I have 1 admin user and 2 other webusers.


Now I checked the other tables within my database for which I dont know the purpose:
at the line 'g3uk5_users', I have 1 other admin user
at the line 'ja8br_users', I have 1 other admin user
at the line 'jos_users', I have 1 other admin user
at the line 'nnwv4_users', I have 1 other admin user
at the line 'oceou_users', I have 1 other admin user
at the line 'owkpy_users', I have 1 other admin user
at the line 'oyv_users', I have 1 other admin user
at the line 'tasnp_users', I have 1 other admin user
at the line 'v35bx_users', I have 1 other admin user
at the line 'xbt4k_users, I have 1 other admin user
My database should contain only parameters preceded by books_? Right?


I scanned myphpmyadmin for my other websites and hosting. I can find the same parameters...

It looks like the mess.


Your support will be highly appreciated

Mansour,

The problem with the backup is not related to a Joomla! user. The problem is in your MySQL setup. The permissions for your MySQL server are associated with a MySQL user. Sometimes the users are set up in the same step as the database, sometimes they are set up separately. This setup is done through your host panel, cPanel, Plex etc. Your database user is missing a permission that it needs, SHOW CREATE TABLE permission (I had the wrong permission in the earlier post).

If you don't know how to modify your MySQL user, your host's support folks should be able to help you with that.

We still need to talk about the multiple sets of tables that you are backing up, but I want to handle one thing at a time.

Thank you for your patience and Support Dale!

The privileges are apparently already set.


Mansour

You found the correct screen, but you do not have the ability to set the needed permission. You will need to contact your host and ask they to do it.

Hi Dale,

I went back to my hosting, here is their reply:
----------------------------------
We have checked and found that you

have all permissions of the databse, the "create temporary tables" permission

is also set. You can perform all the queries on the database you have. Feel

free to get back to us for further queries or assistance.
----------------------------------

I triied to back up the website, no success. Any other suggestion?

Regards
Mansour

Mansour,

The privilege we need is SHOW CREATE TABLE.

That permission is not one that a normal website would use, it is something that a utility program, like a backup, would use. It is not present on your screen to assign MySQL rights to your database user. That permission looks at an existing table and returns the MySQL commands to recreate that table. We save the code that is returned and that code creates the empty table during the restore step.

We must have this privilege, there is no way to work around it.

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.