On 10/16/2010 12:52 AM, Viktor Balogh wrote:
... the phpMyAdmin software for that. And you can look after how a valid structure looks like in the mysql.initial.sql file. And, in advance, take a full dump of your database. (I have chosen the second method and manually repaired the db.)
please make sure you secure your phpmyadmin install. especially zEmU seems to be a PITA [1][2]
@to the devs: I don't know how many people suffers from this kind of problem, but I would recommend to keep the sql files for each version separate. This would ensure a flawless 5sec install/upgrade, just as with e.g. the wordpress engine.
i recommend someting like "compare db to current layout" or "compare db to xyz.initial.sql". typo3 offers this during the upgrade processes.
cheers, raoul
[1] http://webhostingproblems.net/web-hosting-issues/hosting-security-issues/zme... [2] http://linux.m2osw.com/zmeu-attack