[RSS Feed/News] 3GB DB mysqldump import failure, MySQL -> MariaDB

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
I am attempting to migrate to a new hosting provider, thus mysqldump on the source for DB backup and mysql import on the target.

On disk, my MySQL 5.7 source DB is 5.0GB and the mysqldump file is 3GB, thus importing the 3GB .sql into the target server with MariaDB 10.6

mysqldump with --hex-blob --opt --default-character-set=utf8mb4 --single-transaction [database] > ~/[database].sql whilst the XF site is closed.

On the target server, import with mysql --default-character-set=utf8mb4 --quick...

Read more

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom