phpMyAdmin kawemai i te raraunga 500 hapa? Kaweake MySQL kōnae nui raina whakahau

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

MariaDB whakahau tārua▼

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

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 MariaDB▼

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

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 ▼

🔗Kohinga whakahau mataki korero mo te punaha Linux