How to update without losing database?

Just wondering if there is any easy way of updating and/or reinstalling Bitnami phpbb without losing my mysql database (i.e. my phpbb forum).

I’ve tried copying mysql data folder over to the new installation but that fails with finding mysqld_safe and opening “sock” or something… I can’t believe I’m the only one experiencing this, but yet I haven’t found anyone else asking the same thing…

Hi,

Please take a look this and post if you have any trouble http://wiki.bitnami.com/Native_Installers_Quick_Start_Guide#How_to_upgrade_the_full_Stack_migrating_the_data.3f

Thanks Beltran. So now I know how to restore a db, yet I do not know how to backup my existing db. Also a problem exists in that I can no longer start up my old installation via terminal, when I enter the command: /Applications/Internet/phpbb-3.0.7-0/ctlscript.sh start
it just goes back to the $ prompt without any messages and the server is not started.

Hi,

Did you move the folder to a different location? You can see in the wiki how to create a backup.

The wiki just says to copy the entire bitnami installation directory. How would that help me? My installation doesn’t work anymore. I need to just backup the db. I tried just copying the mysql data folder to the new installation but then mysql wouldn’t start up, said some file was missing or couldn’t open the sock or something.

Hi,

You should copy the installation directory in the same location. I mean if you want to restore your old instalaltion, move the backup to the same location and it should work.

Ok so I re-named my original installation and then re-installed bitnami into the old installation folder as you suggested. As always, it works fine after installing. Now I tried copying my MySQL data folder from the old install to the new install, and this is the message I get upon accessing the phpbb via the web:

SQL ERROR [ mysql4 ]

Access denied for user ’bitnami’@’localhost’ (using password: YES) ¹⁰⁴⁵

Hi,

It is necessary to copy the previous MySQL database credentials that are in the phpbb3/htdocs/config.php file in the new config.php file. I hope it helps.

Thanks Beltran, I just did that. Unfortunately the same error message continues to be displayed when starting up mysql and trying to access my board on the new installation…

Oops, my mistake. Your solution worked wonderfully. I just copied the file from the wrong backup folder. Thanks so much, Beltran!

I’m glad to hear this :)