DB/MySQL

Top / DB / MySQL

Ϥ

MySQL ˴ؤ

ץץȤ

# ѥɤʤ桼
mysql -u <username>

# ѥɤ桼
mysql -u <username> -p

root Υѥѹ

set password for root@localhost=password('<password>');

ݡȤȥݡ

Хååפʤɤˡ

ݡȡʥפμ

# Υǡ١ΤߤΥפ
mysqldump -u <username> <database-name> > hoge.dmp

# ΤΥפ
mysqldump -u root -x --all-databases > hoge.dmp

ݡȡʥפ

# Υǡ١Τߤפ
mysql -u <username> <database-name> < hoge.dmp

# Τפ
# 桼˥ѥɤ̵ʤ -p 
mysql -u <username> -p < hoge.dmp

Last-modified: 2011-10-26 () 14:40:23 (2429d)