Questions tagged [phpmyadmin]

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

Filter by
Sorted by
Tagged with
16
votes
6answers
105k views

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 ...
9
votes
2answers
25k views

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 ...
4
votes
4answers
14k views

How do I find all admin users using phpmyadmin?

I logged into my wp-dashboard after a hack to find that there is a 'ghost' administrator of my site... the only problem is, I can't just list the user table and delete it. I don't know why, but here'...
4
votes
1answer
606 views

What specific database privileges does WordPress need?

I want to create a new database user for my WordPress installation. Usually on localhost, i can just use root, but it is good practice to use a user with as little rights as possible. What are those ...
3
votes
3answers
12k views

Export only pages and posts with mysql dump

How to export only pages and posts using mysql database to database approach? More precisely: what tables should one select for dump (I suppose wp-posts and wp-post-meta ) is it safe to export only ...
3
votes
2answers
3k views

Gaining Login Access via the Database

I have been given a job to amend a Wordpress site. I have only been given access to Cpanel. My questions are can i log in to the back end of Wordpress via Cpanel? If you can't login via Cpanel can i ...
2
votes
4answers
15k views

“#1067 - Invalid default value for 'post_date'” when trying to reset AI after backup

I've restored my Wordpress database from an sql backup. However, in doing so, all of the tables have lost auto increment. When I try to add it back in with this sql ALTER TABLE `mercury_posts` ...
2
votes
5answers
23k views

Manually delete post from database

For whatever reason, I have a post and a page with the same slug name and it causes the db to hang. I can't alter the slug on either so I need to go manually delete the posts from the database and ...
2
votes
3answers
11k views

unable to upload image locally

I followed this tutorial on setting up a local web development setup without mamp. Now my problem is when I go to upload a image in WordPress I get the following error: “Screen Shot 2013-01-05 at ...
2
votes
2answers
892 views

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 ...
2
votes
2answers
465 views

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 ...
2
votes
2answers
3k views

Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?

I'm looking to mass remove or clear the default attribute for variable products in Woocommerce. Is there an easy way to mass clear this value? If not, would you be able to direct me on where I can ...
2
votes
1answer
52 views

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 ...
2
votes
3answers
873 views

How to Move Local Singlesite Database to Remote Multsite Database?

I'm fairly new to Wordpress and I'm a little confuse on how to take the database from my local server and replace it with the one on the server on a Wordpress multisite. I've replace database before ...
2
votes
1answer
1k views

Query to change custom post type with specific category

I need to change several hundred posts with custom post types to regular post type but only from one category within that custom post type. So I have a custom post type 'films' and within that post ...
2
votes
1answer
2k views

How Do I Merge Categories With phpMyAdmin

I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE `wp_term_relationships` SET `term_taxonomy_id` = 112747 WHERE `term_taxonomy_id` = 112748; It did ...
2
votes
2answers
272 views

$wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin

I have this code: $query = "SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id ...
2
votes
0answers
34 views

How to delete posts that does not have a thumbnail?

I have a problem with my blog. The thing is this, all the posts have a thumbnail in this address: wpbv_postmeta-->meta_key-->thumb And several (A LOT) of posts don't work, because I have made a ...
2
votes
0answers
352 views

Emojis getting converted to “?”

Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The respective tables wp_comments and wp_posts are ...
2
votes
0answers
963 views

Set Display Name to first and last name (phpmyadmin SQL Query)

I'm trying to change all the users Display Names to be their first and last name. I have looked into a number of plugins and wrote my own PHP to try and accomplish this however the site has over 50,...
1
vote
6answers
29k views

How can I restore admin capabilities?

So yeah, I'm a genius. I managed delete all my admin capabilities (thank you very much Membership plugin). I could restore them, ...if I had admin access, lol. Anywhoo, how can I give all my ...
1
vote
5answers
12k views

Reseting admin password through PHPMyadmin fails

Following the PHPMyAdmin instructions of this article fails to reset my password properly. I go into WP_Users, find my admin account, click edit, enter my password, change the dropdown to MD5, click ...
1
vote
5answers
2k views

How to replace values in Wordpress DB using phpMyAdmin

I am trying to save a value in a cg_option row/field using phpmyadmin, however data is not stored correctly and when loaded again after saving, only part of data appears. Do I need to use a conversion ...
1
vote
2answers
3k views

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 ...
1
vote
2answers
3k views

How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?

My WordPress site got hacked and the WP Admin user account password was changed by the hacker. This essentially locked the user out of his admin dashboard. It is best (for situations like this) to ...
1
vote
3answers
437 views

Is it possible to create a wordpress database with php code?

