How to backup and rebuild LVE database

Issue

How to back up and rebuild the LVE database?

Environment

• CloudLinux OS

Solution

1. Get the database type

   grep db_type /etc/sysconfig/lvestats2 | grep -v "#"

2. Backup the database
   • If the "db_type=mysql" then

     1. Fetch the connection string from the config:

        grep connect_string /etc/sysconfig/lvestats2
        connect_string = USER:PASSWORD@HOST[:PORT]/DATABASE
        connect_string=jdoe:SoMe_Passwd@203.0.113.2/lveinfo

     2. Backup LVE info database from MySQL server

        mysqldump -u jdoe -h 203.0.113.2 -p -D lveinfo > /root/lveinfo_db_backup_$(date +%Y-%m-%d).sql

   • If the "db_type=sqlite" then

     1. Stop the service and backup data

        service lvestats stop
        tar -zcvf /root/lveinfo_backup_$(date +%Y-%m-%d).tar.gz /var/lve/
        mv /var/lve/lvestats2.db{,.old}

3. Re-create the database

   Warning: The operation will remove the database and recreate it as a new one

   lve-create-db --recreate

   service lvestats start