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 not activatable. The reason why I mention that I'm using MariaDB is that I get this error when I test the connection: > Incompatible/nonstandard server version or protocol detected (10.4.32) <== MariaDB's version I can still continue despite the error, and it shows that it successfully connected to the database, however, whenever trying to run a SQL Script, it can't connect to the database. I've tried: using another user, reinstalling MySQL workbench, reinstalling XAMPP. Yet all of these attempts were in vain. Is there a method to solve this *whilst* keeping MariaDB?

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 immediately in the same window using the same command but I was given the error mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I saw a number of related questions here on stackoverflow but they were all about phpMyAdmin password issues. I would like to rest it to the default password and gain access to MySQL & XAMPP again. I have been going around in circles for an hour. Any help would be appreciated.

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 a long series of errors. I tried the top answer (with over 2000 votes) here: https://stackoverflow.com/questions/18022809/how-can-i-solve-error-mysql-shutdown-unexpectedly/61859561#61859561 , and it worked. Unfortunately, now I cannot access my database tables. I don't know if that is because of something I did to fix the MySQL shutdown error or if it is from the same root problem that caused that error in the first place. The error shown is "#1932 - Table 'dbname.tablename' doesn't exist in engine." Now, I know there's a lot of stuff out there about how to fix this. None of it worked for me. I tried almost all the solutions here: https://stackoverflow.com/questions/38759870/xampp-mysql-table-doesnt-exist-in-engine-1932 , and none of them worked. Most of them centered around moving the ibdata1 file (normally in C:\xampp\mysql\data\) from a backup (C:\xampp\mysql\backup\) to the actual data folder. Since that seemed to work for most people but not for me, I briefly checked out the ibdata1 file to see if it was a permissions issue (as suggested somewhere). Unfortunately, it appears to have become corrupted. Over the course of trying to fix my issues I basically created two other backups in addition to the provided backup folder, thus four ibdata1 files. All of them look quite strange. Two of them contain some intelligible contents (lots of database-related words along with strange characters and symbols) but also have huge blocks of nothing but the character ÿ repeated over and over. The other two have nothing intelligible at all (at least in English) but contain a lot of Chinese characters interspersed with an assortment of strange symbols. The weird part was that apparently the Chinese was actually intelligible; I put some of it into Google Translate and it produced valid sentences about China in the 1980s and 90s, the Beijing Olympics, and other things. The Chinese text would repeat certain phrases and sentences over and over like it was generated by bad AI or something. Freaky weird stuff that I have no idea how it got into my database. It just makes me wonder what on earth is going on and if I should be concerned about more than just my db. So, basically, can the ibdata1 file be "uncorrupted?" Can it be generated again from existing information? Do I have to completely redo the database? Reinstall XAMPP? Any help would be greatly appreciated!

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 as available/not. My question, is how would I get the database to automatically update the dates as unavailable? When I've tried, it makes that date unavailable for every room in every hotel. (Still a newbie at all this, so sorry if this doesn't make any sense!) Attached a rough draught of my ERD for reference.

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 after moving files from an old backup to a MySQL directory, but I did not do that. Another odd thing is I have a backup from a machine (it's VMware), but when I recover from those (I tried a backup from 2 days ago and a 1 week old backup) I get the same error, but the database was working fine until today. So I have no SQL backup and just a VMware machine backup, but even a 2 week old full machine backup is not solving my problem. I guess it's because of a change I made a long time ago, but it did not show up until the server reset. Is there is anything I can do to restore my database and get my data back? I'm using XAMPP on Linux. There is no error in running MariaDB. InnoDB force recovery did not help even 6. I moved all data folder + ib_logfiles + ibdata1 on a new XAMPP, but exactly same the error appears.

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 retrieving it - except from a backup. It's a pain because I now have to thoroughly check that the database is correct before I start to add new records. Has anyone experienced this before, or have any ideas how to fix it? I have purposely tried to recreate the fault but can't. It just happens at random when XAMPP is started.

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] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 22364 2024-01-18 14:54:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2024-01-18 14:54:58 0 [Note] InnoDB: Uses event mutexes 2024-01-18 14:54:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 2024-01-18 14:54:58 0 [Note] InnoDB: Number of pools: 1 2024-01-18 14:54:58 0 [Note] InnoDB: Using SSE2 crc32 instructions 2024-01-18 14:54:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2024-01-18 14:54:58 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-18 14:55:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2024-01-18 14:55:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-18 14:55:00 0 [Note] InnoDB: Setting file 'D:\xampp12\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-18 14:55:00 0 [Note] InnoDB: File 'D:\xampp12\mysql\data\ibtmp1' size is now 12 MB. 2024-01-18 14:55:00 0 [Note] InnoDB: Waiting for purge to start 2024-01-18 14:55:00 0 [Note] InnoDB: 10.4.28 started; log sequence number 18291975; transaction id 87804 2024-01-18 14:55:00 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp12\mysql\data\ib_buffer_pool 2024-01-18 14:55:00 0 [Note] Plugin 'FEEDBACK' is disabled. 2024-01-18 14:55:00 0 [Note] Server socket created on IP: '::'. NetStat doesn't show 3306 as follows

I installed Xampp on my Ubuntu 22.04 box. In its my.cnf, I set

[client]
password =mypassword
port     =3306
socket	 =/opt/lampp/var/mysql/mysql.sock

I saved this and restarted MySQL. When I try Ubuntu's mysql client:

$ mysql --host=localhost --port=3306 -u root -p -S /opt/lampp/var/mysql/mysql.sock

it asked for a password where I gave the configured password but it said

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

What do I need to make this work?

When I try to start on mysql from xampp control panel it says:

20:52:08  [mysql] 	Status change detected: stopped
20:52:08  [mysql] 	Error: MySQL shutdown unexpectedly.
20:52:08  [mysql] 	This may be due to a blocked port, missing dependencies, 
20:52:08  [mysql] 	improper privileges, a crash, or a shutdown by another method.
20:52:08  [mysql] 	Press the Logs button to view error logs and check
20:52:08  [mysql] 	the Windows Event Viewer for more clues
20:52:08  [mysql] 	If you need more help, copy and post this
20:52:08  [mysql] 	entire log window on the forums

below is the log file:

2023-05-23 20:52:02 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 8176
2023-05-23 20:52:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-05-23 20:52:02 0 [Note] InnoDB: Uses event mutexes
2023-05-23 20:52:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-05-23 20:52:02 0 [Note] InnoDB: Number of pools: 1
2023-05-23 20:52:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-05-23 20:52:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-05-23 20:52:02 0 [Note] InnoDB: Completed initialization of buffer pool
2023-05-23 20:52:02 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2023-05-23 20:52:02 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2023-05-23 20:52:02 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2023-05-23 20:52:02 0 [Note] InnoDB: New log files created, LSN=1156629
2023-05-23 20:52:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-05-23 20:52:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-05-23 20:52:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-05-23 20:52:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-05-23 20:52:02 0 [Note] InnoDB: Waiting for purge to start
2023-05-23 20:52:02 0 [Note] InnoDB: 10.4.28 started; log sequence number 1157132; transaction id 1865
2023-05-23 20:52:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-05-23 20:52:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-05-23 20:52:02 0 [Note] Server socket created on IP: '::'.

please help me on what to do next

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 slots is set to true, I need to retrieve the quantity from the list_slots field, which contains JSON data structured like this: [{"start":"09:00","quantity":30},{"start":"09:30","quantity":30}]. Otherwise, I should use the quantity field directly. ---------- 1- SQL For Creating Table: ------------------- CREATE TABLE price_options ( id INT UNSIGNED PRIMARY KEY, slots BOOLEAN, quantity INT, list_slots TEXT NULL ); 2- Adding data in table for case: 1 ----------- INSERT INTO price_options (slots, quantity, list_slots) VALUES (TRUE, 0, '[{"start":"09:00","quantity":30},{"start":"09:30","quantity":30}]'); 3 -Adding data in table for case: 2 ----------- INSERT INTO price_options (slots, quantity, list_slots) VALUES (FALSE, 30, NULL); ---------- 4- Required Output for Both Cases: =============================== **Case 1:** ----------- **slots** field is **true**, i want total quantity calculated from **list_slots** field. Output should be (30+30) = 60 **Case 2:** ----------- **slots** field is **false**, i want total quantity from quantity field. This time we will ignore **list_slots** field. Output should be: 30 ---------- Note: ----- 1. **list_slots** field type is text. 2. The MySQL version I'm using is **10.4.24-MariaDB** (Xampp). ---------- I hope it helps to understand the issue Any help or guidance on how to approach this would be greatly appreciated. Thank you.

I'm completely new to MySQL and phpmyadmin. I was trying to add a password to my database/phpmyadmin but then I got this error: >mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) > >phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. I'm using XAMPP on a MacBook Air. I've gone through couple of YouTube videos but they're on windows, and the XAMPP looks very different from mine. I will continue looking for help but I am not winning currently.

I need to insert data into 3 tables in a single query Table SkillData | UserIndex | SkillPoint | TotalSkill | | -------- | --------------- | ---------- | | 1 | 5202 | 99 | Table Emblems | UserIndex | CountEmblem | Status | | -------- | --------------- | ---------- | | 1 | 1265 | 1 | Table Rewards | UserIndex | Level | Code | | -------- | --------------- | ---------- | | 1 | 99 | 1005 |

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 UserInfo2 | UserIndex | Itemnumber | ItemCount | | -------- | --------------- | ---------- | | 8 | 1265 | 50 | | 4 | 1899 | 41 | | 1 | 5202 | 99 | | 3 | 125 | 60 | Table UserInfo3 | UserIndex | Itemnumber | ItemCount | | -------- | --------------- | ---------- | | 6 | 5205 | 85 | | 1 | 6666 | 41 | | 3 | 4455 | 44 | | 1 | 5202 | 50 | I'm trying to use this query with two tables, but it doesn't work: DELETE ItemInfo1, ItemInfo2 FROM ItemInfo1 LEFT JOIN ItemInfo2 ON ItemInfo1.UserIndex = ItemInfo2.UserIndex WHERE ItemInfo1.UserIndex = 1;

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 that table fails as it should, but INSERT behaves as if it has worked. Why is that? Example: CREATE SERVER nonexistentserver FOREIGN DATA WRAPPER nonexistentserverwrapper OPTIONS ( HOST '127.0.0.1', DATABASE 'thereIsNoServerSoThereIsNoDatabase', USER 'andNoUser', PASSWORD 'AndNoPassword!', PORT 12345 ); CREATE TABLE mytable ( theLine INT NOT NULL AUTO_INCREMENT PRIMARY KEY, theContent VARCHAR(255) NOT NULL ) ENGINE=FEDERATED CONNECTION='nonexistentserver/mytable'; SELECT behaves as I would expect: MariaDB [testdb]> SELECT * FROM mytable; ERROR 1296 (HY000): Got error 10000 'Error on remote system: 0: ' from FEDERATED But INSERT does not: MariaDB [testdb]> INSERT INTO mytable VALUES (NULL, "Hey!"); Query OK, 1 row affected (0.005 sec) Is that a bug or is it supposed to do that? ---------- **Additum 1:** When I do not use install plugin federated soname 'ha_federatedx'; but remove the x first (inspiration from this answer plus comment ), thus use *the old federated* but federatedX, the INSERT gives the expected error.

