Title: Can't export wp_posts table in phpmyadmin
Last modified: August 19, 2016

---

# Can't export wp_posts table in phpmyadmin

 *  [Z](https://wordpress.org/support/users/collegefashion/)
 * (@collegefashion)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/cant-export-wp_posts-table-in-phpmyadmin/)
 * Hi there,
 * I’m having a really strange and pervasive error when trying to export my wordpress
   database in phpmyadmin. Whenever I try to export the database, I get the following
   error:
 * > File not found
   > Firefox can’t find the file at [https://mysite.com/domains/databases/phpMyAdmin/export.php](https://mysite.com/domains/databases/phpMyAdmin/export.php).
   >  * Check the file name for capitalization or other typing errors.
   >  * Check 
   > to see if the file was moved, renamed or deleted.
 * I’ve tested exporting the tables separately, and **I have isolated wp_posts, 
   which is large, at 400+ MB, as the problem.** I can export all the other tables
   just fine, but trying to export wp_posts, whether alone or in combination with
   other tables, won’t work and throws the error.
 * Any thoughts? Is my wp_posts table corrupt? I have a very large site with thousands
   of posts so deleting it is not an option. Any help would be greatly appreciated!

Viewing 1 replies (of 1 total)

 *  [Veronika P.](https://wordpress.org/support/users/veronika-p/)
 * (@veronika-p)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/cant-export-wp_posts-table-in-phpmyadmin/#post-1946783)
 * Hey Z,
 * I see that your post is three month old so I guess that you are maybe not that
   interested in my solution by now. But if anybody else finds this post, he or 
   she may have a use for my workaround 🙂
 * I had the same problem today and what worked for me was this:
 * 1. in the database of the old blog: instead of exporting the whole wp_posts-table
   as a file I unchecked “send” in the export-dialogue, clicked “ok” and thereby
   received the SQL-statements for the table.
 * 2. I copied only the SQL-statements for the table structure but not the statements
   for the table data, i.e.
 * > CREATE TABLE IF NOT EXISTS `wpsj_posts` (
   >  `ID` bigint(20) unsigned NOT NULL
   > AUTO_INCREMENT, `post_author` bigint(20) unsigned NOT NULL DEFAULT ‘0’, `post_date`
   > datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `post_date_gmt` datetime NOT
   > NULL DEFAULT ‘0000-00-00 00:00:00’, `post_content` longtext NOT NULL, `post_title`
   > text NOT NULL, `post_excerpt` text NOT NULL, `post_status` varchar(20) NOT 
   > NULL DEFAULT ‘publish’, `comment_status` varchar(20) NOT NULL DEFAULT ‘open’,`
   > ping_status` varchar(20) NOT NULL DEFAULT ‘open’, `post_password` varchar(20)
   > NOT NULL DEFAULT ”, `post_name` varchar(200) NOT NULL DEFAULT ”, `to_ping` 
   > text NOT NULL, `pinged` text NOT NULL, `post_modified` datetime NOT NULL DEFAULT‘
   > 0000-00-00 00:00:00’, `post_modified_gmt` datetime NOT NULL DEFAULT ‘0000-00-
   > 00 00:00:00’, `post_content_filtered` text NOT NULL, `post_parent` bigint(20)
   > unsigned NOT NULL DEFAULT ‘0’, `guid` varchar(255) NOT NULL DEFAULT ”, `menu_order`
   > int(11) NOT NULL DEFAULT ‘0’, `post_type` varchar(20) NOT NULL DEFAULT ‘post’,`
   > post_mime_type` varchar(100) NOT NULL DEFAULT ”, `comment_count` bigint(20)
   > NOT NULL DEFAULT ‘0’, PRIMARY KEY (`ID`), KEY `post_name` (`post_name`), KEY`
   > type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), KEY `post_parent`(`
   > post_parent`), KEY `post_author` (`post_author`) ) ENGINE=MyISAM DEFAULT CHARSET
   > =utf8 AUTO_INCREMENT=294 ;
 * into the SQL command-line window of the database of the new blog.
 * 3. I used the WordPress tool “export data” in my old blog to download an xml-
   file with all posts and articles in it .
 * 4. I used the WordPress tool “import data” with this xml-file to import all posts
   and articles into my new blog.
 * 5. I was pleased to see that these steps resulted in a working wp_posts database
   table and noticed that this new table was considerably shorter than the old table(
   2 pages instead of 9) but had all articles and pages in it.
 * I hope this helps 🙂

Viewing 1 replies (of 1 total)

The topic ‘Can't export wp_posts table in phpmyadmin’ is closed to new replies.

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [file not found](https://wordpress.org/support/topic-tag/file-not-found/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [wp_posts](https://wordpress.org/support/topic-tag/wp_posts/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Veronika P.](https://wordpress.org/support/users/veronika-p/)
 * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/cant-export-wp_posts-table-in-phpmyadmin/#post-1946783)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics