MRatWork Forum by Mustafa Ramadhan - MYSQL tiba-tiba ERROR!

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, 23:09:17

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- MYSQL tiba-tiba ERROR!

« previous next »

- Print

Pages: [1] Go Down

### Author Topic: MYSQL tiba-tiba ERROR! (Read 1118 times)

0 Members and 1 Guest are viewing this topic.

#### redpages

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

##### MYSQL tiba-tiba ERROR!

« on: 2015-11-03, 18:48:25 »
Dear masta, mohon bantuannya.
Mysql tiba-tiba error. Cek status hasilnya :
Quote

> [root@server100 ~]# service mysql status
> ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Jika di cleanup ada baris spt ini
Quote

> - Get process
> - Create database interface template (Forced)
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
> >>> Execute driverload.php <<<

Sysinfo:
Quote

> A. Kloxo-MR: 7.0.0.b-2015103001
> - Web: hiawatha-9.15.0-f.6.mr.el6.i686
> - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
> B. Plateform:
> - OS: CentOS release 6.7 (Final) i686
> - Hostname: server100.xbackbone.com
> C. Services:
> 1. MySQL: MariaDB-server-10.0.22-1.el6.i686
> 2. PHP:
> - Branch: php54-cli-5.4.45-1.ius.el6.i686
> - Used: --Use PHP Branch--
> 3. Httpd: httpd-2.2.31-1.mr.el6.i386
> - PHP Type: [unknown]
> 4. Lighttpd: --uninstalled--
> 5. Hiawatha: --unused--
> 6. Nginx: --uninstalled--
> 7. Cache: --uninstalled--
> 8. Dns: bind-9.9.7-1.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: 1024 335 688 5 0 40
> -/+ buffers/cache: 294 729
> Swap: 0 0 0
> E. Disk Space:
> Filesystem Size Used Avail Use% Mounted on
> /dev/simfs 30G 5.2G 25G 18% /

Logged

#### noob

- Valuable Member
- Posts: 98
- Karma: +0/-0
- Gender:

##### Re: MYSQL tiba-tiba ERROR!

« Reply #1 on: 2015-11-04, 11:05:00 »
kalo di restart mysql nya gimana?
Code: [Select]

    service mysql restart

Logged
http://kombathost.com | Your ultimate webhosting

#### redpages

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #2 on: 2015-11-04, 12:17:14 »
Hasilnya seperti ini
Quote

> [root@server100 ~]# service mysql restart
> ERROR! MySQL server PID file could not be found!
> Starting MySQL. ERROR!
> [root@server100 ~]#

Logged

#### MRatWork

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #3 on: 2015-11-04, 12:21:06 »
Infokan 'df -h /; df -ih /'
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #4 on: 2015-11-04, 13:27:34 »
Seperti ini
Quote

> [root@server100 ~]# df -h /; df -ih /
> Filesystem Size Used Avail Use% Mounted on
> /dev/simfs 30G 5.5G 25G 19% /
> Filesystem Inodes IUsed IFree IUse% Mounted on
> /dev/simfs 15M 304K 15M 2% /

Logged

#### MRatWork

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #5 on: 2015-11-04, 14:38:35 »
Infokan 'fdisk -l'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #6 on: 2015-11-04, 21:08:57 »
tidak ada hasilnya
Quote

> [root@server100 ~]# fdisk -l
> [root@server100 ~]#

Logged

#### redpages

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #7 on: 2015-11-05, 05:23:25 »
apakah cara di indonesia-usersgimana-cara-pindah-dari-mariadb-ke-mysql.html bisa saya terapkan untuk kasus mysql saya. mengingat mysql saya MARIADB
pada baris
Quote

> Kelihatannya my.cnf anda di /etc/my.cnf.d tidak match dengan MariaDB.
> Coba rename '/etc/my.cnf.d/my.cnf' ke '/etc/my.cnf.d/my.noncnf' dan copy '/usr/share/mysql/my-medium.cnf' ke '/etc/my.cnf.d/my.cnf'.
> Kemudian coba jalankan 'service mysql restart'.

Logged

#### redpages

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

##### Re: MYSQL tiba-tiba ERROR!

« Reply #8 on: 2015-11-05, 05:49:53 »
udah saya coba dan berhasil.
Quote

> Coba rename '/etc/my.cnf.d/my.cnf' ke '/etc/my.cnf.d/my.noncnf' dan copy '/usr/share/mysql/my-medium.cnf' ke '/etc/my.cnf.d/my.cnf

case close
Logged

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- MYSQL tiba-tiba ERROR!

Top 4 Global Search Engines: Google Bing Baidu Yahoo

..:: 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.05 seconds with 18 queries.

Mirror created by MasterkinG32.CoM