#675 ability to merge tables with the same names

[Steve]

the ability to merge an sql dump into a database and if
the same names appear it will add (ALTER) any fields
from the dump that arn't in the database

REASON:
im working on a new system designing at work and at
home - i could work on a database online, but while im
working on the database im not thinking about security
(i.e who can remember password when trying to code
fast so i just use null passwords) plus the PHP isn't
online (makes it easier to code) so any database is in
the open

[Steve]

Logged In: YES
user_id=1090985

sorry, any data is in the open

[Michal Čihař]

Logged In: YES
user_id=192186

Whould't implementing RFE #631976 be enogh for you? Working
on SQL dumps is hard work, man need to parse it etc...
Creating diff between existing tables and applying it would
solve your problem, wouldn't it?

[Rakesh Kumar]

Hi,
I have also faced this problem many a times during Import.Problem occurs If there is a primary key in table then it shows error for duplicate entry if by chance there is any, and again if you delete all the insert data from mysql dump it shows error for adding multiple primary key.
I would like to work on it.Should I?

[Rakesh Kumar]

I am working on it.

[Madhura Jayaratne]

I think it would be best to discuss this on the developer mailing list first.