💡 WordPress uses MySQL as its database management system. WordPress database is where all of the necessary website data is stored. Not just the basic information like usernames and passwords but posts, pages and comments, even the website theme and WordPress configuration settings.
Here you can find various SQL snippets and PHPMyAdmin tips.
Instruction: Parameter PARAMETER TYPE DESCRIPTION DEFAULT REQUIRED $format string Output can be PHP date format or Unix timestamp. no yes $date string mysql2date() only recognizes “Ymd H:i:s” format, so the original timestamp string needs to be converted to this format. no yes $translate boolean If true, the specified date and format string will be passed … Read full article →
![WordPress database error Table .dbwp options is marked as crashed and should be repaired - WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]](https://wpxss.com/wp-content/webp-express/webp-images/uploads/2022/10/WordPress-database-error-Table-.dbwp_options-is-marked-as-crashed-and-should-be-repaired.png.webp "WordPress database error Table './db/wp_options' is marked as crashed and should be repaired [✔️ SOLVED]")
Here are 4 different methods to fix the scary-looking error: “WordPress database error Table ‘./db/wp_options’ is marked as crashed and should be repaired”. NOTE: It is critically important that you backup your database before performing any of the following suggestions. You’re fully responsible for undertaking this yourself, I can’t be held responsible if you break … Read full article →
This simple query allows you to transfer all posts from one user to another. SQL query This will assign all posts from author ID=14 to the user with ID=1 (admin). WP-CLI This will remove the user [email protected] and assign all his posts to user with ID=1 (admin).
While building and testing WooCommerce addons, I find myself in need of quickly deleting all WooCommerce products from the database. WPCLI is the easiest way to go, as you can achieve the desired results via a single line. NOTE: if your database prefix isn’t the default wp_, you’ll need to change it with your actual database … Read full article →
The SAVEQUERIES wp-config constant saves database queries to an array and We can use that array to display queries. The information saves each query, what function called it, and how long that query took to execute. To enable SAVEQUERIES add this to the wp-config.php file: Then in the footer of your theme put this: <?php … Read full article →
Want to change the domain name for your WordPress website? No problem, in this guide We’ll walk you through 5 different methods to change the domain name for a WordPress website from cPanel PHPMyAdmin. Before following this guide make sure you’ve down the following: registered the desired domain name and pointed it towards your hosting … Read full article →
A lot of WordPress backup plugins have limitations and are just pushing you to purchase the pro version. That is why I always recommend cperforming a manual backup of WordPress websites, whenever you can. How to do manually backup WordPress: Download all files from Filemanager or FTP Export the database from PHPMyAdmin How to Manually … Read full article →
Locked out of your wp-admin area? Forgot the password? No problem, the easiest way to regain access is to reset your admin password from your database via phpMyAdmin. Step 1. Open PHPMyAdmin The first step is to log into your cPanel and under Databases select phpMyAdmin. Step 2. Select your database name From the left … Read full article →
Is your website loading slowly? Redirects? Popups? Can’t login? Strange folders? Files with weird names? Huge number of failed/deferred emails that you didn’t even send? These are just some of the most common symptoms of a hacked WordPress website. If you are experiencing some of these problems – do not panic! In this guide, I’ll … Read full article →
Here are various ways to disable all WordPress plugins at once in cPanel. Disable all plugins via FTP or FileManager Step 1. Login to cPanel > File Manager Step 2. Open /wp-content folder Step 3. Rename /plugins folder to plugins.bak Disabling all plugins using PhpMyAdmin Step 1. Login to your PHPMyAdmin Step 2. Open your … Read full article →