phpmyadmin - Read For Learn

How to make custom column Admin>Users sortable?

Query to import data from one MultiSite table to another (pages/sub-pages)

OK So I worked this out. This query will do the trick of moving the pages: INSERT INTO wp_xxx_posts SELECT * FROM wp_posts WHERE post_parent IN (123,456,789,1011); The xxx relates to the destination MultiSite ID (wp_3_posts for example). The (numbers) in brackets are the parent ID’s (‘post_parent’ in the WP table) of the pages I … Read more

Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?

Don’t know if it’s the best way but her is a very simple way to do it: Install a new copy of WAMP. Copy the files from the old HD to you newly installed wamp \bin\mysql\mysql…\data folder. Log in to phpmyadmin (that comes with WAMP) and create a dump of the database

Delete all one-word comments

DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA If you have privileges to login to MySQL and query data you could collect all the comment_ID values that have one word. SELECT comment_ID FROM wp_comments WHERE REPLACE(TRIM(comment_content),’ ‘,”)=TRIM(comment_content); You can test this by also seeing the comment_content SELECT comment_ID,comment_content FROM wp_comments WHERE REPLACE(TRIM(comment_content),’ ‘,”)=TRIM(comment_content); … Read more

WordPress database import: Row size too large

The problem occurs in MySQL 5.6.20 or later, if the innodb_log_file_size in the my.ini is set too low. I changed mine to 16M and the problem went away. Thanks to @Otto for the solution. http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html

Delete All Product Images in phpmyadmin

You can loop through all the woo-commerce products and delete them along with their attachment(images).. $args = array( ‘post_type’ => ‘product’, … ); $loop = new WP_Query( $args ); while ( $loop->have_posts() ) : $loop->the_post(); ?> <?php wp_delete_post( $loop->post->ID ); wp_delete_attachment( $loop->post->attachment_id ); ?> <?php endwhile; ?>

Can’t find my wordpress DB in phpmyadmin

I don’t see any reason to login as root if you only need the one database… Have you tried logging in to phpMyAdmin as the user with the same credentials as your WordPress installation? user: bn_wordpress pass: 0cca6aaab5 port: 3306 We could avoid phpMyAdmin all together… From the command line you can dump the database … Read more

Set meta_key and meta_value for all registered user in wordpress using sql query [closed]

Add this code in functions.php. visit your site you, it will automatic add/update all user meta value. After executing this code just comment out or remove this code. $args = array( ‘fields’ => ‘all’, ); $blogusers = get_users( $args); foreach($blogusers as $key => $user){ update_user_meta( $user->ID, ‘is_activated’, 1 ); } OR you can also do … Read more

Users table association with users_metadata table appears broken

In the users table the primary key should be ID (auto-increment) and the user_login, user_nicename and user_email fields should be indexed. In the usermeta table the umeta_id should be primary key (auto-increment) and the umeta_id and meta_key fields should be indexed.

+ More