Re: About mysqldump

2006-06-22 Thread Dilipkumar
Hi, Take the dump using --tab which will give you .txt and .sql file. Move the dump to the new version of mysql and try using load data infile '/tmp/user.txt' into table user; Jørn Dahl-Stamnes wrote: On Thursday 22 June 2006 04:00, Daniel da Veiga wrote: On 6/21/06, Jørn Dahl-Stamnes <

Re: About mysqldump

2006-06-21 Thread Jørn Dahl-Stamnes
On Thursday 22 June 2006 04:00, Daniel da Veiga wrote: > On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: > > On Wednesday 21 June 2006 17:17, Barry wrote: > > > Jørn Dahl-Stamnes schrieb: > > > > Is it possible to get mysqldump to include rights that has been > > > > GRANTED to a database

Re: About mysqldump

2006-06-21 Thread Daniel da Veiga
On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: On Wednesday 21 June 2006 17:17, Barry wrote: > Jørn Dahl-Stamnes schrieb: > > Is it possible to get mysqldump to include rights that has been GRANTED > > to a database or to tables in the database that is being dumped? > > Dump the Grant t

Re: About mysqldump

2006-06-21 Thread Jørn Dahl-Stamnes
On Wednesday 21 June 2006 17:17, Barry wrote: > Jørn Dahl-Stamnes schrieb: > > Is it possible to get mysqldump to include rights that has been GRANTED > > to a database or to tables in the database that is being dumped? > > Dump the Grant tables? I have though of it. Currently I am dumping the mys

Re: About mysqldump

2006-06-21 Thread Barry
Jørn Dahl-Stamnes schrieb: Is it possible to get mysqldump to include rights that has been GRANTED to a database or to tables in the database that is being dumped? Dump the Grant tables? -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing