phpMyAdmin yokungenisa idatha ye-500 impazamo? Thumela i-MySQL enkulu yomgca womyalelo wefayile

Kukho umntu obandakanyekayoEzorhweboIshishini bahlobo, njeFaka iphaneli yeVestaCPEmva koko, ufuna ukudlulaphpMyAdminUkungenisa ulawulo lweDatabaseMySQL database, iimpazamo ezingama-500 zihlala zivela, kwaye ukungenisa elizweni kuyasilela emva kokuzama amaxesha amaninzi...

Isenokuba ngenxa yoqwalaselo lwephp.ini okanye ezinye iingxaki, ngoko ke thumela ngaphandle okanye ungenise kwiphpMyAdminMySQLIifayile ezinkulu zithatha ixesha elide kakhulu, kwaye amaxesha e-PHP aphelile, abangela ukuthunyelwa okanye ukungenisa ngaphandle kokusilela...

Nokuba ulungisa kwaye unyuse uqwalaselo lwenkumbulo yeefayile ezinxulumeneyo, ayizukunceda...

Kweli nqanaba, sinokudlula Linux Ukuphunyezwa komgca womyalelo:

• Sebenzisa i-MySQL yomyalelo we-backup umgca wokukhuphela ngokukhawuleza i-database ye-MySQL;
• Sebenzisa umgca womyalelo wokungenisa weMySQL ukungenisa ngokukhawuleza isiseko sedatha seMySQL.

Umyalelo wedatha ye-MySQL yokuthumela ngaphandle

Umyalelo wokugcina i-MariaDB▼

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

Umyalelo wokugcina iMySQL ▼

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

• Umyalelo awuquki iisimboli []
• Nceda utshintshe "dumpfilename" kwigama lakho lefayile yesiseko seMySQL.
• Qaphela utolo lwasekunene > ithunyelwa ngaphandle.

Unzip ifayile yedatabase ye-.gz MySQL

Ukuba ifayile yakho yedatha ye-MySQL ine-.gz compression suffix, ayinakungeniswa kwisiseko sedatha ngomgca womyalelo we-SSH.

Phambi kokuba usebenzise umyalelo wokurhweba ngaphandle kwesiseko sedata seMySQL, nceda ufake le ilandelayo .gz decompression command to decompress▼

gunzip FileName.gz

• Nceda utshintshe i-"FileName" kwigama le-MySQL database yakho yoxinzelelo ipakethe, umzekelo: xxx.sql.gz

Umyalelo wesiseko sedatha yeMySQL

Umyalelo wokungenisa uMariaDB▼

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

Umyalelo wokungenisa iMySQL ▼

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

• Umyalelo awuquki iisimboli []
• Nceda utshintshe "dumpfilename" kwigama lakho lefayile yesiseko seMySQL.
• Qaphela utolo lwasekhohlo < Kukungenisa elizweni.

Ngeminye imiyalelo ye-SSH kwiinkqubo zeLinux, ungabona apha ▼

🔗Inkqubo yeLinux yokujonga ingqokelela yomyalelo