Control Web Panel

WebPanel => MySQL => Topic started by: boka003 on April 05, 2016, 11:25:00 PM

Title: Copy MySQL database
Post 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
Title: Re: Copy MySQL database
Post by: Sandeep on April 06, 2016, 05:36:19 AM
if you have the two databases export through phpmyadmin export feature
Title: Re: Copy MySQL database
Post by: boka003 on April 06, 2016, 11:27:54 AM
Yes,  i know about export and impirt.
But this databases are pretty big,  is there any way to import databases via ssh?
Title: Re: Copy MySQL database
Post by: Sandeep on April 06, 2016, 03:36:20 PM
You need mysql database dump to restore the database through ssh
Title: Re: Copy MySQL database
Post by: boka003 on April 06, 2016, 04:18:34 PM
Is possible to send tables betwen databases ?

Like, send table (users) from one database to another ?
Title: Re: Copy MySQL database
Post by: Sandeep on April 06, 2016, 07:49:41 PM
through ssh separate database tables are not exported to another database
Title: Re: Copy MySQL database
Post by: Administrator on April 07, 2016, 09:28:31 AM
you need to check mysql commands, and you can do it from ssh, for example
Code: [Select]
mysql -e "show databases;"