How to Move Database to Docker?

BrodyStone21 · Aug 20, 2024

I've been having a lot of issues with NameCheap hosting, so I decided I'm just going to do selfhost and run everything in Docker (what I'm used to). I need to migrate from an actual server to Docker.

How do I transfer the database from my hosting provider to Docker? I've already downloaded the database file.

BrodyStone21 · Aug 20, 2024

I was able to get the database moved and connected, however, I'm getting an error that says:

PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table flarum.flarum_settings doesn't exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection:php:82

I'm using: crazy-max/docker-flarum

Full Error:

Fixing perms...
[cont-init.d] 02-fix-perms.sh: exited 0.
[cont-init.d] 03-config.sh: executing...
Setting timezone to America/Indianapolis...
Setting PHP-FPM configuration...
Setting PHP INI configuration...
Setting OpCache configuration...
Setting Nginx configuration...
Initializing files and folders...
cp: can't create '/data/assets': File exists
cp: can't create '/data/storage': File exists
Permissions already fixed in /data/assets
Permissions already fixed in /data/extensions
Permissions already fixed in /data/storage
Permissions already fixed in /opt/flarum/vendor
Checking parameters...
Checking database connection...
Waiting 60s for database to be ready...
Database ready!
Creating Flarum config file...
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82): PDO->prepare()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist (SQL: select `value`, `key` from `flarum_settings`) in /opt/flarum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#2 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#3 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#7 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#8 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#10 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#11 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#12 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#15 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#16 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#17 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#18 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#20 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#21 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#22 {main}
  thrown in /opt/flarum/vendor/illuminate/database/Connection.php on line 712
PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82): PDO->prepare()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist in /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /opt/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(368): Doctrine\DBAL\Driver\PDOConnection->prepare()
#2 /opt/flarum/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#6 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#7 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#10 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#11 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#12 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#15 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#16 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#17 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#18 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#20 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#21 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#22 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#23 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#24 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#25 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flarum_settings' doesn't exist (SQL: select `value`, `key` from `flarum_settings`) in /opt/flarum/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /opt/flarum/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/flarum/vendor/illuminate/database/Connection.php(359): Illuminate\Database\Connection->run()
#2 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2413): Illuminate\Database\Connection->select()
#3 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2626): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /opt/flarum/vendor/illuminate/database/Query/Builder.php(2622): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/flarum/vendor/flarum/core/src/Settings/DatabaseSettingsRepository.php(25): Illuminate\Database\Query\Builder->pluck()
#7 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(30): Flarum\Settings\DatabaseSettingsRepository->all()
#8 /opt/flarum/vendor/flarum/core/src/Settings/MemoryCacheSettingsRepository.php(42): Flarum\Settings\MemoryCacheSettingsRepository->all()
#9 /opt/flarum/vendor/flarum/core/src/Settings/DefaultSettingsRepository.php(30): Flarum\Settings\MemoryCacheSettingsRepository->get()
#10 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(401): Flarum\Settings\DefaultSettingsRepository->get()
#11 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(140): Flarum\Extension\ExtensionManager->getEnabled()
#12 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(371): Flarum\Extension\ExtensionManager->getExtensions()
#13 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionManager.php(389): Flarum\Extension\ExtensionManager->getEnabledExtensions()
#14 /opt/flarum/vendor/flarum/core/src/Extension/ExtensionServiceProvider.php(31): Flarum\Extension\ExtensionManager->extend()
#15 [internal function]: Flarum\Extension\ExtensionServiceProvider->Flarum\Extension\{closure}()
#16 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(329): call_user_func()
#17 /opt/flarum/vendor/flarum/core/src/Foundation/Application.php(270): Flarum\Foundation\Application->fireAppCallbacks()
#18 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(151): Flarum\Foundation\Application->boot()
#19 /opt/flarum/vendor/flarum/core/src/Foundation/InstalledSite.php(82): Flarum\Foundation\InstalledSite->bootLaravel()
#20 /opt/flarum/vendor/flarum/core/src/Console/Server.php(32): Flarum\Foundation\InstalledSite->bootApp()
#21 /opt/flarum/flarum(24): Flarum\Console\Server->listen()
#22 {main}
  thrown in /opt/flarum/vendor/illuminate/database/Connection.php on line 712
[cont-init.d] 03-config.sh: exited 255.
[cont-finish.d] executing container finish scripts...
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.
[s6-finish] sending all processes the KILL signal and exiting.

clarkwinkelmann · Aug 20, 2024

BrodyStone21 do your tables use a prefix? Can you use an SQL visual tool or command line to check if the table mentioned in the error message exists in the database?

I'm not familiar with Docker or that script. I would be cautious using something I don't understand well. Make sure you know how to backup and restore your forum if anything ever goes wrong. You could also create a backup and check the table names in the database dump that way instead of connecting to the database.