Shigo da bayanai kuskure 500? Linux fitarwa babban layin umarni na fayil MySQL

wani ya tsunduma a cikiE-kasuwanciAbokan masana'antu, kawaiShigar da kwamitin VestaCPBayan haka, so ku wucephpMyAdminshigo da sarrafa bayanaiMySQL database, an sami kurakurai 500, kuma shigo da kaya ya gaza bayan an gwada sau da yawa ...

Wataƙila saboda sanyi na php.ini, ko wasu matsalolin, don haka fitarwa ko shigo da su cikin phpMyAdminMySQLBabban fayil ɗin yana ɗaukar tsayi da yawa, kuma lokacin php yana haifar da gazawar fitarwa ko shigo da shi...

Ko da gyare-gyaren yana inganta tsarin ƙwaƙwalwar ajiyar fayilolin da ke da alaƙa, ba zai taimaka ba ...

A wannan lokacin, zamu iya wucewa Linux Aiwatar da layin umarni:

• Yi amfani da layin umarni na MySQL don fitar da bayanan MySQL da sauri;
• Yi amfani da layin umarni na shigo da MySQL don shigo da bayanan MySQL cikin sauri.

Umurnin fitarwa na MySQL

MySQL Dokokin Ajiyayyen ▼

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

• umarnin bai ƙunshi alamomi ba []
• Da fatan za a canza "dumpfilename" zuwa sunan fayil ɗin bayanai na MySQL.
• Kula da kibiya dama > shi ne fitarwa.

Cire fayil ɗin bayanai na .gz MySQL

Idan fayil ɗin bayanai na MySQL yana matsawa tare da .gz suffix, ba za a iya shigo da shi cikin ma'ajin bayanai ta hanyar layin umarni na SSH ba.

Kafin gudanar da umarni don shigo da bayanan MySQL, da fatan za a shigar da wannan .gz unzip umarni don buɗewa ▼

gunzip FileName.gz

• Da fatan za a canza "FileName" zuwa sunan rumbun adana bayanai na MySQL, misali: xxx.sql.gz

Umurnin shigo da bayanai na MySQL

MySQL umarni shigo da ▼

mysql -u root -p[root密码] [数据库名称] < dumpfilename.sql

• umarnin bai ƙunshi alamomi ba []
• Da fatan za a canza "dumpfilename" zuwa sunan fayil ɗin bayanai na MySQL.
• Kula da kibiya ta hagu < shigo da kaya ne.

Ana iya samun ƙarin umarnin SSH don tsarin Linux anan ▼

tarin umarnin duba bayanan tsarin Linux

Umurnin duba bayanan tsarin Linux [tsarin] uname -a #Duba kernel/tsarin aiki/shugaban bayanin CPU -n 1 /etc/fitilar #Duba sigar tsarin aiki cat /proc/cpuinfo #Duba sunan mai masaukin bayanan CPU #Duba sunan kwamfuta lspci -t ...