I connect to a remote database and want to save data from a table to a file on a local server. As far as I know the team

SELECT ... INTO OUTFILE '/file_name.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

saves data to a file on the server host.

Is it possible to save data from a table to a file on a local server, and if so, how?

PS It would be perfect if this could be done using SQLyog tools.

  • If only via sftp mount the local directory to a remote server - Maxim Timakov
  • So, in fact, in SQLyog you can configure access to a remote server ... there, on the Mysql tab, you can configure the ip, port, login and password to the connected database .... or does not work? .... depending on who manages this database, it may be necessary to configure access via SSH (ask admin to request ip log pass or public key) - Aleksey Shimansky
  • I ’ve created a test database on db4free.net ... you can try logging in via SQLYog yourself and see what works: имя сервера: db4free.net порт: 3306 База данных: testyoyotest Username: testyoyotest pass: qwerty - Alexey Shimansky

0