MRatWork Forum by Mustafa Ramadhan - Migrasi Kloxo antar VPS

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, 19:04:28

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Migrasi Kloxo antar VPS

« previous next »

- Print

Pages: [1] 2 Go Down

### Author Topic: Migrasi Kloxo antar VPS (Read 5824 times)

0 Members and 1 Guest are viewing this topic.

#### pohon

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

##### Migrasi Kloxo antar VPS

« on: 2013-07-11, 09:48:49 »
Salam buat semua.
Setelah satu bulan lebih berkutat dengan proses instalasi Kloxo-MR, akhirnya berhasil juga pakai Kloxo-MR. Awalnya emang ngotot install dari Kloxo-official dulu. Setelah gagal berulang kali, akhirnya install fresh Kloxo-MR dan ternyata sukses. Thanks buat Mr. MR. Apresiasi saya buat usaha dan perjuangan KangMas Mustafa Ramadhan.
Saya ada beberapa pertanyaan, dan bagi sesepuh mungkin ini pertanyaan bodoh. Maklum, saya newbie...

- Saat ini saya memiliki 2 VPS. Sebut saja VPS Lama dan VPS Baru - beda fisik dan beda IP. Di VPS Lama saya memasang Kloxo-Official. Di VPS Baru sudah terpasang Kloxo-MR. Pertanyaan saya, bagaimana cara memindahkan semua data (web, database, dan client) dari VPS Lama ke VPS Baru? Untuk info, VPS Lama kapasitasnya sudah mepet. Jadi tidak mungkin pakai metode backup yang di ZIP (sudah di coba dan kapasitas memang tidak memungkinkan). Saya juga sudah mencoba mencopy data menggunakan scp, tapi terjadi masalah terkait owner. Ownernya beda semua. Akhirnya saya menggunakan rsync. Berhasil dicopy dan owner sama, tapi tidak terbaca di Kloxo-MR. File yang saya rsync: /var/lib/mysql dan /home. Apa mungkin ada direktory yang belum saya copy? Mohon pencerahannya.
- Untuk dns template, bagaimana cara memindahkannya? Di pikiran saya, saya coba untuk mensetting VPS Baru dulu, setelah semua transfer file, berkas, dan setting beres, baru domain saya arahkan ke VPS Baru.

Terima kasih untuk pencerahannya.
Note: Donasi dalam bentuk Rupiah diterima? Kirim kemana?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### MRatWork

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

##### Re: Migrasi Kloxo antar VPS

« Reply #1 on: 2013-07-11, 13:52:45 »
Yang anda maksud tidak terbaca itu bagaimana?.
Apa sudah jalankan 'sh /script/fix-all; sh /script/restart-all' setelah rsync?.
Soal donasi, silahkan baca viewtopic.php?f=4&t=4495
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #2 on: 2013-07-11, 15:44:33 »
Maksudnya tidak terbaca itu, di daftar client di kloxo tidak muncul nama-nama clientnya.
Wah... itu belum saya jalankan mas... Ini akhirnya saya jalankan. Dan hasilnya gak bisa masuk karena mySQL nya gak bisa di-restart.
Code: [Select]

    [root@pohon mysql]# sh /script/fix-all; sh /script/restart-all

    - For help, type '/script/fixdns --help'
    - No argument supplied. Defaulting to localhost (master) servers

    Could not open database connection.
    - For help, type '/script/fixphp --help'
    - No argument supplied. Defaulting to localhost (master) servers

    Could not open database connection.
    - For help, type '/script/fixweb --help'
    - No argument supplied. Defaulting to localhost (master) servers

    Could not open database connection.Initialize PureFtp service
    - Initialize process
    - Restart xinetd service for pureftp

    Change qmail.init
    --------------------------
    Set '/home/vpopmail/bin/vchkpw' for root:root ownership
    Set '/home/vpopmail/bin/vchkpw' for 4751 permissions
    --------------------------
    Set '/var/qmail/control/locals' with 'localhost' only
    --------------------------
    Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    --------------------------
    Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)--------------------------

    - For help, type '/script/fixmail --help'
    - No argument supplied. Defaulting to localhost (master) servers

    Could not open database connection.--------------------------
    Could not open database connection.
    Stopping kloxo:
    Waiting for the process to die.....
    Stopped kloxo

    Starting kloxo: 11
    Could not open database connection.Started kloxo

    Stopping named:                                            [  OK  ]
    Starting named:                                            [  OK  ]
    Stopping httpd:                                            [  OK  ]
    Starting httpd:                                            [  OK  ]
    Restarting qmail:
    * Stopping qmail-smtpd.
    * Sending qmail-send SIGTERM and restarting.
    * Restarting qmail-smtpd.
    Stopping xinetd:                                           [  OK  ]
    Starting xinetd:                                           [  OK  ]
    Stopping mysqld:                                           [  OK  ]
    MySQL Daemon failed to start.
    Starting mysqld:                                           [FAILED]
    [root@pohon mysql]#

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### MRatWork

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

