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
0
votes
1answer
267 views

WP website showing blank page after moving from subdomain to main domain

I created my website on the subfolder https://www.lokaction.be/dev/. After it was finished, I moved the website's files to the main adress https://www.lokaction.be/ (ftp). And after that, I edited ...
1
vote
3answers
253 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
3answers
2k 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 ...
0
votes
2answers
37 views

WP CLI can't delete plugin related table

I have installed a plugin following wp plugin install ... CLI command and then activate through CLI command its working properly. But problem is that when I deactivate then delete the plugin the table ...
0
votes
1answer
84 views

Clients with empty username are not receiving request new password email

I am looking after a old site from a client and a lot of users dont have username. I had setup in woocommerce "When creating an account, automatically generate a username from the customer's email ...
2
votes
3answers
712 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 ...
1
vote
1answer
465 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 ...
0
votes
1answer
48 views

submit form data to wordpress existing database table using my plugin

i have created a plugin for wordpress to sbmit form dtails to wordpress database. I created a table in cpanel phpmyadmin called 'wp_in_booking'. im trying to send the form data, but it can not get ...
0
votes
1answer
202 views

Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working

So interestingly, I moved my main plugin file into a folder within the plugin directory. Where before the register_activation_hook worked perfectly well, it now does not work; however, the ...
2
votes
0answers
192 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 ...
0
votes
0answers
30 views

duplicate wordpress site on same bdd

I have only one bdd with 2 wordpress sites : first with _wp suffix second with _wp2 suffix. For the url : mydomain/site1 mydomain/site2 Now i need to duplicate the site2 as site3 (mydomain/site3) ...
0
votes
1answer
13k views

Trouble Installing Wordpress Get PHP Not Running Answer

I have seen this topic discussed several places on the internet, both in the Wordpress official forums and on individuals' blogs. Despite having worked through some of the suggestions, I am still ...
0
votes
2answers
2k 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 ...
0
votes
5answers
250 views

Wordpress not taking password and username

I am in a strange situation, I installed wordpress on my godaddy hosting everything was fine and i developed my theme in nice way, But now i cant login in wp-login.php, i try to reset my password ...
0
votes
1answer
337 views

WooCommerce categories do not show in Backend

I have created categories for Woocommerce via phpmyadmin. Including three tables: term_taxonomy, termmeta, terms. And then go to wp-admin/edit-tags.php?taxonomy=product_cat&post_type=product, it ...
0
votes
1answer
5k 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 , ...
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 ...
1
vote
0answers
147 views

Wordpress Database Huge wp_usermeta Table

I have a wordpress site with over than 700,000 users. Each user adds more than 20 rows to the wp_usermeta table ! this is causing very slow queries and the website started to crash, login failure and ...
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 ...
0
votes
1answer
183 views

Can't update WordFence Options, clear data manually

I ran across this problem today. Found enough bits on Stack Overflow to finally get me there, but figured I'd post a coherent answer to my question. Problem: I can't save changes in WordFence, and ...
0
votes
2answers
2k views

How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category

I have tried the following phpMyAdmin query in an effort to delete all posts, from wordpress category 378, that are over 400 days old. DELETE a,b,c,d FROM wp_posts a LEFT JOIN wp_term_relationships b ...
-1
votes
1answer
2k views

SQL command to export post_content from wp_posts using phpMyAdmin

I'm trying to select all the data from within the post_content column in the wp_posts table in WordPress so I can export/import it into a new database. Somehow this content didn't properly make it ...
1
vote
1answer
516 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 ...
2
votes
1answer
48 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
2answers
10k 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 ...
0
votes
1answer
215 views

403 Forbidden Localhost Wamp Apache Php

I’m completely new to wordpress/website design and I’m following a tutorial on youtube about creating custom themes. I’ve set up a website in localhost and I’m using permalinks to navigate to pages in ...
0
votes
1answer
6k views

phpMyAdmin displays error when importing database

I'm migrating a WordPress for a friend to a different server. I have already backed up all files and was given a copy of the database by the old server admin. The problem is that when I try and import ...
0
votes
1answer
228 views

AWS Bitnami Wordpress - SELECT command denied to user

