How to take mysql backup from A machine & Restore to B machine in centos?

Claim your Biolink Click Here
0 like 0 dislike
331 views
How to take mysql backup from A machine & Restore to B machine in centos?
in Education & Reference by (830 points) | 331 views

1 Answer

0 like 0 dislike

In CLI

A Machine:
mysqldump -u root -p database1 > database1.sql
scp -r database1.sql root@1.1.1.1:/

B Machine:
mysql -p database1 < database1.sql

by

Related questions

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) | 121 views
0 like 0 dislike
1 answer
How to take backup and restore mysql database in linux(centos)
asked Jul 14, 2017 in Education & Reference by Krish (1.1k points) | 220 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 (830 points) | 97 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) | 430 views
1 like 0 dislike
1 answer
How to set Date and Time on linux(centos) From a Command Prompt?
asked May 27, 2014 in Education & Reference by Yogi (460 points) | 308 views
0 like 0 dislike
1 answer
How to create a USER Account with ROOT Privileges in Linux (Centos)
asked Jun 17, 2014 in Education & Reference by Bhoomika (-30 points) | 242 views
1 like 0 dislike
1 answer
Unable to restrict access from .htaccess in my centos, please help
asked Nov 4, 2014 in Education & Reference by Simmi (830 points) | 2.6k views
1 like 0 dislike
1 answer
How to Verify a CentOS Linux Server is 32 Bit or 64 Bit?
asked Aug 6, 2013 in Education & Reference by Vikas | 777 views
0 like 0 dislike
1 answer
How to zip all files named with test in centos via PHP
asked Jul 27, 2018 in Education & Reference by Neha (1.1k points) | 235 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,312 questions
1,473 answers
569 comments
4,809 users