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
Opened by Simone (simogiro) - Friday, 11 March 2016, 17:20 GMT
Last edited by Sergej Pupykin (sergej) - Wednesday, 16 March 2016, 13:09 GMT
|
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
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.
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