Control Web Panel
WebPanel => MySQL => Topic started by: boka003 on April 05, 2016, 11:25:00 PM
-
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
mysql -e "show databases;"