WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]

First of all i wouldn’t use phpmyadmin for a database that large. Use something like Sequel Pro its free and easy to use.

Second if you dont want the tables that WPML Created and you have removed the plugin from your site you can remove the tables that it creates.

Upload the sql to a new database on your local machine and remove all this tables for each site:

wp_icl_cms_nav_cache
wp_icl_content_status
wp_icl_core_status
wp_icl_flags
wp_icl_languages
wp_icl_languages_translations
wp_icl_locale_map
wp_icl_message_status
wp_icl_node
wp_icl_reminders
wp_icl_strings
wp_icl_string_positions
wp_icl_string_status
wp_icl_string_translations
wp_icl_translate
wp_icl_translate_job
wp_icl_translations
wp_icl_translation_status

I assuming your prefix is wp_(1,2,3) and so on.

Related Posts:

  1. How to Move Local Singlesite Database to Remote Multsite Database?
  2. Database Tables Lost Indexes? How to Recover?
  3. WP MultiSite: Can’t select database error after changing to new domain
  4. How can I trust switch_to_blog()?
  5. DB connection error after copying a WordPress Multisite instance to a second location
  6. Add WordPress MU Network Admin via Database
  7. How to tell which database tables belongs to which multisite site
  8. what are pmxi tables? [closed]
  9. Shared table across network
  10. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  11. Multisite: How to store global options vs. site options?
  12. Uploading/Deploying a Multi Site Install
  13. Multisite database upgrade SSL error
  14. Configure WordPress to read from database only, never write
  15. Multiple Domains and Subdomains Using Multisite Installation
  16. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  17. Migrating WPMS from apache to IIS7 causes Database Error
  18. Synchronizing Two WordPress Sites Content
  19. SQL to check how many sites a user is a member of
  20. How to clone and locally run a network for testing
  21. Two WordPress sites sharing the same database
  22. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  23. Split a database will improve performance?
  24. Multisite Subdomain Using More Resources Than Others?
  25. How to change the database prefix in multisite (WPMU) install
  26. Importing Multiple DB to one MU database
  27. Make WordPress Search for Both Main Domain and Subdomain
  28. Woocommerce and different checkout field for different countries
  29. Does WordPress MultiSite use separate MySql databases?
  30. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  31. Multisite setup creating custom table
  32. Is there a way to run upgrade.php for one blog?
  33. Within the database, where is the flag which says that a user has Super Admin rights?
  34. Bulk activate a theme on multisite
  35. Migrating Multisite – Database error, missing wp_blogs table
  36. How to store custom user data on the database?
  37. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  38. Multiple multisite instances connecting to the same database
  39. WordPress Multisite – can I somehow merge the tables?
  40. How to force change Network site multi language subdirectory base URL?
  41. Multisite with subfolders- can’t access main site- Error establishing a database connection
  42. Create a database for each site created in multisite?
  43. Use WordPress MultiSite (WPMS) with a remote database for each created site
  44. WordPress Multisite blogs not working after domain swap
  45. Least expensive way to get table prefix in multisite installation
  46. 2 website 1 database… Local to online
  47. new multisite, old db
  48. Removing Mutlisite lines stop DB connection
  49. how to migrate wpmu from one host to the other?
  50. How can I create blog specific database table in multisite?
  51. List recent 25 blogs across the network
  52. Is it best to avoid using $wpdb for security issues?
  53. How many databases do I need?
  54. Locking one blog of many in a multi user/blog WordPress installation
  55. WordPress Multisites or Multiple WP Single sites?
  56. $wpdb->update prefixes database name to table when executing query
  57. Combining user database tables while keeping all other data in seperate for multiple sites?
  58. How to make multi site with single Database?
  59. Update WP install to WP network & it broke the DB connection
  60. Sharing users across multiple sites, each on their own database
  61. Minimize Performance Issues of MultiSite Large Number of Tables Created
  62. importing data into wordpress db
  63. How to share User Database between Two Multisite Installations + More
  64. How long is “as long as possible” in wp_cache_set()?
  65. WPMU on MySQL limited to 1GB of space?
  66. Questions about MU database schema and how to list all blogs
  67. How to automatically translate plugin using translate.wordpress.org
  68. How to use the same users table on multiple wordpress sites
  69. A database for each category?
  70. Structure of multilingual and multiregional directory listing website for translation
  71. Problems with WordPress multisite directories/url structures and admin access after migration
  72. allow multisite in the installation process
  73. How do I split a single WPML site with 6 languages (English is Main) into Multisite with 5 subfolders
  74. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  75. Will resetting my database affect other sites on my multisite WordPress install?
  76. Can I replace the “Upgrade Network” with SQL query?
  77. WordPress Database Cleanup
  78. Optimal setup for Multi Domain WordPress with Woocommerce
  79. wordpress multisite – handle Database
  80. Importing Posts into New Website with Same User ID’s
  81. WordPress automatic Login on other page?
  82. How to reconnect database to existing wordpress multisite setup after changing site name
  83. Multi-site database upgrade claims success, but db_version not updated
  84. Blog switch wpml string translation (multi-site)
  85. Multiple domain with one database
  86. Problem in adding new site on WP multisite
  87. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  88. MySql Database In WordPress Multisite
  89. WP DB Location for “Next Post to Create” Index Value
  90. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  91. Plugin data shared in Multisite
  92. Merging versions of wp_posts based on post_title
  93. WordPress multisite and one database
  94. WordPress Multisite platform for different city for single db
  95. 4th Network Site Database Errors?
  96. Is there a full explanation on how to share a database with two WordPress sites on same server?
  97. HyperDB, Multisite – on new site creation put site’s tables to specific database
  98. Many big issues in the website, WP_Debug not showing
  99. Development time to Install and Configure WPML (https://wpml.org/) [closed]
  100. WPML is blocking WP core update