تبدیل MySQL به MariaDB در دایرکت ادمین

حتمابرای شما هم اتفاق افتاده که بخواهید دیتا بیس خود را از MySQL به MariaDB تغییر دهید.

نسخه دیتا بیس MariaDB نسبت به MySQL جدید تر می باشد و کاربران زیادی تمایل دارند که با این دیتا بیس کار کنند.

در این آموزش میخواهیم تبدیل MySQL با نسخه 5.5 به MariaDB با نسخه 5.5 را در کنترل پنل direct admin آموزش دهیم.

نکته :

قبل از هر کاری از دیتا بیس خود بکاپ کاملی تهیه کنید تا در هنگام تغییر اگر مشکلی بوجود آمد سریعا دیتا بیس قبلی خود را ریستور کنید.

برای تهیه بکاپ دیتا بیس نیز می توانید از کامند های زیر در SSH سرور استفاد نمایید:

cd /usr/local/directadmin/custombuild
./build set mysql_backup yes
./build mysql_backup

پس از این که فرایند بکاپ گیری تمام شد حال می توانید نام بکاپ را تغییر دهید:

mv mysql_backups mysql_backups.`date +%F`
./build set mysql_backup no

در ادامه از آدرس:

/var/lib/mysql folder

کپی تهیه نمایید و با استفاده از کامند زیر MySQL را متوقف می کنید. پس از تهیه کپی نیز بکاپ را در پوشه ای دیگر قرار می دهیم:

perl -pi -e 's/mysqld=ON/mysqld=OFF/' /usr/local/directadmin/data/admin/services.status
service mysqld stop
cd /var/lib
cp -Rp mysql mysql.conversion_backup

حال می توانیم نصب MariaDB را آغاز کنیم:

./build set mariadb 5.5
./build set mysql_inst mariadb
./build mariadb

پس از نصب کامل MariaDB می بایست کانفیگ های مهم مانند PHP را مجدد بررسی و نصب کنیم. برای انجام این کار نیز می توانیم از کامند زیر استفاده نمایید:

./build php n

پس از انجام تمامی این مراحل اکنون می توانید بکاپ خود را در دیتا بیس ریستور کنید. برای انجام این کار نیز می توانید از کامند زیر استفاده نمایید:

perl -pi -e 's/mysqld=OFF/mysqld=ON/' /usr/local/directadmin/data/admin/services.status
./build set mysql_backup yes

برای تبدیل MariaDB به MySQL نیز دقیقا همین مراحل را انجام می دهید.

امیدواریم این آموزش توانسته باشد نیاز شما را برطرف کند. هاستینو هاست ارزان

آموزش MySQL به MariaDB , نحوه آپدیت MySQL به MariaDB , تغییر MySQL به MariaDB در دایرکت ادمین , تغییر MySQL به MariaDB در direct admin

1,814 پاسخ

  1. I signed up for rio66bet.info. It seems legit so far. Placing my first bets now. The site seems a bit slow, but it looks good, so fingers crossed! Here’s the link for anyone curious: rio66bet

  2. п»їTo be honest, I discovered a useful article about generic pills from India. It covers the manufacturing standards for generic meds. In case you need reliable shipping to USA, check this out: п»їbest india pharmacy. Worth a read.

  3. What’s the deal, everyone? I hit up ketqua888 just the other day, and it looks like an alright spot. Gotta compare it to your usual haunts, but it wasn’t terrible. Give it a try at ketqua888.

  4. п»їLately, I found an interesting guide about generic pills availability. It covers the safety protocols when buying antibiotics. If you are looking for reliable shipping to USA, go here: п»їhttps://polkcity.us.com/# mexico pharmacy. Might be useful.

  5. п»їTo be honest, I found a useful page concerning cheap Indian generics. It explains the manufacturing standards when buying antibiotics. In case you need Trusted Indian sources, go here: п»їhttps://kisawyer.us.com/# п»їlegitimate online pharmacies india. Worth a read.

  6. п»їRecently, I stumbled upon a useful report regarding ordering meds from Mexico. It details how to save money when buying antibiotics. If anyone wants affordable options, check this out: п»їUpstate Medical. It helped me.

  7. п»їActually, I stumbled upon a helpful resource regarding ordering meds from India. It covers WHO-GMP protocols for ED medication. If anyone wants Trusted Indian sources, visit this link: п»їread more. It helped me.

  8. п»їRecently, I discovered a helpful resource regarding ordering meds from India. It explains the manufacturing standards on prescriptions. If you are looking for cheaper alternatives, go here: п»їlink. Hope it helps.

  9. п»їJust now, I discovered an interesting resource about Indian Pharmacy exports. The site discusses how to save money for ED medication. If you are looking for Trusted Indian sources, go here: п»їkisawyer.us.com. Worth a read.

  10. п»їLately, I stumbled upon a helpful article concerning cheap Indian generics. It explains CDSCO regulations for generic meds. In case you need reliable shipping to USA, check this out: п»їindian pharmacy. Cheers.

  11. п»їJust now, I stumbled upon a great report concerning ordering meds from India. It covers the manufacturing standards for ED medication. If anyone wants factory prices, read this: п»їkisawyer.us.com. Good info.

  12. п»їActually, I stumbled upon a great resource concerning generic pills from India. It explains how to save money when buying antibiotics. If you are looking for cheaper alternatives, visit this link: п»їkisawyer.us.com. Worth a read.

  13. п»їLately, I discovered an informative report regarding generic pills availability. The site discusses how to save money for ED medication. In case you need Trusted pharmacy sources, read this: п»їUpstate Medical. Good info.

  14. п»їActually, I stumbled upon an interesting page concerning safe pharmacy shipping. It details how to save money on prescriptions. If anyone wants cheaper alternatives, go here: п»їhttps://polkcity.us.com/# mexico prescription online. Good info.

  15. п»їTo be honest, I discovered a helpful guide about generic pills from India. The site discusses the manufacturing standards when buying antibiotics. If anyone wants reliable shipping to USA, read this: п»їkisawyer.us.com. It helped me.

  16. п»їLately, I stumbled upon a helpful article regarding ordering meds from India. It covers how to save money on prescriptions. For those interested in factory prices, take a look: п»їmore info. Hope it helps.

  17. п»їRecently, I came across a great report concerning buying affordable antibiotics. The site discusses WHO-GMP protocols when buying antibiotics. In case you need cheaper alternatives, check this out: п»їOnline medicine home delivery. Worth a read.

  18. п»їActually, I discovered an interesting article regarding generic pills from India. It covers the manufacturing standards for ED medication. If you are looking for factory prices, go here: п»їindia online pharmacy. Good info.

  19. п»їActually, I came across a useful page about generic pills availability. The site discusses how to save money when buying antibiotics. If you are looking for cheaper alternatives, go here: п»їwebsite. Might be useful.

  20. FYI, a detailed overview on Mexican Pharmacy safety. It explains how to avoid scams for generics. Link: п»їhttps://polkcity.us.com/# pharmacy mexico.

  21. п»їTo be honest, I discovered an interesting guide regarding cheap Indian generics. It details WHO-GMP protocols when buying antibiotics. If anyone wants Trusted Indian sources, read this: п»їtop 10 pharmacies in india. Worth a read.

  22. п»їJust now, I found an interesting article about cheap Indian generics. The site discusses how to save money for ED medication. For those interested in cheaper alternatives, check this out: п»їhttps://kisawyer.us.com/# india pharmacy mail order. Might be useful.

  23. п»їRecently, I discovered an informative resource regarding ordering meds from India. The site discusses WHO-GMP protocols for ED medication. For those interested in cheaper alternatives, read this: п»їkisawyer.us.com. Good info.

  24. FYI, a helpful analysis on Mexican Pharmacy safety. It explains pricing differences for ED meds. Full info: п»їhttps://polkcity.us.com/# meds from mexico.

  25. п»їActually, I came across an interesting guide regarding Indian Pharmacy exports. It details how to save money when buying antibiotics. In case you need reliable shipping to USA, take a look: п»їhomepage. Cheers.

  26. п»їActually, I stumbled upon an interesting resource concerning cheap Indian generics. It details WHO-GMP protocols on prescriptions. In case you need Trusted Indian sources, take a look: п»їhttps://kisawyer.us.com/# india pharmacy. It helped me.

  27. п»їActually, I stumbled upon a useful article about cheap Indian generics. It covers CDSCO regulations for generic meds. If anyone wants cheaper alternatives, check this out: п»їkisawyer.us.com. Hope it helps.

  28. п»їRecently, I stumbled upon a great page about cheap Indian generics. It details WHO-GMP protocols for ED medication. In case you need factory prices, check this out: п»їhttps://kisawyer.us.com/# buy medicines online in india. Cheers.

  29. п»їTo be honest, I came across a useful resource regarding Indian Pharmacy exports. It details the manufacturing standards when buying antibiotics. If you are looking for reliable shipping to USA, read this: п»їmail order pharmacy india. Hope it helps.

  30. Stop overpaying and save cash on meds, you should try checking this resource. The site explains trusted Mexican pharmacies. Huge savings at this link: п»їofficial site.

  31. п»їActually, I came across a useful page regarding buying affordable antibiotics. It covers the manufacturing standards for generic meds. If you are looking for cheaper alternatives, read this: п»їnavigate here. It helped me.

  32. п»їJust now, I stumbled upon a useful report about ordering meds from India. It explains WHO-GMP protocols when buying antibiotics. If you are looking for reliable shipping to USA, visit this link: п»їkisawyer.us.com. Cheers.

  33. Quick question about getting antibiotics without prescription. I ran into a decent post that ranks trusted vendors: п»їthis link. Any thoughts?.

  34. п»їLately, I discovered a helpful report regarding cheap Indian generics. The site discusses CDSCO regulations for ED medication. If you are looking for factory prices, visit this link: п»їkisawyer.us.com. Cheers.

  35. п»їLately, I came across an informative article regarding Indian Pharmacy exports. It covers CDSCO regulations for ED medication. If you are looking for reliable shipping to USA, check this out: п»їhttps://kisawyer.us.com/# indian pharmacies safe. Might be useful.

  36. п»їActually, I found a great report concerning ordering meds from India. It details the manufacturing standards for generic meds. If you are looking for cheaper alternatives, take a look: п»їhttps://kisawyer.us.com/# indian pharmacies safe. It helped me.

  37. п»їLately, I found an informative page about cheap Indian generics. It details how to save money for ED medication. If you are looking for factory prices, take a look: п»їkisawyer.us.com. Worth a read.

  38. Just wanted to share, an important analysis on cross-border shipping rules. The author describes quality control for ED meds. Source: п»їhttps://polkcity.us.com/# mexico pharmacy.

  39. п»їActually, I discovered an interesting guide about generic pills from India. It covers the manufacturing standards on prescriptions. In case you need Trusted Indian sources, read this: п»їkisawyer.us.com. It helped me.

  40. FYI, an official overview on FDA equivalent standards. It explains the best shipping methods for antibiotics. Link: п»їhttps://polkcity.us.com/# the purple pharmacy mexico.

  41. п»їTo be honest, I stumbled upon a useful article regarding generic pills from India. It details how to save money on prescriptions. If anyone wants Trusted Indian sources, take a look: п»їkisawyer.us.com. Hope it helps.

  42. п»їRecently, I came across a helpful page about buying affordable antibiotics. It covers how to save money for ED medication. In case you need Trusted Indian sources, visit this link: п»їtop online pharmacy india. Might be useful.

  43. п»їActually, I found a useful page concerning generic pills from India. The site discusses how to save money when buying antibiotics. In case you need factory prices, visit this link: п»їhere. It helped me.

  44. п»їTo be honest, I found an interesting page about buying affordable antibiotics. It explains how to save money on prescriptions. If anyone wants reliable shipping to USA, check this out: п»їп»їclick here. Cheers.

  45. п»їActually, I discovered an interesting report concerning cheap Indian generics. It explains the manufacturing standards when buying antibiotics. In case you need cheaper alternatives, take a look: п»їhttps://kisawyer.us.com/# buy medicines online in india. Might be useful.

  46. п»їActually, I came across an interesting article about buying affordable antibiotics. The site discusses the manufacturing standards when buying antibiotics. In case you need Trusted Indian sources, take a look: п»їkisawyer.us.com. Hope it helps.

  47. п»їRecently, I discovered an informative page regarding buying affordable antibiotics. It covers how to save money for ED medication. If anyone wants Trusted pharmacy sources, check this out: п»їuseful link. Hope it helps.

  48. п»їTo be honest, I found a useful guide regarding generic pills from India. It covers how to save money for generic meds. In case you need factory prices, visit this link: п»їhttps://kisawyer.us.com/# п»їlegitimate online pharmacies india. Cheers.

  49. п»їTo be honest, I stumbled upon an interesting guide concerning buying affordable antibiotics. It covers WHO-GMP protocols for generic meds. For those interested in cheaper alternatives, check this out: п»їrecommended. Cheers.

  50. п»їActually, I came across an interesting resource about ordering meds from India. It explains WHO-GMP protocols on prescriptions. In case you need Trusted Indian sources, check this out: п»їkisawyer.us.com. Good info.

  51. п»їTo be honest, I found a useful report about generic pills from India. It covers WHO-GMP protocols when buying antibiotics. If you are looking for reliable shipping to USA, read this: п»їhttps://kisawyer.us.com/# india pharmacy. Cheers.

  52. п»їActually, I stumbled upon a helpful resource about Indian Pharmacy exports. It explains the manufacturing standards for ED medication. In case you need cheaper alternatives, take a look: п»їhttps://kisawyer.us.com/# indianpharmacy com. It helped me.

  53. п»їTo be honest, I discovered a helpful guide regarding buying affordable antibiotics. It covers WHO-GMP protocols on prescriptions. For those interested in factory prices, read this: п»їhttps://kisawyer.us.com/# world pharmacy india. Worth a read.

  54. Stop overpaying and save on pharmacy costs, I recommend visiting this page. It shows where to buy cheap. Good deals available here: п»їhttps://polkcity.us.com/# pharmacy mexico.

  55. FYI, a detailed analysis on FDA equivalent standards. It breaks down the best shipping methods for ED meds. Source: п»їhttps://polkcity.us.com/# farmacia mexicana en linea.

  56. п»їTo be honest, I stumbled upon a great article about ordering meds from India. It covers CDSCO regulations for generic meds. For those interested in Trusted Indian sources, go here: п»їnavigate here. Might be useful.

  57. п»їActually, I found an informative resource concerning generic pills from India. It details how to save money when buying antibiotics. For those interested in cheaper alternatives, take a look: п»їrecommended. Cheers.

  58. п»їRecently, I found a helpful article about ordering meds from India. It explains CDSCO regulations for generic meds. In case you need reliable shipping to USA, read this: п»їhttps://kisawyer.us.com/# best online pharmacy india. Might be useful.

  59. п»їActually, I stumbled upon a useful report concerning cheap Indian generics. The site discusses the manufacturing standards for generic meds. In case you need reliable shipping to USA, check this out: п»їcheapest online pharmacy india. Cheers.

  60. п»їLately, I found a great report regarding generic pills availability. It details regulations when buying antibiotics. In case you need affordable options, check this out: п»їhttps://polkcity.us.com/# pharmacy online. Good info.

  61. To save money on prescriptions, you should try checking this report. The site explains where to buy cheap. Good deals available here: п»їreading.

  62. п»їRecently, I found a helpful resource regarding Indian Pharmacy exports. The site discusses WHO-GMP protocols for ED medication. If you are looking for Trusted Indian sources, visit this link: п»їkisawyer.us.com. Worth a read.

  63. п»їActually, I came across a useful resource about Indian Pharmacy exports. It covers WHO-GMP protocols when buying antibiotics. If you are looking for reliable shipping to USA, read this: п»їhttps://kisawyer.us.com/# best online pharmacy india. Cheers.

  64. Sharing, a helpful article on FDA equivalent standards. It explains the best shipping methods for antibiotics. Link: п»їhttps://polkcity.us.com/# mexican pharmacies.

  65. п»їRecently, I discovered an informative guide regarding ordering meds from India. It covers the manufacturing standards for generic meds. For those interested in cheaper alternatives, take a look: п»їhttps://kisawyer.us.com/# top 10 online pharmacy in india. Cheers.

  66. п»їRecently, I came across a helpful report regarding buying affordable antibiotics. It covers how to save money on prescriptions. For those interested in Trusted Indian sources, read this: п»їkisawyer.us.com. Cheers.

  67. п»їJust now, I came across a helpful resource concerning ordering meds from India. It explains the manufacturing standards on prescriptions. For those interested in cheaper alternatives, take a look: п»їkisawyer.us.com. Hope it helps.

  68. п»їRecently, I stumbled upon a helpful report regarding ordering meds from Mexico. The site discusses regulations for generic meds. If anyone wants cheaper alternatives, visit this link: п»їhttps://polkcity.us.com/# mexican online pharmacy wegovy. Hope it helps.

  69. п»їTo be honest, I stumbled upon an informative page about ordering meds from Mexico. The site discusses regulations for generic meds. For those interested in cheaper alternatives, take a look: п»їhttps://polkcity.us.com/# order antibiotics from mexico. Hope it helps.

  70. п»їTo be honest, I found a useful article about buying affordable antibiotics. It covers the manufacturing standards when buying antibiotics. If anyone wants reliable shipping to USA, visit this link: п»їhere. Cheers.

  71. п»їJust now, I discovered an informative resource concerning generic pills from India. It details WHO-GMP protocols for generic meds. In case you need cheaper alternatives, read this: п»їmore info. Cheers.

  72. Stop overpaying and save big on pills, I suggest checking this resource. It reveals shipping costs. Discounted options available here: п»їhttps://polkcity.us.com/# order antibiotics from mexico.

  73. п»їLately, I discovered an informative article concerning ordering meds from India. It explains CDSCO regulations for ED medication. In case you need Trusted Indian sources, read this: п»їcheck here. Good info.

  74. п»їRecently, I found a useful report about ordering meds from India. It details how to save money for ED medication. If anyone wants factory prices, check this out: п»їhttps://kisawyer.us.com/# buy prescription drugs from india. It helped me.

  75. п»їRecently, I came across a helpful article concerning safe pharmacy shipping. It explains regulations on prescriptions. For those interested in cheaper alternatives, read this: п»їpolkcity.us.com. Might be useful.

  76. п»їRecently, I stumbled upon a helpful article about Indian Pharmacy exports. It explains WHO-GMP protocols for ED medication. If you are looking for reliable shipping to USA, read this: п»їkisawyer.us.com. Cheers.

  77. п»їActually, I stumbled upon a great article regarding generic pills from India. It details the manufacturing standards when buying antibiotics. If anyone wants cheaper alternatives, take a look: п»їindian pharmacy. Hope it helps.

  78. п»їRecently, I stumbled upon an informative page regarding generic pills availability. The site discusses FDA equivalents on prescriptions. If you are looking for reliable shipping to USA, check this out: п»їsee more. It helped me.

  79. п»їActually, I discovered a helpful page about Indian Pharmacy exports. It explains WHO-GMP protocols when buying antibiotics. If you are looking for reliable shipping to USA, check this out: п»їpharmacy website india. It helped me.

  80. п»їJust now, I stumbled upon a useful guide concerning Indian Pharmacy exports. It covers CDSCO regulations on prescriptions. If anyone wants factory prices, check this out: п»їhere. Worth a read.

  81. п»їActually, I came across a great guide concerning generic pills from India. The site discusses CDSCO regulations on prescriptions. In case you need Trusted Indian sources, check this out: п»їhere. Good info.

  82. п»їActually, I found a useful article regarding Indian Pharmacy exports. It explains WHO-GMP protocols for ED medication. In case you need Trusted Indian sources, read this: п»їkisawyer.us.com. Good info.

  83. For those looking to save cash on meds, you should try checking this page. It shows prices for generics. Huge savings found here: п»їhttps://polkcity.us.com/# mexican pharmacys.

  84. п»їActually, I came across a useful report about cheap Indian generics. It explains how to save money for ED medication. If you are looking for reliable shipping to USA, go here: п»їhttps://kisawyer.us.com/# buy prescription drugs from india. Hope it helps.

  85. п»їLately, I came across an informative guide concerning buying affordable antibiotics. It covers CDSCO regulations for ED medication. If you are looking for cheaper alternatives, visit this link: п»їkisawyer.us.com. Cheers.

  86. FYI, a helpful analysis on Mexican Pharmacy safety. It breaks down quality control for generics. Full info: п»їhttps://polkcity.us.com/# mexican pharmacies that ship.

  87. п»їActually, I came across an interesting page regarding cheap Indian generics. It details CDSCO regulations for ED medication. In case you need factory prices, read this: п»їhttps://kisawyer.us.com/# best india pharmacy. It helped me.

  88. п»їJust now, I came across an informative report about cheap Indian generics. The site discusses the manufacturing standards when buying antibiotics. If anyone wants factory prices, go here: п»їkisawyer.us.com. It helped me.

  89. п»їRecently, I came across a helpful report about generic pills from India. It covers the manufacturing standards for ED medication. If anyone wants cheaper alternatives, go here: п»їbest india pharmacy. Hope it helps.

  90. п»їJust now, I stumbled upon a useful resource concerning buying affordable antibiotics. It details the manufacturing standards for ED medication. If you are looking for reliable shipping to USA, read this: п»їbuy prescription drugs from india. Worth a read.

  91. п»їActually, I came across an informative page concerning generic pills from India. The site discusses the manufacturing standards for generic meds. If you are looking for cheaper alternatives, go here: п»їfollow. Worth a read.

  92. п»їTo be honest, I found an informative guide about Indian Pharmacy exports. It covers how to save money on prescriptions. If you are looking for factory prices, check this out: п»їnavigate here. Hope it helps.

  93. п»їJust now, I discovered a great page concerning ordering meds from India. It details CDSCO regulations when buying antibiotics. If you are looking for cheaper alternatives, read this: п»їhttps://kisawyer.us.com/# mail order pharmacy india. Good info.

  94. Xin chào 500 anh em, bác nào muốn tìm nhà cái uy tín để chơi Nổ Hũ đừng bỏ qua con hàng này. Đang có khuyến mãi: Tải Sunwin. Chúc các bác rực rỡ.

  95. Chào cả nhà, nếu anh em đang kiếm sân chơi đẳng cấp để gỡ gạc Nổ Hũ thì xem thử chỗ này. Nạp rút 1-1: Sunwin web. Chiến thắng nhé.

  96. Xin chào 500 anh em, bác nào muốn tìm chỗ nạp rút nhanh để chơi Game bài thì xem thử con hàng này. Uy tín luôn: bj88. Húp lộc đầy nhà.

  97. Hello, I wanted to share a trusted online pharmacy to order health products cheaply. I recommend this pharmacy: MagMaxHealth. Selling high quality drugs and huge discounts. Good luck.

  98. Hi guys, if you need a reliable drugstore to purchase prescription drugs cheaply. I recommend MagMaxHealth: lipitor. Selling generic tablets and huge discounts. Thanks.

  99. Hi guys, if you are looking for a great drugstore to order health products securely. Check out this site: celebrex. Stocking a wide range of meds at the best prices. Thanks.

  100. Greetings, if you need a trusted drugstore to order medicines securely. Check out MagMaxHealth: meclizine. Stocking generic tablets and huge discounts. Hope this helps.

دیدگاهتان را بنویسید

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *