« | Home | »

backup mysql by ssh

By Robin | mei 27, 2007

mysqlMost of you people don’t have ssh access on your webhostingaccount, but for those who have and know why they having it here you find the command to backup your (LARGE) mysql database:

# mysqldump -u USER -p DATABASE > NAME.sql

(press ENTER and give your password)
where USER = your database username – DATABASE = your databasename and NAME = you can choose this

Topics: Linux | No Comments »