Mixing
How do I restore a dump file from mysqldump using kubernetes?
I know how to restore a dump file from mysqldump. Now, I am attempting to do that using kubernetes and a docker container. The database files are in persistent (nfs) mount. The docker cannot be accessed outside of the cluster as there is no need for anything external to touch it.
I tried:
kubectl run -i -t dbtest --image=mariadb --restart=Never --rm=true --command -- mysql -uroot -ps3kr37 < dump.sql
and
kubectl exec mariadb-deployment-3614069618-mn524 -i -t -- mysql -u root -p=s3kr37 < dump.sql
But neither commands worked -- errors about TTY, sockets, and other things hinting that I am missing something vital here.
What am I not understanding here?
I could just stop the deployment, scp the database files, and restart the container and hope for the best. However, what can go right?
The question Install an sql dump file to a docker container with mariaDB sure looks like a duplicate but is not: first, I am on Linux not Windows and more importantly the answers all are about initialising with a dump. I want to be able to trash the data and revert to the dump data. This is a test system that will eventually be the "live" so I need to restore from many potential dumps.
mysql docker
kubernetes mariadb edited Jan 1 at 11:49
Cœur
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
add a comment |
I know how to restore a dump file from mysqldump. Now, I am attempting to do that using kubernetes and a docker container. The database files are in persistent (nfs) mount. The docker cannot be accessed outside of the cluster as there is no need for anything external to touch it.
I tried:
kubectl run -i -t dbtest --image=mariadb --restart=Never --rm=true --command -- mysql -uroot -ps3kr37 < dump.sql
and
kubectl exec mariadb-deployment-3614069618-mn524 -i -t -- mysql -u root -p=s3kr37 < dump.sql
But neither commands worked -- errors about TTY, sockets, and other things hinting that I am missing something vital here.
What am I not understanding here?
I could just stop the deployment, scp the database files, and restart the container and hope for the best. However, what can go right?
The question Install an sql dump file to a docker container with mariaDB sure looks like a duplicate but is not: first, I am on Linux not Windows and more importantly the answers all are about initialising with a dump. I want to be able to trash the data and revert to the dump data. This is a test system that will eventually be the "live" so I need to restore from many potential dumps.
mysql docker
kubernetes mariadb edited Jan 1 at 11:49
Cœur
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27
add a comment |
I know how to restore a dump file from mysqldump. Now, I am attempting to do that using kubernetes and a docker container. The database files are in persistent (nfs) mount. The docker cannot be accessed outside of the cluster as there is no need for anything external to touch it.
I tried:
kubectl run -i -t dbtest --image=mariadb --restart=Never --rm=true --command -- mysql -uroot -ps3kr37 < dump.sql
and
kubectl exec mariadb-deployment-3614069618-mn524 -i -t -- mysql -u root -p=s3kr37 < dump.sql
But neither commands worked -- errors about TTY, sockets, and other things hinting that I am missing something vital here.
What am I not understanding here?
I could just stop the deployment, scp the database files, and restart the container and hope for the best. However, what can go right?
The question Install an sql dump file to a docker container with mariaDB sure looks like a duplicate but is not: first, I am on Linux not Windows and more importantly the answers all are about initialising with a dump. I want to be able to trash the data and revert to the dump data. This is a test system that will eventually be the "live" so I need to restore from many potential dumps.
mysql docker
kubernetes mariadb edited Jan 1 at 11:49
Cœur
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
I know how to restore a dump file from mysqldump. Now, I am attempting to do that using kubernetes and a docker container. The database files are in persistent (nfs) mount. The docker cannot be accessed outside of the cluster as there is no need for anything external to touch it.
I tried:
kubectl run -i -t dbtest --image=mariadb --restart=Never --rm=true --command -- mysql -uroot -ps3kr37 < dump.sql
and
kubectl exec mariadb-deployment-3614069618-mn524 -i -t -- mysql -u root -p=s3kr37 < dump.sql
But neither commands worked -- errors about TTY, sockets, and other things hinting that I am missing something vital here.
What am I not understanding here?
I could just stop the deployment, scp the database files, and restart the container and hope for the best. However, what can go right?
The question Install an sql dump file to a docker container with mariaDB sure looks like a duplicate but is not: first, I am on Linux not Windows and more importantly the answers all are about initialising with a dump. I want to be able to trash the data and revert to the dump data. This is a test system that will eventually be the "live" so I need to restore from many potential dumps.
mysql docker
kubernetes mariadb mysql docker
kubernetes mariadb edited Jan 1 at 11:49
Cœur
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
edited Jan 1 at 11:49
Cœur
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
edited Jan 1 at 11:49
Cœur
18.7k9110150
edited Jan 1 at 11:49
Cœur
18.7k9110150
edited Jan 1 at 11:49
Cœur
18.7k9110150
18.7k9110150
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
asked Jun 23 '17 at 8:05
SardathrionSardathrion
6,2321360100
6,2321360100
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27
add a comment |
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27
add a comment |
2 Answers
2
active
oldest
votes
What I did was this:
- Create an NFS mount with two sub0drectories:
mysqlandinitd. - In
initd, I added several,sqlfiles, including the dump. - Mount
initdas/docker-entrypoint-initdb.din the deployment.This causes all the files to be read at initialisation time provided that it is the first time we run. - The
mysqldirectory is mounted as/var/lib/mysqland contains all the mariaDB files.
If I need to revert, I trash all the contents of the mysql directory and re-create the deployment.
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
add a comment |
This should work:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml exec -i ddevdb-XXXXX -- mysql -u root -h mysqlservice -proot drupal < you-dump.sql
kubeconfig is optional, digitalocean for examples provides that so you can run your commands from your local.
To see if everything looks good:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml run -it --rm --image=mariadb:10.4 --restart=Never mysql -- mysql -h mysqlservice -proot
After which you'll have a terminal inside mysql.
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
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%2fstackoverflow.com%2fquestions%2f44716207%2fhow-do-i-restore-a-dump-file-from-mysqldump-using-kubernetes%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
What I did was this:
- Create an NFS mount with two sub0drectories:
mysqlandinitd. - In
initd, I added several,sqlfiles, including the dump. - Mount
initdas/docker-entrypoint-initdb.din the deployment.This causes all the files to be read at initialisation time provided that it is the first time we run. - The
mysqldirectory is mounted as/var/lib/mysqland contains all the mariaDB files.
If I need to revert, I trash all the contents of the mysql directory and re-create the deployment.
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
add a comment |
What I did was this:
- Create an NFS mount with two sub0drectories:
mysqlandinitd. - In
initd, I added several,sqlfiles, including the dump. - Mount
initdas/docker-entrypoint-initdb.din the deployment.This causes all the files to be read at initialisation time provided that it is the first time we run. - The
mysqldirectory is mounted as/var/lib/mysqland contains all the mariaDB files.
If I need to revert, I trash all the contents of the mysql directory and re-create the deployment.
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
add a comment |
What I did was this:
- Create an NFS mount with two sub0drectories:
mysqlandinitd. - In
initd, I added several,sqlfiles, including the dump. - Mount
initdas/docker-entrypoint-initdb.din the deployment.This causes all the files to be read at initialisation time provided that it is the first time we run. - The
mysqldirectory is mounted as/var/lib/mysqland contains all the mariaDB files.
If I need to revert, I trash all the contents of the mysql directory and re-create the deployment.
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
What I did was this:
- Create an NFS mount with two sub0drectories:
mysqlandinitd. - In
initd, I added several,sqlfiles, including the dump. - Mount
initdas/docker-entrypoint-initdb.din the deployment.This causes all the files to be read at initialisation time provided that it is the first time we run. - The
mysqldirectory is mounted as/var/lib/mysqland contains all the mariaDB files.
If I need to revert, I trash all the contents of the mysql directory and re-create the deployment.
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
answered Jun 27 '17 at 9:48
SardathrionSardathrion
6,2321360100
6,2321360100
add a comment |
add a comment |
This should work:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml exec -i ddevdb-XXXXX -- mysql -u root -h mysqlservice -proot drupal < you-dump.sql
kubeconfig is optional, digitalocean for examples provides that so you can run your commands from your local.
To see if everything looks good:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml run -it --rm --image=mariadb:10.4 --restart=Never mysql -- mysql -h mysqlservice -proot
After which you'll have a terminal inside mysql.
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
add a comment |
This should work:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml exec -i ddevdb-XXXXX -- mysql -u root -h mysqlservice -proot drupal < you-dump.sql
kubeconfig is optional, digitalocean for examples provides that so you can run your commands from your local.
To see if everything looks good:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml run -it --rm --image=mariadb:10.4 --restart=Never mysql -- mysql -h mysqlservice -proot
After which you'll have a terminal inside mysql.
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
add a comment |
This should work:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml exec -i ddevdb-XXXXX -- mysql -u root -h mysqlservice -proot drupal < you-dump.sql
kubeconfig is optional, digitalocean for examples provides that so you can run your commands from your local.
To see if everything looks good:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml run -it --rm --image=mariadb:10.4 --restart=Never mysql -- mysql -h mysqlservice -proot
After which you'll have a terminal inside mysql.
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
This should work:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml exec -i ddevdb-XXXXX -- mysql -u root -h mysqlservice -proot drupal < you-dump.sql
kubeconfig is optional, digitalocean for examples provides that so you can run your commands from your local.
To see if everything looks good:
kubectl --kubeconfig=k8s-XXXXXXX-kubeconfig.yaml run -it --rm --image=mariadb:10.4 --restart=Never mysql -- mysql -h mysqlservice -proot
After which you'll have a terminal inside mysql.
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
answered Jan 6 at 16:23
Alejandro MorenoAlejandro Moreno
3,48112425
3,48112425
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f44716207%2fhow-do-i-restore-a-dump-file-from-mysqldump-using-kubernetes%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
What about mounting NFS into container with your database and then import dump in regular way like locally?
– webdizz
Jun 23 '17 at 16:27