Author Topic: Copy MySQL database  (Read 11974 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Copy MySQL database
« 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
« Last Edit: April 05, 2016, 11:45:25 PM by boka003 »

Offline
*****
Re: Copy MySQL database
« Reply #1 on: April 06, 2016, 05:36:19 AM »
if you have the two databases export through phpmyadmin export feature

Offline
*
Re: Copy MySQL database
« Reply #2 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?

Offline
*****
Re: Copy MySQL database
« Reply #3 on: April 06, 2016, 03:36:20 PM »
You need mysql database dump to restore the database through ssh

Offline
*
Re: Copy MySQL database
« Reply #4 on: April 06, 2016, 04:18:34 PM »
Is possible to send tables betwen databases ?

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

Offline
*****
Re: Copy MySQL database
« Reply #5 on: April 06, 2016, 07:49:41 PM »
through ssh separate database tables are not exported to another database

Offline
*
Re: Copy MySQL database
« Reply #6 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;"
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services