The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
21 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
48 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
1answer
805 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
44 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
72 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
65 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
157 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
92 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
104 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
40 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
54 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
19 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
35 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 ...
0
votes
2answers
102 views

Installing local to live WP into subdirectory

I am having a bit of trouble moving a local WP site live and into a subdirectory. I want a static homepage for now (index.html in the root folder) while I work on the live site (would be found in ...
0
votes
2answers
282 views

Importing wordpress. xml file on new installation

I am trying to move a wordpress installation to a new server. I usualy create a new database using phpmyadmin on the new server, import the sql file from the old server, then install wordpress but ...
0
votes
1answer
123 views

Accidentally deleted active_plugins portion of the wp_options DB table

Ok, so I'm pretty sure I'm screwed here, because I do not have a database backup, but I figured I'd ask just in case. Within PhpMyAdmin, I meant to just go to the wp_options table and empty out ...
0
votes
1answer
227 views

SQL: Select wordpress posts with given text string and add a custom field to them?

I want to select all wordpress posts that have a certain text string. Then to add a custom field to all those posts. Here is what I figured out so far but it doesn't work INSERT INTO wp_postmeta ...
0
votes
1answer
464 views

Trouble Installing Wordpress Get PHP Not Running Answer

I have seen this topic discussed several places on the internet, both in the Wordpress official forums and on individuals' blogs. Despite having worked through some of the suggestions, I am still ...
0
votes
1answer
143 views

Phpmyadmin - post editing

i am total newbie with phpmyadmin, and the first time i use it, was to delete a lot of spam comments.I m not sure is it possible to do what i want , but another option would be to go trough 400-500 ...
0
votes
2answers
236 views

Resetting menu_order to 0 for posts in PHPmyAdmin?

Installed a plugin that allows the re-ordering of posts from any post type / category / tag using a drag/drop interface. After some time of using, my post order went haywire and new posts began to ...
0
votes
2answers
307 views

How to copy post titles to post slug in phpmyadmin

I just imported 1000 post into a custom post type on a site and the slugs are all blank. There is a problem with the importing plugin i'm using. My SQL is weak :-/ know what i need to do but not sure ...
0
votes
0answers
27 views

Dissapered all posts by 2013 year

Dissaperd all posts posted in 2013. There are no posts, images and tags for this year. I've checked it in the phpMyAdmin and find them. But they don't shows in administrtor panel. Any idea? Thanks!
1
vote
2answers
147 views

Why do I get a WAMP homepage when clicking on specific website's URL on LocalHost?

Using WAMPSERVER for windows 7, smartgit and Safe Search Replace I have pulled a wordpress code from my git, downloaded a database and inserted into my localhost's phpmyadmin. My home page works but ...
1
vote
1answer
79 views

Delete all one-word comments

I'm trying to delete all wordpress comments with only one word. I found this mysql query to delete all comments at once, but that's not what I want to achieve: DELETE FROM wp_comments WHERE ...
0
votes
1answer
1k views

unable to upload image locally

I followed this tutorial on setting up a local web development setup without mamp. Now my problem is when I go to upload a image in WordPress I get the following error: “Screen Shot 2013-01-05 at ...
2
votes
2answers
404 views

How to do a MySQL dump from production site without using a search and replace script for local development?

I performed a MySQL dump of my WordPress production database to be imported into my local development environment. I plan on frequently performing this database dump and import. Is it possible for me ...
1
vote
1answer
362 views

Making someone a WordPress administrator using PhpMyAdmin

After database problems on my provider side, I had to reset my admin user password. But then this user was not an admin anymore. In PhpMyAdmin I see that it has a user_status value of 0. How can I ...
0
votes
2answers
140 views

Recovering a wordpress blog that got corrupted

recently i had my blog up and running, but i installed some new software by accident and messed it up.i have reinstalled my word press, and i was wondering is there a way i can recover my old post? I ...
0
votes
1answer
3k views

Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?

Is it possible to backup files from a old hard drive without having access to phpmyadmin? Could someone point me in the right direction?
0
votes
4answers
3k views

Manually delete post from database

For whatever reason, I have a post and a page with the same slug name and it causes the db to hang. I can't alter the slug on either so I need to go manually delete the posts from the database and ...
0
votes
4answers
1k views

Reseting admin password through PHPMyadmin fails

Following the PHPMyAdmin instructions of this article fails to reset my password properly. I go into WP_Users, find my admin account, click edit, enter my password, change the dropdown to MD5, click ...
2
votes
2answers
368 views

Moving database with phpMyAdmin

I have a remote (website) version of a wordpress site and it's got more recent information than my local (computer) version. I would like to move the data over to my local using phpMyAdmin, what is ...
0
votes
1answer
43 views

How to migrate a database from a server to another

I try the export method of phpmyadmin, but the user is exported with the data... so there is no way to re import it into another database without error message. The old user is name : ...
0
votes
1answer
301 views

Export posts with postmeta without ID?

I have some select posts on one database that I need to export and import into a different database. Because both databases are operating independently, there is overlap with post IDs so I can't ...
0
votes
1answer
587 views

Export SQL query based on custom field?

I'm operating on two WordPress sites and I need to export posts only with a specific custom field from one site and import into the other. I can't do a generic dump of the database because some data ...
0
votes
4answers
4k views

How can I restore admin capabilities?

So yeah, I'm a genius. I managed delete all my admin capabilities (thank you very much Membership plugin). I could restore them, ...if I had admin access, lol. Anywhoo, how can I give all my ...
0
votes
1answer
73 views

How can I get posts from 9/13/11 to today with SQL? [closed]

I have been working with a client to redesign his site and we are at the stage where we are going live, except I'm running into a little problem. Time is of the essence, as the deadline is mid-day ...
1
vote
1answer
312 views

Query to import data from one MultiSite table to another (pages/sub-pages)

I'm updating a standard install with about 500 (eek!!) pages to a MultiSite for easier sub-site management. I basically want to take a sub-page and its children from the root site and copy the data ...
0
votes
1answer
414 views

How do i edit the plugin files in DataBase via phpMyAdmin?

I need guidance to edit the WordPress plugin and theme files via phpmyadmin If I want to edit a particular plugin file or remove a plugin completely from database, I could able to find them ,but I ...
1
vote
1answer
499 views

How to add an export function to a custom Option Theme Page

I'm creating a new Wordpress template and I have a question: I've added a custom Option Page to my new template (you can see what I'm doing Here and Here) but now I would like to add a new function. ...
4
votes
1answer
404 views

What specific database privileges does WordPress need?

I want to create a new database user for my WordPress installation. Usually on localhost, i can just use root, but it is good practice to use a user with as little rights as possible. What are those ...