Sending this again because I got no response the first time and didn't know if it was because I did something wrong protocol wise or if it was just because no one had any idea on what my issue could be. If anyone has a link they can point me to in either case it would be greatly appreciated. I will keep searching as well. Thanks E. On 8/11/20 11:25 PM, Elliot Holden wrote:
Hello All,
New to the list, so maybe an expert has the easy answer to this one...
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).
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 know I'm probably missing something simple but just don't know... they both seem to use the same InnoDB engine. I did notice the Db character set is different between the databases though (highlighted in blue below).
Maybe do I need to upgrade to MariaDB *10.4.14*
Any help would be greatly appreciated.....?
Details about each server listed below:
_* *_
_*MySQL*_
Server version: 5.7.28-log Source distribution Protocol version: 10 Server characterset: latin1 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8
*************************** 1. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES
_* *__*MariaDB*_
Server version: 5.5.5-10.4.8-MariaDB MariaDB Server Protocol version: 10 Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8
*************************** 7. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, foreign keys and encryption for tables Transactions: YES XA: YES Savepoints: YES
-- Elliot Holden (404)884-8593 elliot@elliotmywebguy.com https://www.ElliotMyWebGuy.com
-- Elliot Holden (404)884-8593 elliot@elliotmywebguy.com https://www.ElliotMyWebGuy.com