Copy a MySQL Database to a new Server via SSH with one command Using ssh

This doesn't work as-is, at least for me it doesn't. If you define a new db name that is different from the original db name, it must first exist. Otherwise you can't give it as an argument to mysql to load data in from a script (or here from a pipe). On the other hand, if you want to use the same target database name as the source database name, you need to add "--databases" switch in order to include the "CREATE DATABASE" statement to the dump. Then you must not give NEW_DB_NAME as a parameter to the mysql command or else you get "ERROR 1049 (42000): Unknown database 'NEW_DB_NAME'" So either:

ssh -C user@newhost "mysql -uUSER -pPASS -e 'create database NEW_DB_NAME;'" && mysqldump --force --log-error=mysql_error.log -uUSER -pPASS OLD_DB_NAME | ssh -C user@remotehost "mysql -uUSER -pPASS NEW_DB_NAME"

or, to use the same db name for target as the source:

mysqldump --databases --force --log-error=/root/mysql_error.log -uUSER -pPASS OLD_DB_NAME | ssh -C user@newhost "mysql -uUSER -pPASS"

Also note that "--add-drop-table" and "--extended-insert" are rendundant since at least in 5.1 they're on by default; see an excerpt from 'man mysqldump' below: --- Some mysqldump options are shorthand for groups of other options. --opt and --compact fall into this category. For example, use of --opt is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. Note that all of the options that --opt stands for also are on by default because --opt is on by default.

vwal · 721 weeks and 2 days ago

People who are fond of doing a lot of work can know to convert the database. In other ways, hire writers review, and you will see the different dimensions to come across with new perspectives.

rojeciju · 161 weeks and 3 days ago

google

KGF123 · 158 weeks and 5 days ago

I am working in a computer field and this is one of my favorites sites which helps me in fixing the books which are occurring in my program. The information provided here will be really helpful for the techies like me. CBD topicals

Juvanta · 157 weeks and 6 days ago

You just do to me, what you do And it feels like I've been rescued fireboy and watergirl

lindaperryly · 149 weeks and 1 day ago

Wow. Nice to see this post here. It is one of the best websites, and it provides some programming code. I think this post will be helpful for the programmers to fix SQL errors. Thank you for sharing the command, Gsm antenna and it is really informative too.

ryanbabraham · 146 weeks and 1 day ago

I am a regular visitor of this website and good to see these command line interfaces and commands https://uselegalcbd.com you have described here. With these commands you can perform various tasks so easily. I am looking here for more such updates and keep up the good work.

Alyssalauren · 113 weeks and 6 days ago

Up all night cabinets idaho falls

tillyracker · 101 weeks and 3 days ago

They https://essaysprofessors.com do their job honestly and with high quality, because all the work is done not by bachelor students, but by real teachers!

Morrello · 89 weeks ago

They https://essaysprofessors.com do their job honestly and with high quality, because all the work is done not by bachelor students, but by real teachers!

Morrello · 89 weeks ago

seofox · 79 weeks and 6 days ago

We facilitate you with custom-made solutions to fit your business’s specific needs. Here, at ITSolutions24x7, we have skilled developers to create a high-performing website. [url=https://itsolution24x7.com/wordpress-development]Ecommerce website development[/url]