The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
116 views

#1273 - Unknown collation: 'utf8mb4_unicode_ci' [on hold]

I'm trying to migrate my site from hostgator to local windows on desktopserver - and when I try to import the database I get this error: 1273 - Unknown collation: 'utf8mb4_unicode_ci' I've been ...
0
votes
1answer
43 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
30 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
29 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
51 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
12 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
22 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
101 views

MySQL 1005 ErrNo 1 - “can't create table” when importing DB backup into phpmyadmin?

I have been developing a WordPress site locally using the following mysql version: LOCAL DATABASE SERVER: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.40-0ubuntu0.14.04.1 ...
0
votes
0answers
41 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
51 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
43 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
104 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
20 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
739 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
0answers
24 views

Assigning Terms in Taxonomy to Custom Taxonomy

I had a site with posts, in which I exported posts and imported those posts as a CPT (Junior) in my localhost installation. For doing this, I opened the .xml file (export file) and replaced every ...
0
votes
1answer
197 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
66 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
26 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
281 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
6k 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
99 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
186 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
250 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
670 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
205 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
208 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
62 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
145 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
67 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
159 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 ...
1
vote
2answers
531 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
2answers
232 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
274 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
1k 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
281 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
386 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
614 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 ...
1
vote
2answers
156 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
87 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
2k 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
463 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
681 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
170 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
4k 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
4k 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
2k 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
412 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
44 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
429 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 ...