You are Here: FAQ ->Scripting and Programming Languages->MySQL Database->Article #7


WebHosting 5.0 This article is for 1&1 Linux WebHosting only.


How to import a database (dump)



To import a MySQL dump first upload the dump file to your webspace via FTP.
Once the file is in your webspace, please log into your shell account via SSH and
run this command:

mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
Enter password:


Note: If you have a Managed Server with MySQL 5 please enter the following :
mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx -S /kunden/tmp/mysql5.sock < dump_file.sql

Please replace this information with the MySQL login data shown in your
control panel.

Note: Not all packages have SSH Access. If you don't have SSH access, then
please use phpMyAdmin to import your dumpfile.


Print Article
How useful was this article?
(From 5 = Very Useful to 1 = Not useful at all):
1 2 3 4 5