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
0
votes
1answer
1k 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 ...
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
366 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
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 ...
0
votes
1answer
381 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 ...
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 /...
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 ...
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
760 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
160 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
182 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
92 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
49 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
5answers
10k 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 ...
0
votes
1answer
784 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
77 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 ...
0
votes
1answer
109 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 ...
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?
0
votes
4answers
67 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 ...
1
vote
1answer
322 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 ...
1
vote
1answer
3k 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
3answers
123 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 ...
0
votes
1answer
259 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
0answers
26 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
63 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
1answer
227 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
23 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
1answer
17 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
758 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 ...
1
vote
1answer
2k 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 -...
1
vote
2answers
2k 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 ...
1
vote
1answer
390 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
874 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,...
1
vote
2answers
80 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
1answer
46 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
93 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
1k 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 ...
1
vote
2answers
2k 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
2answers
21k 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
0answers
37 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
661 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
636 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 root/...
0
votes
2answers
5k 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
768 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 > '" . date('Y-...
0
votes
1answer
1k 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
756 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
2answers
27 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
867 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
1answer
747 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 (...