658,605 questions
-4
votes
0
answers
53
views
How to save session shopping cart data into database
I have a shopping script where customers can add items to their cart and then view their cart.
But i don't know how to make the checkout page to be able to SAVE THE SESSION items (CART DATA) into the ...
- 21
-1
votes
0
answers
21
views
why is station_name suppressed in my LOAD DATA INFILE [duplicate]
In my bash script below I am able to load data into mysql, but somehow some fields are not correctly captured.
#!/bin/bash
DB_USER="myuser"
DB_PASS="mypass"
DB_NAME="aws_db&...
- 1,590
0
votes
0
answers
46
views
PHPMyAdmin won't let me update a password for a user account, even though I'm logged into the root account [closed]
I'm trying to update the password for the user account in a MySql database managed through PHPMyAdmin. I'm logged in as root and I'm changing the password through User accounts/change password. Here's ...
- 459
-4
votes
0
answers
34
views
Restored mysql directory in XAMPP and now MySQL server won't start [closed]
When I changed my development machine to a Mac, it created case sensitivity problems with the database on my XAMPP server. I was attempting a solution offered here: MySQL case sensitivity table name ...
0
votes
0
answers
33
views
Safe deployment of new features for live Flutter app with Node.js backend [closed]
I have a Flutter app live on the App Store with ~400 users and a Node.js backend running on AWS EC2 with MySQL. I want to add new features safely without breaking the app for current users.
...
-1
votes
0
answers
29
views
Cannot Start mysql.service on ubuntu after restore of files [closed]
I had to restore the MySQL files on Ubuntu from a system backup. Unfortunately mysqld will not start. I chowned the directory to mysql:mysql but I still get this error:
`Defined-By: systemd
Support: ...
- 622
-2
votes
0
answers
34
views
MySQL Stored Procedure INSERT INTO a temp table from CTE erroring [duplicate]
I am creating a temp table in a stored procedure to hold the results of a CTE query. Without the temp table the query works fine. The code is below. I keep getting an error at the INSERT INTO line - ...
- 1
0
votes
0
answers
94
views
SQL table(s) to get desired output in PHP [closed]
I have a PHP table in this format:
$Output = array (
'strSMD' => array (
'name' => 'blabla',
'server' => 'https:/blabla.com',
'profile' => 'https://blabla.com/...
- 1
-3
votes
1
answer
55
views
Why mysqldump is returning cannot find table ">" in python subprocess [duplicate]
i have created a mini python tool to backup using mysqldump
import os
import subprocess
from datetime import datetime
from dotenv import load_dotenv,dotenv_values
load_dotenv(dotenv_path="./...
-1
votes
0
answers
50
views
How to setup MySQL InnoDB Cluster for High Availability in Docker Compose [closed]
I am trying to set up a MySQL InnoDB Cluster for High Availability in Docker Compose. Below are the files.
docker compose
version: '3'
services:
mysql-server-1:
container_name: mysql-server-1
...
2
votes
1
answer
71
views
Mysql query to show records with 3 date criterias
I need a little help with a select query please.
I need to pull 3 records at a time from a table to display on a form where people can sign up to one or any of the three matches displayed on the form
...
- 81
1
vote
3
answers
63
views
How to count distinct concurrent resource max usage using a mysql query?
I have to validate a software license based on the concurrent resources concurrently used.
I have this MYSQL table:
resource-id
from
to
1
13/01/2026 09:00
13/01/2026 20:30
1
14/01/2026 18:00
14/01/...
- 9,667
0
votes
1
answer
71
views
I can add a JSON column cast index in MySQL, but not in Rails, using the same query
I've added a JSON format column metadata_json to a database table digilearning_support_files, and am trying to do an index on a value that will be stored in there.
In the MySQL client terminal, the ...
- 33.1k
0
votes
0
answers
27
views
in gcp mysql, can't get the authentication_iam plugin to load [migrated]
I'm running mysql via gcp's cloud platform and I'm trying to get service account iam passwordless access working. Today's blocker is the authentication_iam plugin.
The docs (and AIs) tell me to set ...
- 3,803
1
vote
1
answer
91
views
How can I get a single entry from a custom database table in WordPress? [duplicate]
I added a custom table to my database and I want to call on a particular row as defined by the ID and then display the string contents of another column in that row.
The user makes a selection from a ...
- 39