recovering from database corruption

[uprs]

Hi - our site recently had a couple mysql tables get corrupted (possibly our ISP ran out of /tmp space?)

I went through and repaired the tables, and two lost all rows: CubeCart_admin_users and CubeCart_shipping_zones.

I have a backup, but unfortunately it's from a previous CC version, so I have some of the data needed to re-populate these tables, but not quite all of it. I'm wondering if someone can help me fill in the blanks, or otherwise re-populate the tables through some other means.

For shipping_zones I have the following from the old backup:

INSERT INTO `CubeCart_shipping_zones` VALUES

(1,'Local State/Province','|226|',0,'|62|',1),

(2,'National','|226|',0,'',2),(3,'Europe','|2|5|14|20|21|27|33|54|56|57|58|67|70|72|73|80|82|83|97|98|103|105|117|122|123|124|126|132|140|141|150|160|171|172|176|177|185|189|193|194|199|205|206|223|225|',0,'',3);

...which seems adequate except that this insert seems to be missing the "postcodes" column... can anyone provide that from a default US install?

For admin_users I have the following from the old backup:

INSERT INTO `CubeCart_admin_users` VALUES

(1,'Redacted Name','redactedusername','redacted_hashedpassword','[email protected]',31,1,'This user was setup during installation.',0,0,<redacted_time_value>),(2,'Administrator','redactedusername','redacted_hashedpassword','[email protected]',506,1,'',0,0,<redacted_time_value>);

... looks like it's mising the password salt column, and a few other columns... I'm sure i can fake a few of those (browser, sessId and Ip?), but maybe someone can point me to the proper way to generate a hash/salt pair for a given password? Or just a method to make a new admin user and I can tweak the ID to match other DB tables, etc.

The other table was the docs table, but I think we can handle that one.

Any other recommendations?

Thanks!