Jump to content

mysqldump --result-file flag


Recommended Posts

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!

 

 

 

Link to post
Share on other sites
This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.