FS#48538 - [phpmyadmin] : SQL file format is not well formed

Attached to Project: Community Packages
Opened by Simone (simogiro) - Friday, 11 March 2016, 17:20 GMT
Last edited by Sergej Pupykin (sergej) - Wednesday, 16 March 2016, 13:09 GMT
Task Type Bug Report
Category Upstream Bugs
Status Closed
Assigned To Sergej Pupykin (sergej)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
Export Database or Table on SQL file format is not well formed.
The file generate is not possible import without sql error.


Additional info:
* package version(s)
* config and/or log files etc.


Steps to reproduce:
This task depends upon

Closed by  Sergej Pupykin (sergej)
Wednesday, 16 March 2016, 13:09 GMT
Reason for closing:  Upstream
Comment by Simone (simogiro) - Friday, 11 March 2016, 19:54 GMT

Additional info:
* package version(s)
4.5.5.1-1

Steps to reproduce:
export your database in sql format.
Import the file generate.

In the sql file in the command for create table is non present the command for create the primary key and other.
Comment by Simone (simogiro) - Friday, 11 March 2016, 23:03 GMT

Comment by Sergej Pupykin (sergej) - Saturday, 12 March 2016, 12:06 GMT
did you report upstream?
Comment by Simone (simogiro) - Saturday, 12 March 2016, 15:18 GMT
This is the export of my contatti table, from old
version of PhpMyAdmin in the .sql format.

--
-- Structure table `mp_contatti`
--

CREATE TABLE `mp_contatti` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_titolo` varchar(3) NOT NULL,
`nome` varchar(256) NOT NULL,
`cognome` varchar(256) NOT NULL,
`id_specializzazione` int(11) NOT NULL,
`citta` varchar(256) NOT NULL,
`id_regione` varchar(3) NOT NULL,
`stato` varchar(256) NOT NULL,
`descrizione` text NOT NULL
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=266 DEFAULT CHARSET=latin1 AUTO_INCREMENT=266 ;

INSERT INTO `mp_contatti` (`id`, `id_titolo`, `nome`, `cognome`, `id_specializzazione`, `citta`, `id_regione`, `stato`, `descrizione`) VALUES
(4, '02', 'Mario Rossi', 'Mario', 3, 'Milano', '16', 'Italia', ''),
-- -- --




This is the export of the same table from new version
of PhpMyAdmin (4.5.5.1-1).

--
-- Structure table `mp_contatti`
--

CREATE TABLE `mp_contatti` (
`id` int(11) NOT NULL,
`id_titolo` varchar(3) NOT NULL,
`nome` varchar(256) NOT NULL,
`cognome` varchar(256) NOT NULL,
`id_specializzazione` int(11) NOT NULL,
`citta` varchar(256) NOT NULL,
`id_regione` varchar(3) NOT NULL,
`stato` varchar(256) NOT NULL,
`descrizione` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `mp_contatti` (`id`, `id_titolo`, `nome`, `cognome`, `id_specializzazione`, `citta`, `id_regione`, `stato`, `descrizione`) VALUES
(4, '02', 'Mario Rossi', 'Mario', 3, 'Milano', '16', 'Italia', ''),
-- -- --

Import this (from new version) in other database generate the table but
if you backup the data into the table, the import
operation of the data generate the sql error.

Import the backup of the file .sql from old version of
PhpMyAdmin the import is ok, no error.


My server database is mariaDb 10.1.12-3
Php 7.0.4-2

Comment by Sergej Pupykin (sergej) - Wednesday, 16 March 2016, 13:08 GMT
phpmyadmin package just copies PHP files, so you should report this bug to upstream.

Loading...