Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

Re: [PHP-DB] How to take Backup ? From: David Orlovich (david.orlovich <email protected>)
Date: 07/02/04

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
MySQL, then your restore command won't need to include the -p flag, as
the root password won't be set. Once you've restored the backup, go
into MySQL and enter:
flush privileges;
at the prompt to reinstall your root password etc.

Hope that helps.

Cheers, DavidO.

On 2/07/2004, at 4:26 PM, Rinku wrote:

> 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
Dr David Orlovich,
Senior Lecturer in Botany.

Department of Botany,
University of Otago,
P.O. Box 56,
(Courier: 464 Great King Street)
Dunedin,
New Zealand.

Phone: (03) 479 9060
Fax: (03) 479 7583

Web: http://www.botany.otago.ac.nz/

Ecology, Conservation and Biodiversity Research Group:
http://www.otago.ac.nz/erg/

Botanical Society of Otago: http://www.botany.otago.ac.nz/bso/ 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php