Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Rw ui expands macro

Rw expand
expandedtrue
titleSoftware Requirements

Server

Software

  • XAMPP for Linux Apache + MariaDB + PHP
  • Version 5.6.30


Rw ui expands macro

Rw expand
expandedtrue
titleApplication Details

Database

  • MariaDB(MySQL) Config File - /opt/lampp/etc/my.cnf
  • MariaDB Data Directory - /opt/lampp/var/mysql

Database backups

  • Directory - /opt/lampp/mysql_backups/
  • Crontab - does daily full database dump
    • jz322@cbsugobiixvm09:~/bin$ crontab -l
    • 5 2 * * * /home/jz322/bin/jz322_backup.sh > /dev/null 2>&1
  • Scripts
    • /home/jz322/bin/jz322_backup.sh
    • /home/jz322/bin/mysql.con - Database Connection Script that contains root username and password

Example – how to edit data table