mysql

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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