I'm using Amazon Web Services (AWS) Wordpress which uses Bitnami. I've created a test template, wrote a SELECT statement to test pulling data from the database, uploaded the template, selected the ...
0
votes
3answers
128 views

header background color changed after drop & import database in phpmyadmin

This is what I did in phpmyadmin. Export DB in .sql format Drop all tables Import the exported DB The database should be same, but the website looks weird as below... how come...? Before (black ...
0
votes
0answers
412 views

An SQL query to find orphaned image attachments and their meta

This is for people who are good with MySQL queries. I'm using phpMyAdmin locally to try to optimize an old WordPress & Woocommerce site which has gone through a couple of iterations over the years....
1
vote
1answer
2k 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 ...
0
votes
1answer
152 views

Change Custom Post Type to Post + Category

I have a rather difficult problem, I have a news site and I used a custom template with custom post-types for each "category" and now I want to change the template, but I can not change the posts for ...
0
votes
1answer
5k views

Connection refused on locahost after importing database?

I'm using Wordpress Instant for my development environment. It's a portable dev environment that allows me to run a local wp install off a usb, so it's portable and I can take it from one computer to ...
0
votes
0answers
203 views

Adding wordpress posts using phpmyadmin

I am trying to add wordpress posts exported from phpmyadmin into a site that already has wordpress posts. The process would work fine if the site I am trying to upload the sql file to was a brand ...
1
vote
2answers
138 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
votes
1answer
3k views

cannot log in to the mysql server (wamp and wordpress)

When I run wamp (an offline webserver) and then run phpmyadmin, user and password are asked. I haven't used wamp in a while so basically I forgot user and password. I've followed some guides like this ...
0
votes
1answer
2k views

Unable to install and upload theme due to php.ini file [closed]

Issues with uploading my theme to localhost using WAMP Server on Windows 7 Home version. I've changed the limit to 635mb in the php.ini. However, there seems to be TWO php.ini files. These are ...
0
votes
1answer
56 views

How to periodically roll back WordPress to a fixed point in time?

I have a demo WordPress site that showcases a plugin I created. The plugin lets users interact with content from the front-end and could potentially result in a nightmare of content bloat over time. I'...
0
votes
1answer
41 views

Users table association with users_metadata table appears broken

I noticed an issue after deploying a custom theme build to a Go Daddy Managed WordPress installation (client's request, RIP) wherein users created by the admin account in the WP back-end weren't ...
0
votes
6answers
25k 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 ...
0
votes
3answers
444 views

lost all the links in WordPress after changing hosting

I am moving my wordpress website from one hosting to another. i moved my file(from filesmanager) correctly i export database from phpmyadmin to new host phpmyadmin Home page working fine (http://...
0
votes
1answer
4k views

#1062 - Duplicate entry '1' for key 'PRIMARY'

I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me with this? #1062 - Duplicate entry '1' for key 'PRIMARY'
0
votes
1answer
376 views

How to retrieve user data based on role using SQL?

I need to retrieve user data from SQL database and I have managed to do it with the SQL code given below: SELECT wpu6_users.display_name AS n_user_display_name, t1.meta_value AS ...
0
votes
1answer
68 views

I want to create a 300 multi-site wordpress network using subdomains

This is the network on this site and i have two multi-sites apart from the main one, what i want to know that, can i create this many multi-sites, without the network crashing or having too much ...
0
votes
1answer
312 views

I can not access my local PhpMyAdmin control panel

I have created a local WordPress (WP) website on my computer using the limited edition of DesktopServer. I then used FileZilla to download the WP files along with the associated database. Now I cannot ...
1
vote
1answer
350 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
0answers
15 views

Lamp stack not supporting phpmyadmin? [closed]

I have install lamp stack + word-press in my Ubuntu 16.04, in that apache2 , word-press is running but when i try to run phpmyadmin is not running i need to create new database so how to run ...
0
votes
2answers
3k views

Wordpress redirects to old login after migration

I've followed all the steps for migrating my existing wordpress site to another server. However, when I try to login to the migrated site, it keeps redirecting me to the old one, despite whether I use ...
1
vote
1answer
723 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
1answer
16k 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?