lost all my countries!

[jenpen]

Hi,
I've posted before, last week, but got no responses and getting desperate now.
I was deleting some countries from the list (Locations/Taxes > Countries) when I got a blue screen. After rebooting and logging back into the same admin area I realised all my countries had gone. There isn't even an "Add Country" button there. There's an error message that says:

1030 Got error 134 from storage engine
in:
[select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from zen_countries order by countries_name limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I can't go back as I had to reboot.

When I did a test order and went to "Estimate Shipping Cost" and "Please Choose your Country", all the countries I hadn't deleted are still there. But I need to delete some more, and I can't if they're not listed in the Admin. I also need to add "Australia" back in, as I accidentally deleted it too.
I'm running this locally on my machine at the moment.
Help?

[fairestcape]

Could be a corrupt database. Try doing a repair first.

You are going to have to check all the tables relating to countries and zones, and compare them with a copy of the original SQL file used to create the database. Then you may have to drop the corrupted tables and then re-create them. Then you will have to insert the data.

The SQL you need is probably all in the original mysql_zencart.sql file that is in the SQL folder, inside the INSTALL folder, of an unzipped copy of ZC.

If you have phpMyAdmin, the process is relatively straight forward.

[jenpen]

fairestcape, I have phpMyAdmin but nothing to do with mySQL is straightforward to me. Do you mean there's a file in an unzipped copy (I have one) that I can simply use to over-write the corrupted file? And can anyone point me at a 'databases for dummies' tutorial?

[stevesh]

If you haven't added too many products, I'd start from scratch and re-install.

[fairestcape]

If you haven't added too many products, I'd start from scratch and re-install.

Yes... I was going to suggest the same. As you're on a local drive, we cant even ask you for your C-Panel login to help fix the dbase, and I'm afraid I haven't time to give you a crash course on MySQL !

However, keep your existing store and dbase, and install a fresh webshop in a sub directory.

To recover product data, you could try installing EASYPOPULATE on your existing site, then using it to produce a tab-delimited file of all your existing product data.

When your new installation is ready, you can run this file through easypopulate on your new store, and all your product data will appear there in a couple of seconds.

[jenpen]

Yes, I agree, best to start again. I will install EasyPopulate, sounds good. Here's hoping I created my template the right way and can just overwrite the files, as that was the most laborious bit.
I'll do it live this time, so I can call the troops in if necessary. Thanks guys.

[fairestcape]

What you could do, is once you have created your NEW site (with its NEW database), you could go back to your ORIGINAL site, and edit the configure.php files to point to the NEW database. (Remember then that you will have TWO templates (sites) pointing to the same database, so dbase changes in the OLD shop will also show in the NEW shop.)

Then you may have to run fix_cache_key.php in the NEW site in order to reset the cache.

This file is available in the downloads section.