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
2
votes
2answers
464 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
59 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
1k 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
2k 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
6answers
24k 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
82 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
382 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
2k 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
655 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
567 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 ...

1 2 3 4