[BlueOnyx:24851] Re: EasyMigrate question

[Michael Stauber]

Hi Jeff,

> Any way to use easy-migrate to transfer the mysql for a SINGLE site?
> Asking for a friend who destroyed a single database on one site… :-D

Uuuuh. Not really. :p

This migrates all SQL database:

/usr/sausalito/sbin/easy-migrate.pl --source <IP-of-Source-Server> -p 22
--mysql

So you might not want that.

Migrating just one Vsite ...

/usr/sausalito/sbin/easy-migrate.pl --source <IP-of-Source-Server> -p 22
--ip <new-ip-of-vsite> --vsites www.site.com

... will migrate the Vsite and user data as well as the MySQL databases.
But as that also pulls over the User-data it means you might loose
emails and other Vsite and User changes that happened since the Vsite
went life on the new server.

But there is something else:
=============================

On the new where the SQL database went walkies, go to "Site Management"
/ <Site> / "Services" / "MariaDB". Scroll down to "MariaDB databases of
this virtual site:" and see if the database(s) for that Vsite are still
shown.

Chances are: If the DBs are still known to CODB *and* you did a recent
Easy-Migrate, then the SQL database SQL-dumps that Easy-Migrate did
during the migration are still present. If so, the second button in the
row of five (the mouse-over helptext says "Restore SQL database ...") is
in dark color (dark blue for example) and allows you to restore the
SQL-dump.

Alternatively you might find the SQL dumps on the file system:

On 5209R:

/home/sites/<vsite>/sql

On 5210R:

/home/sites/<vsite>/wwwroot/sql

The source server of the migration also will have these files present
form the last Easy-Migrate run.

Lastly and if all fails you can use phpMyAdmin on the old server to just
export the database you want and then can import it on the new server
either via phpMyAdmin or via the GUI page "Site Management" / <Site> /
"Services" / "MariaDB". It has an upload button that lets you upload and
import an SQL database dump.

One of these methods should get your friend up and running. :-)

-- 
With best regards

Michael Stauber