HOWTO migrate stuff automatically from WebFaction!

Two files were created at same place config.ini is: "dbname.opalmigration.sql" and " and "dbname.opalmigration-local.passwd" Can I get rid of them? (I noticed my new password in there).

@sean I'm running into a similar issue as others in this thread - my db user owns multiple databases, and the second db migration removed the user. I thought the permissions might automatically resolve, but turns out my dbuser only has permissions on the latest migrated database. I can't figure how to grant the user privileges to the other databases again. Is there a way to do this, or what would the recommended solution be?
Thanks!
EDIT: I deleted the previously migrated databases, created new ones assigned to the same user and then did a manual export/import -- I'm wondering if there is any caveats to be aware of with this approach (coming from mysql)? Things look fine as far as I can tell, but curious if the wfmigrate script was doing any additional steps one should be aware of. Thanks!

Just signed up for Opal and am starting to use wfmigrate. A few bits of feedback:

EDIT: I've sorted these into 'high priority' and 'low priority'. Since wfmigrate only has a shelf life of 30 more days, there are some that need prioritising.

High Priority

1. It seems like the ssh password doesn't support certain characters (e.g. `) My original ssh_pass = v5`h1j1M`L didn't work.
2. wfmigrate didn't seem to migrate over my HTTPS site route, only the HTTP site route. It'd be nice if it could do this automatically. Or at the very least if I could define in the config.ini my Opal front end settings (e.g. Shared Certificate/LetsEncrypt, redirect HTTP to HTTPS etc.)
3. wfmigrate wordpress doesn't seem to work for cases where the Wordpress install isn't in the base directory (e.g. if wordpress is installed in a subdirectory as explained by wordpress here). It'd be nice if there was an option called wordpress_path that could be used to specify a subdirectory for the wordpress install, and so that the script knows where to find wp-config.php. (I assume my only option now is to use the php and maria migrations separately).

Low Priority

1. It'd be good if the tool supported SSH Keys for logging in to the WF servers (e.g. if ssh_pass = is left intentionally blank, then the tool would try logging in with SSH). Saves having to write SSH passes in the config, and makes it easier to maintain multiple configs.
2. I just set up wfmigrate for a simple php app (wfmigrate php) from WF. Running --mode simulate gave just: Simulation Started / Simulation Complete messages. But when I ran with --mode do I got a lot more debug messages. Looks like the simulate didn't work properly? I can confirm that the migrate did work when using --mode do though. EDIT: Looks like --mode simulate runs with loglevel INFO but --mode do runs with DEBUG, hence the confusion.
3. It'd be nice if the type of transfer (wordpress, php, maria, psql) could be defined in the ini file as opposed to having to define it on the command line. E.g. at the start of each ini file you insert a block [php] or [wordpress] or [maria] or [psql]. Couple of benefits: a) it helps with documentation: each config file is self explanatory about what type of transfer is. b) could help with automating wfmigrate. No need for wfmigrate php config.ini, just find . -name *.ini -exec wfmigrate {} \;
4. The ability to define multiple apps in one config would be nice. E.g.

   [app]
   appname = foo
   
   [app]
   appname = bar

   5. Any way to define the Webfaction/Opalstack login details just once? I'm migrating 10-20 apps over. It's a bit painful having to copy/paste the login details over to each ini file. Not very DRY. Having a separate accounts.ini file where I can define accounts just once would be really useful. Something like wfmigrate php CONFIG.ini --accounts accounts.ini where the --accounts flag would overwrite any info already found in the CONFIG.ini file
   I'm still playing with wfmigrate, so I'll report back on more issues soon. Keep up the good work, We have just 30 days to migrate from WF now. Thanks to all you're doing!

My last two WordPress migrations ended like this:

2020-11-08 16:48:08 : INFO : Checking .htaccess for incompatible directives
Traceback (most recent call last):
  File "/usr/local/bin/wfmigrate", line 67, in <module>
    migrator.run()
  File "/opt/app_migrators-1.3.2/wf_wordpress/migrator.py", line 184, in run
    self.migrate()
  File "/opt/app_migrators-1.3.2/wf_wordpress/migrator.py", line 166, in migrate
    self.wf_migrator_php.check_htaccess()
  File "/opt/app_migrators-1.3.2/lib/wf_migrator_php.py", line 136, in check_htaccess
    for line in fp:
  File "/usr/lib64/python3.6/encodings/ascii.py", line 26, in decode
    return codecs.ascii_decode(input, self.errors)[0]
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 87: ordinal not in range(128)

Please advise.

OMG! That was amazing. I was able to migrate some of my simpler apps in no time flat.

Now, of course, I have some weird stuff with Laravel which I had to install separately and then use a symbolic link to point to the public directory. I don't get the impression that will be a simple thing to migrate. So I'm guessing I'll need to manually do those sites after installing Laravel, Composer, etc?

Also, I have private MySQL instances. Can those be migrated using the tool? I'm guessing no because it doesn't follow the standard patterns (as in there are no databases or database users in the Webfaction control panel).