Messages

1

Kloxo-MR Technical Helps / Re: mysql doesn't start

« 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 " ?

2

Kloxo-MR Technical Helps / Re: mysql doesn't start

« 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


3

Kloxo-MR Technical Helps / Re: mysql doesn't start

« 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?

4

Kloxo-MR Technical Helps / Re: mysql doesn't start

« 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

5

Kloxo-MR Technical Helps / Re: mysql doesn't start

« 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?

6

Kloxo-MR Technical Helps / Re: mysql doesn't start

« on: 2016-09-05, 16:45:54 »

didn't work

7

Kloxo-MR Technical Helps / 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)