[phpXperts] Re: Back-Up and Restore of Database

backing up
$ mysqldump Database -u User -p Password > Database.sql
u do this command at mysql's bin folder it will then save the DUMP of your database to that .sql file. in text format

to restore:
$ mysql Database < Database.sql -u User -p Password

The two commands given by Zakir Hossain are commandline style and these are actually most recommended.
In using phpmyadmin you might end up ruining the exactness of a database. Well in phpmyadmin you have the gzip option enabled which makes it compressed also. And also you can add the drop if exists options etc etc.

best regards

9el
__._,_.___

Visit phpXperts website at www.phpxperts.net

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___