root quota - viewing and changing

Had this odd issue with a database over the weekend where importing the database using mysql -u root -p dbname < dbfile.sql would fail with error 122.

The database was 650mb and the error 122 is usually the result of not enough disk space. We have about 250gb (raid) on that server, we never set root with a separate partition, only boot swap and /.

I ended up users a customers account to import the db after banging my head on the wall for couple of days.

Shouldn’t root have been able to handle this import?
How do I view what root quota is?
Can one change it as easily as other unix quota?