Question

Transferring several WordPress websites from shared hosting

  • Posted September 21, 2013

Hi I have Issue transferring several websites from shared hosting. While transferring I used How to Set Up Multiple WordPress Sites on a Single Ubuntu VPS and How to Migrate WordPress from Shared Hosting to a Cloud Server with Zero Downtime tutorials(!). What I have to do is to transfer about 10 websites from shared hosting to digital ocean. At shared hosting I had 3 dbases:

  1. arkbonline
  2. arkbonline_laconsta
  3. arkbonline_tree - the last base was used by most of those 10 websites, they had different prefixes. arkbonline_laconsta - had only one website laconsta.ru. With the help of How to Migrate WordPress from Shared Hosting to a Cloud Server with Zero Downtime tutorial it was pretty easy to transfer laconsta.ru website. Now it has its own database with the same name but different username.

The second website used arkbonline_tree database. I’ve restored the sql script to a new database with a different name - let’s call it tree_ocean. Created new SQL user for this new restored database. Then I set up all the virtual hosting stuff and uploaded contents of the wordpress website to digital ocean. After updating DNS the issue I face is that the website sends me to /wp-admin/install.php page. It does not display any error message. It simply thinks that it is clean installation of Wordpress. I’ve tried to reinstall it several times. But every time I get /wp-admin/install.php page. I didnt face this issue with the first WP website. What would you recommend me check?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Awesome! Glad to hear that! :]

It worked! Thank you! I also had to update new prefix in DB as WP was saying that I had no rights to see this page, after attempt to log in. <br>Again, Thank You so Much!

Try setting $table_prefix to ‘as_’ (not ‘aS_’). Does that fix it?

While this DB worked in shared hosting - there were several websites attached to this DB but with different prefixes. <br> <br>This is the exact command from Terminal app log: <br>mysql -h localhost -u root -p Activteac_Ocean < tree4.sql <br> <br>tree4.sql - is the export script of the base from shared hosting

Hmm why do you have that much tables in the ActivSQL database? What commands did you run when you migrated MySQL from shared hosting to your droplet?

mysql> use Activteac_Ocean; <br>Reading table information for completion of table and column names <br>You can turn off this feature to get a quicker startup with -A <br> <br>Database changed <br>mysql> show tables; <br>±--------------------------------+ <br>| Tables_in_Activteac_Ocean | <br>±--------------------------------+ <br>| aa_commentmeta | <br>| aa_comments | <br>| aa_links | <br>| aa_options | <br>| aa_postmeta | <br>| aa_posts | <br>| aa_term_relationships | <br>| aa_term_taxonomy | <br>| aa_terms | <br>| aa_usermeta | <br>| aa_users | <br>| ab_commentmeta | <br>| ab_comments | <br>| ab_links | <br>| ab_options | <br>| ab_postmeta | <br>| ab_posts | <br>| ab_term_relationships | <br>| ab_term_taxonomy | <br>| ab_terms | <br>| ab_usermeta | <br>| ab_users | <br>| ae_commentmeta | <br>| ae_comments | <br>| ae_flag_album | <br>| ae_flag_comments | <br>| ae_flag_gallery | <br>| ae_flag_pictures | <br>| ae_links | <br>| ae_ngg_album | <br>| ae_ngg_gallery | <br>| ae_ngg_pictures | <br>| ae_options | <br>| ae_postmeta | <br>| ae_posts | <br>| ae_term_relationships | <br>| ae_term_taxonomy | <br>| ae_terms | <br>| ae_usermeta | <br>| ae_users | <br>| ag_commentmeta | <br>| ag_comments | <br>| ag_links | <br>| ag_options | <br>| ag_postmeta | <br>| ag_posts | <br>| ag_term_relationships | <br>| ag_term_taxonomy | <br>| ag_terms | <br>| ag_usermeta | <br>| ag_users | <br>| ai_commentmeta | <br>| ai_comments | <br>| ai_fresh_slider | <br>| ai_links | <br>| ai_options | <br>| ai_postmeta | <br>| ai_posts | <br>| ai_term_relationships | <br>| ai_term_taxonomy | <br>| ai_terms | <br>| ai_usermeta | <br>| ai_users | <br>| ak_carousel_entries_wpress | <br>| ak_carousel_wpress | <br>| ak_commentmeta | <br>| ak_comments | <br>| ak_links | <br>| ak_options | <br>| ak_postmeta | <br>| ak_posts | <br>| ak_term_relationships | <br>| ak_term_taxonomy | <br>| ak_terms | <br>| ak_usermeta | <br>| ak_users | <br>| am_commentmeta | <br>| am_comments | <br>| am_links | <br>| am_options | <br>| am_postmeta | <br>| am_posts | <br>| am_term_relationships | <br>| am_term_taxonomy | <br>| am_terms | <br>| am_usermeta | <br>| am_users | <br>| an_commentmeta | <br>| an_comments | <br>| an_links | <br>| an_options | <br>| an_postmeta | <br>| an_posts | <br>| an_term_relationships | <br>| an_term_taxonomy | <br>| an_terms | <br>| an_usermeta | <br>| an_users | <br>| ao_commentmeta | <br>| ao_comments | <br>| ao_links | <br>| ao_options | <br>| ao_postmeta | <br>| ao_posts | <br>| ao_term_relationships | <br>| ao_term_taxonomy | <br>| ao_terms | <br>| ao_usermeta | <br>| ao_users | <br>| aq_commentmeta | <br>| aq_comments | <br>| aq_links | <br>| aq_options | <br>| aq_postmeta | <br>| aq_posts | <br>| aq_term_relationships | <br>| aq_term_taxonomy | <br>| aq_terms | <br>| aq_usermeta | <br>| aq_users | <br>| as_bpspro_login_security | <br>| as_bpspro_seclog_ignore | <br>| as_commentmeta | <br>| as_comments | <br>| as_links | <br>| as_options | <br>| as_postmeta | <br>| as_posts | <br>| as_redirection_groups | <br>| as_redirection_items | <br>| as_redirection_logs | <br>| as_redirection_modules | <br>| as_term_relationships | <br>| as_term_taxonomy | <br>| as_terms | <br>| as_usermeta | <br>| as_users | <br>| as_wowslider | <br>| az_commentmeta | <br>| az_comments | <br>| az_dt-blog | <br>| az_dt-frontpages | <br>| az_dt-sidebars | <br>| az_dt-slides | <br>| az_dt-slideshows | <br>| az_links | <br>| az_options | <br>| az_postmeta | <br>| az_posts | <br>| az_term_relationships | <br>| az_term_taxonomy | <br>| az_terms | <br>| az_usermeta | <br>| az_users | <br>| ba_commentmeta | <br>| ba_comments | <br>| ba_links | <br>| ba_options | <br>| ba_postmeta | <br>| ba_posts | <br>| ba_term_relationships | <br>| ba_term_taxonomy | <br>| ba_terms | <br>| ba_usermeta | <br>| ba_users | <br>| budjk_commentmeta | <br>| budjk_comments | <br>| budjk_links | <br>| budjk_options | <br>| budjk_postmeta | <br>| budjk_posts | <br>| budjk_term_relationships | <br>| budjk_term_taxonomy | <br>| budjk_terms | <br>| budjk_usermeta | <br>| budjk_users | <br>| graft2840_commentmeta | <br>| graft2840_comments | <br>| graft2840_links | <br>| graft2840_options | <br>| graft2840_postmeta | <br>| graft2840_posts | <br>| graft2840_term_relationships | <br>| graft2840_term_taxonomy | <br>| graft2840_terms | <br>| graft2840_usermeta | <br>| graft2840_users | <br>| grgf6104_commentmeta | <br>| grgf6104_comments | <br>| grgf6104_lazyestfiles | <br>| grgf6104_links | <br>| grgf6104_options | <br>| grgf6104_postmeta | <br>| grgf6104_posts | <br>| grgf6104_term_relationships | <br>| grgf6104_term_taxonomy | <br>| grgf6104_terms | <br>| grgf6104_usermeta | <br>| grgf6104_users | <br>| grgf6104_wppa_albums | <br>| grgf6104_wppa_comments | <br>| grgf6104_wppa_exif | <br>| grgf6104_wppa_iptc | <br>| grgf6104_wppa_photos | <br>| grgf6104_wppa_rating | <br>| inprdx_carousel_entries_wpress | <br>| inprdx_carousel_wpress | <br>| inprdx_commentmeta | <br>| inprdx_comments | <br>| inprdx_ehu_data | <br>| inprdx_ehu_stats | <br>| inprdx_links | <br>| inprdx_options | <br>| inprdx_postmeta | <br>| inprdx_posts | <br>| inprdx_term_relationships | <br>| inprdx_term_taxonomy | <br>| inprdx_terms | <br>| inprdx_usermeta | <br>| inprdx_users | <br>| intra_commentmeta | <br>| intra_comments | <br>| intra_links | <br>| intra_options | <br>| intra_postmeta | <br>| intra_posts | <br>| intra_term_relationships | <br>| intra_term_taxonomy | <br>| intra_terms | <br>| intra_usermeta | <br>| intra_users | <br>| kdbra1530_commentmeta | <br>| kdbra1530_comments | <br>| kdbra1530_links | <br>| kdbra1530_options | <br>| kdbra1530_postmeta | <br>| kdbra1530_posts | <br>| kdbra1530_redirection_groups | <br>| kdbra1530_redirection_items | <br>| kdbra1530_redirection_logs | <br>| kdbra1530_redirection_modules | <br>| kdbra1530_term_relationships | <br>| kdbra1530_term_taxonomy | <br>| kdbra1530_terms | <br>| kdbra1530_usermeta | <br>| kdbra1530_users | <br>| mgstre_commentmeta | <br>| mgstre_comments | <br>| mgstre_links | <br>| mgstre_options | <br>| mgstre_postmeta | <br>| mgstre_posts | <br>| mgstre_term_relationships | <br>| mgstre_term_taxonomy | <br>| mgstre_terms | <br>| mgstre_usermeta | <br>| mgstre_users | <br>| mgstre_wpsc_also_bought | <br>| mgstre_wpsc_cart_contents | <br>| mgstre_wpsc_checkout_forms | <br>| mgstre_wpsc_claimed_stock | <br>| mgstre_wpsc_coupon_codes | <br>| mgstre_wpsc_currency_list | <br>| mgstre_wpsc_download_status | <br>| mgstre_wpsc_meta | <br>| mgstre_wpsc_product_rating | <br>| mgstre_wpsc_purchase_logs | <br>| mgstre_wpsc_region_tax | <br>| mgstre_wpsc_submited_form_data | <br>| pgktr_commentmeta | <br>| pgktr_comments | <br>| pgktr_links | <br>| pgktr_ngg_album | <br>| pgktr_ngg_gallery | <br>| pgktr_ngg_pictures | <br>| pgktr_options | <br>| pgktr_postmeta | <br>| pgktr_posts | <br>| pgktr_term_relationships | <br>| pgktr_term_taxonomy | <br>| pgktr_terms | <br>| pgktr_usermeta | <br>| pgktr_users | <br>| tpddz47614_commentmeta | <br>| tpddz47614_comments | <br>| tpddz47614_dmsguestbook | <br>| tpddz47614_forum_forums | <br>| tpddz47614_forum_groups | <br>| tpddz47614_forum_posts | <br>| tpddz47614_forum_threads | <br>| tpddz47614_forum_usergroup2user | <br>| tpddz47614_forum_usergroups | <br>| tpddz47614_links | <br>| tpddz47614_options | <br>| tpddz47614_postmeta | <br>| tpddz47614_posts | <br>| tpddz47614_term_relationships | <br>| tpddz47614_term_taxonomy | <br>| tpddz47614_terms | <br>| tpddz47614_usermeta | <br>| tpddz47614_users | <br>| wpahf6203_commentmeta | <br>| wpahf6203_comments | <br>| wpahf6203_links | <br>| wpahf6203_options | <br>| wpahf6203_postmeta | <br>| wpahf6203_posts | <br>| wpahf6203_term_relationships | <br>| wpahf6203_term_taxonomy | <br>| wpahf6203_terms | <br>| wpahf6203_usermeta | <br>| wpahf6203_users | <br>±--------------------------------+ <br>312 rows in set (0.01 sec) <br> <br>mysql> <br> <br>As_ is the prefix I want my transferred website to catch. <br> <br>Here is part of config.php: <br> <br><…> <br>define(‘DB_NAME’, ‘Activteac_Ocean’); <br> <br>/** ??? ??? MySQL / <br>define(‘DB_USER’, ‘ActivSQL’); <br> <br>/* ??? ? ??? ??? MySQL / <br>define(‘DB_PASSWORD’, ‘here_is_password’); <br> <br>/* ??? ??? MySQL */ <br>define(‘DB_HOST’, ‘localhost’); <br><…> <br>$table_prefix = ‘aS_’; <br><…>

Does Activteac_Ocean have wordpress’s tables? <br><pre>use Activteac_Ocean; <br>show tables;</pre>

mysql> show databases; <br>±--------------------+ <br>| Database | <br>±--------------------+ <br>| information_schema | <br>| Activteac_Ocean | <br>| arkbonline_laconsta | <br>| diForNumberOne | <br>| mysql | <br>| performance_schema | <br>±--------------------+ <br>6 rows in set (0.00 sec) <br> <br>mysql> <br>— <br>Activteac_Ocean - is the issue base

Log in to mysql as root (<code>mysql -h localhost -u root -p</code>) and run <code>show databases;</code> <br> <br>What does it output?

Yep, with the user used in Wp configuration I see all the tables I expect.