XF 2.2 Issue with Importing xf_profile_post_comment Table in XenForo 2.2

[lucien_lies]

I'm encountering an issue while importing a database from one XenForo 2.2 forum to another. All tables have been imported successfully except for xf_profile_post_comment, which is not being imported at all.

I've checked database permissions and connectivity, and all seems in order. There are no specific error messages during the import process to guide me towards a solution.

Thanks in advance for your assistance.

 

[MentaL]

anything in your local mysql log?

 

[lucien_lies]

now I did it through the terminal and managed to import something, look at the original as it looks:



and how it is seen when the import is finished:







log:

 

[lucien_lies]

anything in your local mysql log?

2023-11-21T00:04:38.607039Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T00:04:38.607787Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T00:04:38.607820Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 20348
2023-11-21T00:04:38.675182Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T00:04:40.322189Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T00:04:41.315818Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T00:04:41.319292Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T00:04:41.419270Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T00:04:41.772239Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T00:04:41.772683Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T00:04:41.806419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T00:04:41.806489Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T00:05:35.515196Z 23 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T00:05:35.515832Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T00:05:36.587183Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T00:07:16.696004Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T00:07:16.696051Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T00:07:16.696074Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 2512
2023-11-21T00:07:16.728798Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T00:07:17.029996Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T00:07:17.592706Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T00:07:17.598263Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T00:07:17.598807Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T00:07:17.634414Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T00:07:17.634543Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T04:07:21.186248Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T04:07:21.186323Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T04:07:21.186372Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 5992
2023-11-21T04:07:21.251225Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T04:07:23.764069Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T04:07:24.505221Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T04:07:24.509407Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T04:07:24.617711Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T04:07:24.659901Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T04:07:24.660735Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T04:07:24.706271Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T04:07:24.706499Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T19:14:31.007282Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T19:14:31.007329Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T19:14:31.007353Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 18916
2023-11-21T19:14:31.050597Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T19:14:34.301486Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T19:14:35.796358Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T19:14:35.801418Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T19:14:35.925726Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T19:14:36.110488Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T19:14:36.110961Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T19:14:36.155983Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T19:14:36.156101Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T20:02:02.460728Z 398 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T20:02:02.461681Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T20:02:03.221006Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T20:02:16.204511Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T20:02:16.204567Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T20:02:16.204594Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 9368
2023-11-21T20:02:16.239023Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T20:02:17.551412Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T20:02:18.448502Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T20:02:22.192737Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T20:02:22.193183Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T20:02:22.222399Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T20:02:22.222513Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T20:18:11.870266Z 316 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T20:18:11.870985Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T20:18:18.832332Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T20:18:33.522788Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T20:18:33.522860Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T20:18:33.522899Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 15352
2023-11-21T20:18:33.558458Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T20:18:33.986435Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T20:18:34.751982Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T20:18:36.288209Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T20:18:36.288655Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T20:18:36.317584Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T20:18:36.317679Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.

 

[MentaL]

2023-11-21T00:04:38.607039Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T00:04:38.607787Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T00:04:38.607820Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 20348
2023-11-21T00:04:38.675182Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T00:04:40.322189Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T00:04:41.315818Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T00:04:41.319292Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T00:04:41.419270Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T00:04:41.772239Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T00:04:41.772683Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T00:04:41.806419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T00:04:41.806489Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T00:05:35.515196Z 23 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T00:05:35.515832Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T00:05:36.587183Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T00:07:16.696004Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T00:07:16.696051Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T00:07:16.696074Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 2512
2023-11-21T00:07:16.728798Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T00:07:17.029996Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T00:07:17.592706Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T00:07:17.598263Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T00:07:17.598807Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T00:07:17.634414Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T00:07:17.634543Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T04:07:21.186248Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T04:07:21.186323Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T04:07:21.186372Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 5992
2023-11-21T04:07:21.251225Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T04:07:23.764069Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T04:07:24.505221Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T04:07:24.509407Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T04:07:24.617711Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T04:07:24.659901Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T04:07:24.660735Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T04:07:24.706271Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T04:07:24.706499Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T19:14:31.007282Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T19:14:31.007329Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T19:14:31.007353Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 18916
2023-11-21T19:14:31.050597Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T19:14:34.301486Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T19:14:35.796358Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-11-21T19:14:35.801418Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-11-21T19:14:35.925726Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T19:14:36.110488Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T19:14:36.110961Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T19:14:36.155983Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T19:14:36.156101Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T20:02:02.460728Z 398 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T20:02:02.461681Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T20:02:03.221006Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T20:02:16.204511Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T20:02:16.204567Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T20:02:16.204594Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 9368
2023-11-21T20:02:16.239023Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T20:02:17.551412Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T20:02:18.448502Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T20:02:22.192737Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T20:02:22.193183Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T20:02:22.222399Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T20:02:22.222513Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.
2023-11-21T20:18:11.870266Z 316 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.30).
2023-11-21T20:18:11.870985Z 0 [System] [MY-013105] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Normal shutdown.
2023-11-21T20:18:18.832332Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
2023-11-21T20:18:33.522788Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-11-21T20:18:33.522860Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-11-21T20:18:33.522899Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld (mysqld 8.0.30) starting as process 15352
2023-11-21T20:18:33.558458Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-21T20:18:33.986435Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-11-21T20:18:34.751982Z 0 [Warning] [MY-013829] [Server] Missing data directory for ICU regular expressions: C:\laragon\bin\mysql\mysql-8.0.30-winx64\lib\private\.
2023-11-21T20:18:36.288209Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-11-21T20:18:36.288655Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-11-21T20:18:36.317584Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060
2023-11-21T20:18:36.317679Z 0 [System] [MY-010931] [Server] C:\laragon\bin\mysql\mysql-8.0.30-winx64\bin\mysqld: ready for connections. Version: '8.0.30'  socket: ''  port: 3306  MySQL Community Server - GPL.

nothing showing there. i recall having issues importing due to text lengths on a message field for my xf_posts, so I switched it from medium to long. Although, this is a random thought.



once i tried to import again, it worked.



It may not work for you.

 

[Chris D]

To be clear, there isn't a separate profile post comments step, as it is handled inside the profile post step, and the number of records imported is supposed to match only the number of profile post rows.

The comment importing relies on latest_comment_ids being populated in the profile posts table. If this is not populated for any reason, you should run a profile posts rebuild on the source XenForo before importing.