To move a site from localhost i usually do the following: 1, Install adminer plugin on your localhost (lets you download the database file) 2, Use an FTP to upload all files 3, Change the php config files details to work on host 4, Open the mysql file saved from Adminer and then edit the … Read more
Take a back up before trying anything! 🙂 (I use the Duplicator plugin for that, if you don’t already have a solution. When you delete users in WordPress, it gives the option to attribute conent to another user. Would this suit your needs?
Try this: http://localhost/phpmyadmin/ The manual says:: DesktopServer comes with PHPMyAdmin which allows you to manage your MySQL databases. You can access this tool two ways. Open DesktopServer In the left bottom corner is a [ Sites ] button, click it. This will open a page in your default browser, at the top is a menu … Read more
Add following in WHERE condition of your SQL query. WHERE t1.meta_key = “<?php echo $wpdb->prefix; ?>capabilities” AND ( t1.meta_value LIKE ‘%ROLE_YOU_WANT_TO_FILTER%’) Let me know if it works for you or not.
Somethings wrong with your permission setting. Login to your server via SSH. You can login using your terminal. I’ve created a blog about how to connect to your server via SSH if you’re using windows. Run the following commands: chown www-data:www-data -R * # Let Apache be owner find . -type d -exec chmod 755 … Read more
In general, things that are not content, better not be in the DB in the first place. Site header images should be in you CSS, making them part of your code which you manage with GIT. This is obviously easier said than done with the way wordpress core and many plugins geared towards storing everything … Read more
Adding wordpress posts using phpmyadmin
You can try this plugin see this This plugin adds a simple post-type drop-down to the post editor interface, allowing you to reassign any post to a new post type. It allows you to switch post’s type while editing your post. Post Type Switcher
An SQL query to find orphaned image attachments and their meta
duplicate wordpress site on same bdd