MRatWork Forum by Mustafa Ramadhan - gak bisa convert mysql to mariadb

Sponsor:
Server and Web Integrator
Link:
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:

MRatWork Forum | Please login or register. | 2017-11-07, 18:17:42

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- gak bisa convert mysql to mariadb

« previous next »

- Print

Pages: [1] Go Down

### Author Topic: gak bisa convert mysql to mariadb (Read 2450 times)

0 Members and 1 Guest are viewing this topic.

#### prandah

- Senior Member
- Posts: 343
- Karma: +0/-0

##### gak bisa convert mysql to mariadb

« on: 2013-08-07, 09:49:23 »
Code: [Select]

    [root@pegasus ~]# sh /script/mysql-to-mariadb
    *** Change MySQL to MariaDB - begin ***
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
                  : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5
                  : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
                  : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
                  : kloxo-mr-varnish-3.0 updates
    Cleaning up Everything
    Cleaning up list of fastest mirrors
    Update Services Branch List
    - List for 'dns' branch
    - List for 'dovecot' branch
    - List for 'httpd' branch
    - List for 'lighttpd' branch
    - List for 'mysql' branch
    - List for 'nginx' branch
    - List for 'php' branch
    - List for 'qmail' branch

    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
                  : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5
                  : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
                  : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
                  : kloxo-mr-varnish-3.0 updates
    Cleaning up Everything
    Cleaning up list of fastest mirrors
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Setting up Remove Process
    No Match for argument: mysql*.i386
    Determining fastest mirrors
     * base: mirror.ash.fastserv.com
     * extras: mirror.ash.fastserv.com
     * kloxo-mr-epel: mirror.symnds.com
     * kloxo-mr-ius: mirror.symnds.com
     * updates: centos.mirror.nac.net
    0 packages excluded due to repository protections
    No Packages marked for removal
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Setting up Remove Process
    No Match for argument: mysql*.i686
    Loading mirror speeds from cached hostfile
     * base: mirror.ash.fastserv.com
     * extras: mirror.ash.fastserv.com
     * kloxo-mr-epel: mirror.symnds.com
     * kloxo-mr-ius: mirror.symnds.com
     * updates: centos.mirror.nac.net
    0 packages excluded due to repository protections
    No Packages marked for removal
    [root@pegasus ~]# cat /etc/redhat-release
    CentOS release 6.4 (Final)
    [root@pegasus ~]#

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: gak bisa convert mysql to mariadb

« Reply #1 on: 2013-08-07, 09:56:34 »
File kloxo-mr.repo sudah diedit dan jalankan 'yum clean all'?.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### prandah

- Senior Member
- Posts: 343
- Karma: +0/-0

##### Re: gak bisa convert mysql to mariadb

« Reply #2 on: 2013-08-07, 10:09:15 »
sama mas :
Code: [Select]

    [root@pegasus ~]# yum clean all
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
                  : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
                  : kloxo-mr-varnish-3.0 updates
    Cleaning up Everything
    [root@pegasus ~]# sh /script/mysql-to-mariadb
    *** Change MySQL to MariaDB - begin ***
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
                  : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
                  : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
                  : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
                  : kloxo-mr-varnish-3.0 updates
    Cleaning up Everything
    Update Services Branch List
    - List for 'dns' branch
    - List for 'dovecot' branch
    - List for 'httpd' branch
    - List for 'lighttpd' branch
    - List for 'mysql' branch
    - List for 'nginx' branch
    - List for 'php' branch
    - List for 'qmail' branch

    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Cleaning repos: base extras kloxo-mr-atrpms kloxo-mr-centalt kloxo-mr-centosec
                  : kloxo-mr-epel kloxo-mr-ius kloxo-mr-ius-c5 kloxo-mr-mariadb64
                  : kloxo-mr-release-neutral-arch kloxo-mr-release-neutral-noarch
                  : kloxo-mr-release-version-arch kloxo-mr-release-version-noarch
                  : kloxo-mr-varnish-3.0 updates
    Cleaning up Everything
    Cleaning up list of fastest mirrors
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Setting up Remove Process
    No Match for argument: mysql*.i386
    Determining fastest mirrors
     * base: mirror.ash.fastserv.com
     * extras: mirror.ash.fastserv.com
     * kloxo-mr-epel: www.gtlib.gatech.edu
     * kloxo-mr-ius: mirror.symnds.com
     * updates: mirror.cs.vt.edu
    0 packages excluded due to repository protections
    No Packages marked for removal
    Loaded plugins: fastestmirror, priorities, protectbase, replace, security
    Setting up Remove Process
    No Match for argument: mysql*.i686
    Loading mirror speeds from cached hostfile
     * base: mirror.ash.fastserv.com
     * extras: mirror.ash.fastserv.com
     * kloxo-mr-epel: www.gtlib.gatech.edu
     * kloxo-mr-ius: mirror.symnds.com
     * updates: mirror.cs.vt.edu
    0 packages excluded due to repository protections
    No Packages marked for removal
    [root@pegasus ~]#

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: gak bisa convert mysql to mariadb

