How to back-up MySQL in a snap
Clash Royale CLAN TAG#URR8PPP up vote
1
down vote
favorite
I've installed NextCloud in a snap under Ubuntu 16.04 LTS. The MySQL installation in the snap uses a socket file locate in the snap's (containerized) /tmp rather than a network socket. I don't want to reconfigure the snap's MySQL configuration to add a network listener, as I expect that such changes might get lost with upgrades or re-installations.
I want to back up NextCloud's MySQL environment using mysqldump, but without a network listener I need to know the location of the socket file as it appears to the host (non-snap) environment. At the moment, I've found the socket appears to the host system as "/tmp/snap.0_nextcloud_eKluT5/tmp/sockets/mysql.sock", but I don't think that path will stay consistent. Is there a way to dynamically query the mappings between the snap environment and the host environment (e.g. the snap's /tmp maps to the hosts /tmp/snap.0_nextcloud_eKluT5/tmp)?
mysql snap
asked Feb 24 at 20:30
B.Martin
62
add a comment |Â
up vote
1
down vote
favorite
I've installed NextCloud in a snap under Ubuntu 16.04 LTS. The MySQL installation in the snap uses a socket file locate in the snap's (containerized) /tmp rather than a network socket. I don't want to reconfigure the snap's MySQL configuration to add a network listener, as I expect that such changes might get lost with upgrades or re-installations.
I want to back up NextCloud's MySQL environment using mysqldump, but without a network listener I need to know the location of the socket file as it appears to the host (non-snap) environment. At the moment, I've found the socket appears to the host system as "/tmp/snap.0_nextcloud_eKluT5/tmp/sockets/mysql.sock", but I don't think that path will stay consistent. Is there a way to dynamically query the mappings between the snap environment and the host environment (e.g. the snap's /tmp maps to the hosts /tmp/snap.0_nextcloud_eKluT5/tmp)?
mysql snap
asked Feb 24 at 20:30
B.Martin
62
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I've installed NextCloud in a snap under Ubuntu 16.04 LTS. The MySQL installation in the snap uses a socket file locate in the snap's (containerized) /tmp rather than a network socket. I don't want to reconfigure the snap's MySQL configuration to add a network listener, as I expect that such changes might get lost with upgrades or re-installations.
I want to back up NextCloud's MySQL environment using mysqldump, but without a network listener I need to know the location of the socket file as it appears to the host (non-snap) environment. At the moment, I've found the socket appears to the host system as "/tmp/snap.0_nextcloud_eKluT5/tmp/sockets/mysql.sock", but I don't think that path will stay consistent. Is there a way to dynamically query the mappings between the snap environment and the host environment (e.g. the snap's /tmp maps to the hosts /tmp/snap.0_nextcloud_eKluT5/tmp)?
mysql snap
asked Feb 24 at 20:30
B.Martin
62
I've installed NextCloud in a snap under Ubuntu 16.04 LTS. The MySQL installation in the snap uses a socket file locate in the snap's (containerized) /tmp rather than a network socket. I don't want to reconfigure the snap's MySQL configuration to add a network listener, as I expect that such changes might get lost with upgrades or re-installations.
I want to back up NextCloud's MySQL environment using mysqldump, but without a network listener I need to know the location of the socket file as it appears to the host (non-snap) environment. At the moment, I've found the socket appears to the host system as "/tmp/snap.0_nextcloud_eKluT5/tmp/sockets/mysql.sock", but I don't think that path will stay consistent. Is there a way to dynamically query the mappings between the snap environment and the host environment (e.g. the snap's /tmp maps to the hosts /tmp/snap.0_nextcloud_eKluT5/tmp)?
mysql snap
mysql snap
asked Feb 24 at 20:30
B.Martin
62
asked Feb 24 at 20:30
B.Martin
62
asked Feb 24 at 20:30
B.Martin
62
asked Feb 24 at 20:30
B.Martin
62
asked Feb 24 at 20:30
B.Martin
62
62
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1009417%2fhow-to-back-up-mysql-in-a-snap%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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