Drush and specifying source dump and target dump options
Using temporary files to store and transfer sql-dump. It is recommended that you specify --source-dump and --target-dump options on the command line, or set '%dump' or '%dump-dir' in the path-aliases section of your site alias records. This facilitates fast file transfer via rsync.
What exactly does that mean? Is some random location i make up really better than the temporary directory? Or should i be giving it some specific directory, on different serves or something? Guidance please.
$options['dump-dir'] = '/home/ben/tmp/dumps';
with no matter what i did to the folder:
[email protected]:~/code/sdl/web (continuum *)$ sudo chown root:root -R /home/ben/tmp
[email protected]:~/code/sdl/web (continuum *)$ sudo chmod 775 -R [email protected]:~/code/sdl/web (continuum *)$ ls -la /home/ben/tmp/dumpstotal 8
drwxrwxr-x 2 root root 4096 2011-08-28 22:12 .
drwxrwxr-x 3 root root 4096 2011-08-28 22:12 ..
drush sql-sync --alias-path=.. @sdl.stage @sdl.local
You might want to make a backup first, using the sql-dump command.
Do you really want to continue? (y/n): y
mysqldump: Can't create/write to file '/home/ben/tmp/dumps/simone.mayfirst.org_drupal-sdl-stage.sql-1314585287' (Errcode: 2)
mv: cannot stat `/home/ben/tmp/dumps/simone.mayfirst.org_drupal-sdl-stage.sql-1314585287': No such file or directory
rsync: change_dir "/home/ben/tmp/dumps" failed: No such file or directory (2)
rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1526) [Receiver=3.0.7]
Could not rsync from [error]
But this works:
$options['dump-dir'] = '/tmp';
[email protected]:~/code/sdl/web (continuum *)$ ls -la /tmp/