Lowetsani cholakwika cha 500 database? Kutumiza kwa Linux ku MySQL lalikulu mzere wamafayilo

wina anachita nawoZamalondaAnzake amakampani, basiIkani gulu la VestaCPPambuyo pake, mukufuna kupitaphpMyAdminkulowetsa kasamalidwe ka databaseMySQL database, pakhala zolakwika 500, ndipo kuitanitsa kunalephera pambuyo poyesera kangapo...

Mwina chifukwa cha php.ini kasinthidwe, kapena mavuto ena, kotero kutumiza kapena kuitanitsa mu phpMyAdminMySQLFayilo yayikulu imatenga nthawi yayitali kwambiri, ndipo kutha kwa php kumapangitsa kutumiza kapena kutumiza kulephera ...

Ngakhale kusinthidwako kumapangitsa kusintha kwamakumbukidwe a mafayilo okhudzana, sikungathandize ...

Panthawiyi, tikhoza kudutsa Linux Kukhazikitsa mzere wolamula:

• Gwiritsani ntchito mzere wosunga zosunga zobwezeretsera wa MySQL kuti mutumize mwachangu database ya MySQL;
• Gwiritsani ntchito mzere wolamula wa MySQL kuti mulowetse mwachangu ma database a MySQL.

MySQL export database command

MySQL Backup Commands ▼

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

• lamulo silimaphatikizapo zizindikiro []
• Chonde sinthani "dumpfilename" kukhala dzina lafayilo yanu ya MySQL.
• Onani muvi wakumanja > ndi kutumiza kunja.

Chotsani .gz MySQL database file

Ngati fayilo yanu ya database ya MySQL yapanikizidwa ndi .gz suffix, siingathe kutumizidwa ku database kudzera pa mzere wa SSH.

Musanapereke lamulo loti mulowetse database ya MySQL, chonde lowetsani lamulo lotsatirali la .gz unzip kuti mutsegule ▼

gunzip FileName.gz

• Chonde sinthani "FileName" kukhala dzina lankhokwe yanu ya MySQL, mwachitsanzo: xxx.sql.gz

MySQL import database command

MySQL import command ▼

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

• lamulo silimaphatikizapo zizindikiro []
• Chonde sinthani "dumpfilename" kukhala dzina lafayilo yanu ya MySQL.
• Onani muvi wakumanzere < ndi import.

Malamulo ena a SSH pamakina a Linux atha kupezeka apa ▼

Kusonkhanitsa kwadongosolo la Linux system view

Lamulo lowonera zidziwitso za Linux system [system] uname -a #Onani kernel/operating system/CPU information head -n 1 /etc/issue #Onani mtundu wa opareshoni cat /proc/cpuinfo #Onani dzina la homuweki wa CPU #Onani dzina la kompyuta lspci -t ...