Previously when I exported a database it looked like this:
CREATE TABLE 'config' (
'ID_Config' int(1) NOT NULL AUTO_INCREMENT,
'nome_site' varchar(255) DEFAULT NULL,
'thema' char(50) NOT NULL,
PRIMARY KEY ('ID_Config')
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
The auto_increment and primary key went straight to the CREATE command.
Now when I export it looks like this:
CREATE TABLE IF NOT EXISTS 'config' (
'Id' int(11) NOT NULL,
'versao' varchar(10) NOT NULL,
'sitemodelo' varchar(4) NOT NULL,
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ;
--
-- Indexes for table 'config'
--
ALTER TABLE 'config'
ADD PRIMARY KEY ('Id');
--
-- AUTO_INCREMENT for table 'config'
--
ALTER TABLE 'config'
MODIFY 'Id' int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
A class I found on the internet class.leitor_sql.php
does not read the rest of the commands, only what is inside CREATE
.
Question: Is there a way to change the export setting of mysql in phpMyAdmin?
Thank you.