RxNorm Installation

Support
1

RxNorm
I am trying to upload RxNorm and am getting an error message that states
Query Error:
Load Data Local infile forbidden

7.0.0
I’m using OpenEMR version

Google Chrome:
I’m using:

Windows 10
I’m using:

yes
Starting crash recovery from checkpoint LSN=112977962
2022-11-03 16:10:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-11-03 16:10:12 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2022-11-03 16:10:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-11-03 16:10:12 0 [Note] InnoDB: Setting file ‘C:\xampp\mysql\data\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2022-11-03 16:10:12 0 [Note] InnoDB: File ‘C:\xampp\mysql\data\ibtmp1’ size is now 12 MB.
2022-11-03 16:10:12 0 [Note] InnoDB: Waiting for purge to start
2022-11-03 16:10:12 0 [Note] InnoDB: 10.4.25 started; log sequence number 112977971; transaction id 38860
2022-11-03 16:10:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-11-03 16:10:12 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2022-11-03 16:10:12 0 [Note] Server socket created on IP: ‘::’.

2

You need to enable the ‘local_infile’ option in MySQL.
A quick web search will show various tutorials on how to do this in XAMPP, but to make a long story short, you need to add the option “local_infile=ON” , to your my.ini file, then restart XAMPP and and try again.