Otu esi akwado ma weghachite MySQL/MariaDB ọdụ data na Linux


Edemede a na-egosi gị ọtụtụ ihe atụ bara uru gbasara otu esi arụ ọrụ ndabere dị iche iche nke MySQL/MariaDB ọdụ data site na iji mysqldump iwu yana anyị ga-ahụkwa otu esi eweghachi ha site na enyemaka nke mysql na mysqlimport iwu na Linux.

mysqldump bụ mmemme ndị ahịa na-enye iwu, a na-eji ya tụfuo ọdụ data MySQL mpaghara ma ọ bụ nke dịpụrụ adịpụ ma ọ bụ mkpokọta ọdụ data maka ndabere n'ime otu faịlụ dị larịị.

Anyị na-eche na ị tinyelarị MySQL na sistemụ Linux nwere ikike nhazi yana anyị kwenyere na ị nwelarị ntakịrị ihe ọmụma nke MySQL.

Ọ bụrụ na ị nweghị MySQL arụnyere ma ọ bụ na-enweghị ihe ọ bụla ikpughe na MySQL wee gụọ anyị akụkọ n'okpuru.

  • Otu esi etinye MySQL na Nkesa dabere na RHEL
  • Otu esi etinye MySQL na Rocky Linux na AlmaLinux
  • Etu esi etinye MySQL na Ubuntu Linux
  • Otu esi etinye MySQL na Debian
  • 20 MySQL (Mysqladmin) Iwu maka nchịkwa nchekwa data na Linux
  • 12 MySQL/MariaDB Omume Kachasị Mma maka Linux

Olee otú ndabere MySQL database na Linux?

Iji were ndabere nke MySQL ọdụ data ma ọ bụ ọdụ data, nchekwa data ga-adị na nchekwa data nkesa na ị ga-enwerịrị ike ịnweta ya. Usoro nke iwu ahụ ga-abụ.

# mysqldump -u [username] –p[password] [database_name] > [dump_file.sql]

The paramita nke iwu kwuru bụ ndị a.

  • [aha njirimara]: Aha njirimara MySQL bara uru.
  • [paswọọdụ] : Okwuntughe MySQL dị irè maka onye ọrụ.
  • [database_name]: Aha ọdụ data bara uru ịchọrọ iwere ndabere.
  • [dump_file.sql]: Aha faịlụ ndabere nke ịchọrọ ịmepụta.

Ka iwere ndabere nke otu nchekwa data, jiri iwu dị ka ndị a. Iwu a ga-atụfu usoro nchekwa data [rsyslog] na data n'ime otu faịlụ mkpofu a na-akpọ rsyslog.sql.

# mysqldump -u root -ptecmint rsyslog > rsyslog.sql

Ọ bụrụ na ịchọrọ iwere ndabere nke ọtụtụ ọdụ data, mee iwu a. Iwu ihe atụ a na-ewe nkwado ndabere na mpaghara nchekwa data [rsyslog, syslog] na data n'ime otu faịlụ a na-akpọ rsyslog_syslog.sql.

# mysqldump -u root -ptecmint --databases rsyslog syslog > rsyslog_syslog.sql

Ọ bụrụ na ịchọrọ iwere ndabere nke ọdụ data niile, wee jiri iwu a na nhọrọ -all-database. Iwu na-esonụ na-eweghachite ndabere nke ọdụ data niile na nhazi ha na data n'ime faịlụ a na-akpọ all-databases.sql.

# mysqldump -u root -ptecmint --all-databases > all-databases.sql

Ọ bụrụ na ịchọrọ naanị ndabere nke usoro nchekwa data na-enweghị data, wee jiri nhọrọ -no-data na iwu. Iwu dị n'okpuru na-ebupụ nchekwa data [rsyslog] Ọdịdị n'ime faịlụ rsyslog_structure.sql.

# mysqldump -u root -ptecmint -–no-data rsyslog > rsyslog_structure.sql

Iji kwado nchekwa data data enweghị nhazi, jiri nhọrọ –no-create-info jiri iwu ahụ. Iwu a na-ewebata data [rsyslog] data n'ime faịlụ rsyslog_data.sql.

# mysqldump -u root -ptecmint --no-create-db --no-create-info rsyslog > rsyslog_data.sql

Site n'iwu dị n'okpuru, ị nwere ike were ndabere nke otu tebụl ma ọ bụ tebụl akọwapụtara nke nchekwa data gị. Dịka ọmụmaatụ, iwu a na-ewe naanị nkwado ndabere na mpaghara wp_posts site na wordpress nchekwa data.

# mysqldump -u root -ptecmint wordpress wp_posts > wordpress_posts.sql

Ọ bụrụ na ịchọrọ iwere ndabere nke otutu ma ọ bụ ụfọdụ tebụl site na nchekwa data, wee kewaa tebụl ọ bụla na ohere.

# mysqldump -u root -ptecmint wordpress wp_posts wp_comments > wordpress_posts_comments.sql

Iwu dị n'okpuru na-eweghachite ndabere nke ihe nkesa dịpụrụ adịpụ [172.16.25.126] nchekwa data [gallery] n'ime sava mpaghara.

# mysqldump -h 172.16.25.126 -u root -ptecmint gallery > gallery.sql

Olee otú iweghachi MySQL database?

N'ime nkuzi a dị n'elu, anyị ahụla otu esi ewere ndabere nke ọdụ data, tebụl, ihe owuwu, na data naanị, ugbu a, anyị ga-ahụ otu esi eweghachi ha site na iji usoro a.

# # mysql -u [username] –p[password] [database_name] < [dump_file.sql]

Iji weghachi nchekwa data, ị ga-emerịrị nchekwa data efu na igwe ebumnuche wee weghachi nchekwa data site na iji iwu msyql. Dịka ọmụmaatụ, iwu a ga-eweghachi faịlụ rsyslog.sql na nchekwa data rsyslog.

# mysql -u root -ptecmint rsyslog < rsyslog.sql

Ọ bụrụ na ịchọrọ iweghachi nchekwa data dị adị na igwe ezubere iche, mgbe ahụ ị ga-eji iwu mysqlimport.

# mysqlimport -u root -ptecmint rsyslog < rsyslog.sql

N'otu aka ahụ, ị nwekwara ike iweghachite tebụl nchekwa data, nhazi na data. Ọ bụrụ na akụkọ a masịrị gị, kesaa ya na ndị enyi gị.