$ mysqldump -u user -p[passwd] [dbname] > [sqlfile]To restore:
$ mysql -u user -p[passwd] [dbname] < [sqlfile]Ex: to export (dump) and import a backup of database "data1" with user "user1" and password "passwd1" on "localhost" to "backup.sql" use below command:
$ mysqldump -u user1 -ppass1 data1 > backup.sql
$ mysql -u user1 -ppass1 data1 < backup.sql
* * * * * command to be executed - - - - - | | | | | | | | | +----- day of week (0 - 6) | | | +------- month (1 - 12) | | +--------- day of month (1 - 31) | +----------- hour (0 - 23) +------------- min (0 - 59)Read more here:

(c) Copyright 2009 Entertainment Hacking All Rights Reserved. Powered by VietServer.vn
Blogger Templates created by Deluxe Templates
Wordpress Theme by Skinpress
shared host, vps windows, vps linux, vps vn, thue may chu, thue server, thue may chu gia re, ten mien, dich vu seo, dich vu rao vat, traffic gia re, boot alexa
