Database backup
Clash Royale CLAN TAG#URR8PPP up vote
0
down vote
favorite
I want to take backup of Xampp database available in /opt/lampp/var/mysql
`but I am unable to do it.
I used below command
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se >
07feb.sql
and
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -h root -u root -p vive.se >
07feb.sql
Result is same
bash: 07feb.sql: Permission denied
Then I used
sudo -s
sudo mysqldump -u root -p vive.se > 07feb.sql
Result is
sudo: mysqldump: command not found
and it created a Empty file named 07feb.sql in /opt/lampp/htdocs/vivek.s
What is wrong while I saw my friend using same command and he got
database backup of 95 MB.
What should I try.
Thanks
16.04 mysql lamp xampp database
asked Feb 7 at 18:12
Vivek Sharma
187
add a comment |Â
up vote
0
down vote
favorite
I want to take backup of Xampp database available in /opt/lampp/var/mysql
`but I am unable to do it.
I used below command
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se >
07feb.sql
and
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -h root -u root -p vive.se >
07feb.sql
Result is same
bash: 07feb.sql: Permission denied
Then I used
sudo -s
sudo mysqldump -u root -p vive.se > 07feb.sql
Result is
sudo: mysqldump: command not found
and it created a Empty file named 07feb.sql in /opt/lampp/htdocs/vivek.s
What is wrong while I saw my friend using same command and he got
database backup of 95 MB.
What should I try.
Thanks
16.04 mysql lamp xampp database
asked Feb 7 at 18:12
Vivek Sharma
187
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I want to take backup of Xampp database available in /opt/lampp/var/mysql
`but I am unable to do it.
I used below command
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se >
07feb.sql
and
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -h root -u root -p vive.se >
07feb.sql
Result is same
bash: 07feb.sql: Permission denied
Then I used
sudo -s
sudo mysqldump -u root -p vive.se > 07feb.sql
Result is
sudo: mysqldump: command not found
and it created a Empty file named 07feb.sql in /opt/lampp/htdocs/vivek.s
What is wrong while I saw my friend using same command and he got
database backup of 95 MB.
What should I try.
Thanks
16.04 mysql lamp xampp database
asked Feb 7 at 18:12
Vivek Sharma
187
I want to take backup of Xampp database available in /opt/lampp/var/mysql
`but I am unable to do it.
I used below command
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -u root -p vive.se >
07feb.sql
and
/opt/lampp/htdocs/vivek.s$ sudo mysqldump -h root -u root -p vive.se >
07feb.sql
Result is same
bash: 07feb.sql: Permission denied
Then I used
sudo -s
sudo mysqldump -u root -p vive.se > 07feb.sql
Result is
sudo: mysqldump: command not found
and it created a Empty file named 07feb.sql in /opt/lampp/htdocs/vivek.s
What is wrong while I saw my friend using same command and he got
database backup of 95 MB.
What should I try.
Thanks
16.04 mysql lamp xampp database
16.04 mysql lamp xampp database
asked Feb 7 at 18:12
Vivek Sharma
187
asked Feb 7 at 18:12
Vivek Sharma
187
asked Feb 7 at 18:12
Vivek Sharma
187
asked Feb 7 at 18:12
Vivek Sharma
187
asked Feb 7 at 18:12
Vivek Sharma
187
187
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53
add a comment |Â
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
3
down vote
accepted
The problem is that you do not have permission to write to /opt/lampp/htdocs/vivek.s as your normal user. Running mysqldump as root elevates mysqldump (unnecessarily), but the redirection happens with the permissions of the shell - running as your regular user.
There's a few workarounds:
- Start a root shell by e.g.
sudo -iorsudo -s. You should not use sudo to run the next command - mysqldump. Use
tee:mysqldump -u root -p vive.se | sudo tee 07feb.sql > /dev/null
This will run the process tee as root, writing one copy to file, and redirecting stdout to /dev/null as we don't need it.
Another workaround would be to write the backup to a location where your user has write permission, for instance your home directory.
answered Feb 7 at 18:20
vidarlo
7,25642140
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
accepted
The problem is that you do not have permission to write to /opt/lampp/htdocs/vivek.s as your normal user. Running mysqldump as root elevates mysqldump (unnecessarily), but the redirection happens with the permissions of the shell - running as your regular user.
There's a few workarounds:
- Start a root shell by e.g.
sudo -iorsudo -s. You should not use sudo to run the next command - mysqldump. Use
tee:mysqldump -u root -p vive.se | sudo tee 07feb.sql > /dev/null
This will run the process tee as root, writing one copy to file, and redirecting stdout to /dev/null as we don't need it.
Another workaround would be to write the backup to a location where your user has write permission, for instance your home directory.
answered Feb 7 at 18:20
vidarlo
7,25642140
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
add a comment |Â
up vote
3
down vote
accepted
The problem is that you do not have permission to write to /opt/lampp/htdocs/vivek.s as your normal user. Running mysqldump as root elevates mysqldump (unnecessarily), but the redirection happens with the permissions of the shell - running as your regular user.
There's a few workarounds:
- Start a root shell by e.g.
sudo -iorsudo -s. You should not use sudo to run the next command - mysqldump. Use
tee:mysqldump -u root -p vive.se | sudo tee 07feb.sql > /dev/null
This will run the process tee as root, writing one copy to file, and redirecting stdout to /dev/null as we don't need it.
Another workaround would be to write the backup to a location where your user has write permission, for instance your home directory.
answered Feb 7 at 18:20
vidarlo
7,25642140
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
add a comment |Â
up vote
3
down vote
accepted
up vote
3
down vote
accepted
The problem is that you do not have permission to write to /opt/lampp/htdocs/vivek.s as your normal user. Running mysqldump as root elevates mysqldump (unnecessarily), but the redirection happens with the permissions of the shell - running as your regular user.
There's a few workarounds:
- Start a root shell by e.g.
sudo -iorsudo -s. You should not use sudo to run the next command - mysqldump. Use
tee:mysqldump -u root -p vive.se | sudo tee 07feb.sql > /dev/null
This will run the process tee as root, writing one copy to file, and redirecting stdout to /dev/null as we don't need it.
Another workaround would be to write the backup to a location where your user has write permission, for instance your home directory.
answered Feb 7 at 18:20
vidarlo
7,25642140
The problem is that you do not have permission to write to /opt/lampp/htdocs/vivek.s as your normal user. Running mysqldump as root elevates mysqldump (unnecessarily), but the redirection happens with the permissions of the shell - running as your regular user.
There's a few workarounds:
- Start a root shell by e.g.
sudo -iorsudo -s. You should not use sudo to run the next command - mysqldump. Use
tee:mysqldump -u root -p vive.se | sudo tee 07feb.sql > /dev/null
This will run the process tee as root, writing one copy to file, and redirecting stdout to /dev/null as we don't need it.
Another workaround would be to write the backup to a location where your user has write permission, for instance your home directory.
answered Feb 7 at 18:20
vidarlo
7,25642140
answered Feb 7 at 18:20
vidarlo
7,25642140
answered Feb 7 at 18:20
vidarlo
7,25642140
answered Feb 7 at 18:20
vidarlo
7,25642140
7,25642140
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
add a comment |Â
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
It also worked for me. Thanks
– Vivek Sharma
Feb 14 at 7:54
add a comment |Â
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%2f1003960%2fdatabase-backup%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
use a directory where you can store a file. the ">" part has no permission to write. Regarding the 2nd one: directory to mysqldump is not in the PATH. Use an absolute path
– Rinzwind
Feb 7 at 18:19
@Rinzwind, It worked. Thanks
– Vivek Sharma
Feb 14 at 7:53