Copy MySQL database

Hello,

I have one wordpress site, that i need to copy (like every 10 days).
I can duplicate files and move it via root.

But is there any way to move database, like to copy everything in one database to another one.

If i have 2 databse can i migrate tables between databases ?

Thank you

if you have the two databases export through phpmyadmin export feature

Yes,  i know about export and impirt.
But this databases are pretty big,  is there any way to import databases via ssh?

You need mysql database dump to restore the database through ssh

Is possible to send tables betwen databases ?

Like, send table (users) from one database to another ?

through ssh separate database tables are not exported to another database

you need to check mysql commands, and you can do it from ssh, for example

Code: [Select]

mysql -e "show databases;"