Moving large mySQL database
Hi All, this is not exactly an e-class question, but I think this section would provide the best answer.
First off, I have a 3gb database and no shell / ssh access to the source machine. I have root access on the target. I have tried using the provided export methods (cpanel backups!) but they do not produce a viable database dump.
Short of stopping mysql, creating a tar of the database and copying it over to the target, I am at a loss, and as mentioned I do not have this level of access.
Is there a way to pull the database to the source machine directly from a remote mysql connection? Or some other method I haven't mentioned? Something like a manual one-shot replicate?