Import a large database

mysql -u mysqlusernamehere -p databasenamehere < exportfile.sql

Notes:

• The exportfile needs to be plaintext, not zipped.
• The exportfile must be free of any create database statements
• When importing over an existing (filled with data) database -> delete all existing tables first !

OR

• Create exportfile with droptables, gzip outputted
• Visit directadmin -> mysql -> import backup