Title: MySQL Error while staging website Last modified: July 25, 2024 --- # MySQL Error while staging website * Resolved [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/) * Hey, * I was creating a staging for my website using Softaculous on cPanel, when I got an error at 95% at the stage of “propagating database” saying the following: - Could not make the query numbered : 0 MySQL Error No : 1146MySQL Error : Table‘**********. FexhIp_blogs’ doesn’t exist * The asterisks being the target table (the table that the staging website is supposed to be using if the staging would’ve succeeded) * When talking to my hosting provider, they had told me to remove some files from a large folder of mine on the server since it was over 500GB. I’ve now reduced the folder to just 20GB but the issue persists. I honestly don’t have an idea what could be the problem, since they told me that creating an empty column in the table wouldn’t help either. * Do you have any ideas? * Thanks, Ron * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmysql-error-while-staging-website%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 8 replies - 1 through 8 (of 8 total) * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17915681) * “FexhIp_blogs” is not a default WP table. Determine which plugin is responsible for it. Try deactivating that plugin and retrying the staging creation. * While creating an empty column a table will not help, creating an empty table with all of its proper columns with the right formats **might** help. Export the table from your current DB using phpMyAdmin. You only need to export one line of data since you’ll be making an empty table. Import the file into the staging DB and delete any imported content, leaving an empty table with all the right columns. * If that doesn’t help, try using a different staging app such as [WP Staging plugin](https://wordpress.org/plugins/wp-staging/), or [manually replicating the site](https://developer.wordpress.org/advanced-administration/upgrade/migrating/#changing-your-domain-name-and-urls). * Thread Starter [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17916205) * Do you know how to understand which plugin is it? * When going on PHPmyadmin, I couldn’t even understand which DB is related to my main webpage… * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17917695) * Sorry, I’m not aware of what plugin might make such a table. Maybe once you find it through phpMyAdmin the structure or content might give you some clues. N.B.— it’s also possible a theme had created the table, not a plugin. It may not even be a theme or plugin you currently use, but did use in the past. * You can learn the correct DB for your site from the site’s wp-config.php file. It’s the value defined as `DB_NAME`. * Fun fact: You can have multiple individual WP sites within the same DB as long as the `$table_prefix` assignment in wp-config.php is unique for every site. The default is “wp_”, but it can be nearly any string of characters. * Thread Starter [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17919126) * So I did find the DB name in the wp-config.php file. * Though interestingly, I didn’t find any “Fexhlp_blogs” table, which is quite interesting to me. * Do you know what could this possibly mean? * Thread Starter [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17919146) * Thing I found after a little looking through the wp-config.php file, is that the table prefix is Fexhlp. If that helps, in anyway… - This reply was modified 1 year, 10 months ago by [rshrayer](https://wordpress.org/support/users/rshrayer/). * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17919961) * Oh! Is this for a multisite installation? If so, that is a standard default table. Doesn’t really change much, it’s still the same problem. Helps with my understanding of the issue though. I’m more convinced there’s an issue with the export/import process you used. Some tools like that are great for single site installations but are not necessarily reliable with multisite. * All I can suggest is what I said in the last paragraph of [my initial reply](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17915681). In essence, use a different tool or method. * Thread Starter [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17919996) * This isn’t a multisite installation. I’m using Softaculous, provided by the hosting provider. * I’ll try using a different tool then, as you suggested in the first paragraph. * Will update. Thanks! * Thread Starter [rshrayer](https://wordpress.org/support/users/rshrayer/) * (@rshrayer) * [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17921952) * Updating – went well! The site is a little slow, but is ok for my production purposes, considering I have some very large files on the website that were copied to the staging website. * Thanks! Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘MySQL Error while staging website’ is closed to new replies. ## Tags * [MySQL](https://wordpress.org/support/topic-tag/mysql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 2 participants * Last reply from: [rshrayer](https://wordpress.org/support/users/rshrayer/) * Last activity: [1 year, 10 months ago](https://wordpress.org/support/topic/mysql-error-while-staging-website/#post-17921952) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics