Import a large database

mysql -u mysqlusernamehere -p databasenamehere < exportfile.sql


  • 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 !


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

Leave a Comment