Tagged Questions
0
votes
2answers
67 views
MySQL Syntax Error upon restoring database from backup
Performed a bad import to my Wordpress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier.
Dropped all tables in the database and then did an import from my ...
3
votes
2answers
358 views
How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
Normally, a MySQL database can be exported and imported using these simple SSH commands:
Export:
mysqldump -u USERNAME -p PASSWORD DATABASE_NAME > filename.sql
Import:
mysql -u USERNAME -p ...
0
votes
1answer
184 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
429 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
2answers
621 views
export individual posts to text files or a single csv file
I'd like to export my blog posts to plain text files so I can version control and update them using emacs org-mode via the org2blog package. However, I'm unfamiliar with SQL and the wordpress ...
0
votes
1answer
1k views
How to Mirror WordPress database from Remote server to Local server
Before I embark on this tutorial from the WordPress Codex on mirroring a WordPress database from a remote server to a local one. I'd like to get some feedback from SE users who have successfully ...
