Rarulula inkinga ye-MySQL ERROR kulayini 1: Umyalo ongaziwa '-'

ukhonaMySQLNgihlangabezane nalolu hlobo lomlayezo wephutha ohlanya kulayini womyalo:“ERROR at line 1: Unknown command '-'"?

Awuwedwa futhi lesi sihloko sizocubungula le nkinga evamile kodwa edidayo futhi ikunikeze isisombululo esiqinisekisiwe.

Imbangela yephutha idaluliwe

Ukuze uqonde leli phutha, kufanele uqale uqonde umthombo walo.

KWMySQLEmgqeni womyalo, lapho sisebenzisamysqldumpLapho ungenisa noma uthekelisa isizindalwazi usebenzisa amathuluzi, ungase uhlangane ngezinye izikhathi\-Izinhlamvu ezikhethekile ezinjalo.

Lo mlingisi angase ahunyushwe kabi njengohlamvu lokuphunyuka kunketho yomugqa womyalo, okubangela ukuthi i-MySQL yehluleke ukubona nokwenza umyalo ngendlela efanele, ngaleyo ndlela iphonse "Unknown command"iphutha.

Ukubaluleka kokuhambisana kwenguqulo

Ngokuvamile, le nkinga ihlobene nokuhambisana kwenguqulo ye-MySQL noma i-MariaDB.

Ikakhulukazi uma udlulisela idatha phakathi kwezinguqulo ezihlukene zamaseva, leli phutha maningi amathuba okuthi lenzeke.

Ngokwesibonelo, ake sithi usebenzisa inguqulo ye-MariaDB engu-10.5.25 kuseva yomthombo kanye nenguqulo 10.3.39 kuseva eqondiwe. Umehluko phakathi kwalezi zinguqulo ezimbili ungabangela ithuluzi lomugqa womyalo ukuthi liziphathe ngendlela engafanele, kubangele leli phutha.

Ungahlola ukuthi yini esetshenziswayo njengamanje ngokusebenzisa umyalo olandelayomysqldumpInguqulo:

mysqldump --version

Lapho ubhekana nale nkinga, indlela eqondile nephumelelayo iwukuqinisekisa ukuthi amaseva amabili asebenzisamysqldumpAmathuluzi awenguqulo efanayo, noma okungenani wonke asebenzisa inguqulo yakamuva yochungechunge lwawo. Lokhu kunciphisa amaphutha ngenxa yokungafani kwenguqulo.

Thuthukisa inguqulo ye-MySQL/MariaDB

Uma iseva yakho isebenzisa inguqulo endala ye-MariaDB, ukuyithuthukisa kuyinketho enhle.

Nakuba inqubo yokuthuthukisa ilula, qiniseka ukuthi wenza ikhophi yasenqolobaneni ngaphambi kokusebenza ukuze uvimbele izingozi phakathi nenqubo yokuthuthukisa.

CentOS Ithuthukisa i-MariaDB ku-7

Kuzinhlelo ze-CentOS 7, ukuthuthukisa i-MariaDB kungenziwa ngokulandela lezi zinyathelo ezilandelayo:

1. Gcina isizindalwazi: Ngaphambi kokuthuthukisa, qiniseka ukuthi wenza ikhophi yasenqolobaneni egciniwe kuqala. Ungasebenzisa umyalo olandelayo kuI-HestiaCPYenza isipele ngokuchofoza okukodwa kuphaneli yokulawula:

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

   Lokhu ngeke nje kugcine imininingwane yakho egciniwe, kodwa futhi kuzoqinisekisa ukululama okusheshayo uma ukuthuthukiswa kwehluleka.

2. Buyekeza i-MariaDB: Thuthukisela i-MariaDB enguqulweni yakamuva usebenzisa umyalo olandelayo:

   sudo yum update mariadb-server
   

   Noma, kuye ngesimo, faka iphakheji yenguqulo ye-MariaDB yakamuva.

Isiphetho nezincomo

"Unknown command '-'"Nakuba iphutha lingase libonakale linzima, akunzima ukulixazulula inqobo nje uma uthola umnyombo wenkinga futhi uthathe izinyathelo ezifanele.

1. Qinisekisa ukuthi izinguqulo zamathuluzi phakathi kwamaseva ziyafana ukuze unciphise izinkinga ezibangelwa ukungahambisani.
2. 保持MariaDB版本的最新状态，以避免由于旧版本导izinkinga ezihlukahlukene ezibangelwa.

总结

Isihluthulelo sokuxazulula amaphutha e-MySQL ukuqonda uhlobo lwenkinga nokuthola ukulungiswa okufanele.

Ngokuthuthukisa inguqulo yesizindalwazi kanye nokuqinisekisa ukuhambisana kwamathuluzi, izinkinga ezinjalo zingagwenywa ngempumelelo.

Njengomphathi wesizindalwazi noma umthuthukisi, udinga ukugcina ukubheka okubukhali ngaso sonke isikhathi ukuze uqinisekise ukuzinza nokuphepha kohlelo.

Manje, hlola izinguqulo zakho ze-MySQL/MariaDB ngokushesha ukuze uqiniseke ukuthi zisesikhathini samanje futhi zithuthukisa njengoba kudingeka.

Ungavumeli la maphutha amancane ehlise ukukhiqiza kwakho!