-
Published Question
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...
1
•
•
By
mhweb
MySQL
WordPress
-
Published Question
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...
1
•
•
By
mhweb
MySQL
-
Published Question
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...
3
•
•
By
mhweb
Apache
-
Published Question
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...
1
•
•
By
mhweb
MySQL
-
Published Answer
@puneetmysql unfortunately, the Mysql_Upgrade command has been deprecated since version 8.0.16.
•
By
mhweb
-
Published Question
If I create a new droplet using the Ubuntu 18.04, does it come with any security enabled by default?
1
•
•
By
mhweb
Ubuntu 18.04
-
Published Question
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...
1
•
•
By
mhweb
MySQL
WordPress
-
Published Question
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...
1
•
•
By
mhweb
WordPress
-
Published Question
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 ...
1
•
•
By
mhweb
MySQL
MariaDB
WordPress
-
Published Question
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...
2
•
•
By
mhweb
WordPress
-
Published Question
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...
1
•
•
By
mhweb
MySQL
WordPress
-
Published Answer
I’ll check your suggestions.
However, this is what do get: why when setting up the droplet, everything about WordPress, themes, p…
•
By
mhweb
-
Published Question
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...
2
•
•
By
mhweb
MySQL
WordPress
-
Published Answer
I’ve found this query causing the problem:
This is what the show processlist shows in “info”
`SELECT SQLCALCFOUNDROWS wppos…
•
By
mhweb
-
Published Question
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...
2
•
•
By
mhweb
MySQL
-
Published Answer
It finally finished.
•
By
mhweb
-
Published Question
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...
1
•
•
By
mhweb
Ubuntu 18.04
-
Published Question
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...
1
•
•
By
mhweb
Let's Encrypt
-
Published Question
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...
1
•
•
By
mhweb
WordPress
-
Published Answer
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…
•
By
mhweb