I had a wordpress site working in my old setup. For several reasons I had to change to a different subnet on my freenas system. I've been able to get everything working except transfering my old wordpress database. The old jail with the wordpress server info still exists in my pool in jails. My new wordpress site in jails_2 has an empty database. My initial thought was to export the original DB with phpMyAdmin and then reimport the sql into the new server. As this is uncharted territory for my I have a few questions and any suggestions would be great.
1) Do I have to have phpMyAdmin in the same jail as the databases I want to work on or can I add a storage mount to the jail in I want to manipulate the DB on?
2) Where is the DB located? I can't seem to get phpMyAdmin to recognize it. I see the php files in the /usr/local/www/wordpress directory.
3) Is my best option to restore my PFSense router config to the old subnet, reboot FreeNAS with an old config, export the DB data and then re import it into my new wordpress after restoring the new subnet in PFSense and FreeNAS?
1) Do I have to have phpMyAdmin in the same jail as the databases I want to work on or can I add a storage mount to the jail in I want to manipulate the DB on?
2) Where is the DB located? I can't seem to get phpMyAdmin to recognize it. I see the php files in the /usr/local/www/wordpress directory.
3) Is my best option to restore my PFSense router config to the old subnet, reboot FreeNAS with an old config, export the DB data and then re import it into my new wordpress after restoring the new subnet in PFSense and FreeNAS?