Yadda ake Canja wurin Duk Databases MySQL Daga Tsohon zuwa Sabon Sabar


Canja wurin ko ƙaura bayanan MySQL/MariaDB tsakanin sabobin yawanci yana ɗaukar matakai kaɗan kaɗan kawai, amma canja wurin bayanai na iya ɗaukar ɗan lokaci gwargwadon girman bayanan da kuke son canjawa.

A cikin wannan labarin, zaku koyi yadda ake canjawa ko ƙaura duk bayanan MySQL/MariaDB daga tsohuwar uwar garken Linux zuwa sabon uwar garken, shigo da shi cikin nasara kuma tabbatar da cewa bayanan yana nan.

  • Tabbatar an shigar da sigar MySQL iri ɗaya akan sabar guda biyu tare da rarraba iri ɗaya.
  • Tabbatar samun isasshen sarari kyauta akan uwar garken biyu don riƙe fayil ɗin jujjuya bayanai da kuma bayanan da aka shigo da su.
  • Kada ka taɓa yin la'akari da matsar da data directory na bayanai zuwa wani uwar garken. Kada ku taɓa yin rikici da tsarin ciki na bayanan, idan kun yi haka, za ku fuskanci matsaloli a nan gaba.

Fitar da Bayanan Bayanai na MySQL zuwa Jujjuya Fayil

Da farko fara da shiga tsohuwar uwar garken ku kuma dakatar da sabis ɗin mysql/mariadb ta amfani da tsarin systemctl kamar yadda aka nuna.

# systemctl stop mariadb
OR
# systemctl stop mysql

Sannan zubar da duk bayanan MySQL zuwa fayil guda ta amfani da umarnin mysqldump.

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

Da zarar an gama juji, kun shirya don canja wurin bayanan bayanai.

Idan kuna son zubar da bayanai guda ɗaya, kuna iya amfani da:

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

Canja wurin Databases MySQL Juji Fayil zuwa Sabon Sabar

Yanzu yi amfani da umarnin scp don canja wurin fayil ɗin jujjuya bayanan bayananku zuwa sabon uwar garken ƙarƙashin littafin gida kamar yadda aka nuna.

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

Da zarar kun haɗa, za a canja wurin bayanan zuwa sabuwar uwar garken.

Shigo da Bayanan Bayanai na MySQL Juji Fayil zuwa Sabon Sabar

Da zarar an yi cinikin fayil ɗin juji na MySQL zuwa sabon uwar garken, zaku iya amfani da umarni mai zuwa don shigo da duk bayananku cikin MySQL.

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

Da zarar an gama shigo da kaya, zaku iya tabbatar da bayanan bayanai akan sabobin biyu ta amfani da umarni mai zuwa akan harsashi mysql.

# mysql -u user -p
# show databases;

Canja wurin Databases na MySQL da Masu amfani zuwa Sabon Sabar

Idan kuna son matsar da duk bayanan MySQL ɗinku, masu amfani, izini da tsarin bayanan tsohuwar uwar garken zuwa sababbi, zaku iya amfani da umarnin rsync don kwafi duk abun ciki daga kundin bayanan mysql/mariadb zuwa sabon sabar kamar yadda aka nuna.

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

Da zarar an gama canja wurin, zaku iya saita ikon mallakar asusun bayanan mysql/mariadb zuwa mai amfani da rukuni na mysql, sannan kuyi lissafin adireshi don bincika cewa an canja wurin duk fayiloli.

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

Shi ke nan! A cikin wannan labarin, kun koyi yadda ake yin ƙaura cikin sauƙi duk bayanan MySQL/MariaDB daga wannan sabar zuwa wani. Yaya kuke samun wannan hanyar idan aka kwatanta da sauran hanyoyin? Muna son jin ta bakinku ta hanyar sharhin da ke kasa don isa gare mu.