Menu

Menu

Our Blog

The latest post from us

Dropping tables

Deleting or dropping a table can be necessary if you want to import a backup file and need to make space. In other cases deleted plugins sometimes leave tables in your database that are no longer used. However, you need to be sure you know what you are doing before dropping a table as this can potentially break your entire site!

If you are, here is how to do it:

  1. In your database, mark the table or tables you want to delete via check box on the left.
  2. In the drop-down menu at the bottom, choose “drop”.
  3. You will then be taken to a confirmation screen. If you choose “yes”, the table will be delete irreversibly.

Dropping An Entire Database

You can not only drop tables one by one, but you can also get rid of a database all at once. A case where that might be neccessary is when you have moved your site to another server and no longer need the database. Of course, only drop it if you have successfully exported and imported the database to its new location.

  1. Click on “Databases” to view all databases in your account.
  2. Mark the checkbox of the database you no longer need. Double check that the tick mark is in the right place!
  3. At the bottom of the list, click on “Drop”. A confirmation prompt will pop up. If you press “ok”, the database in question will be history.

Copying Your Database

Making a copy of your database is a good idea if you are setting up a development environment to test out themes and plugins before introducing them to your live site. It’s done quickly within phpMyAdmin by choosing your database and going to “Operations” > “Copy database to:”.

Replacing The Table Prefix

For security’s sake,it is a good idea to use a different table prefix for your WordPress install than the default “wp_”. However, if you have forgotten to change this during the install, phpMyAdmin can help you remedy the situation by replacing “wp_” with something else via the bottom menu. Just make sure you also update wp-config.php to reflect the change.

In Short: phpMyAdmin, The WordPress User’s Best Friend.

 

LEAVE YOUR COMMENTS

Optimizing your WordPress Database in phpMyadmin

After using WordPress for a while your database becomes fragmented. Because  over time memory overheads which increases your overall database size and query execution time. You can see it in the right column when looking at your database. Optimizing Database

Optimization means clearing up this data and should be done regularly. Optimizing your database with phpMyadmin is really easy:

  • Access the database you want to optimize. Click on the “check all” box at the bottom of the screen to mark all tables within that database.
  • Use the drop-down menu on the right to select “Optimize table”.
  • Depending on your version of phpMyadmin you might have to click on “Go” to start the optimization process.
    Done! This will optimize your WordPress tables by defragmenting tables. It will make your WordPress queries run a little faster and slightly reduce the size of your database.

CHECKING AND REPAIRING TABLES

Sometimes tables will crash. It’s not pretty and might result in all of your posts or drafts disappearing or cause some other kind of mayhem. However, oftentimes phpMyadmin can repair the table and everything will go back to normal.

If something is amiss on your website, you might first to check if any of the tables in your database is at fault:

  1. Open the database in question.
  2. Select all tables by clicking on “check all” at the bottom of the screen.
  3. Use the drop-down menu to choose “check table”. You might also have to click the “Go” button at the bottom to start the process.
    phpMyAdmin will show a page with the results. In the right column you will be able to see if your tables are deemed OK or not.Should any of theme exhibit a problem, repairing it is just as easy as optimizing:
  4. Mark the tables that needs to be repaired by checking their boxes.
  5. From the drop-down menu, choose “Repair table” to start the process. Alternatively, you might have to click on “Go” to get it going.

Renaming Your Database

Should you ever need to rename your database, that is entirely within the scope of phpMyAdmin. You can find that option under “Operations” while viewing your database. If you do rename it, make sure the data within your website’s wp-config.php gets updated accordingly.

click here to continue >>

LEAVE YOUR COMMENTS

Creating the WordPress Database

Creating a database for your fresh WordPress install is most commonly the gateway for people to use phpMyAdmin for first time.

To install WordPress, on the database side you will need the following:

  • A database name
  • Username of database
  • User password of database

Let’s see how we can set up all of these in phpMyadmin:

  • A click on “Databases” will bring you to the following menu:
    Create Database
  • Pick a name for your database and enter it in the “Create Database” field. Choose something that describes what the database is used for, it will be very helpful when you have more than one database running in the same place.
    Next, choose a collation from the drop-down menu. Pick the one that fits best for your language and encoding. In most cases you should go with “utf8mb4_general_ci” for coding.
    Create Database_languageWhen you are done with this, click the “Create” button. The new database should then appear in the list.

