database - Read For Learn

localize elements in database

WordPress Local And Live Site

My best practice to run a production system and keep a development version with a simple and easy configuration. Notice: This works super awesome on small wordpress websites. Create production and development configuration files: wp-config-dev.php (contains local database configuration, site url and debugging) _wp-config-live.php (contains production database config., live site url and disabled debugging configuration) … Read more

delete duplicate comments

fastest replacement DB

You may wish to post this same query in the TokuDB-users community here… https://groups.google.com/forum/#!forum/tokudb-user Good luck with your research. -dave

Super slow queries from author archive pages killing my database

If memory serves, the problem is because you are doing a very large query and then running multiple checks across all of them with your max statement. You might have much better luck breaking it out into two queries so that you can keep the iterative processing to a minimum. For example, you might: Query … Read more

Migrate database between 2 different wordpress version

2 website 1 database… Local to online

How to fix it ? Go in SQL and write this code : UPDATE `wp2_usermeta` SET `meta_key` = REPLACE(`meta_key`, ‘wp_’, ‘wp2_’); UPDATE `wp2_options` SET `option_name` = REPLACE(`option_name`, ‘wp_’, ‘wp2_’); 🙂

How to connect to a remote database in WordPress?

You can set up another connection and use that database the same way you would interact with the WP database with $wpdb. This example creates an instance in $odb to be used the same as you would use $wpdb: global $odb; $db_user = “Your DB Username”; $db_pass = “Your DB Password”; $db_name = “Your DB … Read more

How to share plugin created database tables between two WordPress sites

I realized that all you have to do is find where the database is returned (in my case it is wp-init.php) and change the prefix to reflect the shared database: $wpdb->prefix=”wp_”;

wp_editor content in plugin options page

+ More