Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
1answer
10 views

Duplicate database to roll back theme & content changes

I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-...
-1
votes
0answers
7 views

Product attributes show up in admin panel but not anywhere in the database

I have a WooCommerce site on which I had a person work on with a custom products importer. The importer was supposed to loop through a csv file, add products, prices, stock etc, as well as search ...
0
votes
1answer
41 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
67 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 ...
0
votes
1answer
34 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 ...
1
vote
1answer
41 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
0answers
19 views

Mapping DNS with the IP in my server

I got a domain and I administer it through Cloudflare, and I have my server (a virtual machine with ubuntu that I control through SSH) with wordpress installed, when I write the IP of my server in the ...
0
votes
0answers
12 views

Why can't I use Kanjis on permalink? [duplicate]

I've already read the 'What topics can I ask about here?' section but I'm still not sure if I can ask this type of question here, so here it goes. I'm starting a blog about the Japanese language. I ...
0
votes
1answer
26 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
49 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 ...
0
votes
0answers
14 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
27 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
34 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 ...
1
vote
1answer
281 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 ...
0
votes
0answers
229 views

Set stock status thru SQL EVENT

I would like to update my stock status thru SQL. Every night my products stock is updating by cron. Unfortunately stock status is not updating and many products with 0 stock are "in stock". So I ...
0
votes
2answers
28 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 ...
1
vote
0answers
45 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 ...
0
votes
1answer
51 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 ...
1
vote
1answer
226 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 ...
0
votes
1answer
563 views

Export Yoast Keywords from MySQL/phpMyAdmin

I'd like to export all focus keywords from Yoast, as we're moving platforms to Craft CMS and using a similar tool, Ethercreative's SEO tool. I'd love a good query to pull these from the database, ...
0
votes
1answer
76 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 ...
1
vote
2answers
158 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 ...
0
votes
0answers
157 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....
0
votes
1answer
51 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
1k 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
78 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
74 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 ?
0
votes
3answers
74 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
1answer
581 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
33 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
28 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
3answers
126 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://...
1
vote
1answer
329 views

Adding user data to an existing user_id

I'm using phpMyAdmin to add some new user records to the existing users within a WordPress database. The database is for a WordPress Multisite network. I had to migrate my old WP site to the new site,...
0
votes
1answer
142 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
178 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
61 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 ...
1
vote
2answers
1k 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` ...
0
votes
1answer
107 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 ...
2
votes
1answer
37 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 ...
0
votes
1answer
236 views

Changing Wordpress author name in database

I originally begun my wordpress site using a psudonym. Over the past few years I have been attributing my own name to all articles and have had the author name options switched off. Now I'm changing ...
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
2k 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
350 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
0answers
12 views

import posts with dutch/special letters

I am importing posts from a csv file using the plugin Really Simple CSV Importer. I am uploading some posts in dutch language. The plugin uploads all the posts nicely but fails for the post which has ...
0
votes
1answer
230 views

Changing a Child theme's name on MAMP localhost

I would like to change the child-theme name on my localhost (MAMP) set up for a project I'm working on. Obviously changing the folder name is easy enough, as is changing the child-theme's name in the ...
0
votes
2answers
943 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
1answer
260 views

Editing mysql tables/database with wordpress or other app/cms

I have a particular use case which i am not sure is common or suitable to wordpress. I have built a website without using wordpress using html css javascript and have it connected to a custom mysql ...
0
votes
1answer
815 views

Changing the entire permalink

I have a plugin that creates a custom post. I want to change the permalink from: https://[site name]/lesson/lesson-1/ To: https://[site name]/learn/lesson1.php Through the wp admin interface, I can ...
1
vote
1answer
28 views

Will changing the folder name two directories above a fresh wordpress installation break the site?

I have a client who would like two Wordpress installs on his LAMP stack. The thing is he forgot to give me the directory names that he wants them on. So as per standard LAMP stack each site will be /...
2
votes
3answers
394 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 ...