Add user

  • Next up you will have to create a user who has all access privileges to your newly created database. There are several ways to do so. The one that i find most convenient is to click on your newly created database. From there pick “Privileges.”
    Clicking on “Add user account” will lead you to the screen where you can create a dedicated user for that database. Enter a user name in the respective field (make sure that “Use text field:” is selected from the drop-down menu) and then enter a hard-to-guess password. Again, make sure it says “Use text field” in front of it and don’t forget to write everything down so you don’t forget!
    The “Host” field will most often be filled with “localhost”, however, you have to check with your provider for this.
    Under “Database for User” make sure that the checkbox that says “Grant all privileges on database [your database name]” is enabled.
    Create_userNow click “Go”
    Create_Database_doneCongratulations, you now have the database name, username, and password you will need to install WordPress.

Continue >>

LEAVE YOUR COMMENTS

 backups databaseCREATING BACKUPS OF YOUR DATABASE

Regardless if you are managing a database or not, it’s always good to make backup copies of your website. This can prevent a myriad of problems and help in a speedy recovery in the event of a disaster.

Among all the things that phpMyAdmin can do, performing a database backup is arguably the most important. As mentioned, the database contains the meat and potatoes of your website, you do not want to lose it. Therefore, you should perform regular backups and always back up your database before updating WordPress or making any other big changes to your website.

To create a backup of your database, you have two options available: export or a plugin.

Exporting Your Database

PhpMyAdmin has  a built-in feature to back up your information. When logged into the tool, you’ll see a tab along the top labeled, “Export.”

backups database - export

When you click this tab, you’re provided with a couple of options:

backups database - export

Export Method: Determine if you want to customize the backup by selecting options yourself or simply do a quick copy. This allows you to select any tables you wish in the event you don’t want to do a total backup.

Format: Choose which format you want the tables saved. If you want to recover, it is easier to select the option for SQL.

Using a Plugin

Keeping regular backups of your WordPress site is the best thing you can do for your WordPress security. While the WordPress database contains majority of your site information, it still lacks a fairly important element, images. All your images are stored in the uploads folder in your /wp-content/ directory. Even though the database has the information which image is attached where in the post, it is useless if the image folder doesn’t have those files.

Often beginners think that the database backup is all what they need. It is NOT true. You need to have a full site backup that includes your themes, plugins, and images. No, most hosting company do not keep daily backups.

WordPress has an abundance of quality plugins for backing up a website. The hardest part is picking which one to use because all of theme have excellent functionality.

You can refer to the best and free backup plugins for WordPress here.

Continue >>

LEAVE YOUR COMMENTS

phpMyAdmin_database

Every WordPress website consists of two parts : the core files and a MySQL database. Of the two, the database is the much more important component.

For WordPress, this file keeps track of a slew of information. Everything from user data to the comment section is available in the WordPress database.

In this article, we’re going to show you how to manage your database using the phpMyAdmin tool in Cpanel. This can help you keep the information clean, optimized and secure.

What is phpMyAdmin?

phpMyAdmin  is an adminstration tool for said databases, and one of the most popular out there. A lot of hosting providers use it  to enable their customers to organize their databases. It also ships with popular development platforms such as WampServerXAMPP, and MAMP.

As you can guess from the name, PHP is the language of PhpMyAdmin. And therefore PhpMyAdmin usable with a normal web browser, can be accessed from anywhere you have an Internet connection.

Connecting to Your WordPress Database

As cPanel is a versatile tool and widely used, we’re going to show you how to access the database using this platform. There are many advantages to using cPanel, and phpMyAdmin is one of them.

To access phpMyAdmin:

  • STEP 1: Log into your Cpanel dashboard.
  • STEP 2: Scroll down to phpMyAdmin and click the icon.  In cPanel, it is usually  located in databases section. However, your hosting control panel might look different.phpMyAdmin
  • Step 3: Select your WordPress database. After that, you will be able to see WordPress tables.

At the install, a number  of standard tables will be created in your WordPress database – 11 to be exact. Over time, plugins will add to this number with their own tables, however, the core tables for every fresh WordPress install are these :

  • wp_commentmeta – for the meta data of comments on your site
  • wp_comments – store all comments here
  • wp_links – deprecated but holding information entered in WordPress’s Link featured
  • wp_options – everything input under Administration > Settings is stored in this table
  • wp_postmeta – the meta data of your posts
  • wp_posts – data for posts, pages and navigation items goes here
  • wp_terms – mainly holds information for taxonomies such as categories and tags
  • wp_term_relationship – this saves the relationships with posts and taxonomies
  • wp_term_taxonomy – describes taxonomies with the wp_terms table
  • wp_usermeta – unsurprisingly, the user meta data
  • wp_users – all users go here

These are only some of the tables that may be available in your database. This list can become quite long with every plugin you add. Each plugin can have a collection of tables for settings, functions and data.

Most of the time, these tables are easy to identify as they will often be labeled by the name of the actual plugin.

Continue >>

LEAVE YOUR COMMENTS

Deactivate All Plugins When Not Able to Access WP-Admin

Often times during troubleshooting, you will be recommended deactivate all plugins and activate them one by one. What’s worst is sometimes you get locked out of your WordPress admin panel, so you can’t even deactivate the plugins in an easy way. In this article, we will show you how to deactivate all WordPress plugins when not able to access wp-admin area.

There are two methods to disabling your plugins. One requires you to use FTP, and the other requires you to use phpMyadmin.

Deactivate All Plugins Using FTP

For this method, you will need to either use FTP client or your hosting Filemanager.

  • First, you need to connect to your website using FTP client, or File Manager in Cpanel.
  • Once connected, you need to navigate to the /wp-content/folder.
  • Inside wp-content folder, you will see a folder called plugins. This is where WordPress stores all plugins installed on your website.
    Deactivate All Plugins When Not Able to Access WP-Admin
  • Right-click on the plugins folder and select Rename option. Change the name of the plugins folder ( Example: plugins-deactivate). Once you do this, all of your plugins should be deactivated.

If the issue was with your plugins, then you should be able login to your WordPress admin area. Once you do that, go back to your /wp-content/folder and rename “plugins.deactivate” back to plugins. Now you can activate one plugin at a time until your site breaks again. At which point, you will know exactly which plugin caused the issue.

 Deactivate all plugins using phpMyAdmin

You can also deactivate all plugin using phpMyadmin.

  • First, login to your hosting control panel.
  • You need to access phpMyAdmin tool. In cPanel, it is usually  located in databases section. However, your hosting control panel might look different.
    Deactivate All Plugins When Not Able to Access WP-Admin
  • Select your WordPress database. After that, you will be able to see WordPress tables.
  • You need to open the wp_options table (wp_is a default WordPress table prefix. Prefix might be different on your site). In the wp_options table, you should see rows with different options. Find the active_plugins option and then click on the Edit link.
    Deactivate All Plugins When Not Able to Access WP-Admin
  • On the next screen, you will need to change the option_value field to a:0:{} and then click on a Go button.
    Deactivate All Plugins When Not Able to Access WP-Admin

Congratulations! You have successfully deactivate all WordPress plugins using phpMyAdmin.

LEAVE YOUR COMMENTS

4. How to Resolve 500 Internal Server Error on Your WordPress Website.

Re-uploading core files

If the plugin option didn’t fix the internal server error, then it is worth re-uploading the wp-admin and wp-includes folder from a fresh WordPress install.

This will NOT remove any of your information, but it may solve the problem in case any file was corrupted.

First you will need to visit the WordPress.org website and click on the Get WordPress button.

Resolve 500 Internal Server Error

Then continue clicking on the Download WordPress button. This will install WordPress zip file to your computer. You need to extract the zip file and inside it you will find a wordpress folder.

Next you need to connect to your WordPress website using an FTP client. Once connected go to the root folder of your website. It is the folder that has wp-admin, wp-includes, wp-content folders inside it.

In the left column open the WordPress folder on your computer. Now you need to select wp-includes and wp-admin folders and then right-click and select “Upload”.

Resolve 500 Internal Server Error

Your FTP client will now transfer those folder to your server. It will ask you whether you would like to overwrite the files. Select “Overwrite” and then select “Always use this action.”

Your FTP client will now replace your older WordPress files with newer fresh copies. If your WordPress files were corrupted, then this step will fix the internal server error for you.

Contact your hosting provider

If all methods fail to fix internal server error on your website, then it is advised that you should contact your hosting provider. They will be able to check the server logs and locate the root cause of the error.

We hope this article helped you fix the internal server error in WordPress. Have you figured out any other way to get rid of this problem? Please share your solutions with us in the provided comment section below. I am sure, it will be beneficial for others who are facing similar issues.

LEAVE YOUR COMMENTS

4. How to Resolve 500 Internal Server Error on Your WordPress Website.

Increasing PHP MEMORY LIMIT IN WORDpRESS

Sometimes internal server error can happen if you are exhausting your PHP memory limit. Increasing PHP memory limit in WordPress to fix that.

Some of the most common ways of increasing a WordPress website’s PHP memory limits is by altering the code in one of these files:

  • Functions.php File
  • .htaccess File
  • PHP.ini File
  • wp-Config.php File

You need to open the above file and paste the below code in it.

Function File

@ini_set(‘upload_max_size’ , ’64M’);
@ini_set(‘post_max_size’, ’64M’);
@ini_set(‘max_execution_time’, ‘300’);