« Reply #3 on: 2013-08-07, 10:14:09 »
Tunjukkan hasil 'sh /script/sysinfo' dan 'cat /etc/yum.repos.d/kloxo-mr.repo'
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### prandah

- Senior Member
- Posts: 343
- Karma: +0/-0

##### Re: gak bisa convert mysql to mariadb

« Reply #4 on: 2013-08-07, 10:22:10 »
sysinfo :
Code: [Select]

    [root@pegasus ~]# sh /script/sysinfo

    A. Kloxo-MR: 6.5.0.f-2013080605

    B. OS: CentOS release 6.4 (Final) x86_64

    C. Apps:
       1. MySQL: mysql-5.5.29-1.el6.x86_64
       2. PHP: php53u-5.3.27-1.ius.el6.x86_64
       3. Httpd: httpd-2.2.25-1.el6.x86_64
       4. Lighttpd: --uninstalled--
       5. Nginx: nginx-1.5.2-1.el6.x86_64
       6. Qmail: qmail-toaster-1.03-1.3.27.mr.el6.x86_64
          - with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
       7. Dns: djbdns-1.05-17.3.mr.el6.x86_64

    D. Php-type (for Httpd/proxy): php-fpm_event

    E. Memory:
                    total       used       free     shared    buffers     cached
       Mem:         36140       1455      34684          0         75        737
       -/+ buffers/cache:        641      35498
       Swap:        18111          0      18111

    [root@pegasus ~]#

