MySQL mysql dump 떠서 복원하기

>> 첫번째 예제

mysqldump -uroot -pkebi mail > dumpfile

mysql -uroot -pkebi mysql -e "grant insert,update,select,delete,index,alter,create,drop on mail2.* to kebi@localhost identified by 'kebi'"

mysql -uroot -pkebi mysql -e "grant insert,update,select,delete,index,alter,create,drop on mail2.* to kebi@127.0.0.1 identified by 'kebi'"

mysqladmin -uroot -pkebi reload

mysqladmin -uroot -pkebi create mail2

mysql -uroot -pkebi mail2 < dumpfile



>> 두번째 예제

[root@webmail root]# mysqldump -uroot -p비번 디비명 > file_name

[root@webmail root]# mysql -uroot -p비번 디비명 < file_name