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 use dump to take
backup to a specific location., after that how to resore. please help me
regarding this.
thanks
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
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
it should be windows.. .
On Fri, Jan 29, 2010 at 2:29 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
i am working on my pc with mysql-5.0.27-community-nt
*Make a backup of yours databases:*
shell mysqldump -u user -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
-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 you backed up...
=
REM