i am running backups of my mysql database with this command: mysqldump -u admin -p`cat /etc/psa/.psa.shadow` --hex-blob --skip-opt --single-transaction --add-drop-table --create-options --quick --extended-insert --max_allowed_packet=32M --default-character-set=utf8 --disable-keys databasename -r database.sql In an inconsistent way this dump produces in some cases things…
The table xx_user_detail, user_id is int primary index, site1-site9 is combined fulltext index, the total row count is 5 million SELECT * FROM xx_user_detail WHERE (user_id=14) AND MATCH (site1,site2,site3,site4,site5,site6,site7,site8,site9) AGAINST ('苏娟的食品店'); this SQL1 use 0.3s SELECT * FROM xx_user_detail WHERE…
I have an EC2 machine with mysql DB (not containerized). Now I want to stream CDC events to Confluent-managed Kafka. I am using this docker compose file to start the connect platform on the same host. services: connect: image: confluentinc/cp-kafka-connect:latest…
I have a php script that copies data from 1 table to another. The source table and its fields are utf8mb4_general_ci while the target table and its fields are utf8mb4_unicode_ci. I get an "Incorrect string value" each time the script…
I need to dump data from one table in my MySQL 8 database and reimport into a different table which already exists and has it's schema. The schema is identical between the two such as columns, how can I achieve…
I have many tables, but the only one interesting here is the following, let's call it webpages | companyID | lang | URL | 1 | hu | hu.example.com/x | 1 | en | en.example.com/x | 1 | NULL |…
Sad that a simple select query is taking away my breath. I am creating an alerting tool which can alert when the DB credential expires. The tool can do this on both MSSQL and MySQL. In MySQL I am selecting…
When converting to GeoJSON I'm finding that lat/lon are being transposed. I don't understand the reason why and haven't found any suitable answers in the MySQL documentation. The WKT seems to be correct as verified with https://wktmap.com/ The GeoJSON is…
this is the problem. I have two tables - ps5 and xbox:- id ps5_game John COD Jean GTA Kash COD Don PVZ Trey GOW Nate UC id xbox_game Jarvis UC Carl GOW Damon COD Donny GOW Trav GOW Natty UC…
I have this table using InnoDB as engine: create table if not exists Playlists( UserId bigint unsigned not null, Title varchar(50) not null, IsPublic bool not null, primary key (UserId, Title), foreign key (UserId) references Users(Id) on delete cascade on…