← Back to team overview

maria-discuss team mailing list archive

Re: Missing table rows when importing a MySQL 5.7.8 database into MariaDB 10.4.8 database


>     When I use mysqldump to backup a MySQL 5.7.8 database then import that database into a MariaDB
>     10.4.8 database, at least one (maybe more) of the imported tables is missing rows. This is a
>     WordPress database and the table in question is the wp_options table. I'm only getting 29 rows
>     imported when there should be over 600 (in the original MySQL database).

Noted, 29 not 600.

>     I'm using the mysqldump and mysql utilities located on the MariaDB server:
>     mysqldump  Ver 10.17 Distrib 10.4.8-MariaDB, for Linux (x86_64)
>     mysql  Ver 15.1 Distrib 10.4.8-MariaDB, for Linux (x86_64) using readline 5.1
>     My steps as performed on the MariaDB server (the server I'm importing to).
>     1. mysqldump -u username -pPassword -h remote_mysql_server database_name > wp_backup.sql
>     2. mysql -u username -pPassword -h localhost database_name < wp_backup.sql
>     When I run mysql (on the local MariaDB server) and import the wp_backup.sql to the
>     remote_mysql_server everything works fine and all rows are importing into a test database out
>     there:
>     mysql -u username -pPassword -h remote_mysql_server database_name < wp_backup.sql
>     So the above works

I am guessing it's 29 in 'all' of 'all rows are imported'.
actually have *all*  600?

Follow ups