MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: redpages on 2017-03-18, 23:42:52

Title: Migrase DB antar VPS
Post by: redpages on 2017-03-18, 23:42:52

Dear master,
Bagaimana memigrasikan DB antar VPS yang ukurannya besar. Ukuran DB sekira 400 MB, kalau pakai metode export import SQL rasanya ga kuat di koneksi. Bisa kah pakai cara copy file yg ada di /var/mysql ... ?

Mohon pencerahannya

Sysinfo

Quote

A. Kloxo-MR: 7.0.0.b-2015083001
   - Web: hiawatha-9.14.0-f.6.mr.el6.i386
   - PHP: php54s-5.4.44-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server30.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.21-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.44-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type:
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.11.10-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: djbdns-1.05-17.4.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1006        940         65         48         68        469
   -/+ buffers/cache:        402        604
   Swap:         2047         60       1987
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/vda1        20G  6.9G   12G  37% /

Title: Re: Migrase DB antar VPS
Post by: MRatWork on 2017-03-19, 03:49:48

Kalau pakai storage-engine selain Innodb ya tinggal salin isi tempat lama ke tempat baru.

Title: Re: Migrase DB antar VPS
Post by: redpages on 2017-03-19, 09:41:12

saya cek lewat phpmyadmin tipenya Aria. berarti bisa. Makasih infonya.