kloxo-mr.repo
Code: [Select]

    [root@pegasus ~]# cat /etc/yum.repos.d/kloxo-mr.repo
    [kloxo-mr-release-neutral-noarch]
    name=Kloxo-MR - release-neutral-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-neutral-arch]
    name=Kloxo-MR - release-neutral-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-version-noarch]
    name=Kloxo-MR - release-version-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-version-arch]
    name=Kloxo-MR - release-version-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-testing-neutral-noarch]
    name=Kloxo-MR - testing-neutral-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-neutral-arch]
    name=Kloxo-MR - testing-neutral-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-version-noarch]
    name=Kloxo-MR - testing-version-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-version-arch]
    name=Kloxo-MR - testing-version-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-srpms]
    name=Kloxo-MR - srpms
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
    enabled=0
    gpgcheck=0

    # ==================================

    [kloxo-mr-centalt]
    name=Kloxo-MR - centalt - $basearch
    baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0
    exclude=openssh* perl* mariadb* bind*

    # ==================================

    [kloxo-mr-ius]
    name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
    baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
    mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
    enabled=1
    gpgcheck=0
    exclude=php52* mysql5*

    [kloxo-mr-ius-c5]
    name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
    baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0
    includepkgs=php52*

    # ==================================

    [kloxo-mr-epel]
    name=Kloxo-MR - Extra Packages for EL 6 - $basearch
    baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
    mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
    enabled=1
    gpgcheck=0

    # ==================================

    # for varnish
    [kloxo-mr-varnish-3.0]
    name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
    baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
    enabled=1
    gpgcheck=0

    # ==================================

    # for hiawatha
    [kloxo-mr-centosec]
    name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
    baseurl=http://centos6.ecualinux.com/$basearch
    enabled=1
    gpgcheck=0
    exclude=cairo*

    # ==================================

    # for nginx-stable
    [kloxo-mr-nginx]
    name=Kloxo-MR - nginx repo
    baseurl=http://nginx.org/packages/centos/6/$basearch/
    gpgcheck=0
    enabled=0

    # ==================================

    # for mariadb
    [kloxo-mr-mariadb32]
    name=Kloxo-MR - mariadb32 repo
    baseurl=http://yum.mariadb.org/5.5/centos6-x86
    enabled=0
    gpgcheck=0

    # for mariadb
    [kloxo-mr-mariadb64]
    name=Kloxo-MR - mariadb64 repo
    baseurl=http://yum.mariadb.org/5.5/centos6-amd64
    enabled=1
    gpgcheck=0

    # ==================================

    # for atrpms
    [kloxo-mr-atrpms]
    name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
    baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
    gpgcheck=0
    enable=0
    [root@pegasus ~]#

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: gak bisa convert mysql to mariadb

« Reply #5 on: 2013-08-07, 11:18:51 »
Bisa jadi ada masalah di mariadb server sehingga rpm tidak tersedia.
Jika pakai Centos 6, sebaiknya pakai mariadb dari centalt dimana perlu ubah kloxo-mr.repo menjadi:
Code: [Select]

    [kloxo-mr-release-neutral-noarch]
    name=Kloxo-MR - release-neutral-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-neutral-arch]
    name=Kloxo-MR - release-neutral-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-version-noarch]
    name=Kloxo-MR - release-version-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-release-version-arch]
    name=Kloxo-MR - release-version-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0

    [kloxo-mr-testing-neutral-noarch]
    name=Kloxo-MR - testing-neutral-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-neutral-arch]
    name=Kloxo-MR - testing-neutral-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-version-noarch]
    name=Kloxo-MR - testing-version-noarch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-testing-version-arch]
    name=Kloxo-MR - testing-version-$basearch
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
    enabled=0
    gpgcheck=0

    [kloxo-mr-srpms]
    name=Kloxo-MR - srpms
    baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
    enabled=0
    gpgcheck=0

    # ==================================

    [kloxo-mr-centalt]
    name=Kloxo-MR - centalt - $basearch
    baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0
    exclude=openssh* perl* bind*

    # ==================================

    [kloxo-mr-ius]
    name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
    baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
    mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
    enabled=1
    gpgcheck=0
    exclude=php52* mysql5*

    [kloxo-mr-ius-c5]
    name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
    baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
    #mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
    enabled=1
    gpgcheck=0
    includepkgs=php52*

    # ==================================

    [kloxo-mr-epel]
    name=Kloxo-MR - Extra Packages for EL 6 - $basearch
    baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
    mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
    enabled=1
    gpgcheck=0

    # ==================================

    # for varnish
    [kloxo-mr-varnish-3.0]
    name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
    baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
    enabled=1
    gpgcheck=0

    # ==================================

    # for hiawatha
    [kloxo-mr-centosec]
    name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
    baseurl=http://centos6.ecualinux.com/$basearch
    enabled=1
    gpgcheck=0
    exclude=cairo*

    # ==================================

    # for nginx-stable
    [kloxo-mr-nginx]
    name=Kloxo-MR - nginx repo
    baseurl=http://nginx.org/packages/centos/6/$basearch/
    gpgcheck=0
    enabled=0

    # ==================================

    # for mariadb
    [kloxo-mr-mariadb32]
    name=Kloxo-MR - mariadb32 repo
    baseurl=http://yum.mariadb.org/5.5/centos6-x86
    enabled=0
    gpgcheck=0

    # for mariadb
    [kloxo-mr-mariadb64]
    name=Kloxo-MR - mariadb64 repo
    baseurl=http://yum.mariadb.org/5.5/centos6-amd64
    enabled=0
    gpgcheck=0

    # ==================================

    # for atrpms
    [kloxo-mr-atrpms]
    name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
    baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
    gpgcheck=0
    enable=0
    [root@pegasus ~]#

