database

Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error

Make sure your database connection is correct define(‘DB_NAME’, ‘database-name’); define(‘DB_USER’, ‘database-username’); define(‘DB_PASSWORD’, ‘database-password’); define(‘DB_HOST’, ‘localhost’); And you should test with plain php file for connecting database like below codes <?php $connect = mysql_connect(‘localhost’, ‘root’, ‘password’); if (!$connect) { die(‘Could not connect: ‘ . mysql_error()); } echo ‘Connected successfully’; mysql_close($connect); To make it flexible on localhost … Read more

wordpress ‘database update required’ loop after update

For anyone stumbling across this now, I might have the solution. If you’ve tried the above steps provided by OP, instead of matching the database functions lower the db_version value in the wp_options by 1. In case your $wp_db_version in your version.php is 45805 (as was the case for me), try setting your db_version value … Read more

How can I get my wordpress password from an SQL file?

Since you are the admin of the site, I assume you have access to phpMyAdmin. If so, find the database (look for the name in the wp-config.php file), and use phpMyAdmin to access the wp-users table. If not, see below. Find your admin user account in that table, and change the email address (I am … Read more

Reducing Database Query Time

While there are specific MySQL tuning options available, and of course the possibility of moving your database to a dedicated server; ultimately the issue is the way WooCommerce handles variations. WooCommerce itself warns about the impact of performance when creating variations, you even have to confirm your choice when creating variable products. So first off … Read more

Importing CSV into database table not working?

You can use Load data infile MySQL Query instead of looping through each entry. Doc: https://dev.mysql.com/doc/refman/8.0/en/load-data.html For example: $wpdb->query( $wpdb->prepare( “LOAD DATA LOCAL INFILE %s INTO TABLE sas FIELDS TERMINATED BY ‘,’ ENCLOSED BY %s IGNORE 1 LINES (@category,@temple) SET category = @category, temple = @temple;”, $_FILES[‘file’][‘tmp_name’], ‘”‘ ) ); Make sure that fields from … Read more

Use WordPress MultiSite (WPMS) with a remote database for each created site

By the time plugins are loaded, it’s too late to change databases. You could add a series of switch/options in your wp-config.php switch ( $ _SERVER[‘HTTP_HOST’] ) { case ‘somedomain.com’: define(‘DB_NAME’, ‘zzzzzz’); define(‘DB_USER’, ‘yyyyyyy’); define(‘DB_PASSWORD’, ‘xxxxxx’); define(‘DB_HOST’, ‘localhost’); break; case ‘anotherdomain.com’: define(‘DB_NAME’, ‘aaaaaa’); define(‘DB_USER’, ‘bbbbb’); define(‘DB_PASSWORD’, ‘cccccc’); define(‘DB_HOST’, ‘localhost’); break; } But this would then … Read more

+ More