mysqldump --result-file flag

[phdphd]

Hi All,

I am in the process of moving my database from a local Windows system to a Debian VPS server.

So far to back up my database I have been using this syntax :

mysqldump -uroot -p --databases database_name --routines --events> filename.sql

In this page

http://www.it-iss.com/mysql/mysql-copying-a-database-users-and-privileges-between-two-servers/

the author recommends to use also the --result-file to prevent line end issues when moving from a Windows system to a Linux system.

Would the right syntax be as follows then ?

mysqldump -uroot -p --databases database_name --result-file= filename.sql --routines --events

Thanks!

 

 

 

[requinix]

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_result-file

[phdphd]

Thanks.

mysqldump -uroot -p --databases db_name --routines --events --result-file=file_name.sql

did the trick.