daws qhov teeb meem ntawm MySQL ERROR ntawm kab 1: Tsis paub hais kom ua '-'

Puas yog koj nyob hauvMySQLKuv tau ntsib qhov kev ua yuam kev vwm no ntawm kab hais kom ua:“ERROR at line 1: Unknown command '-'"?

Koj tsis yog ib leeg thiab tsab xov xwm no yuav delve rau hauv qhov teeb meem no tsis meej pem thiab muab kev daws teeb meem rau koj.

Qhov laj thawj ntawm qhov yuam kev tau nthuav tawm

Txhawm rau nkag siab qhov yuam kev no, koj yuav tsum xub nkag siab nws qhov chaw.

在MySQLHauv kab hais kom ua, thaum peb sivmysqldumpThaum importing lossis xa tawm cov ntaub ntawv siv cov cuab yeej, tej zaum koj yuav ntsib\-Xws li cov cim tshwj xeeb.

Tus cwj pwm no yuav raug txhais yuam kev raws li tus cwj pwm khiav hauv kev xaiv kab lus, ua rau MySQL tsis lees paub thiab ua tiav cov lus txib kom raug, yog li ntuav "Unknown command" yuam kev.

Qhov tseem ceeb ntawm version compatibility

Feem ntau, qhov teeb meem no muaj feem xyuam rau version compatibility ntawm MySQL lossis MariaDB.

Tshwj xeeb tshaj yog thaum koj hloov cov ntaub ntawv ntawm txawv versions ntawm servers, qhov kev ua yuam kev no feem ntau tshwm sim.

Piv txwv li, xav tias koj siv MariaDB version 10.5.25 ntawm qhov chaw server thiab version 10.3.39 ntawm lub hom phiaj server. Qhov sib txawv ntawm ob lub versions tuaj yeem ua rau cov cuab yeej kab hais kom coj tus cwj pwm tsis sib xws, ua rau qhov yuam kev no.

Koj tuaj yeem tshawb xyuas qhov tam sim no siv los ntawm kev khiav cov lus txib hauv qab nomysqldumpVersion:

mysqldump --version

Thaum daws qhov teeb meem no, txoj hauv kev ncaj qha thiab zoo tshaj plaws yog los xyuas kom meej tias ob lub servers sivmysqldumpCov cuab yeej yog tib yam version, los yog tsawg kawg yog tag nrho cov khiav ntawm qhov tseeb version ntawm lawv cov series. Qhov no txo ​​cov kev ua yuam kev vim version mismatches.

Hloov kho MySQL/MariaDB version

Yog tias koj lub server tab tom ua haujlwm dhau los ntawm MariaDB, hloov kho nws yog qhov kev xaiv zoo.

Txawm hais tias cov txheej txheem hloov kho yog qhov yooj yim, nco ntsoov rov qab cov ntaub ntawv ua ntej ua haujlwm kom tsis txhob muaj xwm txheej thaum lub sijhawm hloov kho.

CentOS Hloov kho MariaDB ntawm 7

Ntawm CentOS 7 systems, kev txhim kho MariaDB tuaj yeem ua tau los ntawm kev ua raws cov kauj ruam hauv qab no:

1. Thaub qab database: Ua ntej hloov kho dua tshiab, nco ntsoov thaub qab cov ntaub ntawv ua ntej. Koj tuaj yeem siv cov lus txib hauv qab no hauvHestiaCPUa ib-nias thaub qab hauv cov tswj vaj huam sib luag:

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

   Tsis tsuas yog qhov no yuav rov qab tau koj cov ntaub ntawv, tab sis nws tseem yuav ua kom rov qab sai yog tias qhov kev hloov kho tsis ua tiav.

2. Hloov tshiab MariaDB:Upgrade MariaDB mus rau qhov tseeb version siv cov lus txib hauv qab no:

   sudo yum update mariadb-server
   

   Los yog, nyob ntawm qhov xwm txheej, nruab qhov tseeb MariaDB version pob.

Cov lus xaus thiab cov lus pom zoo

"Unknown command '-'"Txawm hais tias qhov kev ua yuam kev yuav zoo li nyuaj, nws tsis yooj yim los daws kom ntev npaum li koj pom lub hauv paus ntawm qhov teeb meem thiab ntsuas qhov tsim nyog.

1. Xyuas kom meej tias cov cuab yeej versions ntawm servers zoo ib yam los txo cov teeb meem tshwm sim los ntawm incompatibility.
2. 保持MariaDB版本的最新状态，以避免由于旧版本导ntau yam teeb meem tshwm sim.

mus hais txog

Tus yuam sij rau kev daws qhov yuam kev MySQL yog kom nkag siab qhov xwm txheej ntawm qhov teeb meem thiab nrhiav kev kho kom tsim nyog.

Los ntawm kev txhim kho cov ntaub ntawv version thiab ua kom cov cuab yeej sib raug zoo, cov teeb meem no tuaj yeem zam tau zoo.

Raws li tus thawj tswj hwm database lossis tus tsim tawm, koj yuav tsum tau ua tib zoo saib xyuas txhua lub sijhawm kom ntseeg tau tias kev ruaj ntseg thiab kev nyab xeeb ntawm lub kaw lus.

Tam sim no, tshawb xyuas koj MySQL/MariaDB versions tam sim ntawd kom paub tseeb tias lawv hloov tshiab thiab hloov kho raws li xav tau.

Tsis txhob cia cov kev ua yuam kev me me no ua rau koj cov khoom tsim tau qeeb!