ask for a solution xampp linux error like this? Error : The user specified as a definer ('mariadb.sys'@'localhost') does not exist error : Corrupt Phase 4/7: Running 'mysql_fix_privilege_tables' -ERROR 1449 (HY000) at line 8: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 17: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 60: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 69: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 87: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 173: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 182: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 184: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 195: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 200: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 203: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 327: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 330: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 398: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 403: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 405: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 408: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 412: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 417: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 438: The user specified as a definer ('mariadb.sys'@'localhost') does not exist ERROR 1449 (HY000) at line 446: The user specified as a definer ('mariadb.sys'@'localhost') does not exist FATAL ERROR: Upgrade failed

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 StackOverflow (mostly0, but most questions are regarding "access denied for user at (...)" or they're talking about MYSQL. I have tried finding the files that MYSQL should have (which they're discussing) and looked whether XAMPP had these as well (it did not). ***My question is:*** What could possibly be causing this error? I know the name, password and host are correct. ***How have I tried backing up the database?*** I opened Command Prompt with administrator rights. I navigated to the correct directory where mysqldump is located at. I then typed in: C:\xampp\mysql\bin>mysqldump -e -uNAME -pPWD -hHOST DATABASENAME > C:\winhostMySqlD.sql It *does* create the .sql file, but CMD crashes with the error mentioned above.

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 message "mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table gv_faktur_header_history at row: 2623629". At this point here's the status : - Can not insert any value (Error 2013: Lost connection to MySQL) - Can not issue "CHECK TABLE" command (Error 2013: Lost connection to MySQL) - Can not alter this table (add column) - Can select data from this table - Can select row 2623629 (select * from table limit 2623629 ,1) - Can run "show table status" command I repeat this process several times like this : 1. Reinstalling xampp 2. Importing database using this method

> set global net_buffer_length = 1000000; 
> set global max_allowed_packet = 1000000000; 
> SET foreign_key_checks = 0;
> SET UNIQUE_CHECKS = 0; 
> SET AUTOCOMMIT = 0; 
> use db_name; 
> source backup-file.sql SET
> foreign_key_checks = 1; 
> SET UNIQUE_CHECKS = 1; 
> SET AUTOCOMMIT = 1;

3. Dump the database w/o --skip-extending-insert (success within 4 Minutes, 3,4 GB dump file) 4. Dump the database w/o --skip-extending-insert (failed within 1 Minute, 9xx MB dump file) 5. Dump the database w/o --skip-extending-insert (failed within 1 Minute, 9XX MB dump file ) mysqldump command : mysqldump -u root -p --skip-extended-insert --max-allowed-packet=1G --net-buffer-length=32704 rent_scaff header_history > D:\dobol Environment specifications : - i5 8 gen - Ram 8 GB (3 Gb unuse as seen in task manager) - SSD Storage 512G - mysqldump Ver 10.16 Distrib 10.1.10-MariaDB here's my.ini configuration [client] # password = your_password port = 3306 socket = "C:/xampp/mysql/mysql.sock" [mysqld] port= 3306 socket = "C:/xampp/mysql/mysql.sock" basedir = "C:/xampp/mysql" tmpdir = "C:/xampp/tmp" datadir = "C:/xampp/mysql/data" pid_file = "mysql.pid" key_buffer = 16M max_allowed_packet = 1G sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log_error = "mysql_error.log" plugin_dir = "C:/xampp/mysql/lib/plugin/" server-id = 1 innodb_data_home_dir = "C:/xampp/mysql/data" innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = "C:/xampp/mysql/data" innodb_buffer_pool_size = 1G innodb_additional_mem_pool_size = 2M innodb_log_file_size = 250M innodb_log_buffer_size = 250M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 1G [mysql] no-auto-rehash [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout enter code here Mysql Log : Server version: 10.1.10-MariaDB key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=2 max_threads=1001 thread_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 787099 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x3eee2178 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... mysqld.exe!my_parameter_handler() mysqld.exe!my_mb_ctype_mb() mysqld.exe!??2Geometry@@SAPAXIPAX@Z() mysqld.exe!??2Geometry@@SAPAXIPAX@Z() mysqld.exe!?propagate_equal_fields@Item_func_expr_str_metadata@@UAEPAVItem@@PAVTHD@@ABVContext@Value_source@@PAVCOND_EQUAL@@@Z() mysqld.exe!??2Geometry@@SAPAXIPAX@Z() mysqld.exe!??2Geometry@@SAPAXIPAX@Z() mysqld.exe!??2Geometry@@SAPAXIPAX@Z() mysqld.exe!??0Alter_table_prelocking_strategy@@QAE@XZ() mysqld.exe!?mysql_alter_table@@YA_NPAVTHD@@PAD1PAUHA_CREATE_INFO@@PAUTABLE_LIST@@PAVAlter_info@@IPAUst_order@@_N@Z() mysqld.exe!?execute@Sql_cmd_alter_table@@UAE_NPAVTHD@@@Z() mysqld.exe!?mysql_execute_command@@YAHPAVTHD@@@Z() mysqld.exe!?mysql_parse@@YAXPAVTHD@@PADIPAVParser_state@@@Z() mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PAVTHD@@PADI@Z() mysqld.exe!?do_command@@YA_NPAVTHD@@@Z() mysqld.exe!?threadpool_process_request@@YAHPAVTHD@@@Z() mysqld.exe!?tp_end@@YAXXZ() KERNEL32.DLL!SetUserGeoName() ntdll.dll!TpCheckTerminateWorker() ntdll.dll!TpCallbackIndependent() KERNEL32.DLL!BaseThreadInitThunk() ntdll.dll!RtlGetAppContainerNamedObjectPath() ntdll.dll!RtlGetAppContainerNamedObjectPath() Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Please help me how to Dump (backup) a large database, at least how to safely dump the database, so when the process failed, the table remains usable.

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 created an entity called Workplace with primary attribute Workplace_ID, and other attributes Type (farm, retail store, transport etc) and location. Workplace_ID is also the primary key for the other workplaces such as Slaugherhouse, Farm, Transport etc. What I intended was to do was for the other entities' primary key to be foreign key Workplace_ID, where I could easily create new tables specifying type and workplace_ID, relating Workplace entity to for example Farm entity. I have linked the ERD diagram here so that you can see how it was designed. The problem was, my professor didn't even listen to my final presentation, he just saw the auto generated ERD from XAMPP, and said that we were kidding him and wasting his time with a single attribute entity (Farm) having a foreign key as primary key, with the relation being 1 to 1. He then asked us to provide one example from anywhere of such a thing existing, an ERD would serve as a valid example, implying that such a thing was impossible to find, with the implication being if we could not provide any example we would receive 0. An important thing to note that he did not let me clarify my design choices, and that I intended it to be a IS A 1-1 relationship, sure, as in one instance of farm entity can only be one instance of workplace entity, but also that not all instances of workplace entities were instances of farm entities, it would only be instances of workplace entities which had farm as the type attribute. I designed it as such so that all workplaces did not have to include their locations and types again and again in their attributes, you would create a relationship table between two entities specifying type and Workplace_ID. I designed it in such a way since for some, Workplace_ID is primary key, whereas for others, it is simply a foreign key relating to other entities (for example, Batch has Workplace_ID signifying where the particular batch came from (which slaughterhouse), but its primary key is Batch_ID). Could Someone please point me to any example or cite something to potentially even save my grade? The deadline for coming up with even a single example is before my final exam, on the 30th of September. Thanks for taking the time to read, and sorry for this bother.

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 must run mysql_upgrade However when I run that I am greeted with The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server. To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade. The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand. It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem. However again another problem occurs any time I try to log into mysql from the command line, all attempts to log in respond with Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect This does make sense as localhost/phpmyadmin works just fine and I can create new tables or databases but I just cant alter the corrupt database Any help is appreciated this is XAMPP on Ubuntu

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|pemohon_id|mohon_tarikh|mohon_tarikhluput |-|-|-|-| Here's the code that I've tried but it didn't work.

SELECT jawatan_nama, MONTHNAME(mohon_tarikh) AS mname,
       count(jawatan_id) AS total
FROM kod_jawatan
CROSS JOIN tpermohonan
WHERE year(mohon_tarikh) = '2019'
GROUP BY MONTH(mohon_tarikh)

UNION ALL

SELECT 'Jumlah',
       count(jawatan_id) AS total
FROM tpermohonan
CROSS JOIN kod_jawatan
WHERE year(mohon_tarikh) = '2019'

This is the output that I want:

|Bil| Jawatan |Jan|Feb|March|April|May|June|July|August|September|Oct|Nov|Dec| Total | |-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-| How do i get the output I want? Much appreciated for your helps.