RE: how to dump database or tables

2010-01-29 Thread Jerry Schwartz
>-Original Message- >From: Anand kumar [mailto:anand@gmail.com] >Sent: Friday, January 29, 2010 4:36 AM >To: Suresh Kuna >Cc: muralikrishna g; mysql@lists.mysql.com >Subject: Re: how to dump database or tables > >it should be windows.. . > [JS] This will get

Re: how to dump database or tables

2010-01-29 Thread Wagner Bianchi
*Make a backup of yours databases:* shell> mysqldump -u -p --all-databases -e > path/file.dmp Implicit to this command quoted above, you will have the --opt option ( shorthand for --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset )

Re: how to dump database or tables

2010-01-29 Thread Anand kumar
it should be windows.. . On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna wrote: > Which OS your are using ? > > Suresh Kuna > MySQL DBA > > On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g > wrote: > > > i am working on my pc with mysql-5.0.27-community-nt > > > > i have created several data bases a

Re: how to dump database or tables

2010-01-29 Thread Suresh Kuna
Which OS your are using ? Suresh Kuna MySQL DBA On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g wrote: > i am working on my pc with mysql-5.0.27-community-nt > > i have created several data bases and tables in that.. to take backup, we > have to use dump., i dont know the correct syntax how to