Transferring several WordPress websites from shared hosting

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.