MySQL Forums
Forum List  »  Data Recovery

Re: append data to existing database
Posted by: Oli Sennhauser
Date: February 23, 2010 11:11AM

Hi Kevin,

There are several different ways to solve your problem which come to my mind:

In more recent releases there is the --where parameter in mysqldump. You can try to dump with a newer release of mysqldump and connect to your 4.1.8 MySQL db (by the way you should not use such an old release any more...).

Next idea is to edit dump file manually an remove drop/create table statements.

Next idea is to use --add-drop-table=0 parameter (I do not know if this exists already in 4.1.8) and load with --force (which is not a good idea).

You can write a script which removes the create table statement from the dump (I possibly have such one somewhere).

You can use select into outfile or cvs tables (does it exist in 4.1 yet?) to dump data.

And there are a few other workarounds which are a bit more complicated.

If this does not help, drop me a line (oli.sennhauser@fromdual.com)

Regards,
Oli

--

FromDual - Independent and neutral MySQL consulting in Europe!
http://www.fromdual.com

Options: ReplyQuote


Subject
Views
Written By
Posted
7293
February 23, 2010 11:02AM
Re: append data to existing database
3843
February 23, 2010 11:11AM
2816
February 23, 2010 11:24AM
2494
February 26, 2010 10:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.