Hello and welcome to our community! Is this your first visit?
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
    East Texas USA
    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
    A good way to remember objects from arrays is 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
    Thanked 125 Times in 124 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
    Keene, NH
    Thanked 416 Times in 405 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.
    “There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies and the other way is to make it so complicated that there are no obvious deficiencies.” – C.A.R. Hoare, The 1980 ACM Turing Award Lecture


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