Questions tagged [export]

Saving data for posts, pages, custom post types, comments, custom fields, categories, tags, custom taxonomies, and users. Usually used to migrate to another hosting or add data to another WordPress website.

Filter by
Sorted by
Tagged with
24
votes
2answers
73k views

Where does the Media Library live in the database?

I'm exporting a Wordpress site from localhost to a web host, and I am unable to import the Media Library, as the web host is unable to contact localhost. I've uploaded all of the localhost files from ...
20
votes
7answers
28k views

How do I export my WordPress blog as a book? [closed]

I want to export some or all of the posts of a blog into a format that makes sense to a publisher (traditional or self-publisher(e.g.: Lulu.com)) (MS Word, RTF, PDF, epub, something else). What tools ...
13
votes
7answers
36k views

Failed to import Media

When I generate XML file with [Tools > Export] and use [Tools > Import] on another WordPress website I get "Failed to import Media" for each attachment post type. And images that failed to load are ...
11
votes
1answer
1k views

Plugin API for easy admin list table generation, handling & exporting of MySQL tables?

I'm aware of the WP_List_Table class (which has helped tremendously as it stands). However, I'm hunting for something even more capable - some form of API whereby you could simply 'register' a MySQL ...
10
votes
5answers
22k views

How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms

I want to export all Wordpress categories (no posts, just categories) from one blog to another. How can I do that ?
8
votes
2answers
597 views

I want to develop locally with Multisite, then migrate each site to separate remote WP installs

I use WordPress for the majority of my client work. I develop locally with MAMP and then move the sites to the remote server when its time to go live or show the client the progress. I just migrate ...
8
votes
1answer
650 views

WP_User_Query and non-unique usermeta data

We have an issue with a WP plugin that we wrote and maintain - Export User Data A user has reported an issue that non-unique user meta data records are not being returned correctly - here In the ...
8
votes
1answer
13k views

How to export comments in WordPress?

I want to export my comments to Excel, PDF or Word. The format really doesn't matter, I just want them exported. I tried the Export Comments plugin, the standard one, but couldn't get it to work, I ...
7
votes
3answers
11k 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 DATABASE_NAME > filename.sql Import: mysql -u USERNAME -p DATABASE_NAME ...
7
votes
2answers
1k views

Is it possible to “freeze” a WordPress blog?

I'm currently running a 365 photos project and it's based on a WordPress platform. Currently this is very helpful because I can upload the photos easily and manage comments and stuff. Because we are ...
6
votes
2answers
1k views

Export specific menu [duplicate]

How can I export a specific menu out of wordpress? I have a list with many URLs and I need to copy it to multiple sites. But I don't want to do it manually.
5
votes
4answers
5k views

Export all posts as individual plain txt files

I wish to export all of my posts as individual plain text files. So, the format may be something like: title.txt   Title: title Pub date: date Category: cat Lorem ipsum dolor sit amet, ...
5
votes
2answers
3k views

WordPress Theme Options Import/Export

I already have a theme options page that saves to wp_options > kittens_options. I'm looking for a simple way to incorporate an import/export textarea of those options on my options page. I've ...
5
votes
2answers
20k views

Import posts with featured images

I am trying to make an import of posts from my old blog installation. It works fine for posts content but fails for featured images. I've done: tools -> export -> posts -> selected a category. In ...
4
votes
2answers
9k views

One Click demo content installation feature in WordPress theme options panel

I've been seeing a feature of one click demo content installation option on some powerful WordPress themes now a days. Mostly on Themeforest themes. I'd like to know if anyone have any idea about the ...
4
votes
1answer
3k views

Is it possible to export WordPress from command line?

Is it possible to export WordPress from command line? I don't mean use mysqldump to export the database, but create the xml file used to easily import to another WordPress installation.
4
votes
3answers
2k views

Best way to import users, post and categories from an external database

I need to migrate an existing website to WordPress. This website already has a basic database containing users and posts (with a category), but it also has a high number of records so it's not ...
4
votes
6answers
1k views

Most Flawless Way To Transfer from Dev to Prod [duplicate]

Possible Duplicate: Easily Move a WordPress Install from Development to Production? So I've been working with WordPress for a while now and I usually develop locally and then upload everything to ...
4
votes
2answers
521 views

Blog Settings import/export in Wordpress Network environment

I can't use PHPMyAdmin to export/import my blogs from one server to an other because I'm using Wordpress Network. Export/import works pretty well for Posts, custom posts types and their media, but ...
4
votes
1answer
3k views

Problem: Create a cron job to export posts to a WordPress XML file on server

I need a way to automatically export all WordPress posts from a specific date and have it output the file on the server that can be downloaded daily. The reason the XML format is needed is because ...
3
votes
4answers
2k views

Migrating WP site to another URL

