Importing Databases

Webnames Hosting supports a maximum database import size of 2,048 MiB (~2.14 GB)

To import an existing database:

  1. Go to the Websites & Domains tab > Databases (in the Advanced Operations group) > Add New Database.
  2. Enter a name for the database. We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).
  3. Click OK.
  4. To set up database administrator's credentials, click Add New Database User.
  5. Type a user name and a password that will be used for accessing the contents of the database. Click OK.
  6. Click the Webadmin icon in the Tools group. An interface to phpMyAdmin, will open in a separate browser window. The database management tools allow to operate database user accounts and execute SQL queries through the web browser.

If you have a MySQLClosed MySQL is the world's most used open source relational database management system that runs as a server providing multi-user access to a number of databases. database:

  1. Click Query window in the left frame, click the Import files tab,
  2. Select the text file that contains the data and click Go.
  3. Click the Insert data from a text file link.
Note: The current maximum INSERT size permitted is 16 MB (max_allowed_packet). If difficulties are encountered while performing an import, please ensure that the export itself was done in a manner whereby each individual INSERT does not exceed 16 MB (max_allowed_packet). This is often accomplished by disabling the option that refers to 'bulk' exports.

To manage your databases and their contents, phpMyAdmin is accessible from the Panel (the Websites & Domains tab > Databases > database name > Webadmin).