Posts by Kika

    I understand that if a developer thinks this is a standard backup and loads it then this is his fault. However, I think that since a standard mysql dump does not include these lines, the developer will only later discover what he has done and we can prevent it. From the system point of view, this pair of lines is not necessary for restoration.

    I think that the backup sql usualy used for two things :

    - restore the database

    - restore a part of the database or only some datas

    If you use large databases then not too easy remove these lines from exported sqls and this is dangerous if somebody doesn't check the sql before load.

    If somebody would like to restore the database then he could specify the database name if the export doesn't contains that, but if somebody forget to remove these lines then this will cause lot of problems.


    today I had to restore a backup of a database into another database and encountered an interesting problem. Although I provided the name of the new database in the command line, but the sql loaded into the original database and drop all data.

    I checked the sql backup and found these lines:

    CREATE DATABASE /*!32312 IF NOT EXISTS*/ `original_database` /*!40100 DEFAULT CHARACTER SET latin1*/;

    USE `original_database`;

    I recommend that you remove them from the backup because it is very dangerous, it is easy to accidentally drop the current live database and overwrite with the backup if you would like to load the backuped sql file into a new database.

    Hello Nuxwin,

    thanks for your answer.

    I already restored the file from backup and everything is works, I tried, but i can't repruduce the problem.

    When I see into the imscp-db-key I found this:

    KEY = ....
    IV = ...

    in the backup version:

    $db_pass_key = '...';
    $db_pass_iv = '....';

    I didn't found why this is happend


    I tried to upgrade to the current version, but I've got an error. I tried to upgrade to the git current version too, but I've got the same error. Have somebody an idea?

    Bootstrapping installer

    Error was:

    iMSCP::Stepper::_callback: Can't modify constant item in scalar assignment at /etc/imscp/imscp-db-keys line 2, at EOF
    Compilation failed in require at /root/imscp-1.3.7/engine/PerlLib/iMSCP/ line 204.

    [FATAL] iMSCP::Bootstrapper::_genKeys: Can't modify constant item in scalar assignment at /etc/imscp/imscp-db-keys line 2, at EOF
    Compilation failed in require at /var/www/imscp/engine/PerlLib/iMSCP/ line 204, <$fh> line 370.