Back-up contains “empty” database sql

I looked in my log and saw a lot of messages like this:
Access denied; you need (at least one of) the PROCESS privilege(s) for this operation bij query SELECT count(*) FROM information_schema.XTRADB_RSEG gemaakt door do_action(‘wp_ajax_get_database_tables_action’), WP_Hook->do_action, WP_Hook->apply_filters, Xcloner_Api->get_database_tables_action, Xcloner_Database->list_tables

They all concern information schema.
Maybe this is the reason the sql turns out “empty”?

Hello,

Have you checked maybe if your WordPress db user has the right privileges over your website database?

How do I check this? This user was created when the database was created.

Hello,

Login on your hosting cpanel, and there go to your database manager and check that db user account permissions over the database.

I have DirectAdmin and phpMyAdmin.

I repeated the backup generation without looking at the Information Schema which is in the Database selection as unselected (the other 102 tables are selected) and still the sql only contains a header and no table definitions whatsoever.
The log entries are not there after generation so I think those are unrelated?
(Earlier I opened the Information Schema part in the selection)

Is there something else I can check?
Or can I generate the necessary sql from phpMyAdmin?

I have found where the privileges are set and the user of the database has all rights except Grant to the tables within the database.
Having set this I see that the Information Schema is one level higher than the database.
As I do not select it to be in the back-up this cannot be the reason that the sql is “empty”?
Can I look for some log entry or switch on more logging to identify this problem?

Hello,

Can you show a printscreen with the settings you have in Site Backup > Settings > “Mysql options” tab?

Sure…
But how do I add this here?

Looking at the values I see that the Mysql Username is wrong?
The sql username and databasename should be the same but they aren’t?
I cannot change the value? Where is it coming from?
Should this be the mySQLadmin user of the database user (those are different)?

Hello,

You can send the printscreen to [email protected]

Regards

Screen print has been send.

Hello,

Those settings seems oky, can you also send us your Xcloner logs to the same email address, and also a print with the options you have selected on “Database” tab when you run a backup?

I mailed the screen print, log file and sql file.

Hello,

Can you please let me know if you can see the db table fields, when you click on the white arrow next to the db table name you selected to backup?

Send you a new screen print showing that all tables are selected.

Hello,

Haven’t received any printscreen with the info I’ve asked.