Category: MySQL

Cacti Table ‘host’ is marked as crashed and should be repaired

Cacti Table ‘host’ is marked as crashed and should be repaired

My Cacti server lost all host information and on monitor tab its showing error  “Table ‘host’ is marked as crashed and should be repaired”

I tried google got below solution that worked for me .I got my all devices back to monitor.

go to cli directory    /var/www/html/cli/

and run command  “php repair_database.php”

[root@localhost ~]# cd /var/www/html/cli/

[root@localhost cli]# php repair_database.php
Repairing All Cacti Database Tables
Repairing Table -> ‘cdef’ Successful
Repairing Table -> ‘cdef_items’ Successful
Repairing Table -> ‘colors’ Successful
Repairing Table -> ‘data_input’ Successful
Repairing Table -> ‘data_input_data’ Successful
Repairing Table -> ‘data_input_fields’ Successful
Repairing Table -> ‘data_local’ Successful

Continue reading Cacti Table ‘host’ is marked as crashed and should be repaired

Recover MySQL root Password

Recover MySQL root Password

You can recover MySQL database server password with following five easy steps.   Step # 1: Stop the MySQL server process.

Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.

Step # 3: Connect to mysql server as the root user.

Step # 4: Setup new mysql root account password i.e. reset mysql password.

Step # 5: Exit and restart the MySQL server.

Here are commands you need to type for each step (login as the root user):

Step # 1 : Stop mysql service

# /etc/init.d/mysql stop

Output: Stopping MySQL database server: mysqld.

Step # 2: Start to MySQL server w/o password:

# mysqld_safe –skip-grant-tables &

Output:

[1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started

Step # 3: Connect to mysql server using mysql client:

# mysql -u root

Output:

Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer. mysql>

Step # 4: Setup new MySQL root user password

mysql> use mysql; mysql> update user set password=PASSWORD(“NEW-ROOT-PASSWORD”) where User=’root’; mysql> flush privileges; mysql> quit

Step # 5: Stop MySQL Server:

# /etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+  Done                    mysqld_safe –skip-grant-tables

Step # 6: Start MySQL server and test it

# /etc/init.d/mysql start # mysql -u root -p

Source link http://www.cyberciti.biz/tips/recover-mysql-root-password.html

text file

How to transfer VOS3000 database on remote server easly

Its very long process to transfer vos3000 or my sql database to remote server as you take backup and restore on remote server. This is how to transfer VOS3000 database on remote server easly

#mysqldump -u root -pPPPP  vos3000db | ssh root@x.x.x.x  mysql -u root -pKKKK  vos3000db

PPPP is local mysql root password  KKKK is  remote mysql root password x.x.x.x change with your vos3000 or mysql database server IP address

vos3000db is the database which will transfer from loacl server to remote server.

Hope it will help you .

if mysqldum is not working giving error copy backup file locally and restore the backup file as below command.

mysql -h localhost -u root -pPPPP vos3000db < vos3000dbbackup.sq

 

How to backup MySQL on Linux

How to backup MySQL on Linux

Connect to your Linux server via SSH

  1. Use the mysqldump utility to create your database backup. The command is run in the format “mysqldump –host server_name –user username –password db_name > backup_file_name.mysql”
    • Host: the hostname or IP Address of the MySQL server that hosts your database
    • User: your MySQL user name
    • Password: your MySQL password. You will be prompted to enter this when the command is executed.
    • DB Name: the name of your MySQL database
    • Backup File Name: this is the file that will contain the backup of your database.
  2. When prompted enter your database password.
  3. Your database is now being backed up to the specified file.
  4. Additional options can be found by running “mysqldump –help” .