masalah: dump database di powershell. ketika mau diload, muncul error ERROR: ASCII ‘\0’ appeared in the statement, but this is not allowed unless option –binary-mode is enabled and mysql is run in non-interactive mode. Set –binary-mode to 1 if ASCII ‘\0’ is expected. Query: ‘��-‘
Penyebab: powershell pakai UTF-16
Solusi:
powershell “Get-Content ‘utf16.txt’ | Out-File ‘ascii.txt’ -Encoding ascii”
powershell “Get-Content ‘p2024h_arsip.sql’ | Out-File ‘ascii.txt’ -Encoding ascii”
Referensi: https://superuser.com/questions/1786434/convert-utf-16-le-to-utf-8-in-windows-via-command-line
solusi lain: pakai -r ketika dump database
https://dba.stackexchange.com/questions/44721/error-while-restoring-a-database-from-an-sql-dump