2 website 1 database… Local to online

How to fix it ? Go in SQL and write this code :

UPDATE `wp2_usermeta` SET `meta_key` = REPLACE(`meta_key`, 'wp_', 'wp2_');
UPDATE `wp2_options` SET `option_name` = REPLACE(`option_name`, 'wp_', 'wp2_');

🙂

Related Posts:

  1. Multiple Domains and Subdomains Using Multisite Installation
  2. How to Move Local Singlesite Database to Remote Multsite Database?
  3. Will changing the folder name two directories above a fresh wordpress installation break the site?
  4. how to migrate wpmu from one host to the other?
  5. How to migrate subsite from dev multisite to production multisite
  6. DB connection error after copying a WordPress Multisite instance to a second location
  7. what are pmxi tables? [closed]
  8. How to hide or remove unwanted widgets on Multisite installation?
  9. How can I diagnose a slow WordPress admin?
  10. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  11. Shared table across network
  12. WP-Admin not working properly at WordPress multisite with subdirectories
  13. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  14. Uploading/Deploying a Multi Site Install
  15. Configure WordPress to read from database only, never write
  16. wp-admin slow in multisite
  17. Don’t allow access to wp-admin but allow admin-ajax requests to be fulfilled on frontend?
  18. Timeout While Upgrading Network in Multi-site
  19. WordPress network (multisite) /wp-admin/ redirect loop (ERR_TOO_MANY_REDIRECTS)
  20. Copy posts from one blog to another in multisite environment
  21. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  22. Synchronizing Two WordPress Sites Content
  23. Redirect loop (only for multisite network admin)
  24. Manipulate list of themes in wp-admin
  25. How to clone and locally run a network for testing
  26. Two WordPress sites sharing the same database
  27. How to prevent first post and first comment on WP MU?
  28. Creating a Post form outside of the Admin
  29. Multiple Multisite networks on the same domain?
  30. Issue converting single site to multi-site – blogs.dir folder not created
  31. Subdomain and subdirectories together in one installation
  32. WordPress Installation for multi-domains with nginx and php-fpm
  33. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  34. Split a database will improve performance?
  35. Multisite Subdomain Using More Resources Than Others?
  36. How to change the database prefix in multisite (WPMU) install
  37. Importing Multiple DB to one MU database
  38. Change multi-site installation from sub-domains to sub-directories
  39. Make WordPress Search for Both Main Domain and Subdomain
  40. Cookie nonce is invalid – Multisite
  41. WordPress mutisite migration
  42. Why does the My Site dropdown show only a single domain?
  43. Does WordPress MultiSite use separate MySql databases?
  44. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  45. Super admin access to a forgotten WP instance?
  46. Within the database, where is the flag which says that a user has Super Admin rights?
  47. Migrating Multisite – Database error, missing wp_blogs table
  48. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  49. Database Tables Lost Indexes? How to Recover?
  50. Iframe being removed only for some users when publishing a page
  51. Can you manage multiple domain names from a single WordPress multisite network?
  52. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  53. Multiple multisite instances connecting to the same database
  54. Query to import data from one MultiSite table to another (pages/sub-pages)
  55. Create a database for each site created in multisite?
  56. Multisite Installation is all the same site
  57. new multisite, old db
  58. Moving wp-admin folder to a different host in a multisite environment
  59. Multisite installation on an existing single installation
  60. muliple wordpress multisite installs on the same sever
  61. How many databases do I need?
  62. Locking one blog of many in a multi user/blog WordPress installation
  63. WordPress Multisites or Multiple WP Single sites?
  64. Is There A Plugin to Create WP Multisite Installs programatically
  65. Can’t log in to wp-admin after setting up Multisite
  66. Combining user database tables while keeping all other data in seperate for multiple sites?
  67. How to make multi site with single Database?
  68. Is it possible to install WordPress MU on a subdomain?
  69. Sharing users across multiple sites, each on their own database
  70. importing data into wordpress db
  71. How long is “as long as possible” in wp_cache_set()?
  72. Infamous admin login redirect
  73. WPMU on MySQL limited to 1GB of space?
  74. Problems with WordPress multisite directories/url structures and admin access after migration
  75. How to map domains to specific pages in WordPress and display them in the address bar?
  76. Multisite wp-admin redirecting to main wp-admin using NGINX
  77. WordPress Multisite: Login to all subsites at once
  78. wordpress multisite – handle Database
  79. Importing Posts into New Website with Same User ID’s
  80. network admin pages not linked to correctly
  81. WordPress automatic Login on other page?
  82. How to reconnect database to existing wordpress multisite setup after changing site name
  83. Use a single WP installation instead of three
  84. Multi-site Installation in WordPress | Security & Future Migrations
  85. WP Admin Panel for Multi-site install not loading JavaScript for one Subdomain
  86. Multiple domain with one database
  87. Installed in root, want second in subdirectory
  88. MySql Database In WordPress Multisite
  89. WP DB Location for “Next Post to Create” Index Value
  90. wordpress multisite not installing
  91. Admin user getting redirected to /wp-admin/user
  92. Default sub-pages on WordPress Multisite
  93. WordPress multidomains and subfolders
  94. WordPress Multisite platform for different city for single db
  95. Setting up wordpress on a hosting server for the first time
  96. Should I go for Multisite or separate WP Installation?
  97. 4th Network Site Database Errors?
  98. Is there a full explanation on how to share a database with two WordPress sites on same server?
  99. Many big issues in the website, WP_Debug not showing
  100. What could be changing my WP password and blocking plugins from installing?