MySQL Bugs: #100358: database backup

Bug #100358	database backup
Submitted:	29 Jul 2020 5:15	Modified:	29 Jul 2020 11:30
Reporter:	Bindelli Roberto	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.7	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	Backup

Description:
when doing database backup, the resulting sql file has a syntax problem, as :
The last INSERT INTO <<table>> VALUES ... statment does not end with semicolon, so no possibility to restore directly this backup
::::
(1383, 13, 814, 3, 'PS07', 5, null),
(1384, 13, 814, 3, 'PS08', 5, null);

INSERT INTO annexes VALUES 
(1404, 9, 647, 4, '1', null, 3.67),
(1405, 9, 643, 4, '2', 2, 3.49),
(1406, 9, 650, 4, '3', 2, 3.67),
(1407, 9, 656, 4, '4', 3, 2.76),
(1408, 9, 645, 4, '5', 3, 3.49)

# Table civilites;

How to repeat:
using phpmyadmin just backup a database having more than one table... Then try to restore this backup file...

Suggested fix:
add a semicolon after INSERT INTO statment

Hi,

You need to report a bug to phpmyadmin app here (it is not our product):
https://github.com/phpmyadmin/phpmyadmin/issues

kind regards
Bogdan