How to dump (quick) a table into another one.

[Francesco Moi]

Hello.

On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.

Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.

But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.

I'm looking for a faster way. Does anybody know it? Thank you very
much.

PS: I was told about 'mysqldump', but I do not know if it's faster
than mine.

[Dariush]

You can do that very easily using sqlporter.
SQLPorter is total database migration toolkit from realsoftstudio.

Download your free trail from www.realsoftstudio.com

Hope this helps.
SQLPorter database migration toolkit
www.realsoftstudio.com
fr**********@europe.com (Francesco Moi) wrote in message news:<5b**************************@posting.google. com>...

Hello.

On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.

Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.

But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.

I'm looking for a faster way. Does anybody know it? Thank you very
much.

PS: I was told about 'mysqldump', but I do not know if it's faster
than mine.

[Dariush]

You can do that very easily using sqlporter.
SQLPorter is total database migration toolkit from realsoftstudio.

Download your free trail from www.realsoftstudio.com

Hope this helps.
SQLPorter database migration toolkit
www.realsoftstudio.com
fr**********@europe.com (Francesco Moi) wrote in message news:<5b**************************@posting.google. com>...

Hello.

On MySQL, I've got a table I use as 'wild card'. I mean, I store
data into it and, at the end, I dump all the date into 'production'
table.

Until now, I perform it following these steps:
1) I empty 'production' table
2) I make a SELECT of every rows of the 'wild card' table and an
INSERT into 'production' table.
3) I empty 'wild card' table.

But I've got problem: during SELECT+INSERT time, 'production' table
is not full and there's a data lack.

I'm looking for a faster way. Does anybody know it? Thank you very
much.

PS: I was told about 'mysqldump', but I do not know if it's faster
than mine.