Otu esi nyefee ọdụ data MySQL niile site na ochie gaa na nkesa ọhụrụ

Ịnyefe ma ọ bụ ịkwaga nchekwa data MySQL/MariaDB n'etiti sava na-ewekarị naanị obere usoro dị mfe, mana ịnyefe data nwere ike were oge dabere na olu data ị ga-achọ ibufe.

N'ime edemede a, ị ga-amụta otu esi ebufe ma ọ bụ bufee data MySQL/MariaDB niile site na sava Linux ochie gaa na nkesa ọhụrụ, bubata ya nke ọma wee gosi na data ahụ dị.

  • Gbaa mbọ hụ na etinyere otu ụdị MySQL na nkesa abụọ ahụ nwere otu nkesa.
  • Jide n'aka na ị nwere ohere zuru oke na sava abụọ ahụ iji jide faịlụ ekpofu nchekwa data yana nchekwa data ebubatara.
  • Echela mgbe ọ bụla ịkwaga data ndekọ nchekwa data gaa na sava ọzọ. Ya adịla ọgbaghara na nhazi ime nke nchekwa data, ọ bụrụ na ịmee, ị ga-eche nsogbu ihu n'ọdịnihu.

Bupụ ọdụ data MySQL ka ọ bụrụ Faịlụ

Buru ụzọ malite site na ịbanye n'ime ihe nkesa ochie gị wee kwụsị ọrụ mysql/mariadb site na iji usoro systemctl dị ka egosiri.

# systemctl stop mariadb
OR
# systemctl stop mysql

Wee tufuo ọdụ data MySQL niile na otu faịlụ site na iji iwu mysqldump.

# mysqldump -u [user] -p --all-databases > all_databases.sql

Ozugbo agwụchachara, ị dị njikere ịnyefe ọdụ data.

Ọ bụrụ na ịchọrọ ịkwatu otu nchekwa data, ị nwere ike iji:

# mysqldump -u root -p --opt [database name] > database_name.sql

Nyefee MySQL ọdụ data wụfuo faịlụ gaa na nkesa ọhụrụ

Ugbu a jiri iwu scp bufee faịlụ wụfuo ọdụ data gị na sava ọhụrụ n'okpuru ndekọ ụlọ dịka egosiri.

# scp all_databases.sql [email :~/       [All Databases]
# scp database_name.sql [email :~/       [Singe Database]

Ozugbo ị jikọọ, a ga-ebufe nchekwa data na sava ọhụrụ.

Bubata ọdụ data MySQL kwatuo faịlụ na sava ọhụrụ

Ozugbo ebufela faịlụ mkpofu MySQL na sava ọhụrụ, ị nwere ike iji iwu na-esonụ bubata ọdụ data gị niile na MySQL.

# mysql -u [user] -p --all-databases < all_databases.sql   [All Databases]
# mysql -u [user] -p newdatabase < database_name.sql      [Singe Database]

Ozugbo mbubata ahụ mechara, ị nwere ike nyochaa ọdụ data dị na sava abụọ ahụ site na iji iwu na-esonụ na shei mysql.

# mysql -u user -p
# show databases;

Nyefee MySQL ọdụ data na ndị ọrụ gaa na nkesa ọhụrụ

Ọ bụrụ n’ịchọrọ ibugharị ọdụ data MySQL niile, ndị ọrụ, ikike na nhazi data ihe nkesa ochie gaa na nke ọhụrụ, ị nwere ike iji iwu rsync detuo ọdịnaya niile sitere na ndekọ data mysql/mariadb gaa na sava ọhụrụ dịka egosiri.

# rsync -avz /var/lib/mysql/* [email :/var/lib/mysql/

Ozugbo mbufe ahụ mechara, ị nwere ike ịtọ ikike nke mysql/mariadb data ndekọ na onye ọrụ na otu mysql, wee mee ndepụta ndekọ iji lelee na ebufela faịlụ niile.

# chown mysql:mysql -R /var/lib/mysql/
# ls  -l /var/lib/mysql/

Ọ gwụla! N'edemede a, ị mụtara ka ị na-esi na nchekwa data MySQL/MariaDB kwaga n'ụzọ dị mfe site n'otu ihe nkesa gaa na nke ọzọ. Kedu ka esi achọta usoro a ma e jiri ya tụnyere ụzọ ndị ọzọ? Ọ ga-amasị anyị ịnụ gị site na ụdị nkọwa n'okpuru ka iru anyị.