Articles of phpmyadmin

Change sticky status of posts from phpMyAdmin

I have many sticky posts in my database. Is there any SQL function which I could use from phpMyAdmin to change (remove) sticky status of posts, if post is sticky to change it to not sicky.

How to add an export function to a custom Option Theme Page

I’m creating a new WordPress template and I have a question: I’ve added a custom Option Page to my new template (you can see what I’m doing Here and Here) but now I would like to add a new function. Do you know Si Contact Form? In this plugin the end user can download a […]

Why do I get a WAMP homepage when clicking on specific website's URL on LocalHost?

Using WAMPSERVER for windows 7, smartgit and Safe Search Replace I have pulled a wordpress code from my git, downloaded a database and inserted into my localhost‘s phpmyadmin. My home page works but when I click on one of the links I get the WAMP homepage. What am I doing wrong? I have tried the […]

Accidentally deleted active_plugins portion of the wp_options DB table

Ok, so I’m pretty sure I’m screwed here, because I do not have a database backup, but I figured I’d ask just in case. Within PhpMyAdmin, I meant to just go to the wp_options table and empty out active_plugins portion of this table due to not being about to login because of a plugin error. […]

Redirecting to old domain after migration

I have moved one of my website to a new domain, below is what i did. Backed up database Uploaded all the files to the new server. Imported sql into new server via phpmyadmin Now i have used this script to change URL in database. Now, problems i am facing are: All the links are […]

Resetting menu_order to 0 for posts in PHPmyAdmin?

Installed a plugin that allows the re-ordering of posts from any post type / category / tag using a drag/drop interface. After some time of using, my post order went haywire and new posts began to appear in a jumbled order. The plugin’s native reset button resolved this, but the old posts are still jumbled […]

Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?

So I have added myself as an admin via following the instructions on this site: http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/ I have done this before and it has worked. When I go into the dashboard and add the creds as I inputted them via phpMyAdmin according to the steps in the URL above, I get an error message saying […]

Making someone a WordPress administrator using PhpMyAdmin

After database problems on my provider side, I had to reset my admin user password. But then this user was not an admin anymore. In PhpMyAdmin I see that it has a user_status value of 0. How can I make this user an amin in WP dashboard ?

Moving database with phpMyAdmin

I have a remote (website) version of a wordpress site and it’s got more recent information than my local (computer) version. I would like to move the data over to my local using phpMyAdmin, what is the best way to go about this? Should I just export the entire database, import it and re-link my […]

How to do a MySQL dump from production site without using a search and replace script for local development?

I performed a MySQL dump of my WordPress production database to be imported into my local development environment. I plan on frequently performing this database dump and import. Is it possible for me to AVOID running a search & replace script or a MySQL query that updates all of the permalinks, site URLs, etc? Could […]