Copy MySQL database

[boka003]

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

[Sandeep]

if you have the two databases export through phpmyadmin export feature

[boka003]

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

[Sandeep]

You need mysql database dump to restore the database through ssh

[boka003]

Is possible to send tables betwen databases ?

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

[Sandeep]

through ssh separate database tables are not exported to another database

[Administrator]

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

Code Select Expand

mysql -e "show databases;"