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. Add WordPress MU Network Admin via Database
  14. How to tell which database tables belongs to which multisite site
  15. what are pmxi tables? [closed]
  16. Troubleshooting a “You do not have sufficient permissions to access this page” error
  17. Shared table across network
  18. find a random blogid across my multisite network that has at least one post published
  19. Multisite: How to store global options vs. site options?
  20. Uploading/Deploying a Multi Site Install
  21. Multisite database upgrade SSL error
  22. Configure WordPress to read from database only, never write
  23. Transfer Subdomain site to Multisite setup
  24. Which is the recommended method to transfer a wordpress site to wordpress Multisite?
  25. Error 101 after upgrading WordPress
  26. Multiple Domains and Subdomains Using Multisite Installation
  27. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  28. Move a WordPress multisite to subfolder (the whole site)?
  29. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  30. Copy site from one multisite to another
  31. How to change a WordPress network domain
  32. Synchronizing Two WordPress Sites Content
  33. Trying to migrate a WordPress Multisite with Domain Mapping
  34. How to clone and locally run a network for testing
  35. Suggestions for WPMU Migration (advanced)
  36. Two WordPress sites sharing the same database
  37. Issue converting single site to multi-site – blogs.dir folder not created
  38. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  39. PHP Notices appear when browsing any page in admin, but only for child theme, using code from WP Codex
  40. Split a database will improve performance?
  41. Multisite Subdomain Using More Resources Than Others?
  42. How to change the database prefix in multisite (WPMU) install
  43. Importing Multiple DB to one MU database
  44. What is the best practice to get a site from local to online?
  45. Make WordPress Search for Both Main Domain and Subdomain
  46. What should I do? A multisite, a single website or many websites? [closed]
  47. WordPress mutisite migration
  48. Does WordPress MultiSite use separate MySql databases?
  49. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  50. Migrate a WP website from a single-server single-domain to a multi-server multi-domain installation
  51. Multisite setup creating custom table
  52. Is there a way to run upgrade.php for one blog?
  53. Within the database, where is the flag which says that a user has Super Admin rights?
  54. Bulk activate a theme on multisite
  55. How to store custom user data on the database?
  56. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  57. Moving WordPress Multisite
  58. Redirect only posts to New Domain
  59. Database Tables Lost Indexes? How to Recover?
  60. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  61. Multiple multisite instances connecting to the same database
  62. Migrating wordpress multisite and domain mapping plugin
  63. How to convert multi-site to single site
  64. WordPress Multisite – can I somehow merge the tables?
  65. How to fix blocked cookies error that doesn’t let me log into wp-admin?
  66. How to solve this issue
  67. Multisite with subfolders- can’t access main site- Error establishing a database connection
  68. How to move 1 WP site from a mult-site environment to a different multi-site area
  69. Create a database for each site created in multisite?
  70. Adding a existing developed site to a multisite installation of WordPress
  71. Use WordPress MultiSite (WPMS) with a remote database for each created site
  72. Will changing the folder name two directories above a fresh wordpress installation break the site?
  73. WordPress Multisite blogs not working after domain swap
  74. Trouble Migrating all data blog from WordPress.com to WordPress.org
  75. Least expensive way to get table prefix in multisite installation
  76. 2 website 1 database… Local to online
  77. Removing Mutlisite lines stop DB connection
  78. Debugging unserialize errors [closed]
  79. Suspicious mesage appears instead of images
  80. Share DB tables between two blogs on the same WP Multisite installation
  81. Migrating Multisite with WP-Cli and/or Search-Replace-DB
  82. How can I create blog specific database table in multisite?
  83. Detach site from multisite (turn off multisite)
  84. How many databases do I need?
  85. How do I display offsite database info on my wordpress site?
  86. Locking one blog of many in a multi user/blog WordPress installation
  87. Problem in logging in as admin
  88. WordPress Multisites or Multiple WP Single sites?
  89. $wpdb->update prefixes database name to table when executing query
  90. Migrating wordpress sites through localhost and ubuntu
  91. WP MultiSite: Can’t select database error after changing to new domain
  92. Combining user database tables while keeping all other data in seperate for multiple sites?
  93. How to make multi site with single Database?
  94. Update WP install to WP network & it broke the DB connection
  95. Sharing users across multiple sites, each on their own database
  96. importing data into wordpress db
  97. How to share User Database between Two Multisite Installations + More
  98. How long is “as long as possible” in wp_cache_set()?
  99. WPMU on MySQL limited to 1GB of space?
  100. Questions about MU database schema and how to list all blogs
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)