phpMyAdmin soo dejinta xogta 500 qalad? Dhoofinta MySQL khadka taliska faylka weyn

qof ku hawlanaaGanacsiga E-ganacsigaSaaxiibada warshadaha, kaliyaKu rakib guddiga VestaCPIntaa ka dib, raba inaad gudubtophpMyAdminsoo dejinta maamulka databasedatabase MySQL, waxaa dhacay 500 oo khalad ah, soo dejinta ayaa fashilantay kadib markii ay marar badan isku dayeen...

Waxaa laga yaabaa inay sabab u tahay qaabeynta php.ini, ama dhibaatooyin kale, si dhoofinta ama soo dejinta phpMyAdminMySQLFaylka weyni wuxuu qaataa waqti aad u dheer, iyo wakhtiga php-da ayaa sababa dhoofinta ama soo dejinta inay fashilmaan...

Xitaa haddii wax ka beddelku uu hagaajiyo qaabaynta xusuusta ee faylasha la xidhiidha, ma caawin doonto...

Halkaa marka ay marayso, waan dhaafi karnaa Linux Hirgelinta khadka taliska:

• Isticmaal khadka taliska MySQL si aad dhakhso ugu dhoofiso xogta MySQL;
• Isticmaal khadka taliska MySQL soo dejinta si aad dhakhso ugu soo dejiso xogta MySQL.

MySQL amarka xogta dhoofinta

Amarka kaydinta ee MariaDB▼

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

Amarada kaabta MySQL ▼

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

• amarka kuma jiraan calaamado []
• Fadlan "dumpfilename" u beddel magaca faylkaaga xogta MySQL.
• U fiirso falaarta saxda ah > waa dhoofin

Soo saar faylka xogta MySQL .gz

Haddii faylkaaga kaydka MySQL lagu cadaadiyo .gz daba-dheer, laguma soo dejin karo kaydka khadka taliska SSH.

Kahor intaadan socodsiin amarka soo dejinta xogta MySQL, fadlan geli amarka soo socda .gz unzip amarka si aad u furto ▼

gunzip FileName.gz

• Fadlan "FileName" u beddel magaca kaydka xogta MySQL, tusaale ahaan: xxx.sql.gz

MySQL soo dejinta amarka

Amarka soo dejinta ee MariaDB▼

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

MySQL soo dejinta amarka ▼

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

• amarka kuma jiraan calaamado []
• Fadlan "dumpfilename" u beddel magaca faylkaaga xogta MySQL.
• U fiirso falaarta bidix < waa soo dejinta.

Amarro badan oo SSH ah oo loogu talagalay nidaamyada Linux ayaa laga heli karaa halkan ▼

🔗Ururinta macluumaadka nidaamka Linux