Submitted by uinfor on Tue, 06/06/2017 - 09:50 Pro Licensee
Hello, i install script of PHPBB by always makes a mysql database with table structure like "phpbb_users" "phpbb_posts" etc.... and my backup of my database is "foro_posts" "foro_users" and when i import database i have to go table by table rename it and ...
how can i make that the script make tables like this "foro_xxx" ???
In the install of script i can change path and name of database, but always the tables are like "phpbb_xxx "
Thank you
Status:
Active
Comments
Submitted by andreychek on Tue, 06/06/2017 - 18:09 Comment #1
Howdy -- while you can choose the name of your database, there isn't a way to change the table names that phpBB uses... at least, not from within the Install Script.
Unfortunately, the Install Scripts aren't really designed to be imported from other sources.
The best thing we could suggest is to edit the database dump you have from your backups, and change the table names being used in the dump. You could use a search and replace to change "foro_" to "phpbb_", for example.
Sorry that we don't have a better way of handling that! The above idea is the best suggestion we have for that though.
Submitted by uinfor on Wed, 06/07/2017 - 02:43 Pro Licensee Comment #2
Thank you andrey, make the changes table to table is very difficult but i make it, i'm trouble because i change config.php and not make me changes:
<?php
// phpBB 3.2.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'club...._phpbb';
$dbuser = 'club.....';
$dbpasswd = '.........';
$table_prefix = 'foro_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';
@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);
;
Submitted by andreychek on Wed, 06/07/2017 - 08:22 Comment #3
Hmm, I'm not sure I understand -- what problem is it that you're currently seeing?