> 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'. Does wp_backup.sql actually have *all* 600? _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
