oiojin831/mysql.md

Last active September 20, 2015 23:53

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/oiojin831/c7194045cc5ddb4319e3.js"></script>
Save oiojin831/c7194045cc5ddb4319e3 to your computer and use it in GitHub Desktop.

export and import

Raw

디비에서 파일려 가져오기

sudo mysqldump --user root --password=didwoehd33 mylodev > mylodev.sql

다른 서버로 전송

scp ~/mylodv.sql oiojin831@rollintiger.com:~/

내 서버에서 mysql에 저장하기

mysql -u root -p mylodev < ~/mylodev.sql

changing

ALTER TABLE tablename MODIFY columnname INTEGER

Select an option