Might be a question for your host provider if you are using turn key hosting. A typical wordpress site usings a single database with multiple tables.
Moderator
James Huff
(@macmanx)
Volunteer Moderator
Ideally, you’ll only need the database that your site is using.
But, to be safe, first make a backup of all three databases: https://wordpress.org/support/article/wordpress-backups/#database-backup-instructions
When that’s done, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel (consult your hosting provider’s documentation for specifics on these), and open the site’s wp-config.php file with a plain text editor.
In that file, the database under DB_NAME is the database you should keep: https://developer.wordpress.org/apis/wp-config-php/#set-database-name
It’s also possible that you have more than one site in the same database, so you might need to refer to the $table_prefix for which database tables belong to the site you’re keeping: https://developer.wordpress.org/apis/wp-config-php/#table-prefix
If you make a mistake, you can always restore the database backups that you made earlier: https://wordpress.org/support/article/restoring-your-database-from-backup/
Thank you @macmanx and @davesjoshin for your replies.
Screenshot of the DB:
https://imgur.com/a/0Vm7Vrq
I asked my host (Hostinger) and support replied only the first one is active the 2 other are old (which surprises me as the first one is the most recent? Idk)
He recommended to keep all 3, even if the 2 other ones are inactive.
Your thoughts?
Moderator
James Huff
(@macmanx)
Volunteer Moderator
Yeah, so I’ll refer to my reply above.
Just keep the database referenced in your wp-config.php file.
Thank you, I followed your instructions and deleted the 2 extra DB.
It seems one of them was for my staging website so I restored it. 🙂
Any recommendation to optimize the Database queries?
I recently had an issue with tons of pending tasks in my Action Scheduler.
They keep piling up, I had 180,000+ Pending Tasks. I identified it was 90% “rocket_preload_job_preload_url”. So I tried a few things in my WP Rocket settings, and will see if it changes anything.
I’m thinking this is the cause of my slow server response time.
Moderator
James Huff
(@macmanx)
Volunteer Moderator
It sounds like the main problem is WP Rocket, but since that is a commercial plugin, we ask that you please go to their official support channel, so you can get support from the people who know it best: https://wp-rocket.me/support/
Forum volunteers do not have access to commercial products, so they would not know why it is not working correctly. Other community members who may have faced your issue might be able to help you, but your best bet is your product’s developer. We encourage you to use the official support venues, as it allows the developers to be aware of issues with their code and gives back to the community in a more robust way.
