We tried to dump the server, got an error instead.

help-fix-new-www-dump

[victor@ip-172-26-8-125 html]$ drush sql:sync @live @self --debug
 [preflight] Config paths: /var/www/html/vendor/drush/drush/drush.yml
 [preflight] Alias paths: /var/www/html/web/drush/sites,/var/www/html/drush/sites
 [preflight] Commandfile search paths: /var/www/html/vendor/drush/drush/src,/var/www/html/drush
 [info] Starting bootstrap to none [0.68 sec, 2.93 MB]
 [info] Drush bootstrap phase 0 [0.68 sec, 2.93 MB]
 [info] Try to validate bootstrap phase 0 [0.68 sec, 2.93 MB]
 [info] Executing: ssh -o PasswordAuthentication=no victor@www.law.uga.edu '/var/www/html/vendor/bin/drush core:status --fields=db-name --format=json --uri=http://www.law.uga.edu' [0.69 sec, 3.13 MB]
 [info] Executing: /var/www/html/vendor/bin/drush core:status --fields=db-name --format=json --uri=default [1.9 sec, 3.13 MB]
 [info] Executing: ssh -o PasswordAuthentication=no victor@www.law.uga.edu '/var/www/html/vendor/bin/drush core:status --fields=db-name --format=json --uri=http://www.law.uga.edu' [2.55 sec, 3.13 MB]
You will destroy data in droopal and replace with data from www.law.uga.edu/droopal.

 Do you really want to continue? (yes/no) [yes]:
 > yes

 [notice] Starting to dump database on source. [5.55 sec, 3.14 MB]
 [info] Executing: ssh -o PasswordAuthentication=no victor@www.law.uga.edu '/var/www/html/vendor/bin/drush sql:dump --verbose --strict=0 --gzip --result-file=auto --format=json --uri=http://www.law.uga.edu' [5.55 sec, 3.14 MB]
 [notice] Starting to discover temporary files directory on target. [20.38 sec, 3.14 MB]
 [info] Executing: /var/www/html/vendor/bin/drush core:status --format=string --field=drush-temp --uri=default [20.38 sec, 3.14 MB]
 [notice] Copying dump file from source to target. [21.03 sec, 3.14 MB]
 [info] Executing: /var/www/html/vendor/bin/drush core:rsync @self.live:/home/victor/drush-backups/droopal/20240522195932/droopal_20240522_195933.sql.gz @self:/tmp/droopal_20240522_195933.sql.gz --yes --uri=default -- --remove-source-files [21.03 sec, 3.14 MB]

 // Copy new and override existing files at /tmp/droopal_20240522_195933.sql.gz.
 // The source is
 // victor@www.law.uga.edu:/home/victor/drush-backups/droopal/20240522195932/dro
 // opal_20240522_195933.sql.gz?: yes.

 [notice] Starting to import dump file onto target database. [24.56 sec, 3.14 MB]
 [info] Executing: /var/www/html/vendor/bin/drush sql:query --verbose --strict=0 --file=/tmp/droopal_20240522_195933.sql.gz --file-delete --uri=default [24.56 sec, 3.14 MB]

In SiteProcess.php line 214:

  [Symfony\Component\Process\Exception\ProcessFailedException]
  The command "/var/www/html/vendor/bin/drush sql:query --verbose --strict=0 --file=/tmp/droopal_20240522_195933.sql.gz --file-delete --uri=default" failed.

  Exit Code: 1(General error)

  Working directory:

  Output:
  ================


  Error Output:
  ================
   [info] Starting bootstrap to max
   [info] Drush bootstrap phase: bootstrapDrupalRoot()
   [info] Change working directory to /var/www/html/web
   [info] Initialized Drupal 10.2.6 root directory at /var/www/html/web
   [info] Drush bootstrap phase: bootstrapDrupalSite()
   [info] Initialized Drupal site default at sites/default
   [info] Drush bootstrap phase: bootstrapDrupalConfiguration()
   [info] Executing: command -v mysql
   [info] Executing: 'gzip' '-df' '/tmp/droopal_20240522_195933.sql.gz'
   [info] Executing: mysql --defaults-file=/tmp/drush_ACyefg --database=droopal --host=localhost --port=3306 --silent -A < /tmp/droopal_20240522_195933.sql

  In SqlCommands.php line 183:

    [Exception]
    Query failed. Rerun with --debug to see any error message. ERROR at line 1:
     Unknown command '\-'.


  Exception trace:
    at /var/www/html/vendor/drush/drush/src/Commands/sql/SqlCommands.php:183
   Drush\Commands\sql\SqlCommands->query() at n/a:n/a
   call_user_func_array() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:276
   Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
   Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:175
   Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:387
   Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/vendor/symfony/console/Command/Command.php:326
   Symfony\Component\Console\Command\Command->run() at /var/www/html/vendor/symfony/console/Application.php:1096
   Symfony\Component\Console\Application->doRunCommand() at /var/www/html/vendor/symfony/console/Application.php:324
   Symfony\Component\Console\Application->doRun() at /var/www/html/vendor/symfony/console/Application.php:175
   Symfony\Component\Console\Application->run() at /var/www/html/vendor/drush/drush/src/Runtime/Runtime.php:110
   Drush\Runtime\Runtime->doRun() at /var/www/html/vendor/drush/drush/src/Runtime/Runtime.php:40
   Drush\Runtime\Runtime->run() at /var/www/html/vendor/drush/drush/drush.php:139
   require() at /var/www/html/vendor/drush/drush/drush:4
   include() at /var/www/html/vendor/bin/drush:119


Exception trace:
  at /var/www/html/vendor/consolidation/site-process/src/SiteProcess.php:214
 Consolidation\SiteProcess\SiteProcess->mustRun() at /var/www/html/vendor/drush/drush/src/Commands/sql/SqlSyncCommands.php:223
 Drush\Commands\sql\SqlSyncCommands->import() at /var/www/html/vendor/drush/drush/src/Commands/sql/SqlSyncCommands.php:68
 Drush\Commands\sql\SqlSyncCommands->sqlsync() at n/a:n/a
 call_user_func_array() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:276
 Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
 Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/vendor/consolidation/annotated-command/src/CommandProcessor.php:175
 Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:387
 Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/vendor/symfony/console/Command/Command.php:326
 Symfony\Component\Console\Command\Command->run() at /var/www/html/vendor/symfony/console/Application.php:1096
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/vendor/symfony/console/Application.php:324
 Symfony\Component\Console\Application->doRun() at /var/www/html/vendor/symfony/console/Application.php:175
 Symfony\Component\Console\Application->run() at /var/www/html/vendor/drush/drush/src/Runtime/Runtime.php:110
 Drush\Runtime\Runtime->doRun() at /var/www/html/vendor/drush/drush/src/Runtime/Runtime.php:40
 Drush\Runtime\Runtime->run() at /var/www/html/vendor/drush/drush/drush.php:139
 require() at /var/www/html/vendor/drush/drush/drush:4
 include() at /var/www/html/vendor/bin/drush:119