SQL backups not recognized inside docroot

[uberhacker]

Bug Report

v3.0.0-beta.11 on LMDE - (basically Debian 8.9 in disguise)

$ lando version
v3.0.0-beta.11
$ lsb_release -a
No LSB modules are available.
Distributor ID:	LinuxMint
Description:	LMDE 2 Betsy
Release:	2
Codename:	betsy
$ cat /etc/debian_version 
8.9

name: mwoy

# start with drupal8 recipe
recipe: drupal8
config:
    drush: 8.1.13
    php: 7.1 # or other as appropriate
    # modify webroot sub dir as needed
    webroot: docroot
    database: mysql:5.6

# add additional auxiliary services
services:
  cache:
    type: memcached:1.4
  solr:
    type: solr:5.5
    config:
      conf: docroot/modules/contrib/search_api_solr/solr-conf/5.x

# add development environment settings
parameters:
  twig.config:
    debug: true
    auto_reload: true

$ pwd
/var/www/mwoy/docroot
$ lando db-import backup-2017-09-01-17-05-mwoy-117119263.sql 
File /app/backup-2017-09-01-17-05-mwoy-117119263.sql not found!
$ cd ..
$ lando db-import docroot/backup-2017-09-01-17-05-mwoy-117119263.sql 
Preparing to import /app/docroot/backup-2017-09-01-17-05-mwoy-117119263.sql into drupal8 on database:3306 as drupal8...
Importing /app/docroot/backup-2017-09-01-17-05-mwoy-117119263.sql...
10.8MiB 0:00:30 [ 362KiB/s] [================================>] 100%            
Import completed with status code 0

[pirog]

@uberhacker can def replicate this.

Easy to fix and will add some documentation around it to satisfy #316 as well.

thanks for the great bug report!

[slefevre]

I've just discovered that my version of lando can't find files to import outside of the current directory, not just subfolders. I was trying to reference a file in my home dir:

username@jakku-deb9-vm:~/lando/website$ lando db-import ~/website_live_2020-04-21T02-00-00_UTC_database.sql.gz
File /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz not found!

Notice that it was able to expand ~ to /home/username/, so it doesn't seem to be a problem with that expression. Trying the full path to my home directory didn't work either:

username@jakku-deb9-vm:~/lando/website$ lando db-import /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz
File /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz not found!

OS and lando versions:

username@jakku-deb9-vm:~/lando/website$ lando version
v3.0.0-rrc.4

username@jakku-deb9-vm:~/lando/website$ cat /etc/os-release
PRETTY_NAME="Debian GNU/Linux 9 (stretch)"

Copying the file into the lando root did work:

username@jakku-deb9-vm:~/lando/website$ cp website_live_2020-04-21T02-00-00_UTC_database.sql.gz . 
 
username@jakku-deb9-vm:~/lando/website$ lando db-import website_live_2020-04-21T02-00-00_UTC_database.sql.gz
Preparing to import /app/website_live_2020-04-21T02-00-00_UTC_database.sql.gz into database 'pantheon' on service 'database' as user root...
Destroying all current tables in pantheon...
NOTE: See the --no-wipe flag to avoid this step!
Gzipped file detected!
Importing /app/website_live_2020-04-21T02-00-00_UTC_database.sql.gz...

[pirog]

Look at the docs on the DB import command. The path you specify is the path in the container not on your host machine

…

On Thu, Apr 23, 2020 at 4:31 PM slefevre ***@***.***> wrote: I've just discovered that my version of lando can't find files to import outside of the current directory, not just subfolders. I was trying to reference a file in my home dir: ***@***.***:~/lando/website$ lando db-import ~/website_live_2020-04-21T02-00-00_UTC_database.sql.gz File /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz not found! Notice that it was able to expand ~ to /home/username/, so it doesn't seem to be a problem with that expression. Trying the full path to my home directory didn't work either: ***@***.***:~/lando/website$ lando db-import /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz File /home/username/website_live_2020-04-21T02-00-00_UTC_database.sql.gz not found! OS and lando versions: ***@***.***:~/lando/website$ lando version v3.0.0-rrc.4 ***@***.***:~/lando/website$ cat /etc/os-release PRETTY_NAME="Debian GNU/Linux 9 (stretch)" Copying the file into the lando root did work: ***@***.***:~/lando/website$ cp website_live_2020-04-21T02-00-00_UTC_database.sql.gz . ***@***.***:~/lando/website$ lando db-import website_live_2020-04-21T02-00-00_UTC_database.sql.gz Preparing to import /app/website_live_2020-04-21T02-00-00_UTC_database.sql.gz into database 'pantheon' on service 'database' as user root... Destroying all current tables in pantheon... NOTE: See the --no-wipe flag to avoid this step! Gzipped file detected! Importing /app/website_live_2020-04-21T02-00-00_UTC_database.sql.gz... — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#314 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAFOFUEAEXXC56DMBDSWU7LROCQQ3ANCNFSM4DZKQITQ> .