backup.sql size seems small

[PipeHitter]

Greetings to all. Just recently backed up to perform the 2.2.8 upgrade. As I was sorting out by backup.sql files ( I keep atleast two on hand just in case) I noticed the one I performed today (using mysqldump via ssh) was only 6kb big. While the last backup I performed a month ago was 1092kb big. Is that normal?
I went back and deleted backup.sql and re-dumped and it came back the same size (6kb). Any ideas?

[Steve Machol]

No that's not normal. What command are you using to make the backup?

[PipeHitter]

mysqldump --opt -uUSERNAME -p databasename > backup.sql

[Steve Machol]

Hmmm...that really doesn't make any sense. Fill out a support ticket at:

http://www.vbulletin.com/members/support_form.php

Be sure to include the login info to your Admin CP and telnet/ssh.

[PipeHitter]

Err, dunno how my isp will feel about me giving out my ssh info...
It's not that I don't trust the vbulletin team but they REALLY did not want to give me the account in the first place, and I can just see them scanning their logs and seeing the different IP address..

[Steve Machol]

There's not much we'll be able to do without it. Sorry.

[PipeHitter]

Gulp! I've posted them. Who all gets to view that ticket?

[Steve Machol]

Only vB support personnel.

[PipeHitter]

For anyone else's benefit I was not using the correct syntax in typing the command correctly as can be seen above. So I wasn't even getting a good dump! I typed:

mysqldump --opt -uUSERNAME -p databasename > backup.sql

What I needed to type was:

mysqldump --opt -u USERNAME -p DATABASENAME > backup.sql

Apparently that space between the u and my USERNAME made all the difference in the world.


Much thanks to Steve and the vBulletin team for awesome support!