kemudian jalankan 'yum clean all; yum update' dimana kemudian terjadi update dari mysql ke mariadb dari centalt.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### agssbuzz

- Junior Member
- Posts: 28
- Karma: +0/-0

##### Re: gak bisa convert mysql to mariadb

« Reply #6 on: 2013-08-22, 02:42:17 »
Quote from: "MRatWork"

> Bisa jadi ada masalah di mariadb server sehingga rpm tidak tersedia.
> Jika pakai Centos 6, sebaiknya pakai mariadb dari centalt dimana perlu ubah kloxo-mr.repo menjadi:
> Code: [Select]

>     [kloxo-mr-release-neutral-noarch]
>     name=Kloxo-MR - release-neutral-noarch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
>     enabled=1
>     gpgcheck=0

>     [kloxo-mr-release-neutral-arch]
>     name=Kloxo-MR - release-neutral-$basearch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
>     enabled=1
>     gpgcheck=0

>     [kloxo-mr-release-version-noarch]
>     name=Kloxo-MR - release-version-noarch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/noarch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-noarch-mirrors.txt
>     enabled=1
>     gpgcheck=0

>     [kloxo-mr-release-version-arch]
>     name=Kloxo-MR - release-version-$basearch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos6/$basearch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-release-centos6-$basearch-mirrors.txt
>     enabled=1
>     gpgcheck=0

>     [kloxo-mr-testing-neutral-noarch]
>     name=Kloxo-MR - testing-neutral-noarch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
>     enabled=0
>     gpgcheck=0

>     [kloxo-mr-testing-neutral-arch]
>     name=Kloxo-MR - testing-neutral-$basearch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
>     enabled=0
>     gpgcheck=0

>     [kloxo-mr-testing-version-noarch]
>     name=Kloxo-MR - testing-version-noarch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/noarch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-noarch-mirrors.txt
>     enabled=0
>     gpgcheck=0

>     [kloxo-mr-testing-version-arch]
>     name=Kloxo-MR - testing-version-$basearch
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos6/$basearch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-testing-centos6-i386-mirrors.txt
>     enabled=0
>     gpgcheck=0

>     [kloxo-mr-srpms]
>     name=Kloxo-MR - srpms
>     baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
>     enabled=0
>     gpgcheck=0

>     # ==================================

>     [kloxo-mr-centalt]
>     name=Kloxo-MR - centalt - $basearch
>     baseurl=http://centos.alt.ru/repository/centos/6/$basearch/
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-6-$basearch-mirrors.txt
>     enabled=1
>     gpgcheck=0
>     exclude=openssh* perl* bind*

>     # ==================================

>     [kloxo-mr-ius]
>     name=Kloxo-MR - IUS Community Packages for EL 6 - $basearch
>     baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/$basearch
>     mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el6&arch=$basearch
>     enabled=1
>     gpgcheck=0
>     exclude=php52* mysql5*

>     [kloxo-mr-ius-c5]
>     name=Kloxo-MR - IUS Community Packages for EL 5 (special) - $basearch
>     baseurl=http://dl.iuscommunity.org/pub/ius/archive/CentOS/5/$basearch
>     #mirrorlist=http://rpms.potissima.com/repo/mirrors/ius-centos-5-$basearch-mirrors.txt
>     enabled=1
>     gpgcheck=0
>     includepkgs=php52*

