Cannot pull from Flywheel, error: The user specified as a definer ('fw7371338486'@'%') does not exist

Support
1

Bug Summary

When pulling a fresh website from Flywheel, Local displays an error “Uh-oh! We ran into an issue pulling from Flywheel” and I get the following error in log:

The user specified as a definer (‘fw7371338486’@‘%’) does not exist

See full log below for details.

Steps to reproduce

The issue seems to occur when MySQL views are used:

  1. Create a MySQL database view inside your theme functions.php or a plugin activation file
  2. Pull the website to local once the view is created

Environment Info

Macbook Pro M1
Sonoma 14.4.1
Local version: Version 9.1.1+6738
Website config: PHP 8.2.23, MySQL 8.0.16, Web server: nginx

Supporting info

Please provide your Local Log. See this Community Forum post for instructions on how to do so:

{"class":"Process","level":"warn","message":"2025-01-16T09:28:22.971299Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 6964","process":"mysql","thread":"main","timestamp":"2025-01-16T09:28:23.191Z"}
{"class":"Process","level":"warn","message":"2025-01-16T09:28:22.973479Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2025-01-16T09:28:23.191Z"}
{"class":"Process","level":"warn","message":"2025-01-16T09:28:22.974064Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2025-01-16T09:28:23.191Z"}
{"class":"Process","level":"warn","message":"2025-01-16T09:28:23.181416Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-01-16T09:28:23.191Z"}
{"class":"Process","level":"warn","message":"2025-01-16T09:28:23.190903Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld: ready for connections. Version: '8.0.16'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10014  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-01-16T09:28:23.191Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.130Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.130Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.130Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.131Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.131Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-16T09:28:24.131Z"}
{"class":"ImporterConnectV2","level":"error","message":"Unable to import /Users/petervukovic/Local Sites/weeno/app/public/.connect-pull.sql","stack":"Error: ERROR 1449 (HY000) at line 121785: The user specified as a definer ('fw7371338486'@'%') does not exist\n    at %%appPath%%/main/_helpers/importSQLFile.js:1:2667\n    at Generator.next (<anonymous>)\n    at a (%%appPath%%/main/_helpers/importSQLFile.js:1:849)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","thread":"main","timestamp":"2025-01-16T09:28:33.206Z"}
{"class":"FlywheelPullService","level":"error","message":"Error: Local was unable to import the following SQL files: \n\n• /app/public/.connect-pull.sql\n    at ImporterConnectV2.<anonymous> (%%appPath%%/main/importer/Importer.js:1:9910)\n    at Generator.throw (<anonymous>)\n    at o (%%appPath%%/main/importer/Importer.js:1:900)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","thread":"main","timestamp":"2025-01-16T09:28:33.211Z"}
2

Hi @peter_vukovic

If you download a backup and direct import it instead does that work?

4

Hi Nick,

downloading and importing a backup end with an error message:

image
image662×768 52.6 KB

Below is a full log showing the same error occurs.

However, I can open the site and work with it, just need to rebuild the MySQL views.

Manual import log:


