Hello,
Have a look at mysqldump .. it is used for backing up tables and
database.
Example
mysqldump --add-drop-table -c testdatabase -h 127.0.0.1 -u mysqlbk
--password=mysqlbk > testdatabase.bk
Michael
On Thu, 1 Jul 2004 21:26:27 -0700 (PDT)
Rinku <[EMAIL PROTECTED]> wrote:
> I want
Hi Rinku
To dump (backup), I do the following:
/usr/local/mysql/bin/mysqldump -uroot -pyourpassword --opt
--all-databases > ~/backup.sql
To restore, I do this:
cat ~/backup.sql | /usr/local/mysql/bin/mysql -uroot -pyourpassword
If you've dumped your databases in order to install a new version of
Try the mysqldump command
zareef ahmed wrote:
Hi,
If you have phpmyadmin on your system you can export
all your data in sql format which can be restore again
by running that sql script. make sure to check
complete insert checkbox at time of export operations.
Revert Back with any comment or proble
Hi,
If you have phpmyadmin on your system you can export
all your data in sql format which can be restore again
by running that sql script. make sure to check
complete insert checkbox at time of export operations.
Revert Back with any comment or problem.
Zareef Ahmed
--- Rinku <[EMAIL PROTECTED
I want to take backup for Mysql database.
Can any of you tell me how to take Backup and how to Restore it ?
Rinku
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
