I am running mysqldump on Ubuntu Linux (10.0.4 LTS)
my mySQL version info is:
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1
I used the following command:
mysql -u username -p dbname > dbname_backup.sql
However when I opened the generated .sql file, I saw that most of the tables had only the schema dumped and in the few cases where the actual data was dumped, only 1 or two records were dumped (there are ATLEAST several tens of records in each table).
Does anyone know what maybe going on?
Best Answer
I think you expect to see a lot of inserts and probably you see only 1 or 2. Is normal, if you look closer you will see 1 or 2 BIG inserts (extended inserts). Extended inserts are multiple row inserts which includes several VALUES lists.