Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
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:
Click Here
Please login or register. 2024-03-29, 15:23:35

Author Topic: Migrase DB antar VPS  (Read 2626 times)

0 Members and 1 Guest are viewing this topic.

Offline redpages

  • Master
  • **
  • Posts: 372
  • Karma: +0/-0
    • View Profile
Migrase DB antar VPS
« 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% /

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Migrase DB antar VPS
« Reply #1 on: 2017-03-19, 03:49:48 »
Kalau pakai storage-engine selain Innodb ya tinggal salin isi tempat lama ke tempat baru.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline redpages

  • Master
  • **
  • Posts: 372
  • Karma: +0/-0
    • View Profile
Re: Migrase DB antar VPS
« Reply #2 on: 2017-03-19, 09:41:12 »
saya cek lewat phpmyadmin tipenya Aria. berarti bisa. Makasih infonya.

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.03 seconds with 18 queries.

web stats analysis