MySQL Forums
Forum List  »  Backup

import remote database by connect to remote service
Posted by: biagio rea
Date: July 15, 2014 09:15PM

good day guys
to import a remote database on the local pc,
connect directly with the remote service and run a mysql dump, it might be an appropriate method, or is it not recommended?
and the second question, it is irrelevant to use: mysqldump from the command line or a dbmanager like mysql_workbench or SQLyog?

what has happened is
2GB of remote database, a size just too big to be imported with phpmydmin
in remote server there is not any ssh service,
the remote host has opened a door directly to the mysql service
I tried once to make the dump, but the result was a file .sql corrupt, my be a case,
so I suspect that this method is not appropriate,
there might be problems in the verification of tcp packages and their composition in the dump .sql file?

Options: ReplyQuote

Written By
import remote database by connect to remote service
July 15, 2014 09:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.