Move MYSQL DB to another Server

Discussion in 'Installation/Configuration' started by reason8, Apr 2, 2016.

Page 3 of 3
  1. reason8

    reason8 Member

    Hello and good afternoon.
    I believe I have most of this working.
    Databases are being created on the DB server but I can not see them in phpMyAdmin.
    I can see the original master servers databases but not the new one I crated after adding the db server to the multiserver setup.
    How do I view the newly created databases?
     
    reason8, Feb 20, 2017
    #41
  2. AndreasN

    AndreasN New Member

    You can also use dbForge Studio for MySQL's built-in data import and export functionality to transfer databases between servers.
     
    AndreasN, Oct 3, 2019
    #42
  3. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    It sounds like you have phpmyadmin installed on your master server. phpmyadmin needs a web server to run, and needs mysql access from that web server to your db server, so your options are to add your db server to phpmyadmin's configuration on your master server (so you can choose which db server to access from a single phpmyadmin install), or to install a web server like apache on your db server and run phpmyadmin there (so phpmyadmin running on your db server would connect to "localhost").
     
    Jesse Norell, Oct 7, 2019
    #43
Page 3 of 3

Share This Page