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

learn more… | top users | synonyms

1
vote
0answers
21 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
0answers
13 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
18 views

Restose content from revisions - sql query

How i can restore all posts to the closest revision to a particular date via sql query?
0
votes
1answer
43 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
25 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 ...
0
votes
4answers
46 views

POSTS list in WordPress by views

I need a code that causes: <?php while ( have_posts() ) : the_post(); ?> List according to the amount of VIEW, is like to list popular posts only that it will enter the table mh_postmeta, and ...
0
votes
3answers
30 views

What will happen if I delete all my attachment type posts from database?

OK maybe I'm a bit hysterical about performance, but I don't see any reason to have more than double the post entries I need in my database. I mean every image automatically creates an attachment ...
1
vote
1answer
33 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 ...
0
votes
0answers
14 views

Editing a Wordpress SQL table in Phpmyadmin, however its not saving

I'm trying to edit the wp_options table in Phpmyadmin, I can edit it fine using inline editing or the edit feature. Each time I log into phpmyadmin I can see the value has changed to the one I edited. ...
0
votes
1answer
16 views

How can I use WP_Query argument 'Like %..%'?

I didn't find a good headline but this is my problem: I have this code (works fine!): $resume_args = array(); $resume_args['post_type'] = 'resume'; $resume_args['posts_per_page'] = 7; ...
0
votes
1answer
50 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 ...
0
votes
0answers
21 views

get backup file from wordpress database in x days

I have a wordpress website with so many posts and custom fields located in meta table. What I have to do is to make backup from each 30 days (for posts and postsmeta table) and append it to my last ...
0
votes
0answers
23 views

Search Replace long text string no action in phpmyadmin and not in Notepad++

After an update of my Avada Theme there is a new section widget that I like to use. To use it I need to replace a very long text string with a shorter text string. But somehow phpmyadmin and notepad++ ...
0
votes
1answer
32 views

Get category fixed in dropdown browse categories

I tried to get categories directly from phpmyadmin, but i can't. then i tried to create this php scrip in public_html include "wp-includes/category-template.php"; $args = array( ...
0
votes
0answers
42 views

import wp_post table to database issue

I am moving a production website to my local environment to build on a website. The problem is that I can't import the wp_post table in phpmyadmin. After a while it stops and tells me Script timeout ...
0
votes
1answer
62 views

Check if a database is well installed

I tried to install wordpress under eclipse and xampp under ubuntu. I created the database (user: root, password: empty) by a sql command create database wordpress;, that is it. The wordpress seems to ...
0
votes
1answer
19 views

Strings from database are not shown correctly

I created a table in database named (wp_answers) to get the Persian sentences. so I use get_charset_collate. Now the strings in database saved correctly. But when i want to fetch these strings, they ...
0
votes
0answers
24 views

Is it important to add Engine while importing database?

I am importing wordpress database sql file, but destination phpmyadmin not allowing to add ENGINE and CHARSET, But without that file imported and ENGINE, CHARSET is by default. Please tell me is it ...
0
votes
1answer
8 views

Changed meta_key value in structures, now dashboard shows zero users

I was trying to edit the email form field so that it accepts int values like of a phone number. I knew very less about how database values work and this is what i did: 1. Figured out that email field ...
0
votes
1answer
208 views

Post Views / Hit Counter Problem?

I have decide to use WordPress as a CMS to my 5 moths old website. I have already added all previous posts to my new site ( WordPress ). But now I need to change view counts to previous views counts. ...
0
votes
0answers
61 views

I would like to auto-install Wordpress on sub-domain

I am offering WordPress only hosting. I am using WHM/WHMCS automatically create a sub-domain and cpanel account for new clients after they place an order. I would like to automatically install ...
0
votes
1answer
83 views

Files on Localhost, Database on Server

With Wordpress, is it possible to work on localhost but have the DB on a server? So that workflow will be: 1) Work on localhost (but connected to remote database) 2) Upload JUST files via ...
0
votes
2answers
583 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 ...
0
votes
1answer
124 views

2 website 1 database… Local to online

I've two wordpress websites : - One online in FTP folder "www", for this website everything's ok ! - The second website is on localhost for the moment. I would like to put the second website on the ...
1
vote
0answers
159 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 ...
0
votes
0answers
106 views