##### Re: Migrasi Kloxo antar VPS

« Reply #3 on: 2013-07-11, 15:48:55 »
Coba jalankan 'service mysqld restart'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #4 on: 2013-07-11, 15:53:45 »
Code: [Select]

    [root@pohon mysql]# service mysqld restart
    Stopping mysqld:                                           [  OK  ]
    MySQL Daemon failed to start.
    Starting mysqld:                                           [FAILED]

Apa mungkin ketimpa sama file dari VPS Lama waktu saya rsync ya? Tapi sebelum saya running script sh /script/fix-all; sh /script/restart-all masih bisa masuk ke Kloxo loh...
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### MRatWork

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

##### Re: Migrasi Kloxo antar VPS

« Reply #5 on: 2013-07-11, 16:11:33 »
Mestinya tidak terjadi.
Ada masalah di mysql anda.
Untuk periksa, coba berikan hasil dari 'yum list installed mysql* mariadb* MariaDB*'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #6 on: 2013-07-11, 17:46:44 »
Code: [Select]

    [root@pohon script]# yum list installed mysql* mariadb* MariaDB*
    Loaded plugins: fastestmirror, priorities, protectbase, replace
    Loading mirror speeds from cached hostfile
     * base: mirrors.hostemo.com
     * extras: mirrors.hostemo.com
     * kloxo-mr-epel: download.fedoraproject.org
     * kloxo-mr-ius: ius.cu.be
     * updates: mirror.pregi.net
    Excluding Packages from Kloxo-MR - centalt - i386
    Finished
    Excluding Packages from Kloxo-MR - IUS Community Packages for EL 5 - i386
    Finished
    Reducing Kloxo-MR - IUS Community Packages for EL 5 (special) - i386 to included packages only
    Finished
    0 packages excluded due to repository protections
    Error: No matching Packages to list

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### prandah

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

##### Re: Migrasi Kloxo antar VPS

« Reply #7 on: 2013-07-11, 19:33:43 »
MySQL nya error mas
coba cek error log apa penyebabnya ?
ato coba dengan cara ini, mungkin masalahnya mas hampir sama dengan saya ketika saya mau nambahkan HD SSD di dedi saya
1. buka /etc/my.cnf
coba tambahkan "#" di depan baris ini
Code: [Select]

     log-bin=mysql-bin
     binlog_format=mixed

    jadinya akan seperti ini :

    # log-bin=mysql-bin
    # binlog_format=mixed

