phpMyAdmin import database 500 cholakwika? Tumizani fayilo yayikulu ya MySQL mzere wamafayilo

wina anachita nawoZamalondaAnzake amakampani, basiIkani gulu la VestaCPPambuyo pake, mukufuna kupitaphpMyAdminkulowetsa kasamalidwe ka databaseMySQL database, pakhala zolakwika 500, ndipo kuitanitsa kunalephera pambuyo poyesera kangapo...

Mwina chifukwa cha php.ini kasinthidwe, kapena mavuto ena, kotero kutumiza kapena kuitanitsa mu phpMyAdminMySQLFayilo yayikulu imatenga nthawi yayitali kwambiri, ndipo kutha kwa php kumapangitsa kutumiza kapena kutumiza kulephera ...

Ngakhale kusinthidwako kumapangitsa kusintha kwamakumbukidwe a mafayilo okhudzana, sikungathandize ...

Panthawiyi, tikhoza kudutsa Linux Kukhazikitsa mzere wolamula:

• Gwiritsani ntchito mzere wosunga zosunga zobwezeretsera wa MySQL kuti mutumize mwachangu database ya MySQL;
• Gwiritsani ntchito mzere wolamula wa MySQL kuti mulowetse mwachangu ma database a MySQL.

MySQL export database command

Lamulo losunga zobwezeretsera la MariaDB▼

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

MySQL Backup Commands ▼

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

• lamulo silimaphatikizapo zizindikiro []
• Chonde sinthani "dumpfilename" kukhala dzina lafayilo yanu ya MySQL.
• Onani muvi wakumanja > ndi kutumiza kunja.

Chotsani .gz MySQL database file

Ngati fayilo yanu ya database ya MySQL yapanikizidwa ndi .gz suffix, siingathe kutumizidwa ku database kudzera pa mzere wa SSH.

Musanapereke lamulo loti mulowetse database ya MySQL, chonde lowetsani lamulo lotsatirali la .gz unzip kuti mutsegule ▼

gunzip FileName.gz

• Chonde sinthani "FileName" kukhala dzina lankhokwe yanu ya MySQL, mwachitsanzo: xxx.sql.gz

MySQL import database command

Lamulo lolowetsa la MariaDB▼

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

MySQL import command ▼

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

• lamulo silimaphatikizapo zizindikiro []
• Chonde sinthani "dumpfilename" kukhala dzina lafayilo yanu ya MySQL.
• Onani muvi wakumanzere < ndi import.

Malamulo ena a SSH pamakina a Linux atha kupezeka apa ▼

🔗Kutolereni kwamalamulo a Linux system