()ý
Home
Ȩ ȸҰ ý Ʈ ũ
 
 
ۼ : 06-03-21 15:40
MySQL Dumpߴ
 ۾ :
ȸ : 10,116  

1. ߱ $> mysqldump -u[ھ̵] -p ͺ̽ [̺] > ϸ


) mysqldump -ukamkami -p mydatabase > kamkami.pe.kr.sql ̷ ϸ


(mydatabase) ߰Եȴ. ̺ ߰ ʹٸ ) mysqldump -


ukamkami -p mydatabase member_table > kamkami.pe.kr.member_table.sql ̷


̺ ִ.


 


2. ϱ ϴ ϴ. $> mysql -u[ھ̵] -p


[] < ϸ ) mysql -ukamkami -p < kamkami.pe.kr.sql ) mysql -ukamkami


-p mydatabase < kamkami.pe.kr.member_table.sql




 


#mysql -utest -ptest1234 test < test.dmp
                   йȣ    db    


 
 

Total 136
ȣ     ۾ ¥ ȸ
31 Ǽ mysql DB
2006/07/14 9876
30 NAS SAN .....
2006/07/11 4447
29 ý ڱ ....
2006/07/10 4628
28 oracle 9i ġ
2006/06/14 3067
27 oracle datebase shutdown ʵɰ....
2006/06/05 4844
26 x4100
2006/04/26 3072
25 RAID 1-6 ϱ
2006/04/11 3551
24 Ŭ Ƽ ũ Ǯ ӽ ġ.
2006/04/11 13555
23 bdump, cdump, udump
2006/04/11 6887
22 sas disk --- Serial Attached SCSI
2006/04/06 3761
21 ms-sql *.mdf .
2006/04/03 7419
20 tomcat web Manager йȣ Ȯ.
2006/03/31 11055
19 MySQL Dumpߴ
2006/03/21 10117
18 mysql db .
2006/03/21 6685
17 nagios ġ.
2006/03/13 10414
 1  2  3  4  5  6  7  8  9  10  
 
 
 
Administrator Login