Questions tagged [phpmyadmin]

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

-2
votes
0answers
13 views

Any way to optimise wordpress database?

Any way to optimise wordpress database? I dont need manual work ,or plugin is dere any crons job
0
votes
0answers
22 views

Login issue in Wordpress

I'm facing currently an issue with my wordpress site, i don't know exactly what happened but when i try to login from /wp-admin i enter my password and i connect, but naturaly after the session dies i ...
0
votes
1answer
12 views

syntax error for changing user role from database

I want to change user role from the database, UPDATE wp_usermeta SET meta_value = 'a:1:{s:10:"subscriber";b:1;}' WHERE meta_key = 'wp_capabilities' AND meta_value = 'a:1:{s:9:"wpas_user";b:1;}'; ...
0
votes
1answer
28 views

Changing root password in PHPMyAdmin for Wordpress Database when going live

Is it a good idea to create a password and make your password secure for your Wordpress database when uploading the database to a third-party web host (going live instead of hosting on localhost) ...
0
votes
0answers
24 views

Reset post IDs with all post meta

I imported posts from an old website. Posts from the new website have IDs under 100. Posts from the old website have IDs above 9934. I tried to change manually the post IDs in phpmyadmin in order to ...
0
votes
0answers
17 views

Export Custom post + WPML

Hi everybody I have a Main wordpress with 500 custom post type, some of them are in Spanish, some of them in other language through WPML. I need to export them into a new wordpress, but I only ...
0
votes
2answers
31 views

Setting up Wordpress Locally on WAMP for a new site (with one already)

Here are the steps I took in downloading and setting up WordPress on a WAMP (Windows, Apache2, MySQL, PHP): 1.) Download WAMP Server, here: WAMP Server Installation 2.) Download WordPress on ...
0
votes
1answer
14 views

Help locating old custom_css in PHP MyAdmin

I started developing a website, and midway through I changed the URL. I was and still am an amateur so unfortunately I've had some issues with the database now that I'm trying to go back and clean ...
0
votes
0answers
8 views

avoid duplicate content after migration

I've done a full migration of two wordpress site (transferring bunch of blogs). I see that there are few blogs that have been repeated twice. Like, after moving old blogs from old to new sites along ...
0
votes
1answer
25 views

Getting Error Trying to Create Table

I'm trying to create a new table in phpmyadmin. I'm using MAMP and this is of course inside wordpress. <?php function testtheme_database() { global $wpdb; global $testtheme_db_version; $...
0
votes
1answer
40 views

SQL query to bulk change short code in all posts

PHP/SQL noob here. Based on this question I attempted to change some entries in phpmyadmin for my wordpress blog: I want to all galleries to link to file instead to file attachment (add link="file" to ...
0
votes
0answers
15 views

Moving attachment postmeta rows to new database

I am moving a lot of content from one existing (and damaged) Wordpress installation to another existing installation. I am trying to bring the media library attachments into the new site, but when I ...
0
votes
2answers
40 views

Importing posts content from csv

I want to export some specific posts from my database (csv or sql) and then replace content to these and import them back without changing the id number of the posts.I s this possible to do it and if ...
1
vote
1answer
38 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 ...
1
vote
0answers
22 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 ...
0
votes
1answer
16 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-...
0
votes
1answer
97 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
83 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
51 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
276 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
34 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
92 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 ...
1
vote
0answers
85 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
29 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
83 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
2answers
763 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
2answers
35 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
77 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
100 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
317 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
983 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
138 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
3answers
467 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
252 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
82 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
3k 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
156 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
103 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
91 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
1k 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
37 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
31 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
257 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
546 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
196 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
304 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
66 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
3k 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
223 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
45 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 ...