Just curious . Is it some how possible to create a database with php code? I am having only having access to public_html folder and i want to make a wordpress installation. Is there any method to make ...
1
vote
1answer
567 views

Delete all post meta except featured image Using SQL

Please I just migrated my site and I found out that wp_postmeta consumes most of my cpu resources, Is the any Sql code to Delete all post meta except the featured image. I dont want to Use wp ...
1
vote
1answer
6k views

SQL error #1062 - Duplicate entry '1' for key 'PRIMARY' [closed]

When I want to import database, I get the next error: Error SQL query: -- -- Dumping data for table wp_comments -- INSERT INTO wp_comments ( comment_ID , comment_post_ID , comment_author , ...
1
vote
2answers
2k views

Importing wordpress. xml file on new installation

I am trying to move a wordpress installation to a new server. I usualy create a new database using phpmyadmin on the new server, import the sql file from the old server, then install wordpress but ...
1
vote
2answers
2k views

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 ...
1
vote
2answers
455 views

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 ...
1
vote
1answer
671 views

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. ...
1
vote
2answers
2k views

How to delete users with no order history through phpmyadmin sql?

I have a wordpress ecommerce website which I have begun to update after not touching it for over a year. The first thing I did was implement reCaptcha into all inquiry and contact forms to reduce the ...
1
vote
1answer
779 views

Update slug (URL) of pending posts via phpMyAdmin

I need to remove/delete slug of posts on pending via phpMyAdmin. Most of posts on pending have slug/URL which is different from their post title, deleting post slug/URL will force WP to generate new ...
1
vote
1answer
450 views

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.
1
vote
1answer
3k views

Delete all post meta except featured image

My aim is to clear up my database entries. I did a migration from blogger which added many useless post_meta. I found a plugin (db reset) that has the option to reset/delete all post meta. However if ...
1
vote
1answer
28 views

Duplicate posts when posting nulls in records in phpMyAdmin [closed]

I have a phpMyAdmin database with a table whose contents, when inputted from the database, automatically publish the related information. Some of the details within the record may be NULL, and while ...
1
vote
1answer
25 views

Double domain name in category URL-s

My site runs on the latest version of WordPress. However, I have a problem with categories. Permalinks are set correctly and my category path looks like this: example.com/category-name. Links work ...
1
vote
1answer
97 views

Is there a way I can find wordpress posts that don't contain a word?

Am trying to unpublish wordpress posts that don't contain a word., Its like the inverse of search, Search is finding a string in wordpress posts, I need to find wordpress posts,. I think this will be ...
1
vote
2answers
167 views

Delete Wordpress posts from URL list sql query

Is it possible to delete a huge number of wordpress posts through SQL query using phpmyadmin by using a permalink list of posts that I want to delete ?
1
vote
1answer
969 views

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

I am trying to add meta_key and meta_value for the all already registered user in my database via phpmyadmin. I want: meta_key = is_activated and meta_value = 1 Thanks,
1
vote
3answers
3k views

Can't find my wordpress DB in phpmyadmin

I have created a a site on my localhost, But Now I need to upload website on live server so i need to export word press DB from Phpmyadmin, But I cant find any WP DB there. Here is my wp-config file ...
1
vote
1answer
3k views

Delete All Product Images in phpmyadmin

I've just inherited a site that's being migrated to a new host, and I'm attempting to tidy up the database during the process. The WooCommerce site had roughly 10,000 products resulting in somewhere ...
1
vote
1answer
3k views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username -...
1
vote
1answer
126 views

Delete all one-word comments

I'm trying to delete all wordpress comments with only one word. I found this mysql query to delete all comments at once, but that's not what I want to achieve: DELETE FROM wp_comments WHERE ...
1
vote
1answer
18k views

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

Is it possible to backup files from a old hard drive without having access to phpmyadmin? Could someone point me in the right direction?
1
vote
1answer
396 views

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

I'm updating a standard install with about 500 (eek!!) pages to a MultiSite for easier sub-site management. I basically want to take a sub-page and its children from the root site and copy the data ...
1
vote
0answers
14 views

Problem with database mhpMyAdmin [closed]

I have a huge problem. By an error my database is overwriten. 1 have one backup a day, but this is not a solution. Can I don't see the history of queries? Or can I use some software? Can anyone helps ...
1
vote
0answers
30 views

How to display data from custom table in wordpress phpmyadmin

Thanks in advance could anyone here help me, I would like to display the value from the phpmyadmin database in wordpress, The value was stored from the dropdown form and I want display that value in ...
1
vote
1answer
122 views

phpMyAdmin displays error when importing database 2

I'm cloning a WordPress into my PC. I have already backed up all files.. The problem is that when I try and import the database using phpMyAdmin, I get this error message: Error Query SQL: -- Dump ...