How to take backup and restore mysql database in linux(centos)

Claim your Biolink Click Here
0 like 0 dislike
234 views

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

in Education & Reference by (1.1k points) | 234 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 (4.7k points)

Related questions

0 like 0 dislike
1 answer
How to take mysql backup from A machine & Restore to B machine in centos?
asked Mar 4, 2015 in Education & Reference by Simmi (820 points) | 377 views
1 like 0 dislike
1 answer
how to take daily mysql backup as a .sql file in linux automatically
asked Sep 30, 2022 in Education & Reference by Krish (1.1k points) | 162 views
1 like 0 dislike
1 answer
How to Install MySQL 5.7 from Official Yum Repositories in Centos 6.8
asked Sep 8, 2017 in Education & Reference by Krish (1.1k points) | 451 views
1 like 0 dislike
1 answer
how to take daily website backup as a zip in linux automatically
asked Sep 30, 2022 in Education & Reference by Simmi (820 points) | 124 views
0 like 0 dislike
1 answer
How can I check MySQL engine type for all tables in a particular database?
asked Oct 25, 2017 in Education & Reference by Simmi (820 points) | 261 views
0 like 0 dislike
3 answers
How to repair vicidial mysql database
asked Jan 20, 2014 in Education & Reference by Sam (1.6k points) | 2.0k views
0 like 0 dislike
1 answer
How to Generate XML from MySQL database via PHP
asked Aug 13, 2013 in Education & Reference by oreo | 1.2k views
0 like 0 dislike
1 answer
How to avoid 'copying to tmp table on mysql and speed up MySQL query'
asked May 27, 2014 in Education & Reference by Yogi (460 points) | 499 views
1 like 0 dislike
1 answer
How to create a basic Web Service Using PHP, MySQL, XML, and JSON
asked Oct 3, 2013 in Education & Reference by Simmi (820 points) | 3.6k views

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

Most popular tags

Related questions

1,314 questions
1,476 answers
569 comments
4,809 users