AI ์ด์ „์‹œ๋Œ€ (↓์„๊ธฐ์‹œ๋Œ€ IT)/03. SQL

mysql ๋ฐฑ์—…/๋ณต๊ตฌ

๐Ÿ“ฆ DonzBox 2010. 2. 5. 17:45

mysql ๋ฐฑ์—…/๋ณต๊ตฌ

๋ฐฑ์—…ํ•˜๊ธฐ
mysqldump -u [DB์‚ฌ์šฉ์ž] -p [ํŒจ์Šค์›Œ๋“œ] [๋ฐฑ์—…ํ•  ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ด๋ฆ„] > [ํŒŒ์ผ์ด๋ฆ„]

๋ณต๊ตฌํ•˜๊ธฐ
mysql -u [DB์‚ฌ์šฉ์ž] -p [ํŒจ์Šค์›Œ๋“œ] [๋ณต๊ตฌํ•  ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ด๋ฆ„] < [ํŒŒ์ผ์ด๋ฆ„]