How to make WordPress more stable

Due to the rate limiting policy, using WordPress on the free plan has become a hassle.
But what if we could change all of that? Would it be possible to bypass 000webhost’s database limits?
I see you got excited, but that’s sadly not possible.

What we’ll be doing instead is using something called “Remote SQL”. So what this does is move your database outside of 000webhost, while keeping your files and subdomain hosted here.

Without further ado, let’s get started! (applies to users having a new/existing WordPress website)

1 - Exporting the database

Login to the 000webhost cPanel, navigate to Manage Website, then Tools, Database Manager, and go to the PHPMyAdmin page.
I hope you’re still with us!
After you’re there, click on the database, then hit Export
image

Scroll down, then hit Go
image

This will download a backup of your existing database
image

Quick tip: Disable your website for a couple of minutes so no changes are made to the 000webhost database.

To do so, login to the file manager and create a file called maintenance.php and write any maintenance message you want your users to see inside of it.
Next, open the .htaccess file and add the following line of code into it (remove it once you’re done with this tutorial)

DirectoryIndex maintenance.php

2 - Uploading the database

Find the Remote MySQL provider of your choice. For the sake of this tutorial, we’ll be using RemoteMySQL.
Signup and verify your email.
Once that’s done, go to Databases
image

Hit on Create new database
image

Here you go! The database has been created (and the credentials will be displayed in a box). Keep the credentials with you as we’ll be using them later on.

Now hit Action, then PHPMyAdmin
image

Login using the credentials you’ve been given
image

Hit on Import
image

Drag and drop the MySQL file you downloaded earlier
image

Success! Your database has been uploaded.

3 - Linking your website to the new database

Back to the 000webhost cPanel, go to Tools, then File Manager and hit on Upload files
image

Navigate to public_html then scroll down and double click on wp-config.php
image

Replace the database credentials (and host) by the ones provided by the Remote MySQL service
image

Hit Save and close
Awesome! You’ve linked your 000webhost WordPress website to the remote database!

4 - Testing

Now, time to test if it works!
Visit your website and see for yourself!
image

Happy webmastering,
Team 000webhost


Note: This can be used for other non-WordPress projects too.

1 Like