All columns of all views defined as “1” in phpmyadmin export
Putting a vertical line in each Histogram using GraphicsGrid
How can I prevent an oracle who can see into the past from knowing everything that has happened?
How unreachable are Jupiter's moons from Mars with the technology developed for going to Mars?
How can I handle players killing my NPC outside of combat?
Is the UK legally prevented from having another referendum on Brexit?
How can I put a period right after the algorithm's number in the algorithm's title?
How to deal with an underperforming subordinate?
Is it really OK to use "because of"?
How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?
Taking an academic pseudonym?
Boss asked me to sign a resignation paper without a date on it along with my new contract
How to draw a node with two options using TikZ graphs in LaTeX
Do the speed limit reductions due to pollution also apply to electric cars in France?
Lubuntu 18.10 File Manager: How to view directory tree structure?
Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?
Why does a single AND gate need 60 transistors?
What's the reason that we have different quantities of days each month?
Is "accuse people to be racist" grammatical?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Sing Baby Shark
Isn't a semicolon (';') needed after a function declaration in C++?
Do we still track damage on indestructible creatures?
Protagonist constantly has to have long words explained to her. Will this get tedious?
What can I do to encourage my players to use their consumables?
All columns of all views defined as “1” in phpmyadmin export
MySQL 5.7.24, phpmyadmin 4.8.3
phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
show create view v_contacts
returns
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) utf8 utf8_general_ci
Exporting with phpMyAdmin generates a file which contains:
DROP TABLE IF EXISTS `v_contacts`;
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_contacts` AS SELECT
1 AS `rowseq`,
1 AS `airline_rowseq`,
1 AS `airline_name`,
1 AS `country_name`,
1 AS `i_type`,
1 AS `contact_type`,
1 AS `i_index`,
1 AS `i_value`,
1 AS `updated`*/;
SET character_set_client = @saved_cs_client;
and later in the export file, the correct definition:
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.
Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?
phpmyadmin export catalog-views
New contributor
add a comment |
MySQL 5.7.24, phpmyadmin 4.8.3
phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
show create view v_contacts
returns
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) utf8 utf8_general_ci
Exporting with phpMyAdmin generates a file which contains:
DROP TABLE IF EXISTS `v_contacts`;
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_contacts` AS SELECT
1 AS `rowseq`,
1 AS `airline_rowseq`,
1 AS `airline_name`,
1 AS `country_name`,
1 AS `i_type`,
1 AS `contact_type`,
1 AS `i_index`,
1 AS `i_value`,
1 AS `updated`*/;
SET character_set_client = @saved_cs_client;
and later in the export file, the correct definition:
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.
Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?
phpmyadmin export catalog-views
New contributor
add a comment |
MySQL 5.7.24, phpmyadmin 4.8.3
phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
show create view v_contacts
returns
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) utf8 utf8_general_ci
Exporting with phpMyAdmin generates a file which contains:
DROP TABLE IF EXISTS `v_contacts`;
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_contacts` AS SELECT
1 AS `rowseq`,
1 AS `airline_rowseq`,
1 AS `airline_name`,
1 AS `country_name`,
1 AS `i_type`,
1 AS `contact_type`,
1 AS `i_index`,
1 AS `i_value`,
1 AS `updated`*/;
SET character_set_client = @saved_cs_client;
and later in the export file, the correct definition:
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.
Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?
phpmyadmin export catalog-views
New contributor
MySQL 5.7.24, phpmyadmin 4.8.3
phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg:
show create view v_contacts
returns
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) utf8 utf8_general_ci
Exporting with phpMyAdmin generates a file which contains:
DROP TABLE IF EXISTS `v_contacts`;
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_contacts` AS SELECT
1 AS `rowseq`,
1 AS `airline_rowseq`,
1 AS `airline_name`,
1 AS `country_name`,
1 AS `i_type`,
1 AS `contact_type`,
1 AS `i_index`,
1 AS `i_value`,
1 AS `updated`*/;
SET character_set_client = @saved_cs_client;
and later in the export file, the correct definition:
/*!50001 DROP VIEW IF EXISTS `v_contacts`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_contacts` AS select `d`.`rowseq` AS `rowseq`,`d`.`airline_rowseq` AS `airline_rowseq`,`a`.`name` AS `airline_name`,`c`.`name` AS `country_name`,`d`.`i_type` AS `i_type`,`ab`.`hint` AS `contact_type`,`d`.`i_index` AS `i_index`,`d`.`i_value` AS `i_value`,`d`.`updated` AS `updated` from (((`atdb6`.`directory` `d` join `atdb6`.`airline` `a`) join `atdb6`.`country` `c`) join `atdb6`.`abbreviations` `ab`) where ((`d`.`airline_rowseq` = `a`.`rowseq`) and (`a`.`country` = `c`.`rowseq`) and (`ab`.`type` = 'D') and (`d`.`i_type` = `ab`.`code`) and (`d`.`i_type` <> 'LG')) */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
However only the first part is used when importing on another computer with phpMyAdmin 4.0.10.14, so all columns are set to 1.
Same for all views in the same database. Is this a bug, and no export file generated by phpMyAdmin 5.7 should be reused for import by phpMyAdmin 4.8 ?
phpmyadmin export catalog-views
phpmyadmin export catalog-views
New contributor
New contributor
New contributor
asked 1 min ago
Alexandre AvraneAlexandre Avrane
1
1
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230600%2fall-columns-of-all-views-defined-as-1-in-phpmyadmin-export%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
Alexandre Avrane is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230600%2fall-columns-of-all-views-defined-as-1-in-phpmyadmin-export%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown