Questions tagged [phpmyadmin]

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

72 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Duplicate database to roll back theme & content changes

I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-...
0
votes
1answer
455 views

WP website showing blank page after moving from subdomain to main domain

I created my website on the subfolder https://www.lokaction.be/dev/. After it was finished, I moved the website's files to the main adress https://www.lokaction.be/ (ftp). And after that, I edited ...
0
votes
0answers
32 views

duplicate wordpress site on same bdd

I have only one bdd with 2 wordpress sites : first with _wp suffix second with _wp2 suffix. For the url : mydomain/site1 mydomain/site2 Now i need to duplicate the site2 as site3 (mydomain/site3) ...
0
votes
0answers
531 views

An SQL query to find orphaned image attachments and their meta

This is for people who are good with MySQL queries. I'm using phpMyAdmin locally to try to optimize an old WordPress & Woocommerce site which has gone through a couple of iterations over the years....
0
votes
1answer
246 views

Change Custom Post Type to Post + Category

I have a rather difficult problem, I have a news site and I used a custom template with custom post-types for each "category" and now I want to change the template, but I can not change the posts for ...
0
votes
0answers
206 views

Adding wordpress posts using phpmyadmin

I am trying to add wordpress posts exported from phpmyadmin into a site that already has wordpress posts. The process would work fine if the site I am trying to upload the sql file to was a brand ...
0
votes
1answer
220 views

403 Forbidden Localhost Wamp Apache Php

I’m completely new to wordpress/website design and I’m following a tutorial on youtube about creating custom themes. I’ve set up a website in localhost and I’m using permalinks to navigate to pages in ...
0
votes
1answer
415 views

How to retrieve user data based on role using SQL?

I need to retrieve user data from SQL database and I have managed to do it with the SQL code given below: SELECT wpu6_users.display_name AS n_user_display_name, t1.meta_value AS ...
0
votes
1answer
325 views

I can not access my local PhpMyAdmin control panel

I have created a local WordPress (WP) website on my computer using the limited edition of DesktopServer. I then used FileZilla to download the WP files along with the associated database. Now I cannot ...
0
votes
2answers
1k views

Changing Wordpress author name in database

I originally begun my wordpress site using a psudonym. Over the past few years I have been attributing my own name to all articles and have had the author name options switched off. Now I'm changing ...
0
votes
1answer
219 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
136 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
703 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
1answer
110 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
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
19 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
0answers
94 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
5answers
292 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
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
701 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 `...
-1
votes
1answer
4k views

cannot log in to the mysql server (wamp and wordpress)

When I run wamp (an offline webserver) and then run phpmyadmin, user and password are asked. I haven't used wamp in a while so basically I forgot user and password. I've followed some guides like this ...
-1
votes
1answer
2k 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 ...

1
2