We are planning to change the domain name of our website.We are not changing the host but creating a new domain and will close/redirect all traffic to new domain (there will be not update on the old ...
3
votes
1answer
7k views

How to Create Export/Import Functionality for Plugin

I am following the tutorial here http://wp.tutsplus.com/tutorials/creative-coding/creating-a-simple-backuprestore-settings-feature/ The script shows how to export all options into JSON. Since my ...
3
votes
4answers
1k views

How to migrate a WordPress installation from one site to another, including all images?

I need to move a WordPress site hosted on Dream Host to the companies servers. To do so I used the built in import and export feature that comes with WordPress (using a WordPress export file). However,...
3
votes
1answer
2k views

How can I get an XML export of my 1K+ posts WordPress instance?

I'd like to export my database to XML because the import script to my new blog already supports getting data from that. A database backup or wordpress clone is not that useful in this case. The ...
3
votes
1answer
717 views

How do I add paragraph tags to all of my posts after relying on wpauto?

I found a way to export my posts in text form so that I can move them to a blog with static pages. The only problem is that there are no paragraph tags, so every post is a huge block of text. I had ...
3
votes
1answer
2k views

Export WP database for import using WP-CLI on Vagrant Box

Problem Now that I have a new environment with WP-CLI db import / export I need to import a database from a website that never had WP-CLI installed. Question What's the best Non-WP-CLI export ...
3
votes
1answer
8k views

Wordpress Export Import Site Navigation Menu

When I do an export and import the menus get transferred but I have to set the Site Navigation Menu manualy. Obviously it's only a small detail but can I ask is this a bug or expected behaviour and is ...
3
votes
2answers
6k views

How can I export WordPress posts' attachments?

I am in the process of transferring posts from one WordPress install to another. I can use WordPress' Tools --> Export to export the XML I need for my posts. On the new install, I then use Tools --> ...
3
votes
2answers
830 views

How to completely export and import WordPress?

I exported all posts of a WordPress blog. Then I imported the xml file to another WordPress blog. When I tried to search few posts in the new blog, which are in the old blog, I did not find anything. ...
3
votes
2answers
1k views

Non-Linear Questionnaires in Wordpress

I want to make the following happen in Wordpress People answer questions in paginated or single page form. Each next set of options is dependent on the option the user selects preiviously At the end,...
3
votes
2answers
8k views

Import and replace existing page/post content

Is there any way to import a basic, exported Wordpress content XML file and have it replace the existing content? What I'm trying to do is synch up two instances of a site (development and staging ...
3
votes
2answers
205 views

Import and export links from WordPress.com to private site

Is there some way to export/import links from a wordpress.com site to a private site? I have a rather large directory of links. I fetch the opml file and the category levels are there, but when I use ...
3
votes
1answer
25 views

Suggestions for WPMU Migration (advanced)

We have a multisite network with a few hundred sites. We are currently merging with another company and migrating our sites. However we have a few clients who have decided to jump ship and are asking ...
2
votes
5answers
9k views

Export wordpress table to excel

I have created PHP scripts before to export a database table to .xls format like this: $select = "SELECT * FROM tracking"; $export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) )...
2
votes
2answers
11k views

Create a Static HTML Site from WordPress

A friend of mine is investigating the use of WordPress for a dynamic site with some hierarchy. Really, at the moment he just wants "nothing fancier than photos and links between pages," but knowing ...
2
votes
2answers
3k views

How to migrate Wordpress Blogs into Multisite without using the GUI-Import/Export Feature

I'd like to migrate some quite huge Wordpress-Blogs into one Multisite Installation. The Export-Wizard and the Import Wizard are bound to PHP-Limits (Memory, Execution-Time) and so the Export and ...
2
votes
1answer
15k views

Migrate WooCommerce Orders [closed]

I need to export/import all WooCommerce orders from a clients old website to their new website. We basically took their website, redesigned it but the install and everything is the same - besides ...
2
votes
1answer
482 views

Exporting Data from WordPress into a flat table

I need to be able to export the data within WordPress so that each object is contained in a single row, like a flat table. Imagine each post type as it's own database table, containing columns that ...
2
votes
2answers
2k views

Fixing media links after importing to multisite

When i imported all posts and media from a old site to new site which on wordpress multisite. The image links on posts are got broken because how media are stored on a multisite is quite different ...
2
votes
3answers
3k views

Download/View Schema (or DTD) for XML Import

Where can I download the schema (or DTD) for the layout of the WordPress import/export file format?
2
votes
1answer
2k views

Export posts to csv with data from ACF custom fields

I'm trying to export my posts from a custom post type to a csv file. The point I'd like to get back at later is that my posts have custom fields created using the Advanced Custom Fields plugin. I ...
2
votes
1answer
221 views

How do i export the HTML from text widgets?

I placed HTML in several text widgets which where lost after i deleted all inactive widgets and changed themes but i have found the data in the tables. The only problem, its mixed in with all this ...
2
votes
2answers
8k views

MySQL Syntax Error upon restoring database from backup [closed]

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 ...
2
votes
2answers
195 views

Is it possible to import a wordpress backup from a single site in to a multi-site configuration?

I have a local development server with WordPress installed (my desktop Linux Mint 12 box). I'd like to use multi-site WordPress to manage my different client projects through one install, but I have a ...
2
votes
1answer
3k views

What is the best way to export and import theme options?

So what is the best way to create an export and import feature, I tried serialize() and urlencode() on an array of options to be used in a url like so: export.php?data=(long string), and use $_GET ...
2
votes
2answers
4k views

Export a blog(not mine) as a PDF document

Is it possible to export the posts of a blog as a PDF? There is a blog with a couple of hundred posts that I'd like to read on my ereader, so I was wondering whether I could extract those posts into ...
2
votes
1answer
43 views

register_post_status invisible but searchable

I need to "hide" some old posts from the I decided to go with a custom post status to keep them hidden but available at a later time (keeps the admin cleaner..) BUT :) I would like to have the posts ...
2
votes
1answer
15k views

Export navigation menu

I want to export all navigation menu's from one site and import the menu's in another site. I have tried to export the tables: wp_posts wp_postmeta wp_terms wp_termmeta wp_term_relationships And ...
2
votes
1answer
408 views

Importing large data from blogger

My backup data from blogger is 56.3MB large. I tried importing using the Wordpress Blogger plugin. Because the data is too large, I had to configure my php.ini to increase the value of three ...
2
votes
1answer
653 views

WordPress (+WPMU) Import/Export ALL settings?

As we all know WordPress does not import Widgets when you import content with [Tools > Import] and I'm wondering what kind of script could do that? Database has more than just 1 single information ...