amvisser wrote:I've located the opencart.sql and have find the line you were refering to: "Dumping data for table `oc_country`" (By using Notepad).
I've also opened my database by means of PHPAdmin and at the left side I see the folder "oc_country". If I click on that folder, I see 12 countries which I have not deleted before.
However, from that point I actually don't know how to restore the "oc_country" folder/content, despite your instructions. Do I have to copy the data from the opencart.sql to the "oc_country" folder? And if so, what data exactly, untill where? And how would I do such a thing in PHPAdmin? If you could give me further instructions, that would be such a relief.
I'm sorry for my inexperience in OC, but thank you!
Annemiek
If you're not familiar with how to use phpMyAdmin, I
highly recommend you hire someone to do this for you, or at the very least, try this in a test installation first. Playing around with your database without knowing what you're doing can cause serious issues. Make sure you make a backup of your database before editing anything.
The database does not have folders, it stores things in tables (like a spreadsheet). You need to paste the TRUNCATE query text into the query editor area of phpMyAdmin. You then execute that query, and it will empty the oc_country table. (If you can't find the query editor, you might consider looking up a tutorial on phpMyAdmin, so you understand what it does, and how it works.)
After running the TRUNCATE query, then you need to paste the query text that you copied from opencart.sql into the query editor, and execute that query. That should restore all the countries.