samuelhauser
2/19/2015 - 10:46 AM

export/import database

# export
mysqldump database_name > database_exportname.sql

# import
mysql database_name < database_exportname.sql

# with login
mysqldump -u Username -pPassword Database_name > database_exportname.sql

# with login and host
mysqldump -h Host -u Username -pPassword Database_name > database_exportname.sql