Fun at zangOOr Click Here
0 like 0 dislike
90 views

I want to take backup from A server and restore mysql database into to B server in linux(centos)

in Education & Reference by (790 points) | 90 views

1 Answer

0 like 0 dislike
Best answer

Server A
Dump/Backup:

mysqldump -u root -p DBNAME > DBNAME.sql

Transfer to Server B
Transfer:

scp DBNAME.sql [email protected]:.

Restore in Server B
Restore:

mysql -u root -p DBNAME < DBNAME.sql

by (3.3k points)

Related questions

0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
3 answers
asked Jan 20, 2014 in Education & Reference by Sam (1.4k points) | 860 views
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
1 like 0 dislike
1 answer
2 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,243 questions
1,398 answers
564 comments
4,237 users