SOLVED When did the format for exports change

durangod

Well-Known Member
May 12, 2012
505
46
78
cPanel Access Level
Website Owner
Hi, i was wondering when the format for phpMyAdmin export format changed. It used to be that the auto_increment was in the main table query on the last line right along with the CHARSET like so


ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci AUTO_INCREMENT='xx';


But now when i export it, it has the AUTO_INCREMENT in a seperate query that sets the primary key and AUTO_INCREMENT down on the bottom of the export.. I dont like it that way. I found myself having to add the primary key and AI, after i restored some tables because i did not include the additional query.

Is there a way to export the tables in the old fomat with the AI and primary setting in the main table field query?
 
Last edited by a moderator:

cPJeremy

Technical Analyst
Staff member
Feb 13, 2019
58
3
83
Houston TX
cPanel Access Level
Root Administrator
Hello, durangod,

From what I was able to uncover, It does not seem that a recent update should have affected the format of the export. I did also notice that many versions ago there was an issue with PhpMyAdmin where this was occurring for other users. However, this was addressed a few versions of PhpMyAdmin ago.

Can you please confirm what version of PHPMyAdmin and what version of cPanel is installed onto the server? I will do my best to replicate this and gather more details for you.

Thank you!
 

durangod

Well-Known Member
May 12, 2012
505
46
78
cPanel Access Level
Website Owner
Hi, thanks and here you go...

cPanel 78.0.44
phpMyAdmin 4.8.3
cpsrvd 11.78.0.44
libmysql 5.1.73
MySql 10.1.43-MariaDB-cll-lve
PHP 7.2.7
Apache 2.4.41
Kernel 2.6.32-896.16.1.lve1.4.49.el6.x86_64
 

cPJeremy

Technical Analyst
Staff member
Feb 13, 2019
58
3
83
Houston TX
cPanel Access Level
Root Administrator
Hello again,

Thank you for providing this information. Firstly, I did want to mention that at this time I have been able to view a cPanel server running version 78.0.44. During my testing, it seems to me that AUTO_INCREMENT was still being handled via its own separate query. I did also check that my testing server was running the same version of PhpMyAdmin as yours as well.

On both of testing server's (running version 78.0.44, and 84.0.18) the query was never using
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_520_ci AUTO_INCREMENT='xx';

Had you ever made any customizations to PhpMyAdmin? Also, I am sorry to ask but would you be willing to create a support ticket using the link in my signature? We would be able to take a closer look and make more accurate suggestions to possibly resolve this.

Thank you!
 

durangod

Well-Known Member
May 12, 2012
505
46
78
cPanel Access Level
Website Owner
Hi thanks for the quick reply... i think maybe you may have misunderstood my question, sorry if i was not clearer. I too am getting the separate query for the AUTO_INCREMENT and the primary key just like you. My question was how do i get it the other way, the old way where it is included in the main table query itself. I dont like this new way, there is too much risk of me forgetting to grab the other query at the very bottom of the export.


Is it possible to set phpMyAdmin to export the query the old way? Even if i could make it list the other query directly after its matching main query would be better because then i would see it right away.


here is a sample of the old way that im looking for, this is the format i want..


this is part of the main table query


PRIMARY KEY (id))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1");



I hope that makes better sense :)

I cant do a ticket because this particular site of mine is not on the dedi, its on the shared.
 
Last edited:

cPJeremy

Technical Analyst
Staff member
Feb 13, 2019
58
3
83
Houston TX
cPanel Access Level
Root Administrator
Hello again, durangod!

Thank you for getting back to us and I am sorry for initially not fully understanding your question.

Firstly, I wanted to mention that from what I can see, there is not a cPanel supported method of changing this export query. However, the information you provided does not match my exports. Do you recall what version the server was using when you had your exports in that format? Have you confirmed with your host if they have ever made changes to this themselves?

In regards to your question, from what I can see there would not be a way to set this to how it was previously without editing PhpMyAdmin directly. This might have been what your hosting provider did. There is also the option of downgrading PHPMyAdmin but this would be rather difficult. Additionally, both of these options would require root access to the server.

Please let us know if you have any other questions or concerns. Thank you!
 

durangod

Well-Known Member
May 12, 2012
505
46
78
cPanel Access Level
Website Owner
OK no problem and thanks.... as far as i can tell this happened in the last 24 months, i have an old sql download from that time (2 years) and it has the format that im looking for but the sql does not have a phpMyAdmin version in it and i dont know why that is not there in the file. Anyway it is what it is and i thank you for checking it out, thanks for your time... im satisfied.... :) you can mark it solved it you want...
 
  • Like
Reactions: cPanelLauren