Reaction score: 29
root@kif:/var/db/mysql # uname -a FreeBSD kif 10.3-RELEASE FreeBSD 10.3-RELEASE #0 r297264: Fri Mar 25 02:10:02 UTC 2016 email@example.com:/usr/obj/usr/src/sys/GENERIC amd64
Had databases/mysql80-server installed with www/nextcloud running. Wanted to add a www/phpbb3 instance on the same machine. After setting up the new security/py-certbot, a split-horizon DNS so my internal network didn't panic when requesting the SSL certs, and updating the /usr/local/etc/apach24/extra/httpd-vhosts.conf file to reflect both the pages on the same HTTPD, I installed the PHPBB3 instance.
Turns out phpBB3 3.1 (the version I chose) didn't play well with databases/mysql80-server. It was running, and I had the BB built and such, but I was advised to downgrade to databases/mysql56-server, which I did.
What I was left with, after the downgrade was an error from the index.php saying that the password for 'root'@'localhost' wasn't accepted. I copied the temporary pass from /root/.mysql_secret and changed the password to what it was. After that, the error phpBB3 was spitting out was the "database phpbb3" was not found. I did some snooping and and in /var/db/mysql I have a file called mysql.old containing all my original DBs.
I made a backup of /var/db/mysql/mysql.old into my /root to ensure I didn't break anything further that I couldn't come back to. I then tried:
mv ./mysql ./mysql.ORG; cp -r ./mysql.old ./mysql
which did nothing I needed.
I restored the dirs to their original, and created a database in mysql called 'phpbb3', and tried replacing the new phpbb3 directory with the one in mysql.old, which gives me the error :"Table 'phpbb3.phpbb_config' doesn't exist "
All I need to know is how to import the mysql.old information into my new mysql instance.
All I see is information of mysqldump, which I cannot use as my databases (phpbb3 and nextcloud) are not recognized by databases/mysql56-server.
Thank you ahead of time.