Hi Elliot, You should try editing your backup file to only importing wp_options data and check the status of the requests, when an insert execute there is a return string which indicate how many records where created and how many errors/warnings there where.
Then check the result of "SHOW WARNINGS" and "|SHOW INNODB STATUS"| | | |Also the "--opt" should be the default in mysqldump but you could verify that your sql dump file does have charset setup and everything | Regards, On 19/08/2020 06:44, Elliot Holden wrote: > > 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 >> [email protected] >> https://www.ElliotMyWebGuy.com > -- > Elliot Holden > (404)884-8593 > [email protected] > https://www.ElliotMyWebGuy.com > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
