I am moving over my production DB to a test server and this is holding up my progress to get cut over.
Mysqldump of a mysql db isn't complete. When I import to a Maria DB many of the tables aren't populated like they are in the source. One obvious table is the products table. After the import it shows 0 products. In the source there are over a 1,000 products.
This is the command I am using mysqldump -u root -p --opt [source db] > [dumpname.sql]
I am on a Centos 7 target system and a Centos 6 source system.
Please tell me a way to get my complete MySQL DB imported into a Maria DB.