Add a custom field via PhpMyAdmin to all posts and pages avoiding duplicates

I have about 200 pages and 400 posts on my WP site. And I need to add one custom field (sidebar_config: left-sidebar) to all pages and posts. I have this for SQL query in PhpMyAdmin: INSERT INTO ...
0
votes
2answers
63 views

Better way to migrate to server?

Migrating between local and server with Wordpress (SQL) is a bit time consuming, and I'm wondering if there is a better way to do it. With Drupal, there is a module called BackUp&Migrate, which ...
0
votes
0answers
13 views

What are the steps to migrating my blog to a new host?

I recently bought hosting service with Namecheap. I backed up my db from my previous host and now want to migrate everything. I was restoring the db with phpMyAdmin, uploading the sql file, but this ...
0
votes
1answer
32 views

Backing up Wordpress database and files

I've tried a few third party plugins for backing up my site, with some working well and others not so much, so I'm trying out backing up the site manually. Is there anything I'm missing here or is ...
0
votes
0answers
48 views

How to merge 2 WordPress sites?

I have 2 WordPress sites, A and B. Each of them has users and posts. Now, I want to merge these sites. Points to be noted- A has 1000 users and 2000 posts. B has 500 users and 3000 posts. There are ...
0
votes
1answer
96 views

Options table - where does my values go?

I just got my hand into wordpress and wp theme development. I know to create basic wordpress themes from scratch but I wondered how to get into custom theme options. My custom theme options (custom ...
0
votes
0answers
67 views

Unable to replace text string across site

There is a text string (a little over 1000 characters with spaces) that needs to be replaced across the entire of my website. The text recurs over 300 times on my site, is identical, and was been ...
0
votes
0answers
267 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 ...
0
votes
0answers
25 views

Change WordPress Multisite Domain

I created a multisite install on a development domain. Now, I want to change it over to my main domain. I've heard that I shouldn't do a database dump, and change everything with a text editor. I've ...
1
vote
1answer
1k 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 ...
0
votes
1answer
369 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 ...
0
votes
4answers
95 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
0answers
30 views

I would like to import two columns into Wordpress

Very easy- I would like to import two columns, list-id and slider in a CSV into my Wordpress database. list-id must match with Wordpress post. That's it I have used many Wordpress plugins, but they ...
0
votes
0answers
372 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
2answers
12k views

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

I'm new to PHP! I'm trying to import an SQL file using phpMyAdmin through a GoDaddy cPanel(please don't make fun of me) Here's a full readout -- -- Dumping data for table `wp_commentmeta` -- INSERT ...
0
votes
1answer
321 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
269 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 ...
0
votes
1answer
524 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 not ...
0
votes
2answers
1k views

Bulk delete WordPress posts with phpMyAdmin

I have over 8,000 posts generated by wp-o-matic and I want to get rid of all of them. I want to execute this query in phpMyAdmin. I just want to make sure this is safe to run and it's not wiping out ...
0
votes
1answer
279 views

List users with the most posts in the last 30 days

I'm trying to create a MySQL query to display a descending list of users with the most number of posts over the last 30 days. This is not working with me: $where .= " AND post_date > '" . ...
0
votes
1answer
313 views

Using mysql to replace img src?

I tried to use the Enable Media Replace Plugin to replace some images on my site with updated versions. There is an option to update all instances where the file is used on the site, but this only ...
0
votes
1answer
116 views

Plugin can't write to database even though permissions appear correct?

I'm using the Formidable Form plugin, and when I try to add a form, the form isn't saved. According to the developer, the user does not have sufficient permissions to write to the database. Here's how ...
0
votes
1answer
358 views

wp_option table error while importing

I am importing a huge database manually and i have a problem.The error it very vague to me, as i am not much familiar with mysql.The error says the following Its such data that i am unable to ...
0
votes
2answers
20 views

Database question while Migrating from one domain to another on same WebHost [Bluehost]

I am about to migrate WordPress Installation from One Domain to another which are under the same host and have common cpanel. Besides the first step of backing up and moving the WP filesystem, can we ...
0
votes
1answer
103 views

How to track who has deleted files

This is really strange, last night my wordpress has everything in woocommerce store and today all of sudden, the pictures and attributes are gone. How can i see or check wordpress log (if any) what ...