« | Home | »

Restore (LARGE) MySQL by ssh

By Robin | mei 28, 2007

mysqlFor those people who have LARGE mysql databases and want to restore those, they know they have to cut it in little parts to work by phpmyadmin because the size limit…

But now here is the solution for your large sql file:

First upload your file to your webspace and login by ssh:

# mysql -u USER -p DATABASE < NAME.sql

press ENTER and give your database password
USER = your username for the database – DATABASE = the databasename – NAME = the filename you have uploaded

Topics: Linux | No Comments »