Backup issues due to database issues

  • Hello,

    I started the process to backup my WordPress staging site through Duplicator and got a notice. I ran the backup any ways but it would not complete the process. After doing some research, I was not able to figure out the issue so I instead did a backup with Bluehost (my host) and created an account with ManageWP to create a backup with them. Bluehost did not report any trouble although the backup they did included both the current version of the site and the staging version.

    ManageWP was not successful however and I believe that it is because of the same issue. I am new to WordPress and just starting to learn, this is well above my understanding. Please Help!

    ManageWP: “We have detected database tables we believe do not belong to this WordPress install. Do you want to automatically include them in future backups?” 

    ?staging_cK3_actionscheduler_actions

    ?staging_cK3_actionscheduler_claims

    ?staging_cK3_actionscheduler_groups

    ?staging_cK3_actionscheduler_logs

    ?staging_cK3_ce4wp_abandoned_checkout

    ?staging_cK3_ce4wp_contacts

    ?staging_cK3_commentmeta

    ?staging_cK3_comments

    ?staging_cK3_duplicator_packages

    ?staging_cK3_e_events

    ?staging_cK3_e_submissions

    There are a lot of these all starting with staging_cK3_ which I am assuming is referring to the site itself.

    Duplicator: “The notices for tables are 10MB, 100,000 records or names with upper-case characters. Individual tables will not trigger a notice message, but can help narrow down issues if they occur later on.” Followed by a long list similar to what follows.

    cK3_actionscheduler_actions Uppercase: 1 Rows: 9 Size: 128KB

    cK3_actionscheduler_claims Uppercase: 1 Rows:0 Size: 32KB

    cK3_actionscheduler_groups Uppercase:1 Rows:2 Size: 32KB

    cK3_actionscheduler_logs Uppercase: 1 Rows:15 Size: 48KB

    cK3_ce4wp_abandoned_checkout Uppercase:1 Rows:0 Size 32KB

    In each case the title is followed by “Uppercase:1 with a row number and a size.

    I am so sorry if this should be obvious but I am at a loss. Thank you for your help in advance!

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)

  • WordPress saves database tables with an individual prefix in the database. This prefix is stored in the wp-config.php file. Check which prefix is stored there for you. If it is not “staging_cK3_”, then the tables mentioned do not actually belong to your current installation. They may have been created by a plugin you are using that has set up staging, or by a previous WordPress installation that used the same database.

    If the tables really don’t belong to your current project, you can certainly delete them. Make a backup of the whole database beforehand just to be sure.

    Thread Starter tcadi

    (@tcadi)

    Hello @threadi!

    Thank you for the information. I went into the wp-config.php and as far as I can tell the table name is ‘BlF_’ While I am trying to learn as fast as possible I am still very new to this so I may be in the wrong place. Am I in the correct folder?

    If it is a plugin causing the issue how would I determine that?

    Thank you so much for your help! I am sorry for the delayed response yesterday but I am on this all day today and look forward to your next message.

    It would be unusual for a plugin to create its own tables that do not use the same prefix as WordPress, even if it were technically possible. However, the table names you mentioned rather indicate a different WordPress installation, not just a simple plugin.

    I would still recommend proceeding as described above.

    Thread Starter tcadi

    (@tcadi)

    Hello @threadi

    I was able to manually backup the site and am now running into issues deploying the staging site.

    Where would I find the tables to fix/delete them? I have been into the cpannel to find the database names but that is the only time I have used it. I do not want to go in and mess something up by my ignorance.

    Thank you for your help.

    The best way to do this is in your hosting environment, apparently a cpanel interface. If you can already see the table names there, there will certainly also be an option to edit and delete them. If not, contact your hoster’s support team to find out where to do this.

    Thread Starter tcadi

    (@tcadi)

    Thank you, I will look into this.

    Thread Starter tcadi

    (@tcadi)

    Hello,

    I think I have a much better grasp on the problem. I was able to transfer the staging site into production and get a manual backup of the site.

    The Database connected to the site is the one having issues so, of course, I am unable to delete it. My understanding is that something I have done in the process of creating the site has caused the database to capitalize the first line in 100,000 tables? Duplicator provides this information when I try to backup the site through them:

    “The notices for tables are 10MB, 100,000 records or names with upper-case characters”

    I tried using this line in the wp-config.php file: define(‘WP_ALLOW_REPAIR’, true); And then ran a repair which did not do anything.

    Bluehost cannot help me because apparently the database is out of their jurisdiction. Is there something else that I can use to fix the instances above?

    Thank you!

    The message comes from the Duplicator plugin. I would recommend you to contact their support forum: https://www.ads-software.com/support/plugin/duplicator/

    Thread Starter tcadi

    (@tcadi)

    I will try that route. Thank you!

Viewing 9 replies - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.