Migrating Multisite – Database error, missing wp_blogs table

Finally I have been able of import the database succesfully. Because my path is localhost/projects/example and no only localhost, after doing the replace with the plugin I have to manually change some tables path.

On wp_blogs and wp_site tables I have:

  • Domain = localhost/projects/example
  • Path = /

I have to change to:

  • Domain = localhost
  • Path = /projects/example/

And now it works perfectly!!

If somebody know about a way to do this change automaticaly I will love to read it.

Related Posts:

  1. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  2. Migrating WPMS from apache to IIS7 causes Database Error
  3. How to Move Local Singlesite Database to Remote Multsite Database?
  4. new multisite, old db
  5. how to migrate wpmu from one host to the other?
  6. Error establishing a database connection after moving local wordpressmultisite from one directory to another
  7. Error establishing a database connection – Multi-site with subsite don’t exisit [duplicate]
  8. 4th Network Site Database Errors?
  9. Site Redirecting to wp-signup.php
  10. How can I trust switch_to_blog()?
  11. How to migrate subsite from dev multisite to production multisite
  12. DB connection error after copying a WordPress Multisite instance to a second location
  13. what are pmxi tables? [closed]
  14. Shared table across network
  15. Uploading/Deploying a Multi Site Install
  16. Multisite database upgrade SSL error
  17. Configure WordPress to read from database only, never write
  18. Error 101 after upgrading WordPress
  19. Multiple Domains and Subdomains Using Multisite Installation
  20. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  21. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  22. Copy site from one multisite to another
  23. Synchronizing Two WordPress Sites Content
  24. Trying to migrate a WordPress Multisite with Domain Mapping
  25. How to clone and locally run a network for testing
  26. Two WordPress sites sharing the same database
  27. Issue converting single site to multi-site – blogs.dir folder not created
  28. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  29. PHP Notices appear when browsing any page in admin, but only for child theme, using code from WP Codex
  30. Split a database will improve performance?
  31. Multisite Subdomain Using More Resources Than Others?
  32. How to change the database prefix in multisite (WPMU) install
  33. Make WordPress Search for Both Main Domain and Subdomain
  34. WordPress mutisite migration
  35. Does WordPress MultiSite use separate MySql databases?
  36. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  37. Migrate a WP website from a single-server single-domain to a multi-server multi-domain installation
  38. Is there a way to run upgrade.php for one blog?
  39. Within the database, where is the flag which says that a user has Super Admin rights?
  40. How to store custom user data on the database?
  41. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  42. Moving WordPress Multisite
  43. Redirect only posts to New Domain
  44. Database Tables Lost Indexes? How to Recover?
  45. How to convert multi-site to single site
  46. Multisite with subfolders- can’t access main site- Error establishing a database connection
  47. Create a database for each site created in multisite?
  48. Adding a existing developed site to a multisite installation of WordPress
  49. Use WordPress MultiSite (WPMS) with a remote database for each created site
  50. WordPress Multisite blogs not working after domain swap
  51. 2 website 1 database… Local to online
  52. Debugging unserialize errors [closed]
  53. Suspicious mesage appears instead of images
  54. Detach site from multisite (turn off multisite)
  55. How do I display offsite database info on my wordpress site?
  56. Locking one blog of many in a multi user/blog WordPress installation
  57. Problem in logging in as admin
  58. Migrating wordpress sites through localhost and ubuntu
  59. Combining user database tables while keeping all other data in seperate for multiple sites?
  60. How to make multi site with single Database?
  61. Sharing users across multiple sites, each on their own database
  62. importing data into wordpress db
  63. How long is “as long as possible” in wp_cache_set()?
  64. Questions about MU database schema and how to list all blogs
  65. Migration: previous URL redirection after migrating
  66. How to use the same users table on multiple wordpress sites
  67. how to convert a wp multisite into a single site with content from subsites
  68. Problems with WordPress multisite directories/url structures and admin access after migration
  69. After switch domain, some parts of my site still point to my old domain
  70. Getting file errors in a WordPress Multisite ADMIN
  71. How to migrate post media from stand-alone to multisite build
  72. Primary (root) blog of multisite installation forbidden (403)
  73. local wordpress multisite not working on AWS development server “error establishing database connection”
  74. Will resetting my database affect other sites on my multisite WordPress install?
  75. Moving wordpress multisite to new domain
  76. WordPress Database Cleanup
  77. Send data from one WP instance to another and process it there
  78. Migration of Multisite WordPress site from http to https
  79. Optimal setup for Multi Domain WordPress with Woocommerce
  80. wordpress multisite – handle Database
  81. Importing Posts into New Website with Same User ID’s
  82. WordPress automatic Login on other page?
  83. How to reconnect database to existing wordpress multisite setup after changing site name
  84. After cloning my WordPress database to another server, I cannot log in
  85. Multiple domain with one database
  86. Problem in adding new site on WP multisite
  87. MySql Database In WordPress Multisite
  88. WP DB Location for “Next Post to Create” Index Value
  89. Plugin data shared in Multisite
  90. How to install wpengine hosted multisite locally
  91. How to set up wp multisite?
  92. How do I make a copy of WordPress to other folder
  93. Merging versions of wp_posts based on post_title
  94. WordPress multisite and one database
  95. WordPress Multisite platform for different city for single db
  96. Post migration from one site to another site in a network
  97. WordPress MS wp-admin/includes/post.php error with shortcode generator
  98. Moving a primary domain to another host as secondary cause errors in some image URL
  99. Is there a full explanation on how to share a database with two WordPress sites on same server?
  100. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]