2.7.1.6. Database import via control panel

Before import:

  • Make sure the file size is less than 300 MB. If the size is larger, use one of the methods to import databases of any size presented here.
  • Make sure there are no queries in the imported database like CREATE DATABASEsince databases can be create only through the control panel. If there are such requests, the lines with them must be removed from the file using any text editor (for example, Notepad++).
  • Make sure there are no characters in the database user password #... If there are any, change password for a password without these characters.
  1. Open the section "Databases".
  2. Expand the menu of the database into which you want to import the dump and click "Import database":
  3. Fill out the form and click "Import":
    • "Select file (s)" - select the file with the database dump.
    • "Access login and database name" - select database, into which you want to import the dump, and its name user.
    • "Dump encoding" - leave "Do not specify encoding when importing" or select the desired encoding from the list.
    • "Continue importing data if an error occurs" — leave a check mark if you want the import not to stop if any errors occur.
    • "Clear database content before import" — leave the checkbox checked if the dump is to be imported into a cleaned database (all existing data from the selected database will be deleted).
  4. Willopen file-manager and in his block of operations the current import status will be displayed:
Content