I would like to move my phpBB2 site from a sub-folder to my main/public_html directory.In order to move phpBB2 to your public_html, first you have to move your files from the subfolder to the public_html. The easiest way to do this is by using an FTP client manager like FileZilla.
The next step you have to do is to alter the phpBB2 configuration from your cPanel -> phpMyAdmin in the Databases box. Select the phpBB2 database from the drop-down menu at left. Then open the SQL tab and paste the following query in the text field
UPDATE phpbb_config SET script_path = 'new_relative_path_to_phpbb' WHERE config_name = 'current_relative_path_to_phpbb';
You have to change the 'new_relative_path_to_phpbb' and 'current_relative_path_to_phpbb' in the query shown above to meet your environment. For example if you move the phpBB2 installation form subfolder named "forum" to the root of your domain name (the public_html folder), the query will look like:
UPDATE phpbb_config SET script_path = '/' WHERE config_name = '/forum/';
