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-04-19, 12:22:27

Author Topic: Migrase DB antar VPS  (Read 2658 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.

 


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

Page created in 0.055 seconds with 18 queries.

web stats analysis