Title: Database Update
Last modified: October 27, 2025

---

# Database Update

 *  Resolved [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/)
 * Issue with WooCommerce backup. Plugin is version 10.3.3, but the backup is 9.7.1.
   Tried to update manually, but it’s not doing it. Have tried deleting WooCommerce
   and reinstalling but not changing anything. I think it might have something to
   do with the schedule. I have 37 past due, but when I click on them, it times 
   out, so I have no idea what they are. Have installed WP crontrol but that also
   has not helped. Is there a way to knock WooCommerce completely out of the system
   and install a new one? Or any other suggestions appreciated. Been at this for
   two weeks now
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-update-16%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 15 replies - 1 through 15 (of 22 total)

1 [2](https://wordpress.org/support/topic/database-update-16/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/database-update-16/page/2/?output_format=md)

 *  Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/)
 * (@shahzeenfarooq)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18697165)
 * Hi there!
 * Thank you for sharing the details. I understand how frustrating it must be to
   deal with this issue, especially after trying multiple troubleshooting steps.
 * To assist you further, could you please let us know if you received any error
   message when you tried to update the WooCommerce database manually?
 * Also, Go to **WooCommerce → Status → Scheduled Actions**, and look for any “past
   due” or “failed” actions. Try running or deleting them manually if possible. 
   After that please try updating the database manually again by following these
   steps:
    1. Go to your WP database and locate the`wp_wc_admin_notes` table.
    2. Look for any entries related to the database update and check if the status 
       is set to _**Pending**_.
    3. If so, you can manually change the status to **_Actioned_** to see if this resolves
       the issue.
    4. The table structure should look something like this:
    5. ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXc7dXmuXNY-WHOF9XitPm31Nop5DXEGRy_w0c1JU94UV50khm0niDsrCwrWnqXI0tKbOUlaiaN-
       I67nvG0WU211l17g0Ph7q1Su9FteNbi24xdIMcrzzB6BdcKGnPxdC0SIMFThttSemV6ZOOTny1bjGCs?
       key=9gIRttHTrAMtk5eNa-H-Dwl9)
 * Please give this a try, and let me know if it makes a difference.
   If you still
   face the same issue, I’d like to understand your site properly. Please share 
   with us the necessary information below for us to investigate the issue further:
    - **System Status Report** which you can find via WooCommerce > Status
    - **Fatal error logs** (if any) under WooCommerce > Status > Logs.
 * Please use [https://pastebin.com/](https://pastebin.com/) or [https://gist.github.com/](https://gist.github.com/)
   and share a link to that paste in reply here. Once we have more information, 
   we’ll be able to assist you further.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18697368)
 * [https://gist.github.com/davidsgiftsltd/57dd084cdea67fea79a5775cff50fea1](https://gist.github.com/davidsgiftsltd/57dd084cdea67fea79a5775cff50fea1)
 *  [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/)
 * (@mosesmedh)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18697483)
 * Hi [@davidmacnichol](https://wordpress.org/support/users/davidmacnichol/),
 * Thank you for sharing the report. After reviewing it, I noticed that your database
   is not fully up to date, even though your CRON job appears to be active. Could
   you please check with your hosting provider to confirm whether your hosting environment
   supports WP-CLI access?
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698084)
 * Yes supports it
 *  Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/)
 * (@shahzeenfarooq)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698096)
 * Hi there!
   Great! Could you please try updating WooCommerce using the CLI? Here’s
   the command you can use to update WooCommerce via the command line:
 *     ```wp-block-code
       wp wc update
       ```
   
 * For more details on how to use the CLI, you can refer to this guide.[https://wp-cli.org/](https://wp-cli.org/)
 * Alternatively, you can contact your hosting provider and ask them to update the
   WooCommerce database using the CLI. Please let us know if that works for you.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698136)
 * Hi
 * Hosting won’t do it, and that’s beyond my capabilities. I would end up crashing
   the whole site.
 *  [LovingBro (woo-hc)](https://wordpress.org/support/users/lovingbro/)
 * (@lovingbro)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698209)
 * Hi [@davidmacnichol](https://wordpress.org/support/users/davidmacnichol/),
 * I understand how challenging this must feel, especially after trying several 
   steps and wanting to avoid anything that might break your site. Since your hosting
   supports WP-CLI but they can’t run the command for you, there’s still a safe 
   way forward.
 * If you’re not familiar with using the command line, you can access **SSH or Terminal**
   from your hosting control panel (if available) and run the command below:
 * `wp wc update`
 * This command will only trigger WooCommerce’s internal database update process,
   it won’t overwrite or delete any of your data. You can review the WP-CLI documentation
   for more guidance here: [https://wp-cli.org/](https://wp-cli.org/)
 * If that still feels risky, another option is to temporarily enable **WP_DEBUG**
   and check for any database or Action Scheduler errors that appear. Sharing those
   details here will help us pinpoint what’s blocking the update.
 * Once you’ve tried one of these approaches, please let me know how it goes. Let’s
   see how it goes!
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698324)
 * This is what I see when I go into my hosting SSH. No idea where i put the command
   line
 * ![](https://wordpress.org/97f7f223-73d2-40e8-9cc9-f9f5d1040eb3)
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698342)
 * Tried to paste an image of SSH page, but didn’t work.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698390)
 * The SSH page is asking for a key and a handle. How do I get these, as I assume
   this is the first step in getting to the command line
 *  [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/)
 * (@mosesmedh)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698590)
 * Hi [@davidmacnichol](https://wordpress.org/support/users/davidmacnichol/),
 * Thank you for getting back to us and for the clarification. However, I didn’t
   see any image attached. To share images with us, please upload them via **snipboard.
   io** and provide the link.
 * Let’s proceed this way instead. Don’t ask your host to run the code for you. 
   Instead, ask them how you can access WP-CLI on their platform, as the method 
   can vary depending on the hosting provider and the control panel they use.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698652)
 * This is orginal message they sent
 * WP-CLI comes preinstalled with every WordPress hosting package automatically.
 * Before obtaining access to WP-CLI, you will first need to connect to the hosting
   package via SSH.
 * To access this package via SSH, use the hostname and the username, both available
   in your web hosting control panel > SSH Access.
   You must add the public key to
   your SSH page before connecting to our SSH server.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698669)
 * [https://snipboard.io/wAM54T.jpg](https://snipboard.io/wAM54T.jpg)
 *  [LovingBro (woo-hc)](https://wordpress.org/support/users/lovingbro/)
 * (@lovingbro)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698858)
 * Hi [@davidmacnichol](https://wordpress.org/support/users/davidmacnichol/),
 * WP‑CLI is usually preinstalled on most WordPress hosting plans, but you need 
   to connect via SSH to use it. You can log in to your hosting control panel and
   look for the SSH Access section to find your hostname and username, then connect
   using an SSH client and make sure your public key is added. Once connected, you
   can run `wp` commands directly on your server.
 * For more detailed guidance on using WP CLI, including how to configure it and
   run specific commands, please review the following resources: the official WordPress
   documentation at [https://developer.wordpress.org/cli/commands/](https://developer.wordpress.org/cli/commands/),
   the WooCommerce CLI guide at [https://woocommerce.com/document/woocommerce-cli/](https://woocommerce.com/document/woocommerce-cli/),
   this Hosting.com article on using SSH and WP CLI from the command line at [https://kb.hosting.com/docs/how-to-use-ssh-and-wp-cli-from-the-command-line-on-hostingcom-managed-wordpress](https://kb.hosting.com/docs/how-to-use-ssh-and-wp-cli-from-the-command-line-on-hostingcom-managed-wordpress),
   and this Sucuri blog post on connecting to WordPress via SSH using WP CLI at 
   [https://blog.sucuri.net/2023/04/wp-cli-how-to-connect-to-wordpress-via-ssh.html](https://blog.sucuri.net/2023/04/wp-cli-how-to-connect-to-wordpress-via-ssh.html).
   These resources provide step by step instructions so you can work through tasks
   using WP CLI such as the database update task.
 * Let me know if you have any further questions and I’ll be happy to assist.
 *  Thread Starter [davidmacnichol](https://wordpress.org/support/users/davidmacnichol/)
 * (@davidmacnichol)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/database-update-16/#post-18698912)
 * Was working until i got to
    1. After the key pair is generated, to view and copy your **public key** type the
       following command:`more .ssh/id_rsa.pub `You will need the public key in the
       next procedure.
 * This is what i got
 * C:\Users\Owner>more .ssh/id_rsa.pub
   Invalid parameter – /id_rsa.pub
 * Suggestions?

Viewing 15 replies - 1 through 15 (of 22 total)

1 [2](https://wordpress.org/support/topic/database-update-16/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/database-update-16/page/2/?output_format=md)

The topic ‘Database Update’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 22 replies
 * 5 participants
 * Last reply from: [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/)
 * Last activity: [7 months, 1 week ago](https://wordpress.org/support/topic/database-update-16/page/2/#post-18706834)
 * Status: resolved