2. coba hapus file ini di /var/lib/mysql
Code: [Select]

    ibdata1
    ib_logfile0
    ib_logfile1

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

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #8 on: 2013-07-11, 20:23:09 »
Terima kasih mas buat idenya.
Saran no. 1 ternyata memang sudah di comment (#). Jadi saya tidak melakukan perubahan apa pun.
Saran no. 2, saya lakukan dengan rename, ketiga nama file tersebut depannya saya rename jadi __XXX.
Kemudian saya melakukan ini:
Code: [Select]

    [root@pohon mysql]# service mysqld start
    MySQL Daemon failed to start.
    Starting mysqld:                                           [FAILED]

Masih gagal juga... ada pencerahan? :?: :?: :?: :?:
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### prandah

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

##### Re: Migrasi Kloxo antar VPS

« Reply #9 on: 2013-07-11, 20:33:12 »
coba mas
copasin mysql log nya
Code: [Select]

    /var/log/mysqld.log
    sama yang di
    /var/lib/mysql/xxxxx.err (kalo ada)

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

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #10 on: 2013-07-12, 09:27:05 »
Code: [Select]

    [root@pohon log]# vi mysqld.log
    130709 06:57:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130709  6:57:29 [Note] Plugin 'FEDERATED' is disabled.
    130709  6:57:30  InnoDB: Initializing buffer pool, size = 16.0M
    130709  6:57:30  InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    130709  6:57:30  InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    130709  6:57:30  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    130709  6:57:30  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    130709  6:57:30  InnoDB: Started; log sequence number 0 0
    130709  6:57:30 [Warning] 'user' entry 'root@pohon.web.id' ignored in --skip-name-resolve mode.
    @
    "mysqld.log" 766L, 44136C

Code: [Select]

    [root@pohon log]# tail mysqld.log
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 0 44233
    130711 14:22:28  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
    InnoDB: Apply batch completed
    130711 14:22:28  InnoDB: Started; log sequence number 0 44233
    130711 14:22:28 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
    130711 14:22:28 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
    130711 14:22:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

File /var/lib/mysql/xxxxx.err tidak ada.
Code: [Select]

    [root@pohon log]# cd /var/lib/mysql
    [root@pohon mysql]# dir *.err
    dir: *.err: No such file or directory

« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### prandah

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

##### Re: Migrasi Kloxo antar VPS

« Reply #11 on: 2013-07-12, 12:02:21 »
Code: [Select]

    can't find file: './mysql/host.frm

ini masalahnya
coba ketik ini
Code: [Select]

    mysql_upgrade

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

#### pohon

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

##### Re: Migrasi Kloxo antar VPS

« Reply #12 on: 2013-07-16, 14:45:41 »
Code: [Select]

    [root@pohon /]# mysql_upgrade
    Looking for 'mysql' as: mysql
    Looking for 'mysqlcheck' as: mysqlcheck
    Running 'mysqlcheck with default connection arguments
    mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed

Code: [Select]

    [root@pohon /]# cd /var/lib/mysql
    [root@pohon mysql]# dir mysql.sock
    dir: mysql.sock: No such file or directory

Filenya ternyata gak ada...
Apa diinstal ulang aja Kloxonya? Cuma nanti kalo mau pindahin file dan database gini lagi gak ya?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Need hosting with UNLIMITED SPACE?
Look at Pohon Web
Give your id at this forum and get special price.

#### prandah

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

##### Re: Migrasi Kloxo antar VPS

« Reply #13 on: 2013-07-16, 19:17:13 »
kalo saya sih udah nyerah reinstall :hammer:
tapi kalo mindah database meding jangan di rsync kek nya deh
mending di ambil folder database nya ajah
kalo saya sih saya backup database nya (mysldump) atu atu ntar aplodnya pakek scp
daripada kerja dua kali hihihih
« 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: Migrasi Kloxo antar VPS

« Reply #14 on: 2013-07-16, 20:10:00 »
Migrasi dari Kloxo 6.1.12 tidak ada masalah bila Kloxo-MR pakai Centos 5. Kalau pakai Centos 6 ada yang mendapat masalah yang kelihatannya karena tidak samanya storage-engine (misalnya di Kloxo 6.1.12 tidak di 'skip-innodb' tapi di Kloxo-MR di 'skip-innodb').
« 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] 2 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Migrasi Kloxo antar VPS

Top 10 Social Networking: Facebook Twitter LinkedIn Pinterest Google Plus Tumblr Instagram VK Flickr Vine

..:: Monetize Your Website with ylliXmedia ::.. ..:: Online Advertising that Sale Anything with ylliXmedia ::..

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

Page created in 0.04 seconds with 17 queries.

Mirror created by MasterkinG32.CoM