mysqlhotcopy backup from server to another server with permission
up vote
0
down vote
favorite
I have two mysql servers. one server configured manually. One server normal installtion.
server 1 db ownership like userA:group
server 2 db ownership like mysql:mysql
while doing mysqlhotcopy from server1 to server2 the ownership permissions are changing as userA:group. so cant be able to access the database in server2.
I change the permission manually and removing the log files and restarted the mysql. still it is shoung .frm file not found.
please anyone give me the solution for mysqlhotcopy it should not change the destination permission or anybetter way for mysql hotcopy.
mysql
add a comment |
up vote
0
down vote
favorite
I have two mysql servers. one server configured manually. One server normal installtion.
server 1 db ownership like userA:group
server 2 db ownership like mysql:mysql
while doing mysqlhotcopy from server1 to server2 the ownership permissions are changing as userA:group. so cant be able to access the database in server2.
I change the permission manually and removing the log files and restarted the mysql. still it is shoung .frm file not found.
please anyone give me the solution for mysqlhotcopy it should not change the destination permission or anybetter way for mysql hotcopy.
mysql
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have two mysql servers. one server configured manually. One server normal installtion.
server 1 db ownership like userA:group
server 2 db ownership like mysql:mysql
while doing mysqlhotcopy from server1 to server2 the ownership permissions are changing as userA:group. so cant be able to access the database in server2.
I change the permission manually and removing the log files and restarted the mysql. still it is shoung .frm file not found.
please anyone give me the solution for mysqlhotcopy it should not change the destination permission or anybetter way for mysql hotcopy.
mysql
I have two mysql servers. one server configured manually. One server normal installtion.
server 1 db ownership like userA:group
server 2 db ownership like mysql:mysql
while doing mysqlhotcopy from server1 to server2 the ownership permissions are changing as userA:group. so cant be able to access the database in server2.
I change the permission manually and removing the log files and restarted the mysql. still it is shoung .frm file not found.
please anyone give me the solution for mysqlhotcopy it should not change the destination permission or anybetter way for mysql hotcopy.
mysql
mysql
edited Nov 19 at 10:19
Billal Begueradj
5,586132637
5,586132637
asked Nov 19 at 9:19
Sameer Ahmed Z
11
11
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53371519%2fmysqlhotcopy-backup-from-server-to-another-server-with-permission%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