{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.763022Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.768Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.763033Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.35+0/bin/darwin/bin/mysqld (mysqld 8.0.35) starting as process 8146","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.769Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.764030Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.769Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.764588Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.769Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.770093Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.770Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.771454Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.771Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:32.906225Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:32.906Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:33.171998Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:33.172Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:33.172038Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:33.172Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:33.217355Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.35+0/bin/darwin/bin/mysqld: ready for connections. Version: '8.0.35'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10004  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:33.217Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:33.587392Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:33.587Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:34.278469Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:34.278Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-17T08:05:34.280Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-17T08:05:34.280Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-17T08:05:34.281Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-17T08:05:34.281Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:34.312032Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:34.312Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:34.312976Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:34.314Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:34.331223Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:34.331Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.855504Z 12 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.856Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.874076Z 13 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.874Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.890669Z 14 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.891Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.907049Z 15 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.907Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.922016Z 16 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.922Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.937961Z 17 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.938Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.960241Z 18 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.960Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.961849Z 18 [System] [MY-010916] [Server] @@GLOBAL.GTID_PURGED was changed from '' to ''.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.962Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:46.961863Z 18 [System] [MY-010917] [Server] @@GLOBAL.GTID_EXECUTED was changed from '' to ''.","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:46.962Z"}
{"class":"Process","level":"warn","message":"2025-01-17T08:05:53.583418Z 19 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T08:05:53.583Z"}
{"class":"ImporterGeneric","level":"error","message":"Unable to import /Users/petervukovic/Local Sites/weeno/app/sql/backup.sql","stack":"Error: ERROR 1449 (HY000) at line 3853: The user specified as a definer ('fw7371338486'@'%') does not exist\n    at %%appPath%%/main/_helpers/importSQLFile.js:112:19\n    at Generator.next (<anonymous>)\n    at fulfilled (%%appPath%%/main/_helpers/importSQLFile.js:28:58)","thread":"main","timestamp":"2025-01-17T08:06:07.840Z"}
5

I looked in your site files and I see an extra DB backup in your root, backup_19-12-2024.sql. Could you try unzipping your downloaded backup, removing that, zipping it back up and then importing again? It’s possible it’s confusing the import/sync process.

6

I removed that file and created a new backup on Flywheel:

image
image2604×442 33.5 KB

Now it fails completely and the site is never created in WP Local.

The final error message I get is in the bottom right corner, says “Please select a compatible ZIP file”

Strangely, when I unzip the backup file, it only contains wp-content directory and backup.sql, not sure if this is normal?

image
image622×484 41.5 KB

Log:


{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.422052Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.423Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.422056Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.35+0/bin/darwin-arm64/bin/mysqld (mysqld 8.0.35) starting as process 29202","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.424Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.422609Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.424Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.422950Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.424Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.424348Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.424Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.425229Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.425Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.455921Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.456Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.584855Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.585Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.584916Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.585Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:54.594295Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.35+0/bin/darwin-arm64/bin/mysqld: ready for connections. Version: '8.0.35'  socket: '%%site.runData%%/mysql/mysqld.sock'  port: 10014  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:54.594Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:55.323107Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:55.323Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.601Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.602Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.602Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.602Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:1","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.602Z"}
{"class":"Process","level":"warn","message":"nginx: [warn] the \"listen ... http2\" directive is deprecated, use the \"http2\" directive instead in %%router.runPath%%/nginx/conf/server-block-ssl.conf:2","process":"nginx","thread":"main","timestamp":"2025-01-17T17:16:55.602Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:55.604523Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:55.604Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:55.615549Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:55.615Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:55.616114Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:55.616Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:16:55.624664Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:16:55.624Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.337512Z 12 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.337Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.345591Z 13 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.345Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.353140Z 14 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.353Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.361410Z 15 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.361Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.368505Z 16 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.368Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.375918Z 17 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.376Z"}
{"class":"Process","level":"warn","message":"2025-01-17T17:17:06.386565Z 18 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'","process":"mysql","thread":"main","timestamp":"2025-01-17T17:17:06.386Z"}
{"class":"ImporterGeneric","level":"error","message":"Unable to import /Users/petervukovic/Local Sites/weeno/app/sql/backup.sql","stack":"Error: ERROR 1449 (HY000) at line 3854: The user specified as a definer ('fw7371338486'@'%') does not exist\n    at %%appPath%%/main/_helpers/importSQLFile.js:112:19\n    at Generator.next (<anonymous>)\n    at fulfilled (%%appPath%%/main/_helpers/importSQLFile.js:28:58)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","thread":"main","timestamp":"2025-01-17T17:17:12.707Z"}
{"level":"warn","message":"Unable to import site.","stack":"Error: Local was unable to import the following SQL files: \n\n• /app/sql/backup.sql\n    at ImporterGeneric.<anonymous> (%%appPath%%/main/importer/Importer.js:348:23)\n    at Generator.throw (<anonymous>)\n    at rejected (%%appPath%%/main/importer/Importer.js:29:65)\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","timestamp":"2025-01-17T17:17:12.712Z"}
7

There sure seems to be something it’s not liking in the configuration of the site. Are you able to manually import that last backup with the steps here?

Manually Import a Local Site

8

That’s what I tried above - I downloaded the backup from Flywheel and attempted a manual import in Local.

9

Sorry just noticed your link - no I did not attempt a manual import with the steps provided, I tried creating the site from the ZIP file via Local UI. I will try the manual import steps and let you know.

10

Ok I tried the manual import steps. It fails on the db import step with the same error related to SQL definer:

Last login: Fri Jan 17 18:14:38 on ttys008
/Users/petervukovic/Library/Application\ Support/Local/ssh-entry/Hh9ULL5k4.sh
➜  ~ /Users/petervukovic/Library/Application\ Support/Local/ssh-entry/Hh9ULL5k4.sh
-n -e 
Setting Local environment variables...
----
WP-CLI:   WP-CLI 2.11.0
Composer: 2.6.2 2023-09-03
PHP:      8.2.23
MySQL:    mysql  Ver 8.0.35 for macos13 on arm64 (MySQL Community Server - GPL)
----
Launching shell: /bin/zsh ...
➜  public wp db import backup.sql 
ERROR 1449 (HY000) at line 3854 in file: 'backup.sql': The user specified as a definer ('fw7371338486'@'%') does not exist

I can fix this with MySQL CLI by creating the missing user and running the import again:

CREATE USER 'fw7371338486'@'%' IDENTIFIED BY 'password_placeholder';
GRANT ALL ON *.* TO 'fw7371338486'@'%';
FLUSH PRIVILEGES;

But obviously this is quite tedious.

11

Thank you for troubleshooting and sharing these details @peter_vukovic!

It’s been a while since I’ve seen this error but doing some digging it seems that generally when these show up (specifically with the The user specified as a definer does not exist part), it usually means that a specific user who created special “things” in the DB (views, triggers, procedures) isn’t present in the new DB environment. This Stack Overflow answer does give a general idea of the problem and solving it manually: permissions - MySQL error 1449: The user specified as a definer does not exist - Stack Overflow

In the case of a WordPress site, this usually means that one of the plugins installed created a custom view or trigger. Because that view/trigger was created by the user on the remote environment, it’s likely different than the Local site environment. We’ve seen several different plugins do this in the past, and unfortunately, in some cases, it’s ones that aren’t even installed on a site any longer but left behind some junk in the database.