When you try to run an SQL file using mysql
command line program, you may encounter an error saying Failed to open file error 2
.
The following example tries to run the source
command and execute the query.sql
file:
mysql> source query.sql
ERROR:
Failed to open file 'query.sql', error: 2
The code error 2
means that MySQL can’t find the .sql
file that you want to execute.
To solve this error, you need to provide the absolute path to your file location.
You can find the absolute path of your file by opening the terminal in the directory or folder where your SQL file is located and run the pwd
command.
For example, here’s the absolute path to the directory where I save the query.sql
file:
$ pwd
/Users/nsebhastian/Desktop/SQL-files
Now I just need to add the path to the file when I issue the source command:
mysql> source /Users/nsebhastian/Desktop/SQL-files/query.sql
Please note that you need to use forward slashes (/
) to separate your path sections. Using back slashes () may cause the same error.
Here’s an example:
mysql> source UsersnsebhastianDesktopSQL-filesquery.sql
ERROR:
Failed to open file 'UsersnsebhastianDesktopSQL-filesquery.sql', error: 2
Even though the path is correct, MySQL expects a Unix-style path with forward slashes.
You should now be able to execute the SQL file. There are some other causes for error 2 in MySQL, so let’s take a look at that next.
Error 2 because of < or > symbols
Another thing that could cause the error is that you’re adding the greater than >
or less than <
symbol in front of the file path as shown below:
mysql> source < /Users/nsebhastian/Desktop/SQL-files/query.sql
ERROR:
Failed to open file '< /Users/nsebhastian/Desktop/SQL-files/query.sql',
error: 2
The greater than or less than symbol is commonly used to dump MySQL data to an SQL file or execute a script from the terminal without connecting to MySQL server.
You need to remove the symbol to execute the source
command without error.
Error 2 because of semicolon when using .
command
The .
command is an alias of the source
command that you can use to run an SQL file.
I don’t know if it’s a MySQL bug, but when you run the .
command with a semicolon ;
at the end of the file path, you’ll get the error 2 response.
Take a look at the following example:
mysql> . /Users/nsebhastian/Desktop/SQL-files/query.sql;
ERROR:
Failed to open file '/Users/nsebhastian/Desktop/SQL-files/query.sql;',
error: 2
But the same error won’t happen when you use the source
command:
mysql> source /Users/nsebhastian/Desktop/SQL-files/query.sql;
...
# result
...
7 rows in set (0.00 sec)
To solve this issue, you need to omit the semicolon when you’re using the .
command.
And that’s how you fix the MySQL failed to open file error 2
issue.
Just keep in mind that the error is because MySQL can’t find the file you want to execute.
You probably need to check the path you passed into the source
command and see if there’s any typo that causes the error.
Here are my steps:
1. use bank(my database);
2. SOURCE d:NitrotestingSQLBooks_mysqlCookbookrecipestablescow.sql
When I tried to source for a particular .sql file, namely ‘cow.sql’, the following error is displayed:
ERROR:
Failed to open file ‘d:NitrotestingSQLBooks_mysqlCookbookrecipestablescow.sql’, error:2
content of «cow.sql»:
# Tables for online contruct-a-cow ordering scenario
DROP TABLE IF EXISTS cow_order;
#@ _CREATE_COW_ORDER_TABLE_
CREATE TABLE cow_order
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
# cow color, figurine size, and accessory items
color VARCHAR(20),
size ENUM('small','medium','large') DEFAULT 'medium',
accessories SET('cow bell','horns','nose ring','tail ribbon')
DEFAULT 'cow bell,horns',
# customer name, street, city, and state (abbreviation)
cust_name VARCHAR(40),
cust_street VARCHAR(40),
cust_city VARCHAR(40),
cust_state CHAR(2),
PRIMARY KEY (id)
);
#@ _CREATE_COW_ORDER_TABLE_
# Add some orders to the table
INSERT INTO cow_order (color, size, accessories,
cust_name, cust_street, cust_city, cust_state)
VALUES
('Black & White','large','cow bell,nose ring',
'Farmer Brown','123 Elm St.','Bald Knob','AR');
SELECT * FROM cow_orderG
DROP TABLE IF EXISTS cow_color;
#@ _CREATE_COW_COLOR_TABLE_
CREATE TABLE cow_color (color CHAR(20));
#@ _CREATE_COW_COLOR_TABLE_
INSERT INTO cow_color (color)
VALUES
('Black'),
('Brown'),
('Cream'),
('Black & White'),
('Red & White'),
('Red'),
('See-Through');
SELECT * FROM cow_color;
Patch Log (Just to be clear I’ve reinstalled XPMSE and it still CTDs)
[26-10-2020 09:56:16] Nemesis Behavior Version: v0.84
[26-10-2020 09:56:16] Current Directory: C:Program Files (x86)Mr DJThe Elder Scrolls V Skyrim Legendary EditionDataNemesis.Unlimited.Behavior.Engine.v0.84-betaNemesis_Engine
[26-10-2020 09:56:16] Data Directory: C:Program Files (x86)Mr DJThe Elder Scrolls V Skyrim Legendary EditionData
[26-10-2020 09:56:16] Skyrim Special Edition: FALSE
[26-10-2020 09:56:16] Detecting processes…
[26-10-2020 09:56:17] Initializing file check…
[26-10-2020 09:56:17] File Check complete
[26-10-2020 09:56:17] Global reset all: TRUE
[26-10-2020 09:56:17] Mod Checked 1: nemesis
[26-10-2020 09:56:17] Caching alternate animation group…
[26-10-2020 09:56:17] Caching alternate animation complete
[26-10-2020 09:56:17] Reading new animations…
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe0_1hm_boundswordequip.hkx
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe1_1hm_boundswordequip.hkx
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe2_1hm_boundswordequip.hkx
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe3_1hm_boundswordequip.hkx
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe4_1hm_boundswordequip.hkx
[26-10-2020 09:56:17] WARNING(1003): Alternate animation file doesn’t exist. Current alternate animation file will not work | Mod: XPMSE | Animation File: xpe0_mt_sprintforward.hkx
[26-10-2020 09:56:17] Mod installed: XPMSE
[26-10-2020 09:56:17] Reading new animations complete
[26-10-2020 09:56:17] Initializing PCEA Check…
[26-10-2020 09:56:17] PCEA Check complete
[26-10-2020 09:56:17] Reading PCEA files…
[26-10-2020 09:57:03] Mod installed: Nemesis PCEA
[26-10-2020 09:57:03] PCEA Mod: 0Dser_Animations
[26-10-2020 09:57:03] PCEA Mod: 1Creature
[26-10-2020 09:57:03] PCEA Mod: 2Human
[26-10-2020 09:57:03] PCEA Mod: 3SexLab
[26-10-2020 09:57:03] PCEA Mod: 4Defeat
[26-10-2020 09:57:03] Registering new animations…
[26-10-2020 09:57:03] Process count: 433
[26-10-2020 09:57:03] New animations registration complete
[26-10-2020 09:57:03] Background hkx file architecture check: INITIALIZED
[26-10-2020 09:57:03] Processing behavior: temp_behaviors_master.txt
[26-10-2020 09:57:03] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviors_master
[26-10-2020 09:57:03] Processing behavior: temp_behaviors1hm_behavior.txt
[26-10-2020 09:57:03] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviors1hm_behavior
[26-10-2020 09:57:03] Processing behavior: temp_behaviors1hm_locomotion.txt
[26-10-2020 09:57:03] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviors1hm_locomotion
[26-10-2020 09:57:03] C:UserstnguyAppDataLocalNemesisNemesis_AA_Core.psc
[26-10-2020 09:57:03] C:Program Files (x86)Mr DJThe Elder Scrolls V Skyrim Legendary EditionDatascriptsNemesis_AA_Core.pex
[26-10-2020 09:57:03] AA prefix script complete
[26-10-2020 09:57:03] Group base value complete
[26-10-2020 09:57:03] Papyrus CompilerPapyrusCompiler.exe Nemesis_AA_Core.psc -f=TESV_Papyrus_Flags.flg -i=C:UserstnguyAppDataLocalNemesis;Papyrus Compilerscripts -o=C:UserstnguyAppDataLocalNemesis
[26-10-2020 09:57:04] Background hkx file architecture check: COMPLETED
[26-10-2020 09:57:06] AA core script complete
[26-10-2020 09:57:06] C:UserstnguyAppDataLocalNemesisFNIS_aa.psc
[26-10-2020 09:57:06] C:Program Files (x86)Mr DJThe Elder Scrolls V Skyrim Legendary EditionDatascriptsFNIS_aa.pex
[26-10-2020 09:57:06] Papyrus CompilerPapyrusCompiler.exe FNIS_aa.psc -f=TESV_Papyrus_Flags.flg -i=C:UserstnguyAppDataLocalNemesis;Papyrus Compilerscripts -o=C:UserstnguyAppDataLocalNemesis
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (IsCharater: FALSE)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:06] Total single animation processing time for 1hm_locomotion: 0
[26-10-2020 09:57:06] Total group animation processing time for 1hm_locomotion: 0
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 4.2, AA count: 34)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 4.4, AA count: 34 COMPLETE)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 4.6, PCEA count: 12)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 4.8, PCEA count: 12 COMPLETE)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:06] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:09] C:Program Files (x86)Mr DJThe Elder Scrolls V Skyrim Legendary EditionDataNemesis PCEA.esp
[26-10-2020 09:57:09] PCEA esp modification complete
[26-10-2020 09:57:09] PCEA begin script input
[26-10-2020 09:57:09] alternate animationnemesis pcea.script
[26-10-2020 09:57:09] C:UserstnguyAppDataLocalNemesisNemesis_PCEA_Core.psc
[26-10-2020 09:57:09] PCEA script input complete
[26-10-2020 09:57:09] Papyrus CompilerPapyrusCompiler.exe Nemesis_PCEA_Core.psc -f=TESV_Papyrus_Flags.flg -i=C:UserstnguyAppDataLocalNemesis;Papyrus Compilerscripts -o=C:UserstnguyAppDataLocalNemesis
[26-10-2020 09:57:10] Processing behavior: temp_behaviors_master.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:10] Processing behavior: temp_behaviors_master.txt (IsCharater: FALSE)
[26-10-2020 09:57:10] Processing behavior: temp_behaviors_master.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:10] Processing behavior: temp_behaviors1hm_locomotion.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:12] PCEA core script complete
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: core, Existing ID count: 1)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: core, Existing ID count: 1 COMPLETE)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: km, Existing ID count: 2)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: km, Existing ID count: 2 COMPLETE)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: pa, Existing ID count: 2)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 3.8, Mod code: pa, Existing ID count: 2 COMPLETE)
[26-10-2020 09:57:12] Total single animation processing time for 0_master: 0
[26-10-2020 09:57:12] Total group animation processing time for 0_master: 0
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 4.2, AA count: 84)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 4.4, AA count: 84 COMPLETE)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 4.6, PCEA count: 9)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 4.8, PCEA count: 9 COMPLETE)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:12] Processing behavior: temp_behaviors_master.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 1, File extraction complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviors1hm_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:19] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 2, AnimSetData mod selection complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 3, AnimSetData general processing complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 4, AnimSetData new animations complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 5, AnimSetData format check complete)
[26-10-2020 09:57:19] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 1, File extraction complete)
[26-10-2020 09:57:20] Processing behavior: temp_behaviorsanimationsetdatasinglefile.txt (Check point 6, AnimSetData output complete)
[26-10-2020 09:57:20] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 2, AnimData general processing complete)
[26-10-2020 09:57:20] Processing behavior: temp_behaviorsattackbehavior.txt
[26-10-2020 09:57:20] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsattackbehavior
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:20] Total single animation processing time for 1hm_behavior: 0
[26-10-2020 09:57:20] Total group animation processing time for 1hm_behavior: 0
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 4.2, AA count: 16)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 4.4, AA count: 16 COMPLETE)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 4.6, PCEA count: 13)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 4.8, PCEA count: 13 COMPLETE)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:20] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:21] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:21] Processing behavior: temp_behaviorsattackbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:21] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:22] Total single animation processing time for attackbehavior: 0
[26-10-2020 09:57:22] Total group animation processing time for attackbehavior: 0
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 4.2, AA count: 5)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 4.4, AA count: 5 COMPLETE)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 4.6, PCEA count: 13)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 4.8, PCEA count: 13 COMPLETE)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:22] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:23] Processing behavior: temp_behaviors_master.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:23] Processing behavior: temp_behaviorsbashbehavior.txt
[26-10-2020 09:57:23] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsbashbehavior
[26-10-2020 09:57:23] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:23] Processing behavior: temp_behaviorsbashbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:23] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:24] Total single animation processing time for bashbehavior: 0
[26-10-2020 09:57:24] Total group animation processing time for bashbehavior: 0
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 4.6, PCEA count: 1)
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 4.8, PCEA count: 1 COMPLETE)
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:24] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbashbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt
[26-10-2020 09:57:25] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsbehavior
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsblockbehavior.txt
[26-10-2020 09:57:25] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsblockbehavior
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsattackbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:25] Processing behavior: temp_behaviorsbow_direction_behavior.txt
[26-10-2020 09:57:25] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsbow_direction_behavior
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsbow_direction_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsbow_direction_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsbow_direction_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsbow_direction_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsbow_direction_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt
[26-10-2020 09:57:26] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorscrossbow_direction_behavior
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorscrossbow_direction_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsdefaultfemale.txt
[26-10-2020 09:57:26] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharactercharacters femaledefaultfemale
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:26] Total single animation processing time for blockbehavior: 0
[26-10-2020 09:57:26] Total group animation processing time for blockbehavior: 0
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 4.6, PCEA count: 14)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 4.8, PCEA count: 14 COMPLETE)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:26] Processing behavior: temp_behaviorsdefaultfemale.txt (IsCharater: TRUE)
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 1.5, Character bone identification complete)
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:28] Total single animation processing time for defaultfemale: 0
[26-10-2020 09:57:28] Total group animation processing time for defaultfemale: 0
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:28] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:29] Processing behavior: temp_behaviorsblockbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:29] Processing behavior: temp_behaviorsdefaultmale.txt
[26-10-2020 09:57:29] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharactercharactersdefaultmale
[26-10-2020 09:57:29] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:29] Processing behavior: temp_behaviorsdefaultmale.txt (IsCharater: TRUE)
[26-10-2020 09:57:30] Processing behavior: temp_behaviorsdefaultfemale.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:30] Processing behavior: temp_behaviorshorsebehavior.txt
[26-10-2020 09:57:30] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorshorsebehavior
[26-10-2020 09:57:30] Processing behavior: temp_behaviors1hm_behavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:30] Processing behavior: temp_behaviorsidlebehavior.txt
[26-10-2020 09:57:30] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsidlebehavior
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 1.5, Character bone identification complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:31] Total single animation processing time for defaultmale: 0
[26-10-2020 09:57:31] Total group animation processing time for defaultmale: 0
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorshorsebehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorshorsebehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorshorsebehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:31] Processing behavior: temp_behaviorshorsebehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorshorsebehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsmagicbehavior.txt
[26-10-2020 09:57:32] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsmagicbehavior
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsidlebehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsidlebehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsidlebehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsidlebehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsdefaultmale.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsmagicmountedbehavior.txt
[26-10-2020 09:57:32] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsmagicmountedbehavior
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsidlebehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:32] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt
[26-10-2020 09:57:32] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsmagic_readied_direction_behavior
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:33] Total single animation processing time for magic_readied_direction_behavior: 0
[26-10-2020 09:57:33] Total group animation processing time for magic_readied_direction_behavior: 0
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 4.2, AA count: 67)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 4.4, AA count: 67 COMPLETE)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:33] Total single animation processing time for magicmountedbehavior: 0
[26-10-2020 09:57:33] Total group animation processing time for magicmountedbehavior: 0
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 4.2, AA count: 58)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 4.4, AA count: 58 COMPLETE)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 4.6, PCEA count: 1)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 4.8, PCEA count: 1 COMPLETE)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:33] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:34] Total single animation processing time for magicbehavior: 0
[26-10-2020 09:57:34] Total group animation processing time for magicbehavior: 0
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 4.2, AA count: 137)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 4.4, AA count: 137 COMPLETE)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 4.6, PCEA count: 1)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 4.8, PCEA count: 1 COMPLETE)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmagic_readied_direction_behavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:34] Processing behavior: temp_behaviorsmt_behavior.txt
[26-10-2020 09:57:34] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsmt_behavior
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsmagicmountedbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt
[26-10-2020 09:57:35] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsshoutmounted_behavior
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:35] Total single animation processing time for shoutmounted_behavior: 0
[26-10-2020 09:57:35] Total group animation processing time for shoutmounted_behavior: 0
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 4.2, AA count: 15)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 4.4, AA count: 15 COMPLETE)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:35] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:37] Processing behavior: temp_behaviorsmagicbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:37] Processing behavior: temp_behaviorsshout_behavior.txt
[26-10-2020 09:57:37] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsshout_behavior
[26-10-2020 09:57:37] Processing behavior: temp_behaviorsshoutmounted_behavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:37] Processing behavior: temp_behaviorssprintbehavior.txt
[26-10-2020 09:57:37] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorssprintbehavior
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:38] Total single animation processing time for sprintbehavior: 0
[26-10-2020 09:57:38] Total group animation processing time for sprintbehavior: 0
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 4.2, AA count: 13)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 4.4, AA count: 13 COMPLETE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:38] Total single animation processing time for shout_behavior: 0
[26-10-2020 09:57:38] Total group animation processing time for shout_behavior: 0
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 4.2, AA count: 15)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 4.4, AA count: 15 COMPLETE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorssprintbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt
[26-10-2020 09:57:38] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsstaggerbehavior
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:38] Total single animation processing time for staggerbehavior: 0
[26-10-2020 09:57:38] Total group animation processing time for staggerbehavior: 0
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 4.2, AA count: 1)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 4.4, AA count: 1 COMPLETE)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:38] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsshout_behavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt
[26-10-2020 09:57:39] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsweapequip
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (IsCharater: FALSE)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:39] Total single animation processing time for weapequip: 0
[26-10-2020 09:57:39] Total group animation processing time for weapequip: 0
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 4.2, AA count: 12)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 4.4, AA count: 12 COMPLETE)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 4.6, PCEA count: 5)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 4.8, PCEA count: 5 COMPLETE)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:39] Processing behavior: temp_behaviorsweapequip.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsstaggerbehavior.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt
[26-10-2020 09:57:40] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacterbehaviorsweapunequip
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (IsCharater: FALSE)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:40] Total single animation processing time for weapunequip: 0
[26-10-2020 09:57:40] Total group animation processing time for weapunequip: 0
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 4, New animation inclusion complete)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 4.2, AA count: 11)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 4.4, AA count: 11 COMPLETE)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 4.6, PCEA count: 4)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 4.8, PCEA count: 4 COMPLETE)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 5, Prepare to output)
[26-10-2020 09:57:40] Processing behavior: temp_behaviorsweapunequip.txt (Check point 6, Behavior output complete)
[26-10-2020 09:57:41] Processing behavior: temp_behaviorsweapequip.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:41] Processing behavior: temp_behaviors_1stperson_master.txt
[26-10-2020 09:57:41] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviors_master
[26-10-2020 09:57:41] Processing behavior: temp_behaviorsmt_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:41] Processing behavior: temp_behaviorsmt_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:41] Processing behavior: temp_behaviorsmt_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:42] Processing behavior: temp_behaviorsmt_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:42] Processing behavior: temp_behaviorsmt_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:42] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt
[26-10-2020 09:57:42] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviors1hm_behavior
[26-10-2020 09:57:42] Processing behavior: temp_behaviorsweapunequip.txt (Check point 7, Behavior compile complete)
[26-10-2020 09:57:43] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt
[26-10-2020 09:57:43] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviors1hm_locomotion
[26-10-2020 09:57:43] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:43] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt (IsCharater: FALSE)
[26-10-2020 09:57:43] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stperson1hm_locomotion.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt
[26-10-2020 09:57:44] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsbashbehavior
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonbashbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:44] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt
[26-10-2020 09:57:44] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsblockbehavior
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonblockbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt
[26-10-2020 09:57:45] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsbow_direction_behavior
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stperson_master.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stperson_master.txt (IsCharater: FALSE)
[26-10-2020 09:57:45] Processing behavior: temp_behaviors_1stperson_master.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stperson_master.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonbow_direction_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt
[26-10-2020 09:57:46] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorscrossbow_direction_behavior
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stperson_master.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt
[26-10-2020 09:57:46] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersoncharactersfirstperson
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersoncrossbow_direction_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt
[26-10-2020 09:57:46] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorshorsebehavior
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (IsCharater: TRUE)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (Check point 1.5, Character bone identification complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonfirstperson.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt
[26-10-2020 09:57:46] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsidlebehavior
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:46] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:47] Processing behavior: temp_behaviors_1stpersonidlebehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:47] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt
[26-10-2020 09:57:47] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsmagicbehavior
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonhorsebehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:48] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt
[26-10-2020 09:57:48] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsmagicmountedbehavior
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicmountedbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt
[26-10-2020 09:57:49] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsmt_behavior
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:49] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonmagicbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt
[26-10-2020 09:57:50] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsshoutmounted_behavior
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshoutmounted_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt
[26-10-2020 09:57:50] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsshout_behavior
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:50] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonshout_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt
[26-10-2020 09:57:51] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorssprintbehavior
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonsprintbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt
[26-10-2020 09:57:51] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsstaggerbehavior
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonstaggerbehavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonweapequip.txt
[26-10-2020 09:57:51] Behavior output path: c:program files (x86)mr djthe elder scrolls v skyrim legendary editiondatameshesactorscharacter_1stpersonbehaviorsweapequip
[26-10-2020 09:57:51] Processing behavior: temp_behaviors_1stpersonmt_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stpersonweapequip.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stpersonweapequip.txt (IsCharater: FALSE)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stpersonweapequip.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stpersonweapequip.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stpersonweapequip.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt (Check point 1, File extraction & mod selection complete)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt (IsCharater: FALSE)
[26-10-2020 09:57:52] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt (Check point 2, ID replacement & PCEA record complete)
[26-10-2020 09:57:53] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt (Check point 3, Behavior general processing complete)
[26-10-2020 09:57:53] Processing behavior: temp_behaviors_1stperson1hm_behavior.txt (Check point 3.4, No changes detected)
[26-10-2020 09:57:53] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 3, AnimData general new animations complete)
[26-10-2020 09:57:53] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 3.4, AnimData general new animations complete)
[26-10-2020 09:57:56] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 4, AnimData format check complete)
[26-10-2020 09:57:56] Processing behavior: temp_behaviorsanimationdatasinglefile.txt (Check point 5, AnimData output complete)
[26-10-2020 09:58:58] Global reset all: FALSE
[26-10-2020 09:59:00] Running script: SexyMove detector.py
[26-10-2020 09:59:01] Running script: XPMSE detector.py
[26-10-2020 09:59:01] Number of animations: 5808
[26-10-2020 09:59:01] Behavior generation complete: 165 second(s) taken
Hello,
I created a virtual machine in virtualbox which I then exported to OVA format using the export.
In VMWare player I then opened the OVA file. The VM opened, I was able to start the virtual machine and test it. All is working correctly.
I now wanted to export the VMWare virtual machine to a OVF format using the ovftool.
I run the ovftool providing the source and target, the ovftool is throwing a «Failed to open file» error no matter which source I provide. It is very frustrating since even in the verbose log there is no indication about which file the program is failing to find.
The verbose log is not very long so I will post it below.
What am I missing??
======= Verbose log
2018-12-27T23:27:15.862-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] [SSL_DB] Using C:UsersGordynorthAppDataRoamingVMwareovftool_SSLDB as SSL DB
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Subscribing to signal: 2 (SIGINT)
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Subscribing to signal: 4 (SIGILL)
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Subscribing to signal: 22 (SIGABRT)
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Subscribing to signal: 8 (SIGFPE)
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Subscribing to signal: 15 (SIGTERM)
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Initializing progress
2018-12-27T23:27:15.887-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] OvfTool Version: VMware ovftool 4.3.0 (build-10104578)
2018-12-27T23:27:15.888-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Using home directory: C:UsersGordynorthAppDataRoamingVMwareovftool.cfg
2018-12-27T23:27:15.894-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Curl Version: 7.59.0
2018-12-27T23:27:15.894-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Done initializing libs
2018-12-27T23:27:15.894-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Determining source
2018-12-27T23:27:15.895-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Determining target
2018-12-27T23:27:15.895-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Getting source
2018-12-27T23:27:15.896-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Opening source
2018-12-27T23:27:15.896-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] [Context::Context] started. No parameters.
2018-12-27T23:27:15.896-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] [VmxConsumerContext::VmxConsumerContext] started.
2018-12-27T23:27:15.897-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] . is not a file
2018-12-27T23:27:15.903-05:00 verbose OVFTool[15156] [Originator@6876 sub=Default] Backtrace:
—> [backtrace begin] product: VMware Workstation, version: e.x.p, build: build-10104578, tag: OVFTool, cpu: x86_64, os: windows, buildType: release
—> backtrace[00] vmacore.dll[0x001F6D2A]
—> backtrace[01] vmacore.dll[0x00064FD0]
—> backtrace[02] vmacore.dll[0x0006776E]
—> backtrace[03] vmacore.dll[0x0002533C]
—> backtrace[04] ovftool.exe[0x00013FB6]
—> backtrace[05] ovftool.exe[0x0003AF07]
—> backtrace[06] ovftool.exe[0x0023B3CF]
—> backtrace[07] ovftool.exe[0x0023F77B]
—> backtrace[08] ovftool.exe[0x0023EA12]
—> backtrace[09] ovftool.exe[0x00247641]
—> backtrace[10] ovftool.exe[0x000D16E7]
—> backtrace[11] ovftool.exe[0x00159CBF]
—> backtrace[12] ovftool.exe[0x000DAC7C]
—> backtrace[13] ovftool.exe[0x000DB954]
—> backtrace[14] ovftool.exe[0x003846C5]
—> backtrace[15] KERNEL32.DLL[0x00017E94]
—> backtrace[16] ntdll.dll[0x0006A251]
—> [backtrace end]
lunevdanila
19 марта 2017
Что делать если когда я запускаю NFS-CfgInstaller то мне выскакивает данный текст: »ERROR: Failed to open file: C:Program FilesEA GAMESNeed for Speed Underground 2GLOBALGlobalB.lzc,,
Here are my steps:
1. use bank(my database);
2. SOURCE d:NitrotestingSQLBooks_mysqlCookbookrecipestablescow.sql
When I tried to source for a particular .sql file, namely ‘cow.sql’, the following error is displayed:
ERROR:
Failed to open file ‘d:NitrotestingSQLBooks_mysqlCookbookrecipestablescow.sql’, error:2
content of «cow.sql»:
# Tables for online contruct-a-cow ordering scenario
DROP TABLE IF EXISTS cow_order;
#@ _CREATE_COW_ORDER_TABLE_
CREATE TABLE cow_order
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
# cow color, figurine size, and accessory items
color VARCHAR(20),
size ENUM('small','medium','large') DEFAULT 'medium',
accessories SET('cow bell','horns','nose ring','tail ribbon')
DEFAULT 'cow bell,horns',
# customer name, street, city, and state (abbreviation)
cust_name VARCHAR(40),
cust_street VARCHAR(40),
cust_city VARCHAR(40),
cust_state CHAR(2),
PRIMARY KEY (id)
);
#@ _CREATE_COW_ORDER_TABLE_
# Add some orders to the table
INSERT INTO cow_order (color, size, accessories,
cust_name, cust_street, cust_city, cust_state)
VALUES
('Black & White','large','cow bell,nose ring',
'Farmer Brown','123 Elm St.','Bald Knob','AR');
SELECT * FROM cow_orderG
DROP TABLE IF EXISTS cow_color;
#@ _CREATE_COW_COLOR_TABLE_
CREATE TABLE cow_color (color CHAR(20));
#@ _CREATE_COW_COLOR_TABLE_
INSERT INTO cow_color (color)
VALUES
('Black'),
('Brown'),
('Cream'),
('Black & White'),
('Red & White'),
('Red'),
('See-Through');
SELECT * FROM cow_color;
Содержание
- MySQL — How to solve ‘Failed to open file error 2’
- Error 2 because of symbols
- Error 2 because of semicolon when using . command
- Level up your programming skills
- About
- MySQL Failed to open file – error 2 and 22 on Windows
- Share this:
- 30 Comments
- Consent to the use of Personal Data and Cookies
- Solution to SOURCE Error 2 with MySQL
- Writing file paths
- RTFM.WIKI
- Инструменты пользователя
- Инструменты сайта
- Содержание
- MySQL — коллекция ошибок и фиксов
- Ошибки
- Foreign key / Внешние ключи / Ошибка #1217
- Run ‘systemctl daemon-reload’ to reload units
- Can’t init tc log
- MySQL “Got an error reading communication packet” errors
- #1524 — Plugin ‘unix_socket’ is not loaded
- Can’t create a new thread (errno 11)
- #1698 — Access denied for user ‘root’@’localhost’
- mysqldump: Couldn’t execute ‘show events’
- #1214 — The used table type doesn’t support FULLTEXT indexes
- Waiting for table metadata lock
- No directory, logging in with HOME=/
- Can’t create thread to kill server (errno= 11)
- Can’t create a new thread (errno 11)
- unknown variable ‘default-tmp-storage-engine=MyISAM’
- Host ‘a.b.c.d’ is blocked because of many connection errors; unblock with ‘myscladmin flush-hosts’
- Fatal error: Uncaught exception ‘Exception’ with message ‘Error: Can’t open file: ‘./ocr/oc_product.frm’ (errno: 24)
- InnoDB: mmap(137363456 bytes) failed; errno 12
- Правильный UTF-8
- #1146 — Table ‘data_dictionary.CHARACTER_SETS’ doesn’t exist
- /usr/sbin/mysqld: Error on realpath() on ‘/var/lib/mysql-files’ (Error 2)
- ‘ERROR 1214 (HY000) at line 784: The used table type doesn’t support FULLTEXT indexes ‘
- Got an error from unknown thread, /builddir/build/BUILD /storage/myisam/mi_write.c:226
- mysqldump: Got error: (Errcode: 24) when using LOCK TABLES
- Error Number: 1364
- #1030 — Got error -1 from storage engine
- error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’
- open-files-limit в MariaDB
- Unable to lock ./ibdata1, error: 11
- unknown option ‘—skip-locking’
- RTFM.WIKI
- Инструменты пользователя
- Инструменты сайта
- Содержание
- MySQL — коллекция ошибок и фиксов
- Ошибки
- Foreign key / Внешние ключи / Ошибка #1217
- Run ‘systemctl daemon-reload’ to reload units
- Can’t init tc log
- MySQL “Got an error reading communication packet” errors
- #1524 — Plugin ‘unix_socket’ is not loaded
- Can’t create a new thread (errno 11)
- #1698 — Access denied for user ‘root’@’localhost’
- mysqldump: Couldn’t execute ‘show events’
- #1214 — The used table type doesn’t support FULLTEXT indexes
- Waiting for table metadata lock
- No directory, logging in with HOME=/
- Can’t create thread to kill server (errno= 11)
- Can’t create a new thread (errno 11)
- unknown variable ‘default-tmp-storage-engine=MyISAM’
- Host ‘a.b.c.d’ is blocked because of many connection errors; unblock with ‘myscladmin flush-hosts’
- Fatal error: Uncaught exception ‘Exception’ with message ‘Error: Can’t open file: ‘./ocr/oc_product.frm’ (errno: 24)
- InnoDB: mmap(137363456 bytes) failed; errno 12
- Правильный UTF-8
- #1146 — Table ‘data_dictionary.CHARACTER_SETS’ doesn’t exist
- /usr/sbin/mysqld: Error on realpath() on ‘/var/lib/mysql-files’ (Error 2)
- ‘ERROR 1214 (HY000) at line 784: The used table type doesn’t support FULLTEXT indexes ‘
- Got an error from unknown thread, /builddir/build/BUILD /storage/myisam/mi_write.c:226
- mysqldump: Got error: (Errcode: 24) when using LOCK TABLES
- Error Number: 1364
- #1030 — Got error -1 from storage engine
- error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’
- open-files-limit в MariaDB
- Unable to lock ./ibdata1, error: 11
- unknown option ‘—skip-locking’
MySQL — How to solve ‘Failed to open file error 2’
Posted on Nov 03, 2021
Learn how to fix ‘Failed to open file error 2’ in MySQL
When you try to run an SQL file using mysql command line program, you may encounter an error saying Failed to open file error 2 .
The following example tries to run the source command and execute the query.sql file:
The code error 2 means that MySQL can’t find the .sql file that you want to execute.
To solve this error, you need to provide the absolute path to your file location.
You can find the absolute path of your file by opening the terminal in the directory or folder where your SQL file is located and run the pwd command.
For example, here’s the absolute path to the directory where I save the query.sql file:
Now I just need to add the path to the file when I issue the source command:
Please note that you need to use forward slashes ( / ) to separate your path sections. Using back slashes ( ) may cause the same error.
Here’s an example:
Even though the path is correct, MySQL expects a Unix-style path with forward slashes.
You should now be able to execute the SQL file. There are some other causes for error 2 in MySQL, so let’s take a look at that next.
Error 2 because of symbols
Another thing that could cause the error is that you’re adding the greater than > or less than symbol in front of the file path as shown below:
The greater than or less than symbol is commonly used to dump MySQL data to an SQL file or execute a script from the terminal without connecting to MySQL server.
You need to remove the symbol to execute the source command without error.
Error 2 because of semicolon when using . command
The . command is an alias of the source command that you can use to run an SQL file.
I don’t know if it’s a MySQL bug, but when you run the . command with a semicolon ; at the end of the file path, you’ll get the error 2 response.
Take a look at the following example:
But the same error won’t happen when you use the source command:
To solve this issue, you need to omit the semicolon when you’re using the . command.
And that’s how you fix the MySQL failed to open file error 2 issue.
Just keep in mind that the error is because MySQL can’t find the file you want to execute.
You probably need to check the path you passed into the source command and see if there’s any typo that causes the error.
Level up your programming skills
I’m sending out an occasional email with the latest programming tutorials. Drop your email in the box below and I’ll send new stuff straight into your inbox!
About
Nathan Sebhastian is a software engineer with a passion for writing tech tutorials.
Learn JavaScript and other web development technology concepts through easy-to-understand explanations written in plain English.
Источник
MySQL Failed to open file – error 2 and 22 on Windows
I recently had to restore a MySQL backup. It had been a while since I used MySQL, having switched to Postgresql sometime back. First thing I noticed was the lack of a GUI admin tool that PG spoils you with. Making matters worse, the command line tool isn’t even added to your path; you can’t just run “ mysql ” like you can in a Unix shell, much less use the redirect shortcut. And I was getting errors.
Here’s what you need to do to restore a MySQL backup on Windows:
- Run the command line tool from the start menu
- Open your backup file in a text editor. Does it start with a command to create or “use” the database? If not
- Create it, if necessary
- Type “use database” filling in your DB name
- Type “source path-to-SQL-file“. BUT, you must follow these rules:
- Use the full source command, not the . shortcut
- Have no spaces in your path. I copied mine to a root of a drive. Note that spaces in the file name is OK, just not the path.
- Do not quote the file name, even if it has spaces. This gave error 22.
- Use forward slashes in the path, e.g., C:/path/to/filename.sql. Otherwise you’ll get error 2.
- Do not end with a semicolon.
Follow all those rules and it should work fine.
Thanks so much for this info. You where a savior to me this night. In my work for a project for this my site,Code Messiah, I run into an issue when I have to migrate some project in .net to MySQL. Thanks you for this guide. Its short but henvy
Thank you so much
Hi, just a heads up;
You can use backslashes but you’ll have to escape them (“”); and you can use semicolons, it worked as well. However I wouldn’t have figured out that the problem was the spaces in the path, that’s the main issue! So thanks for the article!
Thank you very much, it works!
This was quite helpful. Thanks for the tips.
Источник
Consent to the use of Personal Data and Cookies
This website needs your consent to use cookies in order to customize ads and content.
If you give us your consent, data may be shared with Google.
Solution to SOURCE Error 2 with MySQL
The error happens when importing database backups using the SOURCE command, either because you got the path wrong, or because you used the command incorrectly.
Edited: 2021-01-26 15:34
This is just a quick reminder to those having problems backing up- and importing MySQL databases. Often when I try to import a database using the SOURCE command I will get a SOURCE error 2 message.
The error simply means that we have gotten the file path wrong. However, in my case, it was because I used a less than sign between the SOURCE and the file name.
The reason for my mistake is that I use a greater than sign when backing up a database using mysqldump, and sometimes I mess up because the same logic does not apply when importing. Hopefully I will remember it now.
Writing file paths
To understand how to write the file system paths, read this article: Absolute and Relative Paths
Basically, when making backups, you can either write an absolute path for the destination file, beginning with a forward slash «/», or you can use a relative path. Simply writing the file name of the destination file will write the file in the current directory.
You can use the CD command to navigate to the desired location, if you feel more comfortable doing that.
Источник
RTFM.WIKI
Ordnung muß sein. Ordnung über alles (18+)
Инструменты пользователя
Инструменты сайта
Содержание
MySQL — коллекция ошибок и фиксов
Ошибки
Foreign key / Внешние ключи / Ошибка #1217
Теория в другом месте. Только фикс.
Текст ошибки может быть разным
В mysql cli отключаем проверку внешних ключей, делаем нужный запрос, включаем обратно.
можно ещё проще сделать
Run ‘systemctl daemon-reload’ to reload units
Warning: The unit file, source configuration file or drop-ins of mariadb.service changed on disk. Run ‘systemctl daemon-reload’ to reload units.
Can’t init tc log
MySQL “Got an error reading communication packet” errors
#1524 — Plugin ‘unix_socket’ is not loaded
Can’t create a new thread (errno 11)
Ошибка Can’t create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS -dependent bug
Лимиты установленные для MySQL в файле /etc/security/limits.conf будут переопределены файлом /etc/security/limits.d/90-nproc.conf . Поэтому задавать лимиты нужно в 90-nproc.conf или создать отдельный файл 91-mysql.conf
#1698 — Access denied for user ‘root’@’localhost’
Не работает phpmyadmin под root’ом. Для MySQL 127.0.0.1 и localhost это разные хосты.
Добавляем отдельного пользователя для администрирования
что-то там с sudo и unix_socket, не разбирался пока, но вариант рабочий.
mysqldump: Couldn’t execute ‘show events’
Ошибка mysqldump: Couldn’t execute ‘show events’: Cannot proceed because system tables used by Event Scheduler were found damaged at server start после перехода на MariaDB с MySQL 56 на cPanel сервере
mysql_upgrade по рекомендациям тоже не работает с ошибкой mysqldump: Got error: 1102: Incorrect database name ‘#mysql50#.config’» when selecting the database
И мне помог не cPanel, а Plesk
В /var/lib/mysql/ был каталог с точкой в имени.
Чтобы его найти выполним команду
Решение
Удалить/перенести каталог в другой место, выполнить mysql_upgrade.
#1214 — The used table type doesn’t support FULLTEXT indexes
Индексы FULLTEXT поддерживаются в таблицах InnoDB только начиная с MYSQL 5.6, поэтому попробуйте обновить MYSQL и после этого изменить команду таблицы
Waiting for table metadata lock
No directory, logging in with HOME=/
Подобная ошибка была в Debian с репозиторием dotdeb.
Надо поправить /etc/passwd
Должно быть так
Can’t create thread to kill server (errno= 11)
Скорее всего на сервере недостаточно памяти для выбранных настроек в my.cnf .
Т.е. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections в итоге получается больше чем RAM на сервере.
Решение — уменьшить max_connections и другие параметры исходя из доступных ресурсов.
Can’t create a new thread (errno 11)
Ошибка похожа на Can’t create thread to kill server и также связана с лимитами.
В данном случае нужно увеличить количество открытых файлов и количество процессов ( nofile и nproc ).
По-умолчанию open files равен 1024.
Проверим, чтобы удостовериться
Добавляем в файл /etc/security/limits.conf
Либо устанавливаем лимит только для mysql
Нашёл рекомендацию добавить лимиты в отдельный файл 99-mysql.conf в каталоге /etc/security/limits.d/
unknown variable ‘default-tmp-storage-engine=MyISAM’
Вот такая ошибка может возникнуть если бездумно копировать из разных блогов советы бывалых админов
default-tmp-storage-engine появился только в MySQL 5.6 и если использовать опцию в версии 5.5, то MySQL не запустится.
Host ‘a.b.c.d’ is blocked because of many connection errors; unblock with ‘myscladmin flush-hosts’
Ошибка возникает после 10 (по-умолчанию) неудачных соединений с базой.
Fatal error: Uncaught exception ‘Exception’ with message ‘Error: Can’t open file: ‘./ocr/oc_product.frm’ (errno: 24)
В логе mariadb.log нечто подобное
Решение — см. запись ниже open-files-limit в MariaDB
Текущее использование открытых файлов можно посмотреть так:
InnoDB: mmap(137363456 bytes) failed; errno 12
Решение — уменьшить innodb_buffer_pool_size или добавить RAM.
Правильный UTF-8
а потом трахбах и deprecated
#1146 — Table ‘data_dictionary.CHARACTER_SETS’ doesn’t exist
И опять убунта. Что за чудо система. Не даёт скучать. Сиди чини её нескончаемые баги. Впрочем ничего нового.
И всё начинает работать. До следующего адового бага. Продакшен реди итиху мать.
/usr/sbin/mysqld: Error on realpath() on ‘/var/lib/mysql-files’ (Error 2)
Баг после апгрейда встретился только в Ubuntu
ЕМНИП нужно просто создать каталог /var/lib/mysql-files
‘ERROR 1214 (HY000) at line 784: The used table type doesn’t support FULLTEXT indexes ‘
FULLTEXT INDEX раньше работал только с MyISAM. С версии 5.6 доступен в InnoDB.
Так что либо апгрейд либо ALTER TABLE `yourtable` ENGINE = MyISAM;
Got an error from unknown thread, /builddir/build/BUILD /storage/myisam/mi_write.c:226
Также в логах может быть что-то вроде Incorrect key file for table ‘xyz.MYI’; try to repair it
Казалось бы следует сделать mysqlrepair –auto-repair . Но обычно это не помогает.
Скорее всего нет инодов или кончилось место или недоступен tmpdir в mysql.
Проверяем df -i и df -h . Также проверяем значение tmpdir в my.cnf
mysqldump: Got error: (Errcode: 24) when using LOCK TABLES
Узнал о крутой утилите perror. По коду ошибки покажет, что не так.
Ну и по ошибке выше — попробуйте добавить опцию —single-transaction к mysqldump
Error Number: 1364
Через tcpdump выловил ошибку в php-fpm
Виной всему старый код и новый (5.7) MySQL.
Быстрый фикс — выключить так называемый strict mode
Для этого нужно добавить в my.cnf
Можно также вынести в отдельный файл /etc/mysql/conf.d/disable_strict_mode.cnf
Проверить sql_mode
#1030 — Got error -1 from storage engine
При попытке выполнить SQL запрос в phpmyadmin получаем ошибку #1030 — Got error -1 from storage engine
Вероятно включен innodb_force_recovery в файле my.cnf .
Проверяем логи. Если есть нечто подобное
то значит так оно и есть. Выключаем innodb_force_recovery и всё снова работает.
error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’
Смотрим пароль пользователя debian-sys-maint в файле /etc/mysql/debian.cnf
Выполняем 2 SQL запроса, чтобы вернуть гражданину debian-sys-maint его привилегии
Перезапускаем MySQL сервер
open-files-limit в MariaDB
Systemd самостоятельно контролирует, сколько файлов служба (в нашем случае mariadb-server) может открыть, независимо от того, что вы настроили в /etc/my.cnf или в /etc/security/limits.conf .
И вносим следующие правки
Данные новшества однако документированы. Так что надо просто внимательнее читать release notes и changelog.
Unable to lock ./ibdata1, error: 11
Решение в сети, которое якобы некоторым помогает
увы не помогает.
Бытует мнение, что виной всему Apparmor т.к. нигде кроме Ubuntu ошибка эта не встречалась
Можно попробовать добавить в /etc/apparmor.d/usr.sbin.mysqld
надо проверить
unknown option ‘—skip-locking’
Опцию –skip-locking убрали в MySQL 5.5.
Решение: заменить skip-locking на skip-external-locking
Источник
RTFM.WIKI
Ordnung muß sein. Ordnung über alles (18+)
Инструменты пользователя
Инструменты сайта
Содержание
MySQL — коллекция ошибок и фиксов
Ошибки
Foreign key / Внешние ключи / Ошибка #1217
Теория в другом месте. Только фикс.
Текст ошибки может быть разным
В mysql cli отключаем проверку внешних ключей, делаем нужный запрос, включаем обратно.
можно ещё проще сделать
Run ‘systemctl daemon-reload’ to reload units
Warning: The unit file, source configuration file or drop-ins of mariadb.service changed on disk. Run ‘systemctl daemon-reload’ to reload units.
Can’t init tc log
MySQL “Got an error reading communication packet” errors
#1524 — Plugin ‘unix_socket’ is not loaded
Can’t create a new thread (errno 11)
Ошибка Can’t create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS -dependent bug
Лимиты установленные для MySQL в файле /etc/security/limits.conf будут переопределены файлом /etc/security/limits.d/90-nproc.conf . Поэтому задавать лимиты нужно в 90-nproc.conf или создать отдельный файл 91-mysql.conf
#1698 — Access denied for user ‘root’@’localhost’
Не работает phpmyadmin под root’ом. Для MySQL 127.0.0.1 и localhost это разные хосты.
Добавляем отдельного пользователя для администрирования
что-то там с sudo и unix_socket, не разбирался пока, но вариант рабочий.
mysqldump: Couldn’t execute ‘show events’
Ошибка mysqldump: Couldn’t execute ‘show events’: Cannot proceed because system tables used by Event Scheduler were found damaged at server start после перехода на MariaDB с MySQL 56 на cPanel сервере
mysql_upgrade по рекомендациям тоже не работает с ошибкой mysqldump: Got error: 1102: Incorrect database name ‘#mysql50#.config’» when selecting the database
И мне помог не cPanel, а Plesk
В /var/lib/mysql/ был каталог с точкой в имени.
Чтобы его найти выполним команду
Решение
Удалить/перенести каталог в другой место, выполнить mysql_upgrade.
#1214 — The used table type doesn’t support FULLTEXT indexes
Индексы FULLTEXT поддерживаются в таблицах InnoDB только начиная с MYSQL 5.6, поэтому попробуйте обновить MYSQL и после этого изменить команду таблицы
Waiting for table metadata lock
No directory, logging in with HOME=/
Подобная ошибка была в Debian с репозиторием dotdeb.
Надо поправить /etc/passwd
Должно быть так
Can’t create thread to kill server (errno= 11)
Скорее всего на сервере недостаточно памяти для выбранных настроек в my.cnf .
Т.е. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections в итоге получается больше чем RAM на сервере.
Решение — уменьшить max_connections и другие параметры исходя из доступных ресурсов.
Can’t create a new thread (errno 11)
Ошибка похожа на Can’t create thread to kill server и также связана с лимитами.
В данном случае нужно увеличить количество открытых файлов и количество процессов ( nofile и nproc ).
По-умолчанию open files равен 1024.
Проверим, чтобы удостовериться
Добавляем в файл /etc/security/limits.conf
Либо устанавливаем лимит только для mysql
Нашёл рекомендацию добавить лимиты в отдельный файл 99-mysql.conf в каталоге /etc/security/limits.d/
unknown variable ‘default-tmp-storage-engine=MyISAM’
Вот такая ошибка может возникнуть если бездумно копировать из разных блогов советы бывалых админов
default-tmp-storage-engine появился только в MySQL 5.6 и если использовать опцию в версии 5.5, то MySQL не запустится.
Host ‘a.b.c.d’ is blocked because of many connection errors; unblock with ‘myscladmin flush-hosts’
Ошибка возникает после 10 (по-умолчанию) неудачных соединений с базой.
Fatal error: Uncaught exception ‘Exception’ with message ‘Error: Can’t open file: ‘./ocr/oc_product.frm’ (errno: 24)
В логе mariadb.log нечто подобное
Решение — см. запись ниже open-files-limit в MariaDB
Текущее использование открытых файлов можно посмотреть так:
InnoDB: mmap(137363456 bytes) failed; errno 12
Решение — уменьшить innodb_buffer_pool_size или добавить RAM.
Правильный UTF-8
а потом трахбах и deprecated
#1146 — Table ‘data_dictionary.CHARACTER_SETS’ doesn’t exist
И опять убунта. Что за чудо система. Не даёт скучать. Сиди чини её нескончаемые баги. Впрочем ничего нового.
И всё начинает работать. До следующего адового бага. Продакшен реди итиху мать.
/usr/sbin/mysqld: Error on realpath() on ‘/var/lib/mysql-files’ (Error 2)
Баг после апгрейда встретился только в Ubuntu
ЕМНИП нужно просто создать каталог /var/lib/mysql-files
‘ERROR 1214 (HY000) at line 784: The used table type doesn’t support FULLTEXT indexes ‘
FULLTEXT INDEX раньше работал только с MyISAM. С версии 5.6 доступен в InnoDB.
Так что либо апгрейд либо ALTER TABLE `yourtable` ENGINE = MyISAM;
Got an error from unknown thread, /builddir/build/BUILD /storage/myisam/mi_write.c:226
Также в логах может быть что-то вроде Incorrect key file for table ‘xyz.MYI’; try to repair it
Казалось бы следует сделать mysqlrepair –auto-repair . Но обычно это не помогает.
Скорее всего нет инодов или кончилось место или недоступен tmpdir в mysql.
Проверяем df -i и df -h . Также проверяем значение tmpdir в my.cnf
mysqldump: Got error: (Errcode: 24) when using LOCK TABLES
Узнал о крутой утилите perror. По коду ошибки покажет, что не так.
Ну и по ошибке выше — попробуйте добавить опцию —single-transaction к mysqldump
Error Number: 1364
Через tcpdump выловил ошибку в php-fpm
Виной всему старый код и новый (5.7) MySQL.
Быстрый фикс — выключить так называемый strict mode
Для этого нужно добавить в my.cnf
Можно также вынести в отдельный файл /etc/mysql/conf.d/disable_strict_mode.cnf
Проверить sql_mode
#1030 — Got error -1 from storage engine
При попытке выполнить SQL запрос в phpmyadmin получаем ошибку #1030 — Got error -1 from storage engine
Вероятно включен innodb_force_recovery в файле my.cnf .
Проверяем логи. Если есть нечто подобное
то значит так оно и есть. Выключаем innodb_force_recovery и всё снова работает.
error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’
Смотрим пароль пользователя debian-sys-maint в файле /etc/mysql/debian.cnf
Выполняем 2 SQL запроса, чтобы вернуть гражданину debian-sys-maint его привилегии
Перезапускаем MySQL сервер
open-files-limit в MariaDB
Systemd самостоятельно контролирует, сколько файлов служба (в нашем случае mariadb-server) может открыть, независимо от того, что вы настроили в /etc/my.cnf или в /etc/security/limits.conf .
И вносим следующие правки
Данные новшества однако документированы. Так что надо просто внимательнее читать release notes и changelog.
Unable to lock ./ibdata1, error: 11
Решение в сети, которое якобы некоторым помогает
увы не помогает.
Бытует мнение, что виной всему Apparmor т.к. нигде кроме Ubuntu ошибка эта не встречалась
Можно попробовать добавить в /etc/apparmor.d/usr.sbin.mysqld
надо проверить
unknown option ‘—skip-locking’
Опцию –skip-locking убрали в MySQL 5.5.
Решение: заменить skip-locking на skip-external-locking
Источник
When you try to run an SQL file using mysql
command line program, you may encounter an error saying Failed to open file error 2
.
The following example tries to run the source
command and execute the query.sql
file:
mysql> source query.sql
ERROR:
Failed to open file 'query.sql', error: 2
The code error 2
means that MySQL can’t find the .sql
file that you want to execute.
To solve this error, you need to provide the absolute path to your file location.
You can find the absolute path of your file by opening the terminal in the directory or folder where your SQL file is located and run the pwd
command.
For example, here’s the absolute path to the directory where I save the query.sql
file:
$ pwd
/Users/nsebhastian/Desktop/SQL-files
Now I just need to add the path to the file when I issue the source command:
mysql> source /Users/nsebhastian/Desktop/SQL-files/query.sql
Please note that you need to use forward slashes (/
) to separate your path sections. Using back slashes () may cause the same error.
Here’s an example:
mysql> source UsersnsebhastianDesktopSQL-filesquery.sql
ERROR:
Failed to open file 'UsersnsebhastianDesktopSQL-filesquery.sql', error: 2
Even though the path is correct, MySQL expects a Unix-style path with forward slashes.
You should now be able to execute the SQL file. There are some other causes for error 2 in MySQL, so let’s take a look at that next.
Error 2 because of < or > symbols
Another thing that could cause the error is that you’re adding the greater than >
or less than <
symbol in front of the file path as shown below:
mysql> source < /Users/nsebhastian/Desktop/SQL-files/query.sql
ERROR:
Failed to open file '< /Users/nsebhastian/Desktop/SQL-files/query.sql',
error: 2
The greater than or less than symbol is commonly used to dump MySQL data to an SQL file or execute a script from the terminal without connecting to MySQL server.
You need to remove the symbol to execute the source
command without error.
Error 2 because of semicolon when using .
command
The .
command is an alias of the source
command that you can use to run an SQL file.
I don’t know if it’s a MySQL bug, but when you run the .
command with a semicolon ;
at the end of the file path, you’ll get the error 2 response.
Take a look at the following example:
mysql> . /Users/nsebhastian/Desktop/SQL-files/query.sql;
ERROR:
Failed to open file '/Users/nsebhastian/Desktop/SQL-files/query.sql;',
error: 2
But the same error won’t happen when you use the source
command:
mysql> source /Users/nsebhastian/Desktop/SQL-files/query.sql;
...
# result
...
7 rows in set (0.00 sec)
To solve this issue, you need to omit the semicolon when you’re using the .
command.
And that’s how you fix the MySQL failed to open file error 2
issue.
Just keep in mind that the error is because MySQL can’t find the file you want to execute.
You probably need to check the path you passed into the source
command and see if there’s any typo that causes the error.