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
votes
0answers
11 views

Run a query to convert bitweaver table syntax to HTML table format

I have imported content into WP from a wiki page that was using bitweaver...the format of the tables in the wiki platform are quite different and i wonder if there is a query i can run in phpmyadmin ...
0
votes
2answers
36 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
11 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
0answers
13 views

Automate Search Replace wp_posts content

I am currently replacing wp_posts content using the below sql query update wp_posts set post_content = replace(post_content,'old text','new text'); I use phpmyadmin currently. However I would want ...
0
votes
0answers
14 views

Exporting a multisite DB for a single site production site

So I have a wordpress multisite that houses all of my client test sites(14). This means that its all one database obviously. This client is now ready to go live on a single wordpress instance so I'm ...
-1
votes
1answer
35 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
19 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
0answers
26 views

More than one multisites in localhost

I setup two wordpress multisites in my localhost. When I configured the second one then first multisite broken. When I checked the .htaccess file the configuration for second one automatically updated ...
0
votes
0answers
50 views

How to delete a stuck post using phpMyAdmin

I was attempting to change some leftover http:// references in the DB using Update/Set SQL statements. I was getting confident and started doing them in bulk and stopped noting exactly what I was ...
0
votes
0answers
30 views

How can i move something from user panel to frontend user edit

Hellow stackexchange, How can i move this : It's from a widget that put that there and i want to move it here: On Frontend user edit panel. I look into the widget code and i try something but ...
0
votes
1answer
20 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 ...
0
votes
0answers
23 views

user_id increment?

I wanted an Admin account with user_id 999 in our database, so I changed some settings in the database according to http://www.wpwhitesecurity.com/wordpress-security/change-wordpress-administrator-id/....
1
vote
0answers
36 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
52 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
24 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
222 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
57 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
47 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
47 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
101 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
16 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
29 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
57 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
22 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
1answer
41 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
76 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
68 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
25 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
9 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
311 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
1answer
105 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
2k 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
147 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
209 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 50,...
0
votes
0answers
119 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
67 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
14 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
33 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
53 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
122 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
74 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
348 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
1answer
36 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
457 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
104 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
31 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
397 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
13k 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 ...