Ngenisa isizindalwazi sephutha le-500? I-Linux ikhiphe umugqa womyalo wefayela elikhulu le-MySQL

umuntu ohlanganyeleEzentengiselwanoAbangane bemboni, njeFaka iphaneli ye-VestaCPNgemva kwalokho, ufuna ukudlulaphpMyAdminukungenisa ukuphathwa kwedathabhesiMySQL database, kube namaphutha angu-500, futhi ukungenisa kwehlulekile ngemva kokuzama izikhathi eziningi...

Mhlawumbe ngenxa yokucushwa kwe-php.ini, noma ezinye izinkinga, ngakho-ke thekelisa noma ungenise ku-phpMyAdminMySQLIfayela elikhulu lithatha isikhathi eside kakhulu, futhi ukuphela kwesikhathi kwe-php kubangela ukuthekelisa noma ukungenisa kwehluleke...

Noma ngabe ukuguqulwa kuthuthukisa ukucushwa kwememori yamafayela ahlobene, ngeke kusize...

Kuleli qophelo, singadlula Linux Ukuqaliswa komugqa womyalo:

• Sebenzisa umugqa womyalo wesipele we-MySQL ukuze uthumele ngokushesha isizindalwazi se-MySQL;
• Sebenzisa umugqa womyalo wokungenisa we-MySQL ukuze ungenise ngokushesha imininingwane yolwazi ye-MySQL.

Umyalo wesizindalwazi wokuthekelisa we-MySQL

I-MySQL Backup Commands ▼

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

• umyalo awufaki izimpawu []
• Sicela uguqule i-"dumpfilename" ibe igama lefayela lakho lesizindalwazi se-MySQL.
• Qaphela umcibisholo ongakwesokudla > ukuthekelisa.

Khipha ifayela lesizindalwazi se-.gz MySQL

Uma ifayela lakho lesizindalwazi se-MySQL liminyaniswe ngesijobelelo se-.gz, alikwazi ukungeniswa kusizindalwazi ngomugqa womyalo we-SSH.

Ngaphambi kokusebenzisa umyalo wokungenisa idatha egciniwe ye-MySQL, sicela ufake umyalo olandelayo .gz unzip ukuze uvule unzip ▼

gunzip FileName.gz

• Sicela uguqule i-"FileName" ibe igama lengobo yomlando yakho ye-MySQL, isibonelo: xxx.sql.gz

Umyalo wesizindalwazi wokungenisa we-MySQL

Umyalo wokungenisa we-MySQL ▼

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

• umyalo awufaki izimpawu []
• Sicela uguqule i-"dumpfilename" ibe igama lefayela lakho lesizindalwazi se-MySQL.
• Qaphela umcibisholo wesokunxele < ngukungenisa.

Eminye imiyalo ye-SSH yezinhlelo ze-Linux ingatholakala lapha ▼

Iqoqo lomyalo wokubuka ulwazi lwesistimu ye-Linux

Umyalo wokubuka ulwazi lwesistimu ye-Linux [uhlelo] uname -a #Buka i-kernel/isistimu yokusebenza/inhloko yolwazi lwe-CPU -n 1 /etc/issue #Buka inguqulo yesistimu yokusebenza cat/proc/cpuinfo #Buka igama losokhaya le-CPU #Buka igama lekhompyutha lspci -t ...