Exporting by table

While not directly answering the question, I would strongly recommend you use a DB management application. phpMyAdmin IMO is a nightmare to work with, and as you have discovered, very difficult to manage large files.

If you are on a Mac Sequal Pro is a really amazing app. If you don’t have external access to MySQL it supports SSH tunnelling so you can SSH to the DB server / a server with access to MySQL. You will be able to import / export pretty much any size DB with that.

If you are on windows, I have used a couple of different programs, I would recommend HeidiSQL. It can also do SSH tunnelling (little more effort required).

Related Posts:

  1. Where does the Media Library live in the database?
  2. Failed to import Media
  3. WordPress Theme Options Import/Export
  4. One Click demo content installation feature in WordPress theme options panel
  5. Import and replace existing page/post content
  6. Migrating WP site to another URL
  7. Import old SQL dump into new WordPress version
  8. How to migrate a WordPress installation from one site to another, including all images?
  9. How to completely export and import WordPress?
  10. Download/View Schema (or DTD) for XML Import
  11. GUID not updated on import
  12. Importing large data from blogger
  13. How to get and save WordPress content (html, css, images, videos) from a Java program?
  14. Update Attached Image Size after Import
  15. Export / import WordPress database
  16. Exporting and Importing WordPress Media Libraries and Galleries
  17. WordPress does not import all pages and post
  18. Problems with WordPress Import
  19. In What WordPress Version Was the Import/Export Tool Introduced?
  20. Moving WordPress site to an existing WordPress site
  21. Export Users From Live Site to Import onto staging
  22. Import subdomain WordPress into main domain WordPress
  23. Exporting featured image
  24. product export and import using xml
  25. Export WordPress from one domain to another domain
  26. Existing posts hidden after WP import
  27. WordPress importer – How to handle id clashes for featured images
  28. How to import several big Import XMLs?
  29. Merge two wordpress sites
  30. Moving 2 wordpress sites to one
  31. Export and import all Plugin options
  32. WXR? Export from Drupal 7 – import into WordPress
  33. WordPress Export/Import for custom options.php values?
  34. Java Package Does Not Exist Error
  35. ERROR 1148: The used command is not allowed with this MySQL version
  36. How to import wordpress posts with images from one wordpress site to another?
  37. What is the required format for importing posts into WordPress?
  38. Export navigation menu
  39. How to add featured thumbnail into import XML?
  40. Export WP database for import using WP-CLI on Vagrant Box
  41. How to re-Import the WordPress XML file after editing?
  42. Why shouldn’t @import be used to import a parent theme into a child theme?
  43. Moving a blog from Tumblr to WordPress
  44. Using the Importer on an IIS Server
  45. How can I export and then import posts with featured images?
  46. Does WordPress Import/Export tool actually exports media (images) as well?
  47. How to import a TypePad blog including all media?
  48. Convert WordPress.com embed links to normal embeds
  49. Creating a one click demo importer
  50. WordPress (+WPMU) Import/Export ALL settings?
  51. wordpress custom theme import and export options for sample data [closed]
  52. Is it possible to recover featured images after WordPress export/import
  53. phpMyAdmin displays error when importing database
  54. WXR slicing script
  55. Imported thumbnails have incorrect URL
  56. Merging two databases without borking it
  57. How to export post 2 posts WordPress plugin data [closed]
  58. Extending the woocommerce product export functionality
  59. What is the difference between wp-admin>Export>All content and MySql dump and import
  60. How to access my wordpress via IP in shared hosting
  61. WordPress Local And Live Site
  62. Move Multiple WP Installs on a single domain to WP Multisite
  63. What is basic structure of xml for importing a page in wordpress?
  64. Importer failed to import posts as format “day and name”
  65. Import HTML/JS post to WordPress?
  66. When moving a WordPress installation to a new server, why do I have to update each post before content shows?
  67. How to add biography of user while importing?
  68. How to export a WordPress blog with no export function?
  69. Importing posts via MySql (a csv file) need to be automatically published
  70. Is there a way to show different source feeds on individual pages?
  71. Error in importing wordpress xml [closed]
  72. CSV Import Tables
  73. latency problems with wordpress install (from SQL import)
  74. Import function loses tags
  75. Two-way synchronizing of a post type among multisite blogs
  76. Transferring theme and imported post attachments
  77. WordPress Import (CLI) returns Error Establishing a database connection
  78. Import WordPress content to my website
  79. Request failed due to an error: (http_request_fail
  80. import svg-files from wxr – (upload works, import not)
  81. WordPress All-Import to ATUM Stock Management
  82. Mixed Content: The page at ” was loaded over HTTPS, but requested an insecure font ”
  83. How can I import a BlogML file into my WordPress site?
  84. Content export, reinstall and content import
  85. How to make bulk changes to wordpress posts
  86. XML importing fails
  87. When migrating all backslashes were stripped and special signs are converted in html entities
  88. Imported posts using wrong domain name
  89. How can I avoid duplicate primary keys in SQL import?
  90. Import xml feed
  91. Importable Menus? Along with Pages (a site layout template)
  92. Importing blog failed to download attachments from older (still online) blog
  93. Create CSV for import from File directories?
  94. How to export database correctly for local to online
  95. how to import custom taxonomy (& terms)
  96. Import data from file larger than 15 MB
  97. How to import individual blog posts into WordPress?
  98. Import/Export WordPress demo
  99. Syndicate posts to another blog?
  100. Siteurl code for links