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, 14:42:01

Author Topic: mysql doesn't start  (Read 5049 times)

0 Members and 1 Guest are viewing this topic.

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
mysql doesn't start
« on: 2016-09-05, 15:35:57 »
Hi.
I need a really critical and emergency HELP :-[

mysql doesn't start:
Code: [Select]
#sh /script/restart-mysql

*** Process for MYSQL/MARIADB service ***
Starting MySQL. ERROR!
  - Process: restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR!
-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'


it's my last *.err:
Code: [Select]
160905  6:12:25 [ERROR] mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905  6:12:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905 06:12:25 mysqld_safe mysqld from pid file /var/lib/mysql/srv18558.screweb.com.pid ended
160905 06:12:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160905  6:12:34 [Note] /usr/sbin/mysqld (mysqld 10.0.27-MariaDB) starting as process 24707 ...
160905  6:12:34 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160905  6:12:34 [Note] InnoDB: The InnoDB memory heap is disabled
160905  6:12:34 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160905  6:12:34 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
160905  6:12:34 [Note] InnoDB: Compressed tables use zlib 1.2.3
160905  6:12:34 [Note] InnoDB: Not using CPU crc32 instructions
160905  6:12:34 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160905  6:12:34 [Note] InnoDB: Completed initialization of buffer pool
160905  6:12:34 [Note] InnoDB: Highest supported file format is Barracuda.
160905  6:12:34 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2752155884
160905  6:12:34 [Note] InnoDB: Database was not shutdown normally!
160905  6:12:34 [Note] InnoDB: Starting crash recovery.
160905  6:12:34 [Note] InnoDB: Reading tablespace information from the .ibd files...
160905  6:12:34 [Note] InnoDB: Restoring possible half-written data pages
160905  6:12:34 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2752155894
160905  6:12:34 [Note] InnoDB: 128 rollback segment(s) are active.
160905  6:12:34 [Note] InnoDB: Waiting for purge to start
160905  6:12:34 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 2752155894
160905  6:12:34 [Note] Plugin 'FEEDBACK' is disabled.
160905  6:12:34 [Note] Server socket created on IP: '::'.
160905  6:12:34 [ERROR] mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905  6:12:34 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
160905 06:12:34 mysqld_safe mysqld from pid file /var/lib/mysql/srv18558.screweb.com.pid ended

and it's my server.cnf content:

Code: [Select]
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
performance_schema=on
default-storage-engine=innodb
;###123###skip-innodb
#OpenVZ AIO bug fix
innodb_use_native_aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]

I tired many things but none of them did not resolve the problem :(
what can I do  :-[ :-[ :-\

thanks for your future helps (specially Mustafa Ramadhan)
« Last Edit: 2016-09-05, 15:38:59 by abud »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #1 on: 2016-09-05, 16:12:23 »
Try reboot.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #2 on: 2016-09-05, 16:45:54 »
didn't work

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #3 on: 2016-09-05, 17:33:38 »
Certain table are crash. Need repair. Sadly, not easy to repair for innodb.
« Last Edit: 2016-09-05, 18:29:02 by MRatWork »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #4 on: 2016-09-05, 17:59:44 »
Table ada yang crash. Perlu di-repair. Sayangnya repair untuk innodb tidak mudah.

I'm not Indonesian, can you speak English?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #5 on: 2016-09-05, 18:32:50 »
See again my answer.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #6 on: 2016-09-05, 18:58:40 »
See again my answer.
oh! :'(


I have a .sql file, backup from my db (a backup that got with root user from all DBs include Database: `kloxo` and others) can it help?

and if you have any other source or page that help me to repair that I will try my chance ;)
« Last Edit: 2016-09-05, 19:10:33 by abud »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #7 on: 2016-09-05, 19:10:11 »
If possible, reinstall OS and Kloxo-MR and then restore Kloxo-MR backup file.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #8 on: 2016-09-05, 19:14:15 »
If possible, reinstall OS and Kloxo-MR and then restore Kloxo-MR backup file.

sadly I did not have Kloxo-MR backup file. I have .sql file that made from phpmyadmin with root user.
I can't login to kloxo-MR panel now,can I make a backup file from SSH NOW! and transfer that to another kloxo-MR on another server and replace DB files with my .sql file?if yes! how?
« Last Edit: 2016-09-05, 19:23:59 by abud »

Offline xyrane

  • Junior Member
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #9 on: 2016-09-05, 20:03:57 »
1. Exporting a MySQL database

To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:

mysqldump -uUSERNAME -pPASSWORD DATABASE > backup.sql

Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. The MySQL database will be exported to a file named "backup.sql" in your current directory. The name of the MySQL dump you are exporting to can be whatever you want.

2. Importing a MySQL database

To import a MySQl database, you need to use the mysql command. Here is the full command for importing a MySQL dump into a database:

mysql -uUSERNAME -pPASSWORD DATABASE < backup.sql

Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. For DATABASE you must use an existing database.

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #10 on: 2016-09-05, 21:57:19 »
1. Exporting a MySQL database

To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:

mysqldump -uUSERNAME -pPASSWORD DATABASE > backup.sql

Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. The MySQL database will be exported to a file named "backup.sql" in your current directory. The name of the MySQL dump you are exporting to can be whatever you want.

2. Importing a MySQL database

To import a MySQl database, you need to use the mysql command. Here is the full command for importing a MySQL dump into a database:

mysql -uUSERNAME -pPASSWORD DATABASE < backup.sql

Make sure you replace USERNAME, PASSWORD and DATABASE with the appropriate values for your database. For DATABASE you must use an existing database.
tnx for your answer but:

when I use the command I got this error:
Code: [Select]
mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")" when trying to connect

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #11 on: 2016-09-06, 02:41:04 »
Try rename ./mysql/host to /mysql/host_old and then restart mysql with 'sh /script/restart-mysql'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline abud

  • Junior Member
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: mysql doesn't start
« Reply #12 on: 2016-09-06, 16:39:23 »
Try rename ./mysql/host to /mysql/host_old and then restart mysql with 'sh /script/restart-mysql'.
thanks again

I can't find " /mysql/host " on my server,is your intention " /var/lib/mysql " ?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql doesn't start
« Reply #13 on: 2016-09-06, 16:45:04 »
Inform here 'dir -l /var/lib/mysql'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


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

Page created in 0.03 seconds with 21 queries.

web stats analysis