Hapa te kawemai 500 pātengi raraunga? Linux kaweake MySQL raina whakahau kōnae nui

i uru tetahiE-tauhokohokoHoa o te ahumahi, tikaTāutahia te paewhiri VestaCPI muri i tera, ka hiahia koe ki te haerephpMyAdminkawemai whakahaere pātengi raraungapātengi raraunga MySQL, kua 500 nga hapa, a i rahua te kawemai i muri i nga wa maha...

Akene na te whirihoranga php.ini, etahi atu raru ranei, ka kaweake, kawemai ranei ki phpMyAdminMySQLHe roa rawa te konae nui, na te paunga php ka taka te kaweake, kawemai ranei...

Ahakoa ka pai ake te whakarereketanga i te whirihoranga mahara o nga konae e pa ana, kaore e awhina ...

I tenei wa, ka taea e tatou te paahi Linux Whakamahinga raina whakahau:

• Whakamahia te raina whakahau tārua MySQL ki te kaweake tere te pātengi raraunga MySQL;
• Whakamahia te raina whakahau kawemai MySQL kia tere kawemai i nga papaunga raraunga MySQL.

MySQL tono pātengi raraunga kaweake

Nga Tono Pūrua MySQL ▼

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

• Ko te whakahau kaore he tohu []
• Hurihia te "dumpfilename" ki to ingoa ingoa konae raraunga MySQL.
• Tuhia te pere matau > he kaweake.

Unuhia te kōnae .gz MySQL pātengi raraunga

Mēnā ka kōpekehia tō kōnae pātengi raraunga MySQL ki te kūmuri .gz, kāore e taea te kawemai ki te pātengi raraunga mā te rārangi whakahau SSH.

I mua i te whakahaere i te whakahau ki te kawemai i te paataka raraunga MySQL, whakauruhia te whakahau .gz unzip e whai ake nei hei wetewete ▼

gunzip FileName.gz

• Huri koa "IngoaKōnae" ki te ingoa o tō pūranga pātengi raraunga MySQL, hei tauira: xxx.sql.gz

MySQL kawemai whakahau pātengi raraunga

Tono kawemai MySQL ▼

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

• Ko te whakahau kaore he tohu []
• Hurihia te "dumpfilename" ki to ingoa ingoa konae raraunga MySQL.
• Tuhia te pere maui < he kawemai.

Ka kitea etahi atu tono SSH mo nga punaha Linux i konei ▼

Ko te kohinga whakahau tiro korero punaha Linux

Ko te whakahau maataki korero mo te punaha Linux [pūnaha] uname -a #Tirohia te pata / te punaha whakahaere / te upoko korero CPU -n 1 / etc / putanga #Tirohia te putanga o te punaha whakahaere ngeru /proc/cpuinfo #Tirohia te ingoa kaihautu korero PTM #Tirohia te ingoa rorohiko lspci -t ...