I have a 1.3GB size of large size sql dump.

my main database has 148 tables.

I have already tried to split my sql dump.

 split -b 100M largefile.sql part_  

i got 13 splitted files.

i tried to add splitted code to database using below code

mysql -u root pos64app < mysql-posapp-part-aa
mysql -u root pos64app < mysql-posapp-part-ab
mysql -u root pos64app < mysql-posapp-part-ac
mysql -u root pos64app < mysql-posapp-part-ad
mysql -u root pos64app < mysql-posapp-part-ae
mysql -u root pos64app < mysql-posapp-part-af
mysql -u root pos64app < mysql-posapp-part-ag
mysql -u root pos64app < mysql-posapp-part-ah
mysql -u root pos64app < mysql-posapp-part-ai
mysql -u root pos64app < mysql-posapp-part-aj
mysql -u root pos64app < mysql-posapp-part-ak
mysql -u root pos64app < mysql-posapp-part-al
mysql -u root pos64app < mysql-posapp-part-am
mysql -u root pos64app < mysql-posapp-part-an

And I got this error:

ERROR 1064 (42000) at line 3763: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''2024-11-21 08:57:26' at line 1
ERROR 2006 (HY000) at line 1: MySQL server has gone away

but when i check database it has 120 tables and table size is 650mb but main db size is 1298mb