>     # ==================================

>     [kloxo-mr-epel]
>     name=Kloxo-MR - Extra Packages for EL 6 - $basearch
>     baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch
>     mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
>     enabled=1
>     gpgcheck=0

>     # ==================================

>     # for varnish
>     [kloxo-mr-varnish-3.0]
>     name=Kloxo-MR - Varnish 3.0 for EL 6 - $basearch
>     baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el6/$basearch
>     enabled=1
>     gpgcheck=0

>     # ==================================

>     # for hiawatha
>     [kloxo-mr-centosec]
>     name=Kloxo-MR - CentOS 6 Packages from CentOS.EC
>     baseurl=http://centos6.ecualinux.com/$basearch
>     enabled=1
>     gpgcheck=0
>     exclude=cairo*

>     # ==================================

>     # for nginx-stable
>     [kloxo-mr-nginx]
>     name=Kloxo-MR - nginx repo
>     baseurl=http://nginx.org/packages/centos/6/$basearch/
>     gpgcheck=0
>     enabled=0

>     # ==================================

>     # for mariadb
>     [kloxo-mr-mariadb32]
>     name=Kloxo-MR - mariadb32 repo
>     baseurl=http://yum.mariadb.org/5.5/centos6-x86
>     enabled=0
>     gpgcheck=0

>     # for mariadb
>     [kloxo-mr-mariadb64]
>     name=Kloxo-MR - mariadb64 repo
>     baseurl=http://yum.mariadb.org/5.5/centos6-amd64
>     enabled=0
>     gpgcheck=0

>     # ==================================

>     # for atrpms
>     [kloxo-mr-atrpms]
>     name=Kloxo-MR - Fedora Core 6 - $basearch - ATrpms
>     baseurl=http://dl.atrpms.net/el6-$basearch/atrpms/stable
>     gpgcheck=0
>     enable=0
>     [root@pegasus ~]#

> kemudian jalankan 'yum clean all; yum update' dimana kemudian terjadi update dari mysql ke mariadb dari centalt.

Saya juga ada masalah pak ketika convert mysql ke mariadb.
Convert berhasil, namun panel kloxo nya mati gabisa di akses.[root@ks3099518 ~]# sh /script/cleanup
Code: [Select]

    [root@ks3099518 ~]# sh /script/restart-services
    Stopping httpd:                                           [  OK  ]
    Starting httpd:                                            [  OK  ]
    Stopping nginx:.                                           [  OK  ]
    Starting nginx:                                             [  OK  ]
    Stopping php-fpm:                                        [  OK  ]
    Starting php-fpm:                                         [  OK  ]
    Stopping qmail-toaster: svscan qmail logging.
    qmail-send: no process killed
    Starting qmail-toaster: svscan.
    Stopping xinetd:                                           [  OK  ]
    Starting xinetd:                                            [  OK  ]
    Shutting down MySQL. SUCCESS!
    Starting MySQL.. SUCCESS!
    [root@ks3099518 ~]# service kloxo restart
    Stopping kloxo-phpcgi:                                  [FAILED]
    Starting kloxo-phpcgi:                                   [  OK  ]
    Stopping kloxo-hiawatha:                               [  OK  ]
    Starting kloxo-hiawatha:                                [  OK  ]
    [root@ks3099518 ~]#

Gak bisa cleanup juga.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: gak bisa convert mysql to mariadb

« Reply #7 on: 2013-08-22, 03:04:02 »
Coba lihat di /etc/my.cnf jika ada 'skip-innodb' ubah jadi '#skip-innodb'.
Jika dalam /etc/my.cnf.d tidak ada file my.cnf. copykan /etc/my.cnf.rpmsave ke /etc/my.cnf.d/my.cnf.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- gak bisa convert mysql to mariadb

Top 4 Global Search Engines: Google Bing Baidu Yahoo

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.043 seconds with 18 queries.

Mirror created by MasterkinG32.CoM