Wp_terms: Stores taxonomies regarding content such as categories and tags. Wp_posts: Saves all of your content data such as types, dates and text. Wp_postmeta: Stores the metadata regarding posts and pages. Wp_options: Contains data regarding the website such as urls, posts per page and site description. Wp_links: Manages blogrolls that are used by early versions of WordPress or certain plugins. Wp_comments: Information regarding all comments on your site. Wp_commentmeta: Contains the metadata regarding comments placed by users on your site. It may even impact the speed of your site in terms of SEO. If your site has been up and running for years, these changes may be noticeable to you as well as your visitors. Optimizing the tables in this fashion help make the system run smoothly while making the size a bit smaller. Step 4: As soon as you click this control, phpMyAdmin will automatically run its defragmenting application. Step 3: On the right side of the Check All command, you’ll see a drop down window that says, “With selected.” Click this to open the list of controls and click on, “Optimize table.” You’ll see a link for, “Check All.” You can either click this link or the empty check box next to it on the left. Step 2: Scroll down to the bottom of your table list. As a result, it affects site performance even if just slightly. This can cause the information retrieval to be much slower than it could be. Like many other computerized applications, databases can become fragmented over time. This is because the plugin will save the files for your site as well as the database. Plugins such as blogVault Real-time Backup are very useful. If you would rather spend less time in phpMyAdmin, you can always use a plugin to back up your files. If you want to recover, it is easier to select the option for SQL. This allows you to select any tables you wish in the event you don’t want to do a total backup.įormat: Choose which format you want the tables saved. When logged into the tool, you’ll see a tab along the top labeled, “Export.” When you click this tab, you’re provided with a couple of options:Įxport Method: Determine if you want to customize the backup by selecting options yourself or simply do a quick copy. PhpMyAdmin has a built-in feature to back up your information. To create a backup of your database, you have two options available: export or a plugin. This can prevent a myriad of problems and help in a speedy recovery in the event of a disaster. Regardless if you are managing a database or not, it’s always good to make backup copies of your website. Step 4: Close out of File Manager and cPanel without saving anything. This is the database you want to use in phpMyAdmin. The actual name of your database will follow the “ DB_NAME” part of the code. NOTE: username_wrdp4 will be different in your configuration file. Step 3: Edit the wp-config.php file and look for the following: Inside the root folder, you’ll find the “wp-config.php” file. Step 2: Find the root folder for the website you wish to view. Step 1: Log into cPanel and access your File Manager. If you don’t know which database you’re using for a specific WordPress website, you can find that by accessing your wp-config.php file. Step 5: You now have access to all the data tables related to your site. Step 4: Click on the database that corresponds with the WordPress website you wish to access. If the databases you have are not visible, click the “+” next to your username to expand the list. Step 3: Once you log in, you’ll see your username on the left. This will be located under the header, “Databases.” Step 2: Scroll down to phpMyAdmin and click the icon. It’s a graphical user interface, or GUI, that is web-based and can be accessed from almost anywhere you have an Internet connection. PhpMyAdmin is a free tool that comes with many different kinds of hosting. There are many advantages to using cPanel, and phpMyAdmin is one of them. Accidental changes can lead to everything from broken accounts to preventing WordPress from operating correctly.Īs cPanel is a versatile tool and widely used, we’re going to show you how to access the database using this platform. Any changes you make in phpMyAdmin are permanent and cannot be undone. Connecting to Your WordPress Databaseīefore you modify anything in your database, make a backup copy. This can help you keep the information clean, optimized and secure. In this article, we’re going to show you how to manage your database using the phpMyAdmin tool in cPanel. Everything from user data to the comment section is available in the WordPress database. For WordPress, this file keeps track of a slew of information. Most websites on the Internet use a database for one reason or another.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |