SQLSTATE[HY000] [2006] MySQL server has gone away

turtlekey

From a newbie

I want to migrate my flarum to another server, after finishing all the configures, the error occurs as following:

Flarum encountered a boot error (Doctrine\DBAL\Driver\PDOException)*
SQLSTATE[HY000] [2006] MySQL server has gone away*
thrown in /data/wwwroot/103.45.119.113/forum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php on line 31

what I have done are listed below:

copy the flarum/ to /data/wwwroot/mywebsite/ on my new server;
copy the database(only one, my case is mariadb/seducation/) of flarum to mariadb/ on my new server;
accomplish all the configures(including vhost/*.conf, flarum/config.php);
I have also reloaded nginx and mysql.

So what's the problem? And what should I do?
Another question is how can I migrate my flarum to another server efficiently?
Waiting for reply, thanks.

clarkwinkelmann

turtlekey what hostname did you use for the database? If you're using localhost, you might want to try switching to 127.0.0.1.

Are you able to access the database via other tools like phpMyAdmin? Do you have other apps running on that new server that also access the database? Can you share info about the kind of hosting you are using and the MariaDB version?

turtlekey

clarkwinkelmann
Thanks for your reply! According to your advice:

my hostname for the database is the public IP of my server, when I change it to 127.0.0.1, the error occurs:

Flarum encountered a boot error (Illuminate\Database\QueryException)
SQLSTATE[42S02]: Base table or view not found: 1932 Table 'seducation.settings' doesn't exist in engine (SQL: select `value`, `key` from `settings`)
thrown in /data/wwwroot/103.45.119.113/forum/vendor/illuminate/database/Connection.php on line 664

when I try to access the database via phpMyAdmin, the same error occurs;
no other app accesses the database;
I use vps to host flarum, and the MariaDB version is 10.4.12-MariaDB-log MariaDB Server.

waiting for your help.

xkeyC

turtlekey
It looks like you successfully connected to the database, but some basis data seems to be incomplete.

My suggestion is to reinitialize the database, you should be able to find some information through search engines.

turtlekey

xkeyC
Thanks for your reply!
I just copy the database(only one, my case is mariadb/seducation/) of flarum to mariadb/ on my new server, is it right?

xkeyC

turtlekey
No, the database also needs other base and tables to run. You should initialize the database before copying, or copy the entire data.

xkeyC

turtlekey
In addition, please stop the database when operating the database file and restart it after the operation is complete.
This prevents data corruption.

The best practice for migrating databases should not be to copy files, but to export as .sql files,import afterwards.

turtlekey

xkeyC
Thanks a lot!