.htaccess File

php_value upload_max_filesize 64M
php_value post_max_size 64M

WP-Config File

define(‘WP_MEMORY_LIMIT’, ’64M’);
ini_set(‘post_max_size’, ’64M’);
ini_set(‘upload_max_filesize’, ’64M’);

PHP.ini File

memory_limit = 64M
upload_max_filesize = 64M
post_max_size = 64M
file_uploads = On

checking for all plugins

If none of the above solutions worked for you, then this error is most likely being caused by a specific plugin. It’s also possible that it is a combination of plugins that are not playing nice with each other.

If you have access to the admin dashboard of your WordPress website, you have to deactive all WordPress plugins at once. Refresh your website after deactivation.

Resolve 500 Internal Server Error

What’s worst is sometimes you get locked out of your WordPress admin panel, so you can’t even deactivate the plugins in an easy way. We will show you how to deactivate all WordPress plugins when not able to access wp-admin area in the following article.

Then check your website again. If the site starts functioning properly, then the internal server error must be due to the plugin installed on your WordPress. Now, you need to activate each plugin one by one and refresh your website after each plugin activation. The problematic plugin  will soon be indentified as it will result in a 500 Internal Server error for your website. Get rid of that plugin, and report the error to the plugin author.

Continue >>

LEAVE YOUR COMMENTS

4. How to Resolve 500 Internal Server Error on Your WordPress Website.

To fix this persistent issue, it’s necessary that one should identify the cause of the occurrence. Internal server error in WordPress is often cause by plugin or theme functions. The two other common causes of this error is corrupt .htaccess file and PHP memory limit. Let’s discuss how we can fix them.

Checking the Corrupt .htaccess file

One of the key file in any PHP based application is .htaccess file. This file contains server related configuration rules. If your .htaccess file is corrupted, this can cause a 500 internal server error.  So, the first thing you should do when troubleshooting the internal server error in WordPress is check for the corrupted .htaccess file.

To do this, you will need to login to your site using FTP or File Manager app in your hosting account’s cPanel dashboard. Once logged in to your FTP account, you will see a .htaccess file available in the root directory along with other folders such as wp-content, wp-include and wp-admin.

Resolve-500-Internal-Server-Error

 Then, renaming your main .htaccess file to something like .htaccess_old. Once you have renamed the .htaccess file, try visiting your site to see if this solved the problem.

If it is fixed then that would be great, make sure that you go to Settings >> Permalinks page in WordPress admin area and click the save button without making any changes. This will generate a new .htacess file for you with proper rewrite rules to ensure that your post pages do not return a 404 error.

Troubleshooting any error can save a lot of time and efforts. Initial analysis of the problem can help you identify the root cause. Hence pace way toward resolving the problem at hand. Many reasons can cause the server to raise a 500 internal server error on WordPress website.

If checking for the corrupt .htaccess file solution did not work for you, then you need to continue reading next article.

 

LEAVE YOUR COMMENTS

Internal Server Error

Internal Server Error

Have you encountered 500 internal server errors in WordPress? Internet server error is one of the most common WordPress errors. Since the error doesn’t give any other information, many beginners find it quite frustrating.

Let’s assume that your website is working fine until a few days back, a minor glitch takes place, and it escapes your mind. Suddenly, you start observing a 500 internal error on every page of your website. I know that you are now panicking out. Don’t worry! In this article, we will show you how to easily fix internal server error in WordPress.

1. What is a 500 Internal Server Error?

As the name suggests, this is an error occurs on server level when the server is unable to show the requested page. An internal server error is an application-side issue that can occur on your web server. When you write a specific URL into the address bar or if you click a link on a website, you are requesting the server to show you a page. Presently, for some reason, the server can’t show you that specific page you are seeking which signifies that you are facing an internal server error.

2. Make a WordPress Backup

Most of the time, you are not responsible for the errors that occur on your hosted server. Since humans can make mistake. Some of these errors are severe and may end up compromising your whole website, therefore backing up website data on your server should be a mandatory practice.

In short, making a wordpress backup is the most effective preventive measure. If your hosting provider fails to provide you with the right options to backup website data, you can try the following WordPress Backup Plugins.

3. What Causes Internal Server Error in WordPress?

Internal server error is not specific to WordPress. It can happen with any website running on a web server. Due to the generic nature of this error, it does not tell the developer anything.

Asking how to fix an internal server error is like asking your doctor how to fix the pain without telling them where the pain is. So let’s take a look at how to go about troubleshooting the internal server error in WordPress in the following article.

LEAVE YOUR COMMENTS