Situation
I am testing my backup server and I have attempted to restore emr_backup.tar after I enter the path and answer all question as default answer including the utf type , I get the following error;
Restoring OpenEMR database …
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1
Error creating MySQL database with ‘CREATE DATABASE CHARACTER SET utf8 COLLATE utf8_general_ci’.
I then created the database in mysql and the ran restore script again and received the same error. Am i missing something ?
OpenEMR Version
I’m using OpenEMR version 7.0.0
Browser:
I’m using: Chrome
Operating System
I’m using: Putty on windows 10
Search
Did you search the forum for similar questions?
yes
Logs
Did you check the logs? yes
Was there anything pertinent in them? yes
Please paste them here (surround with three backticks (```) for readability.
'tyran@119w:~$ sudo less /var/log/mysql/error.log
2024-06-18T17:19:39.222646Z 14 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All