mySQL import text file too big 3061

This problem appears to be more complex.

The export I do of the database is in a cron I wrote, which includes this line:

This creates a file about 60MB in size.

However, I just did an export in phpMyAdmin of that database, and it created a 250MB file!

I scanned through the 60MB file, and while I have no way of knowing about the individual items, I do find commands to dump and create all the tables the database contains, followed by the commands to insert each record for the table.

Yet when I try to import that file, I only get a few of the tables created.

When I tried importing the 250MB file phpMyAdmin created, it successfully created all the tables, and as far as I can tell, all the records. So, it's evidently not a size issue at all.

I looked back at the automated export which I have set up to create a database export every 30 minutes, and looking at the file sizes, they're all 60MB, growing gradually smaller as you go back in time. So it always appeared to me that it was working as they grew in size gradually as more records entered the database. But seeing how it's nearly a quarter of the size phpMyAdin export is, and failing on the import, there's something very wrong with it.

But this is the export script. I can't see anything wrong with it:

#!bin-bashvar-backup-dbtemp-priceretail.txtvar-backup-dbtemp-pricewholesale.txt DOY=`date +%Y%m%d` # DATE YYYYMMDD TIME=`date +%H%M` # TIME HHMMbin-tar -czfvar-backup-db-db-$DOY-$TIME.tgzvar-backup-dbtemp-* rm -fvar-backup-dbtemp-* scp -B -S ssh -ihome-backup-.ssh-iddsa PC):-home-backup-db

Any suggestions? Thanks! Liam