How do I import into a MariaDB - MySQL database?

import a database with Ultra Web Hosting phpMyAdmin:

  1. Log in to your control panel with Ultra.
  2. Click phpMyAdmin.
  3. Click the name of the database you are working with.
  4. Click on the "Import" tab near the top.
  5. In the "File to Import" section, click on the "Choose File" button and select the SQL file that you want to import.
  6. In the "Format" section, select "SQL".
  7. Click on the "Go" button.

phpMyAdmin will import the database from the SQL file. The process may take a few minutes, depending on the size of the database.

You may need to clear the database first by deleting it and recreating it in the "MySQL Databases" section of your control panel.

 

Additional tips for importing a database with phpMyAdmin:

 

  • Make sure that the SQL file is in the correct format. The SQL file should be a text file that contains the SQL statements that you want to execute.
  • Make sure that the SQL file is compatible with your MySQL version. The SQL file should be compatible with the version of MySQL that is running on your server.
  • Back up your database before you import the SQL file. This will help you to protect your data in case something goes wrong during the import process. You may backup the database in phpmyadmin via the "Export" tab.

If you need additional help, please contact Ultra support


 

 

 
  • 526 Utilizadores acharam útil

Esta resposta foi útil?

Artigos Relacionados

Strict Standards: Non-static method JLoader::register() should not be called statically in

The error message...  Strict Standards: Non-static method JLoader::register() should not be...

403 Forbidden error with Drupal after install

There are a few things you can do to fix the 403 Forbidden error with Drupal after install:...

How do I update my version of PHP?

PHP needs to be updated. What do I do?We make changing your version of PHP easy. Simply login to...

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate xxxxxxxx bytes)....

What is the Path to ImageMagick?

The path to ImageMagick on Ultra Web Hosting is /usr/bin/. This means that you can access...