Get the warning when upgrade mysql 5.7 to 8.0 on bionic!
0
I already installed MySQL of client and server with 5.7 version.
When I check MySQL packages available :
$ sudo apt search mysql
mysql-client/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Client meta package depending on latest version
mysql-client-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database client binaries
mysql-client-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database core client binaries
mysql-server/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Server meta package depending on latest version
mysql-server-5.7/bionic-updates,bionic-security,now 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries and system database setup
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries
I try to upgrade MySQL from 5.7 to 8.0 version, with following steps:
1. Download the Repository
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
2. installing the package and configuring
$ sudo gdebi mysql-apt-config_0.8.10-1_all.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading state information... Done
Auto configuration for MySQL APT Repo.
MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.
Do you want to install the software package? [y/N]:y
Selecting previously unselected package mysql-apt-config.
(Reading database ... 232093 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.10-1_all.deb ...
Unpacking mysql-apt-config (0.8.10-1) ...
Setting up mysql-apt-config (0.8.10-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
How can I fix that the warnings and update/upgrade all my databases? Asking because I forgot to backup my databases with mysqldump query!
apt upgrade mysql
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
add a comment |
0
I already installed MySQL of client and server with 5.7 version.
When I check MySQL packages available :
$ sudo apt search mysql
mysql-client/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Client meta package depending on latest version
mysql-client-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database client binaries
mysql-client-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database core client binaries
mysql-server/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Server meta package depending on latest version
mysql-server-5.7/bionic-updates,bionic-security,now 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries and system database setup
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries
I try to upgrade MySQL from 5.7 to 8.0 version, with following steps:
1. Download the Repository
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
2. installing the package and configuring
$ sudo gdebi mysql-apt-config_0.8.10-1_all.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading state information... Done
Auto configuration for MySQL APT Repo.
MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.
Do you want to install the software package? [y/N]:y
Selecting previously unselected package mysql-apt-config.
(Reading database ... 232093 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.10-1_all.deb ...
Unpacking mysql-apt-config (0.8.10-1) ...
Setting up mysql-apt-config (0.8.10-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
How can I fix that the warnings and update/upgrade all my databases? Asking because I forgot to backup my databases with mysqldump query!
apt upgrade mysql
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
1
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06
add a comment |
0
0
0
I already installed MySQL of client and server with 5.7 version.
When I check MySQL packages available :
$ sudo apt search mysql
mysql-client/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Client meta package depending on latest version
mysql-client-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database client binaries
mysql-client-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database core client binaries
mysql-server/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Server meta package depending on latest version
mysql-server-5.7/bionic-updates,bionic-security,now 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries and system database setup
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries
I try to upgrade MySQL from 5.7 to 8.0 version, with following steps:
1. Download the Repository
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
2. installing the package and configuring
$ sudo gdebi mysql-apt-config_0.8.10-1_all.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading state information... Done
Auto configuration for MySQL APT Repo.
MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.
Do you want to install the software package? [y/N]:y
Selecting previously unselected package mysql-apt-config.
(Reading database ... 232093 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.10-1_all.deb ...
Unpacking mysql-apt-config (0.8.10-1) ...
Setting up mysql-apt-config (0.8.10-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
How can I fix that the warnings and update/upgrade all my databases? Asking because I forgot to backup my databases with mysqldump query!
apt upgrade mysql
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
I already installed MySQL of client and server with 5.7 version.
When I check MySQL packages available :
$ sudo apt search mysql
mysql-client/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Client meta package depending on latest version
mysql-client-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database client binaries
mysql-client-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database core client binaries
mysql-server/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL Server meta package depending on latest version
mysql-server-5.7/bionic-updates,bionic-security,now 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries and system database setup
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.24-0ubuntu0.18.04.1 amd64 [installed]
MySQL database server binaries
I try to upgrade MySQL from 5.7 to 8.0 version, with following steps:
1. Download the Repository
$ wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
2. installing the package and configuring
$ sudo gdebi mysql-apt-config_0.8.10-1_all.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading state information... Done
Auto configuration for MySQL APT Repo.
MySQL is a fast, stable and true multi-user, multi-threaded SQL database
server. SQL (Structured Query Language) is the most popular database query
language in the world. The main goals of MySQL are speed, robustness and
ease of use.
Do you want to install the software package? [y/N]:y
Selecting previously unselected package mysql-apt-config.
(Reading database ... 232093 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.10-1_all.deb ...
Unpacking mysql-apt-config (0.8.10-1) ...
Setting up mysql-apt-config (0.8.10-1) ...
Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config)
OK
How can I fix that the warnings and update/upgrade all my databases? Asking because I forgot to backup my databases with mysqldump query!
apt upgrade mysql
apt upgrade mysql
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
edited Dec 28 '18 at 13:11
Sourav Ghosh
38529
38529
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
asked Dec 26 '18 at 14:31
abu-ahmed al-khatiriabu-ahmed al-khatiri
985115
985115
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
1
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06
add a comment |
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
1
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
1
1
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06
add a comment |
1 Answer
1
active
oldest
votes
2
This is a cosmetic warning essentially complaining that a script is using the apt-key command and that in the future the command might change so scripts shouldn't be using it since it's designed for humans to use.
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded themysql-serverpackage(s) itself.
– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
draft saved
draft discarded
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%2faskubuntu.com%2fquestions%2f1104673%2fget-the-warning-when-upgrade-mysql-5-7-to-8-0-on-bionic%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
This is a cosmetic warning essentially complaining that a script is using the apt-key command and that in the future the command might change so scripts shouldn't be using it since it's designed for humans to use.
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded themysql-serverpackage(s) itself.
– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
add a comment |
2
This is a cosmetic warning essentially complaining that a script is using the apt-key command and that in the future the command might change so scripts shouldn't be using it since it's designed for humans to use.
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded themysql-serverpackage(s) itself.
– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
add a comment |
2
2
2
This is a cosmetic warning essentially complaining that a script is using the apt-key command and that in the future the command might change so scripts shouldn't be using it since it's designed for humans to use.
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
This is a cosmetic warning essentially complaining that a script is using the apt-key command and that in the future the command might change so scripts shouldn't be using it since it's designed for humans to use.
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
answered Dec 26 '18 at 14:37
Kristopher IvesKristopher Ives
2,11711117
2,11711117
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded themysql-serverpackage(s) itself.
– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
add a comment |
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded themysql-serverpackage(s) itself.
– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
how should i do?
– abu-ahmed al-khatiri
Dec 26 '18 at 14:40
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded the
mysql-server package(s) itself.– Kristopher Ives
Dec 26 '18 at 14:43
Follow the steps in the MySQL Quick Guide - All you have done is installed a package that adds the MySQL repositories, not actually installed or upgraded the
mysql-server package(s) itself.– Kristopher Ives
Dec 26 '18 at 14:43
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
...which means you still have the opportunity to backup your databases before doing the upgrade.
– Eric Mintz
Dec 26 '18 at 15:32
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Ask Ubuntu!
- 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.
draft saved
draft discarded
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%2faskubuntu.com%2fquestions%2f1104673%2fget-the-warning-when-upgrade-mysql-5-7-to-8-0-on-bionic%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
I don't see any errors in that output - just one warning. And I don't see anything in that output that prevents your from backing up your databases.
– user535733
Dec 26 '18 at 15:02
is my databases on 5.7 safe when i upgrade to 8.0? @user535733
– abu-ahmed al-khatiri
Dec 26 '18 at 15:06
1
They are if you back them up first. If not, then no promises.
– user535733
Dec 26 '18 at 15:06