0 like 0 dislike
60 views

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

in Education & Reference by (810 points) | 60 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 root@127.0.0.1:.

Restore in Server B
Restore:

mysql -u root -p DBNAME < DBNAME.sql

by (2.4k 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.3k points) | 405 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
0 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,202 questions
1,347 answers
553 comments
1,994 users