mysql

  1. P

    Mysql or Mariadb. 2 node Replication / Cluster

    We have moved to working from home, and our CRM solutions is a LAMP application and we want to provide an HA environment. (We are currently running on a single server using a VPN to access it. ) I have set up the following environment as a Lab and all works really well until one site loses...
  2. J

    Mysql error!

    Hi I keep getting this error while trying to either configure or even remove mysql-server-8.0 and cant seem to find anything online to help. Even when I do 'sudo apt autoremove -y' I keep getting this error nothing seems to work. Setting up mysql-server-8.0 (8.0.22-0ubuntu0.20.04.3) ... Failed...
  3. B

    Sending info to mysql db

    Hello, I want to make a script that monitorizes the cpu utilization and sends that data to a mysql database. I have two VMs made with ORACLE, they both can comunicate with eachother, I made a script using the top command on VM1 and on the VM2 I have installed myqsl server. I only found how to...
  4. B

    Linux Project

    Hello, I have a personal project that includes some ideas of using Oracle VM, monitoring and some network commands. So far, I have two VMs that can communicate with eachother, I made a database using mysql on one of the VMs and on the other I want to access and see the database on a web server...
  5. K

    Your web server does not appear to support any common PDO database extensions.

    I was following a tutorial for installing and hosting your own web server, but i'm stuck on this from last 2 hrs. I'm new to linux and everything, please help.this the error i'm stuck on
  6. E

    INTO OUTFILE ERROR 2

    Good day, I am trying to run the following command but it does not seem to work. [[email protected] ]# mysql -pPassword asteriskcdrdb -s -b -e "select 'Account ID','Destination','Operator','Provider','Date','BillSec','Rate id','Cost' UNION select...
  7. A

    MYSQL connection problem

    I have VDS with CentOS 7 and schroot environment with Ubuntu 18.10(had to do this, because app i want to launch needs a libstdc++.so.6 version which is not available for CentOS). Application(game server) i want to launch inside schroot needs MySQL connection. So when i set „localhost” as...
  8. Rob

    MySQL administration via command line

    When using MySQL on a Linux server, you'll no doubt come into a situation where you'll want to manipulate something via command line. Some of you will have tools like PHPMyAdmin installed, but you should always know a way to do things via command line. By the way, these examples will also work...
  9. Rob

    Enable the slow query log in MySQL

    If you notice some slowness on your application (ie: website) and are looking to speed things up you can enable slow query logging on your server and inspect some of the slow queries. Slow queries are database queries that take longer than the amount of time you specify in the file. Most...
  10. K

    Rasperry Pi 3 projects

    An important part of my Linux arsenal is my Raspberry Pi running Raspbian. I am seeking ideas for future projects to do on my pi. Currently, I use the pi for these tasks: PHP / Apache / MySQL (test websites, development) FreeRADIUS (username / passwords to access my wifi) Mantis bug tracking...
  11. Rob

    Using mysqldumpslow to read the mysql slow query log

    The MySQL slow query log is one helpful tool that helps system administrators to determine which queries are taking a longer-than-normal time to run. The only thing is.. how to read it so it's helpful? If you don't have the slow query log enabled yet, do that first: mysql enable slow query...
Top