Answer the question
In order to leave comments, you need to log in
How can bash copy the contents of a MySQL database table between two servers?
Good afternoon, tell me please, is it possible to take the contents of one table (row) with a bash script and copy them to an identical table on another database server, having previously cleared it.
I need to carry out such a migration daily by cron
Answer the question
In order to leave comments, you need to log in
mysqldump -h host1 <google.it> > file.sql
mysql -h host2 <google.it> < file.sql
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question