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
1
vote
3answers
958 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
395 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
140 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
202 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
130 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
119 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
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
51 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
36 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
410 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
799 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
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
373 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 ...
2
votes
3answers
7k 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
302 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
47 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
555 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
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
677 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
14 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
350 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
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
1answer
376 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
1k 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
29 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
681 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
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 ...
1
vote
1answer
29 views

Backing up and restoring multiple sites efficiently

We are offering complete website backup and restore services once per month to our clients. 90% of the sites are WordPress but hosted in a variety of hosting facilities with varying access (some ...
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 ...
1
vote
1answer
325 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.
3
votes
4answers
10k 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'...
0
votes
1answer
209 views

Wordpress character set issue

I'm currently migrating a wordpress site to a live server. When trying to import my database via phpMyAdmin I run across the following error below: Error CREATE TABLE `wp_commentmeta` ( `...
0
votes
1answer
741 views

Update custom table on metabox POST

So here is the problem : I have created a metabox field for my posts and I want it to update a custom table (wp_location) in my WP datase... The idea is to update the table with the value of the POST ...
0
votes
1answer
151 views

Need to change all links in page content but not in post content

So usually I would just do a database search and replace for changing my URL but what I've done now is decided to split my site into two different sites which works great for me because of the way I ...
0
votes
0answers
136 views

how to search wordpress database for slug names [duplicate]

I'm trying to rename one of my pages to 2017 and the slug to 2017 as well. When i click save the slug is renamed to 2017-2. To me this means something else is using this slug, but i'm not sure how ...
0
votes
1answer
89 views

Error while submitting form using AJAX and php

Hii i am trying to save data of form to user meta data table by using javascript, AJAX and php. Here is my code HTML Form: <form id="savem" method="post"> <input type="text" name="...
0
votes
1answer
48 views

Way to send multiple values for column to MySQL?

I am creating a plugin that allows the user to select multiple options (as a checkbox), which sends these integer values to MySQL. The way I have this set up at the moment is by taking these values ...
1
vote
3answers
9k 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 ...
0
votes
1answer
755 views

SELECT SQL_CALC_FOUND_ROWS with wordpress search

When I make a search on my site no posts are retrieved and through wordpress debug I get this error message: WordPress database error: [Table 'theme_se.wp_comments' doesn't exist] SELECT ...
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 , ...
0
votes
1answer
609 views

Missing latest posts and options after DB migration via phpMyAdmin

The latest posts and options are not appearing after importing the database. I'm missing all the latest posts and the latest Advanced Custom Fields. The export is from the remote server and import to ...
0
votes
1answer
108 views

wp_login.php redirects to old domain

i changed my domain name associated with my hosting account yesterday when i click on http://mynewdomain.com/wp_login.php it redirects to http://myolddomain.com i already changed the siteurl in ...
1
vote
0answers
94 views

MySql query to get posts with all meta and terms

I'm trying to figureout a way to get all fields from wp_post with all of their custom fields and categories in one mysql query. So in one row of the result I should have post fields with their custom ...
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'
1
vote
0answers
56 views

Restose content from revisions - sql query

How i can restore all posts to the closest revision to a particular date via sql query?
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 ...
1
vote
1answer
309 views

$wpdb to insert html form information

I'm trying to insert posted variables from a form. When I shorten the amount of variables I'm inserting it will sometime pass the information in my mysql database. Once I continue to add on ...