I have a MySQL database existing on a remote server. I only have sql connection privilege. I don't have FTP access to the server, and I need to do a complete dump of the database. I have tried mysqldump
, but the issue is that it is creating the output on the server and as I don't have FTP I can not get the output from the server.
如何进行干净备份并在本地计算机上获得转储文件(当然,备份应该在本地计算机上恢复)?