Back-up contains “empty” database sql

  • Resolved Harm10

    (@harm10)


    4 years, 10 months ago

    Hi! I am testing XCloner as it came recommended……… ??
    When I create a back-up on a “normal” WP site all files are correctly in the tar files.
    The database-backup.sql file however does not contain any table definition.

    The back-up dialog shows this
    Found 0 tables in 1 databases (0 records)
    (which is weird)

    When I use the whole back-up for a remote restore thinks work properly but the WP tables are not set/filled properly (probably due to the “empty” file?).

    What am I doing wrong? I can supply you the log or extract of it if you point me to the part where tables are handled.

Viewing 15 replies - 1 through 15 (of 21 total)
  • Thread Starter Harm10

    (@harm10)

    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”?

    Plugin Support jimiero

    (@jimiero)

    Hello,

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

    Thread Starter Harm10

    (@harm10)

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

    Plugin Support jimiero

    (@jimiero)

    Hello,

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

    Thread Starter Harm10

    (@harm10)

    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?

    Thread Starter Harm10

    (@harm10)

    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?

    Plugin Support jimiero

    (@jimiero)

    Hello,

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

    Thread Starter Harm10

    (@harm10)

    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)?

    Plugin Support jimiero

    (@jimiero)

    Hello,

    You can send the printscreen to [email protected]

    Regards

    Thread Starter Harm10

    (@harm10)

    Screen print has been send.

    Plugin Support jimiero

    (@jimiero)

    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?

    Thread Starter Harm10

    (@harm10)

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

    Plugin Support jimiero

    (@jimiero)

    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?

    Thread Starter Harm10

    (@harm10)

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

    Plugin Support jimiero

    (@jimiero)

    Hello,

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

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘Back-up contains “empty” database sql’ is closed to new replies.