Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [xampp]

28 questions
2
votes
0 answers

Why does INSERTing to a federatedx table fail silently?

For testing, I've set up a XAMPP portable 8.1.12 with 10.4.27-MariaDB and enabled the FederatedX engine using this trick. When I now set up a SERVER that is not existing and a federated table that is "using" that server, running a SELECT against…
Bowi
  • 121
  • 3
2
votes
1 answer

MariaDB table is broken after failed dump process

I need to dump MariaDB InnoDB-database consists of several tables. One table that causes problems has nearly 13 Million rows. A fresh install of XAMPP(V.3.2.2) dump process was successful, after that, dump process always failed with the error…
Albert
  • 21
  • 2
1
vote
1 answer

phpmyadmin - How to fix corrupted ibdata1 file

UPDATE 5-26-25: This same thing happened again with a completely new database. I have a SQL server (hosted through XAMPP) using phpMyAdmin. It has worked fine for months, but today I tried to start mySql through the XAMPP control panel and it gave…
Boom
  • 111
  • 3
1
vote
2 answers

MySQL Workbench error "name is not activatable"

I'm working with Arch Linux using MariaDB through LAMPP, whenever I use MySQL workbench and try to connect to my local database I get the following: Your connection attempt failed for user 'root' to the MySQL server at 127.0.0.1:3306: The name is…
ItsFireStorm
  • 21
  • 3
1
vote
1 answer

Delete records in different tables

I need to delete the records where UserIndex = 1 and ItemNumber = 5202 in all three tables, all in a single query. I am using SQL 2008 R2. Table UserInfo1 UserIndex Itemnumber ItemCount 1 5202 99 1 1600 50 2 155 2 3 125 60 Table…
Ichigo Kurosaki
  • 23
  • 2
1
vote
0 answers

ERD related, can you make one to one relationship with a single attribute entity to another entity?

ERD Here So for my database project, I designed a meat supply chain optimization project for a large organization, for example such as walmart, where every part of the chain is owned by the organization, (transport, farm, retail store etc). I…
Kazi Newaz
  • 11
  • 1
1
vote
1 answer

Column count of mysql.proc is wrong

Im attempting to deal with a corrupted database with little success, when I try to alter this table I am giving the error Column count of mysql.proc is wrong Looking up this error online gives me many results all saying the same variation of, you…
Marc-9
  • 23
  • 1
  • 4
1
vote
1 answer

mysqldump: Got error: 2002: "Can't connect to MySQL server on 'x' (code)" when trying to connect

I am trying to create a back up from a server by using XAMPP (via command prompt). Unfortunately the error is: mysqldump: Got error: 2002: "Can't connect to MySQL server on 'x' (10060)" when trying to connect. I have looked a bit around on…
I try so hard but I cry harder
  • 111
  • 1
  • 2
1
vote
1 answer

Missing Edit Privileges Option In PhpMyAdmin

The Action column of the PhpMyAdmin is not displaying the Edit Privileges. I did not get the solution for this problem. I even tried to upgrade and degrade the PhpMyAdmin version, but nothing worked. I have attached a screenshot of PhpMyAdmin for…
Nivetha R
  • 11
  • 1
  • 2
1
vote
1 answer

XAMPP - Error: MySQL shutdown unexpectedly

Last night MySQL Service on my XAMPP local server was running fine. Today... it starts for 10 seconds and then give me following error: 10:14:28 AM [main] Initializing Modules 10:14:28 AM [main] The FileZilla module is disabled 10:14:28 AM…
Mohal
  • 111
  • 1
  • 4
0
votes
1 answer

Table 'any table' doesn't exist in engine without moving anything

Today after I guess a month or so I rebooted my server and now I get Table 'ANY TABLE' doesn't exist in engine in every InnoDB table that I want to open in phpMyAdmin. My ISAM tables are fine and working. I saw other people had the same problem…
user1772630
  • 1
  • 2
0
votes
0 answers

XAMPP MySQL database problem

I am working on Microsoft Windows 11. Occasionally (seems random), when I open XAMPP it appears to open an old version of my MySQL database. When this happens, all new information I entered on a previous occasion disappears, with no obvious way of…
Nugget
  • 1
0
votes
0 answers

MySQL not starting in XAMPP - Port is not blocked

I already verified port 3306 and it's not blocked port issue. Also, checked Netstat and 3306 is not showing in the list Upon starting MySQL XAMPP shows below error I checked mysql_error.log, below are the contents 2024-01-18 14:54:58 0 [Note]…
Tahir Yasin
  • 125
  • 1
  • 2
  • 8
0
votes
1 answer

How to calculate quantity based on a boolean field and retrieve values from a JSON field in MySQL

I'm working with a table called price_options that has the following fields: id, slots, list_slots, and quantity. Issue Description My objective is to calculate the quantity for each price option based on the boolean value of the slots field. If…
Khuzema
  • 13
  • 3
0
votes
1 answer

MySQL denied me access after changing my password

I am new to MySQL. Today is my first day using it through XAMPP. I have managed to change my password using the code mysqladmin -u root password Suddenly I was denied access from XAMPP and from the MySQL Admin portal. I tried to reset the password…
Learner123
1
2