Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Senior Coder durangod's Avatar
    Join Date
    Nov 2010
    Location
    southwestern USA
    Posts
    1,993
    Thanks
    339
    Thanked 54 Times in 52 Posts

    Dont use rsync for transferring MySql DB files

    Last week i read an article which warned about using rsync command to transfer MySql (sql) DB files. In that article it was mentioned that the rsync command has been accused of corrupting sql files. They gave sftp as an alternative.
    If a php file only has php code within it you do not need to use the closing php tag
    Remember in PHP you shoot Objects with arrows Example: $name->id; then Arrays are $name['id'];
    durangod is short for durango dave

  2. #2
    Regular Coder Vege's Avatar
    Join Date
    Jan 2008
    Posts
    910
    Thanks
    21
    Thanked 121 Times in 120 Posts
    Link the article. I have seen corrupted tables with transferred data files but never with transferred dumps.

  3. #3
    Senior Coder deathshadow's Avatar
    Join Date
    Feb 2016
    Location
    Keene, NH
    Posts
    2,669
    Thanks
    2
    Thanked 388 Times in 378 Posts
    Yeah, source on that would be nice... NOT that I ever trust any sort of automation for dealing with backups or moving them around. Same as how phpMyAdmin often goes bits-up face-down on backing up larger database because of timeout issues.

    You make your backup file on the command line, and you move it with normal plain-Jane FTP software forced into binary mode. You'll NEVER have a problem.

    Start relying on goofy automation, that's where things go bits-up face-down most every time. Take the sleazy shortcut to save a few seconds typing or a few minutes learning, don't be surprised when it bites you.
    I would rather have questions that can't be answered, than answers that can't be questioned.
    http://www.cutcodedown.com


 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •