Sombulula ingxaki ye-MySQL ERROR kumgca 1: Umyalelo ongaziwayo '-'

ukhonaMySQLNdidibene nolu hlobo lomyalezo wempazamo ophambeneyo kumgca womyalelo:“ERROR at line 1: Unknown command '-'"?

Awuwedwa kwaye eli nqaku liza kuphonononga kule ngxaki ixhaphakileyo kodwa edidayo kwaye ikunike isisombululo esiqinisekisiweyo.

Unobangela wempazamo utyhilwe

Ukuze uqonde le mpazamo, kufuneka uqale uqonde umthombo wayo.

InMySQLKumgca womyalelo, xa sisebenzisamysqldumpXa ungenisa okanye uthumela ngaphandle i-database usebenzisa izixhobo, ngamanye amaxesha unokuhlangana\-Abalinganiswa abakhethekileyo.

Lo mbhalo unokutolikwa ngendlela engeyiyo njengophawu lokubaleka kukhetho lomgca womyalelo, obangela ukuba iMySQL ingaphumeleli ukuqaphela nokwenza umyalelo ngokuchanekileyo, ngaloo ndlela iphosa "Unknown command"impazamo.

Ukubaluleka kokuhambelana kwenguqulelo

Ngokuqhelekileyo, lo mbandela unxulumene noguqulelo lokuhambelana kweMySQL okanye iMariaDB.

Ngokukodwa xa uthumela idatha phakathi kweenguqulelo ezahlukeneyo zeeseva, le mpazamo inokwenzeka.

Ngokomzekelo, cinga ukuba usebenzisa i-MariaDB version 10.5.25 kumncedisi womthombo kunye nenguqulo 10.3.39 kwiseva ekujoliswe kuyo. Umahluko phakathi kweenguqulelo ezimbini unokubangela ukuba isixhobo somgca womyalelo siziphathe ngokungaguqukiyo, sibangele le mpazamo.

Ungajonga into esetyenziswayo ngoku ngokusebenzisa lo myalelo ulandelayomysqldumpInguqulelo:

mysqldump --version

Xa ujongene nale ngxaki, eyona ndlela ichanekileyo nesebenzayo kukuqinisekisa ukuba iiseva ezimbini ziyasebenzisamysqldumpIzixhobo zohlobo olufanayo, okanye ubuncinci zonke zisebenza kuhlobo lwamva nje lothotho lwazo. Oku kunciphisa iimpazamo ezibangelwa kukungafani kwenguqulelo.

Phucula inguqulelo yeMySQL/MariaDB

Ukuba iseva yakho iqhuba inguqulelo endala ye-MariaDB, ukuyiphucula lukhetho oluhle.

Nangona inkqubo yokuphucula ilula, qiniseka ukuba ugcina i-database ngaphambi kokuba usebenze ukukhusela iingozi ngexesha lokuphucula.

CentOS Ukuphucula i-MariaDB kwi-7

Kwiinkqubo zeCentOS 7, ukuphuculwa kweMariaDB kunokwenziwa ngokulandela la manyathelo alandelayo:

1. Yenza ikopi yedathabheyisi yakho : Soloko ugcina ikopi yedathabheyisi yakho ngaphambi kokuba uyihlaziye. Ungenza ikopi yekopi enye kwiphaneli yokulawula yeHestiaCP usebenzisa lo myalelo ulandelayo:

   bash /usr/local/hestia/install/upgrade/manual/upgrade_mariadb.sh
   

   Oku akuyi kugcina i-database yakho kuphela, kodwa kuya kuqinisekisa ukubuyiswa ngokukhawuleza ukuba uphuculo aluphumeleli.

2. Hlaziya iMariaDB : Sebenzisa lo myalelo ulandelayo ukuphucula iMariaDB ibe yinguqulelo yamva nje:

   sudo yum update mariadb-server
   

   Okanye, kuxhomekeke kwimeko, faka iphakheji yenguqulo ye-MariaDB yamva nje.

Isiphelo kunye neengcebiso

"Unknown command '-'"Nangona impazamo isenokubonakala inzima, akukho nzima ukuyisombulula ukuba nje ufumana unobangela wengxaki kwaye uthathe amanyathelo afanelekileyo.

1. Qinisekisa ukuba iinguqulelo zesixhobo phakathi kweeseva ziyahambelana ukunciphisa iingxaki ezibangelwa kukungahambelani.
2. 保持MariaDB版本的最新状态，以避免由于旧版本导iingxaki ezahlukeneyo ezibangelwayo.

总结

Isitshixo sokusombulula iimpazamo ze-MySQL kukuqonda uhlobo lwengxaki kwaye ufumane ukulungiswa okufanelekileyo.

Ngokuphucula uguqulelo lwesiseko sedatha kunye nokuqinisekisa ukuhambelana kwesixhobo, iingxaki ezinjalo zinokuphetshwa ngokufanelekileyo.

Njengomlawuli wesiseko sedatha okanye umphuhlisi, kufuneka ugcine uqwalaselo olubukhali ngamaxesha onke ukuze uqinisekise uzinzo kunye nokhuseleko lwenkqubo.

Ngoku, khangela iinguqulelo zakho ze-MySQL/MariaDB ngoko nangoko ukuze uqiniseke ukuba zisexesheni kwaye ziphucule njengoko zifuneka.

Ungavumeli ezi mpazamo zincinci zinciphise imveliso yakho!