Go to scriptcase root folder and rename “config_.php” to “config.php” You’re ready to import SQL file into mysql, if using PHPMyAdmin you should make a ZIP file. You must add “ENGINE=InnoDB” to CREATE statemens, as an example, this:Ĭod_Prj VARCHAR(120) DEFAULT ‘’ NOT NULL, #1071 - Specified key was too long max key length is 1000 bytes All tables MUST use InnoDB engine, some indexes are too long and in MyISAM engine you’ll face this error: Sed -i -E “s/INTO “(.*)” VALUES/INTO \1 VALUES/g” scriptcase.sql Replace all double quotes in INSERT INTO “xxx” VALUES to none with this command as INSERT INTO xxx VALUES: dump > scriptcase.sqlĮrase the 2 first and las line of scriptcase.sql Well, after some headaches and tests i’ve migrated sqlite nm_scriptcase.db to MySQL database, I use GNU/Linux so can’t confirm this procedure for windows.Įxport scriptcase DB to an SQL file with: This steps are recommended for a migration on a server where reinstallation is impossible, but where possible I recommend a backup, manual reinstallation and restore all projects. I will try to make a php program to migrate it in a more transparent steps, should be done by Netmake but they are very busy PD2: Made it work, needed to delete all projects after migration, maybe some issue in encodings, later got restored from previous backup (Options->Configuration->Backup and a later Restore) and is working ok. PD1: Still making some tests, i’m having problems opening APS, will try removing the projects and importing them from backup.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |