I am trying to migrate my website from one host to another, and I am not looking for a canned solution. Upon attempting to observe database information in the installation I discovered that the scripts were disabled on the installation that I am trying to migrate. So, I cannot figure out which database is associated with this installation to back it up before the migration. This is a live website, and I am attempting to not break it. How can I re-enable scripts on the installation? What plugins could be responsible for this? I have seen none that are responsible, but I can list those too if necessary. Is there a simple solution? Do I need to update the version, and if so how could I go about discovering the database information first to ensure that I am not going to break the site doing so?
I am trying to migrate my website from one host to another, and I am not looking for a canned solution. Upon attempting to observe database information in the installation I discovered that the scripts were disabled on the installation that I am trying to migrate. So, I cannot figure out which database is associated with this installation to back it up before the migration. This is a live website, and I am attempting to not break it. How can I re-enable scripts on the installation? What plugins could be responsible for this? I have seen none that are responsible, but I can list those too if necessary. Is there a simple solution? Do I need to update the version, and if so how could I go about discovering the database information first to ensure that I am not going to break the site doing so?
Share Improve this question edited Mar 19, 2020 at 19:20 fuxia♦ 107k39 gold badges255 silver badges459 bronze badges asked Mar 19, 2020 at 19:17 AstrothequeAstrotheque 33 bronze badges 4- do you have phpmyadmin access? – sialfa Commented Mar 19, 2020 at 19:40
- @sialfa Yes, I do. But, I am unfamiliar on how that helps me figure out which database is associated with the installation that I am seeking to migrate. – Astrotheque Commented Mar 19, 2020 at 19:48
- If you access to phpmyadmin, you will see al the databases that are associated to your hosting plan. From there you can check what are the assigned database and then import you db dump! – sialfa Commented Mar 19, 2020 at 22:20
- Thank you, this answer definitely helped me to manage the databases, but still left me wondering which one was the correct database. – Astrotheque Commented Mar 21, 2020 at 4:51
1 Answer
Reset to default 0If you check the wp-config.php you can identify which database is being used:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'this_here');
Then, use phpMyAdmin or Adminer to export the data into an .sql and move it over to the new database for import.