Questions tagged [xampp]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
45 views

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, ...
1
vote
0answers
20 views

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 ...
0
votes
0answers
9 views

Restore MySQL database [duplicate]

I'm using XAMPP on linux. I reinstalled XAMPP, but I didn't know that I need to export/import databases and not copy/paste lampp/var/mysql folder. PhpMyAdmin displays my database but it has no tables. ...
0
votes
0answers
27 views

Generate report by cross join between two tables

I wanted to generate report between two tables by using CROSS JOIN. Below shows the details of table. Table 1: kod_jawatan jawatan_id jawatan_kod jawatan_nama Table 2: tpermohonan mohon_id ...
1
vote
1answer
328 views

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 ...
0
votes
0answers
20 views

Recover MySql data without Frm files

I was using Xampp out of the box and was doing some development work. Someone deleted my Xampp directory but full mysql data folder with ibdata1, iblog, db folders is present. Db folders only have ibd ...
0
votes
2answers
40 views

I'm trying to create a database for a hotel company with multiple hotels. I'm stuck on how to reserve a room?

I'm using Xampp phpmyadmin for the first time... So I've got the basics of the database. Customers, hotels, rooms etc. The customer can chose a check-in and check-out date. An admin can class a date ...
0
votes
1answer
534 views

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 ...
0
votes
0answers
143 views

MySql Service is not running in Linux

I am trying to run xampp on linux through terminal, but mysql database is not running after running the command to start Xampp server I get following output Starting XAMPP for Linux 8.0.2-0... XAMPP: ...
1
vote
1answer
555 views

Missing Edit Privileges Option In PhpMyAdmin [closed]

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. ...
0
votes
0answers
18 views

Deleted MySQL “root” user in phpMyAdmin through XAMPP local host…how to restore? [duplicate]

I was working in phpMyAdmin (XAMPP localhost) to add a user for a new database I created for a local WordPress website, and came upon the list of users named "root". Since I did not remember ...
0
votes
0answers
1k views

#1932 - Table '' doesn't exist in engine after accidental delete

I forgot to export my main table before deleting and reinstalling xampp. I recovered it from the recycling bin, but I get #1932 - Table '' doesn't exist in engine when I try to open any of the tables. ...
0
votes
0answers
836 views

Cannot restart myqsl even after changing port in xampp

I tried to start mysql in xampp but it stops unexpectedly. Below is the extract of the most common lines of error being recorded in error logs: InnoDB: using atomic writes. 2020-01-03 12:49:14 0 [...
1
vote
1answer
1k views

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]...
0
votes
1answer
933 views

MariaDB 'You do not have privileges to manipulate with the users!' [duplicate]

Apache/2.4.41 PHP 7.3.9 Windows 10 64bit I have been using XAMPP without issue for months now, and this morning when I turned on my PC adn tried to accedd my databases via HeidiSQL I received some ...
0
votes
0answers
20 views

Migrate 2 mysql folders on same server

I have installed wamp initailly. But now we have moved to xamp. So, I have 2 mysql folders, C:\xampp\mysql C:\wamp\bin\mysql\mysql\data Now my localhost is pointing to C:\xampp\mysql. I just wanna ...