mhweb
42 contributions
199k contribution views
Recognition
Posts
-
Published Question
How to export/import some data from database table using mysql commands
I'm trying to switch servers for a WordPress site, and I'm starting clean so, I'm only transferring the essential tables to the new db, and the I'm reconfiguring everything again manually. The only issue is that I'm u... -
Published Question
Is it possible to import db tables to mysql 5.7 from msyql 8.0.19?
I'm in the process to transfer a wordpress site to a new droplet which uses an older version of mysql 5.7.23. I want to start with a clean install a database, so only the necessary tables will come to the new database... -
Published Question
How to fix apache high CPU usage on Ubuntu
In the past, I used to managed a WordPress site on DigitalOcean droplet (One-click app) with 2 vCore, 4GB of memory, Ubuntu 16.04, Apache 2.4.18, and mysql community version 5.7.29. Then the website was transferred to...Accepted Answer: Hello, @mhweb What you can do is to monitor the droplet's performance and check from where the CPU usage is coming from. Apache might be consuming more resources if the traffic to your sites is bigger as well. The th... -
Published Question
What's the difference betwee msyql ver 8.0.19 Ubuntu vs mysql community server
I set up a test server on Ubuntu locally at the office, and when I installed mysql and I ran the mysql -V command, I get this result: mysql Ver 8.0.19-0ubuntu0.19.10.3 for Linux on x86_64 ((Ubuntu)) And on the Digita... -
Published Answer
What's the database preparation process to transfer wordpress from mysql 5.7 to 8
@puneetmysql unfortunately, the Mysql_Upgrade command has been deprecated since version 8.0.16. -
Published Question
Does Ubuntu 18.04 come with any security enable by default?
If I create a new droplet using the Ubuntu 18.04, does it come with any security enabled by default? -
Published Question
What's the database preparation process to transfer wordpress from mysql 5.7 to 8
I recently transferred a wordpress site on ubuntu 16.04 with mysql 5.7 to a new droplet using ubuntu 18.04 with mysql 8.0.19, but I simply imported the database from 5.7 to 8.0.19, so my question is if I need to do so... -
Published Question
Can I still get the WordPress One-Click Ubuntu 16.04 with MySQL 5.7?
I'm having problems using the WordPress one-click droplet with Ubuntu 18.04 with MySQL 8.0.29, so I want to create another droplet using the previous Ubuntu 16.04 and mysql 5.7. This is what I was using in the past an... -
Published Question
Can I switch from MySQL to MariaDB for WordPress site without any modifications or conversions?
I'm having so many issues with MySQL 8 on a WordPress site that I'm starting to think on using a different platform. I'm not a super tech savvy user on database, but I read that MariaDB offers better performance out ... -
Published Question
How to secure WordPress server on Ubuntu 18.04 when starting from scratch
I'm planning on spending the time and setting up an Ubuntu server 18.04 for a WordPress website, but I want to make sure the installation is secure as the One-Click WordPress droplet offered by DigitalOcean. So, besid... -
Published Question
How to find out the best MySQL 8 settings should I set in my.cnf
I'm using the WordPress One-Click droplet (https://marketplace.digitalocean.com/apps/wordpress) with 2 cores and 4GB of RAM, and it's running MySQL version 8.0.29, but unlike the previous setup found with Ubuntu 16.04... -
Published Answer
How to configure mysql to prevent processor spikes
I’ll check your suggestions. However, this is what do get: why when setting up the droplet, everything about WordPress, themes, p… -
Published Question
How to configure mysql to prevent processor spikes
I’m running a WordPress site using the one-click DigitalOcean (https://marketplace.digitalocean.com/apps/wordpress) droplet with 2 vCore, 4GB of RAM, 80GB SSD, Ubuntu 18.04, Apache 2.4.29, and mysql community server v... -
Published Answer
Fix mysql high cpu usage on Ubuntu running WordPress
I’ve found this query causing the problem: This is what the show processlist shows in “info” `SELECT SQLCALCFOUNDROWS wppos… -
Published Question
Fix mysql high cpu usage on Ubuntu running WordPress
While doing maintenance to the Ubuntu server running mysql and apache2 using these commands: SELECT tableschema AS “Database”, sum(datalength + indexlength)/1024/1024 AS “size in MB” FROM informationschema.TABLES GROU... -
Published Answer
How long it takes to create droplet from snapshot
It finally finished. -
Published Question
How long it takes to create droplet from snapshot
I created an snapshot of a server, and I'm creating a new droplet with it, but it's been stuck in middle creating the new droplet for about 15mins. Does anyone knows how long it takes to create droplet from snapshot i... -
Published Question
How to set up let's encrypt after moving website to new server
So, I moved a website already using https with Let's Encrypt to a new server, but the new server is not loading the pages because it's https, which isn't setup yet. My questions now is how to set up Let's Encrypt whil... -
Published Question
How to WordPress droplet to another droplet
I have WordPress droplet, and I would like to move it to another newer WordPress droplet. I know I have to create a new droplet (going with marketplace WordPress droplet https://cloud.digitalocean.com/marketplace/5ba1... -
Published Answer
I submit ticket, never heard back
Just to be sure, when you get an email from a technician, you can simply hit the reply button button to respond and submit any othe…