SQL files from flux cp are installed only in Main.DB / how to change it²

[SuPr3Me MoTF]

Hellow, gusy!
How can i change the Default place of the SQL FILES? I dont like the Flux running on the same local of my server main.. how can i change it?

[crazyarashi]

29 minutes ago, SuPr3Me MoTF said:

Hellow, gusy!
How can i change the Default place of the SQL FILES? I dont like the Flux running on the same local of my server main.. how can i change it?

You Can Install Your Flux CP in a different server. then just arrange the config of your flux cp to connect with the your database :))

[SuPr3Me MoTF]

19 hours ago, crazyarashi said:

You Can Install Your Flux CP in a different server. then just arrange the config of your flux cp to connect with the your database :))

I cant find this conf in conf.php... I think this thing too, but, without success. 

[Cyro]

3 hours ago, SuPr3Me MoTF said:

I cant find this conf in conf.php... I think this thing too, but, without success. 

this is the file you need to modfiy
 

[SuPr3Me MoTF]

On 04/05/2017 at 10:50 PM, Cyro said:

this is the file you need to modfiy
 

array( 'ServerName' => 'FluxRO', // Global database configuration (excludes logs database configuration). 'DbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '127.0.0.1', 'Username' => 'ragnarok', 'Password' => 'ragnarok', 'Database' => 'ragnarok', 'Persistent' => true, 'Timezone' => null // Example: '+0:00' is UTC. // The possible values of 'Timezone' is as documented from the MySQL website: // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'." // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!) // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated." ), // This is kept separate because many people choose to have their logs // database accessible under different credentials, and often on a // different server entirely to ensure the reliability of the log data. 'LogsDbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '127.0.0.1', 'Username' => 'ragnarok', 'Password' => 'ragnarok', 'Database' => 'ragnarok', 'Persistent' => true, 'Timezone' => null // Possible values is as described in the comment in DbConfig. ), WHERE is the DbCpConfig? I only see the main and logs dbs   array(   'ServerName' => 'FluxRO',   // Global database configuration (excludes logs database configuration).   'DbCpConfig' => array(   //'Socket' => '/tmp/mysql.sock',   //'Port' => 3306,   //'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.   'Convert' => 'utf8',   // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.   // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)   'Hostname' => '127.0.0.1',   'Username' => 'ragnarok',   'Password' => 'ragnarok',   'Database' => 'ragnarok',   'Persistent' => true,   'Timezone' => null // Example: '+0:00' is UTC.   // The possible values of 'Timezone' is as documented from the MySQL website:   // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."   // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)   // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."   ),

[Akkarin]

At present the cp tables are stored in the same location as the server tables. You can have your cp Web files separate from your server files if your webhosting allows remote sql, but if not I'm afraid you can't separate them. I'd looked into keeping cp tables separate in the past, but for speed and for the sake of extra confusing configs I let the idea go.