MRatWork Forum by Mustafa Ramadhan - ASK Memisahkan mySQL di HD yg berbeda

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:18:52

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- ASK Memisahkan mySQL di HD yg berbeda

« previous next »

- Print

Pages: [1] Go Down

### Author Topic: ASK Memisahkan mySQL di HD yg berbeda (Read 2113 times)

0 Members and 1 Guest are viewing this topic.

#### prandah

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

##### ASK Memisahkan mySQL di HD yg berbeda

« on: 2013-06-07, 21:23:52 »
Halo
saya mau nanya nih. gimana sih caranya step bye step untuk menaruh mySQL/Database di HD yg terpisah
dengan gambaran HD
1 : 1TB
2 : 1TB
rencana untuk yg secondary drive untuk yang mySQL
Quote

> A. Kloxo-MR: 6.5.0.f-2013031819
> B. OS: CentOS release 5.9 (Final) x86_64
> C. Apps:
> 1. MySQL: MariaDB-server-10.0.2-1
> 2. PHP: php53u-5.3.25-1.ius.el5
> 3. Httpd: httpd-2.2.24-1.el5
> 4. Lighttpd: --uninstalled--
> 5. Nginx: nginx-1.5.0-1.el5
> 6. Qmail: qmail-toaster-1.03-1.3.22.mr.el5
> - with: package 1 is not installed
> 7. Dns: bind-9.9.2-3.P2.el5
> D. Php-type (for Httpd/proxy): php-fpm_event
> E. Memory:
> total used free shared buffers cached
> Mem: 24097 21383 2714 0 422 19171
> -/+ buffers/cache: 1789 22307
> Swap: 26111 0 26111

pakek djbdns masih error yah :hammer:
« 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: ASK Memisahkan mySQL di HD yg berbeda

« Reply #1 on: 2013-06-07, 22:04:24 »
Bukannya tinggal di-mount saja partition hd baru ke /var/lib/mysql?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### MRatWork

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

##### Re: ASK Memisahkan mySQL di HD yg berbeda

« Reply #2 on: 2013-07-03, 19:25:57 »
Jika pakai myisam sebagai storage engine caranya cukup mudah:
1. Pastikan isi directory /var/lib/mysql/ tidak ada file ib_logfile0 dan yang sejenis
2. Jika memang memang pakai myisam (bukan innodb) maka jalankan perintah ini:
Code: [Select]

    # service mysql harus distop dulu
    service mysql stop

    # rename directory mysql
    mv -R /var/lib/mysql_original

    # buat directory baru and ownership
    mkdir -p /var/lib/mysql

    # mount hd baru ke directory baru; pastikan nama 'sdb' sudah benar dengan perintah 'fdisk'
    mount -t ext3 /dev/sdb /var/lib/mysql

    # copy dari tempat lama dan sesuaikan ownership
    cp -r /var/lib/mysql_original/* /var/lib/mysql/
    chown -R mysql:mysql /var/lib/mysql/

    # jalankan mysql
    service mysqld restart

    ### jika berjalan lancar; data lama bisa dihapus
    # rm -rf /var/lib/mysql_original

« 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: ASK Memisahkan mySQL di HD yg berbeda

« Reply #3 on: 2013-07-03, 19:40:26 »
saya innodb mas
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

#### prandah

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

##### Re: ASK Memisahkan mySQL di HD yg berbeda

« Reply #4 on: 2013-07-04, 06:47:03 »
akhirnya kelar juga -,-
cuman aneh nya kenapa ya ? akses phpmyadmin keluar 404 not found ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

#### prandah

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

##### Re: ASK Memisahkan mySQL di HD yg berbeda

« Reply #5 on: 2013-07-04, 07:30:25 »
solved
yum reinstall kloxomr-thirdparty-phpmyadmin
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Logged
Main Main Kesini

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- ASK Memisahkan mySQL di HD yg berbeda

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

..:: 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.036 seconds with 17 queries.

Mirror created by MasterkinG32.CoM