We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
New design
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.10.7. Database import via console

Note

Databases up to 300 MB or larger can be imported through the console.

To import the database through the console, do the following:

  1. Through filemanager or any FTPclient upload to the hosting a file with a database dump in the format sql.
  2. Run the command:
    mysql -h host -u login --password='password' name < way/to/file/dump.sql

    In a team:

    • Instead host, login password and name use appropriate data to connect to the databasewhere the import is performed. The password must be enclosed in quotation marks. Note You can omit the key --password and enter the password directly during the connection.
    • Instead path/to/file/dump.sql specify the path to the dump file (or just its name if it is in the current directory).
  3. Enter database user passwordif you did not specify it in the connection command. Attention! For security reasons, in Linux systems, when entering a password or pasting it from the clipboard, characters are not displayed on the screen.
  4. Wait for the command to complete.