I am trying to make a discord bot in PHP (which works, i know not the best choice of language but that is what i am most comfortable with for my own needs for now) with a dashboard. The idea…
I am trying to export my database running this command : sudo mysqldump -h wordpress -u root -p bitnami_wordpress >rescue2.database.sql and got this error : mysqldump: Got error: 2005: “Unknown MySQL server host ‘wordpress’ (-2)” when trying to connect I…
I have installed a fresh Laravel 8 Project using sail https://laravel.com/docs/8.x/installation#getting-started-on-macos I followed the guide. First ran this curl -s "https://laravel.build/example-app" | bash Then this ./vendor/bin/sail up But now I have difficulty connecting using mysql client. This is the command…
I've been investing tons of hours searching and applying many different tests to try and see if I could optimize this query but I was not successfull so far. So this is based on a table with more than 6M…
I don't understand how to fix this. PhpMyAdmin cannot find columns. I even gave each query a name but it doesn't work. SELECT ename, deptno FROM ( SELECT sal FROM emp T ) as E WHERE deptno = 10;
I have a test container for Mysql and I need to import the dump file after the container started. I've tried two options below. public class AbstractTest { public static MySQLContainer<?> mySQLContainer = new MySQLContainer<>("mysql:5.7"); static { mySQLContainer .withDatabaseName("myDatabase") .withCopyFileToContainer(…
step 1：create docker container docker run --name=mysql80 --restart on-failure -d -p3306:3306 -e MYSQL_ROOT_PASSWORD=test-2021 -e MYSQL_ROOT_HOST=% -e TZ=Asia/Shanghai mysql/mysql-server:8.0.23 --lower-case-table-names=1 --bind-address=0.0.0.0 --default-authentication-plugin=mysql_native_password step 2：find mysqlbinlog I use find / -name mysqlbinlog command to find nothing in docker container.
I made a REST api using PHP, and then I hosted it in hostinger you can visit the api here(It just contains a json data). In my browser I am able to get the json data. But in android studio,…
I have a database where data_fine is defined as TEXT and contains values such as "25-05-2021". I need to find all the records between the current date up to 8 days. I tried the following query, but nothing is displayed.…
I need your assistance, experience with zabbix and knowledge: I configured everything like the Avantistech website says. Everything works fine until I try to continue setting up the zabbix server in the web UI. It says "Unable to determine current…