What is the proper MariaDB - MySQL import and export format?

Sure, here are the steps on how to import and export databases using phpMyAdmin in your control panel with Ultra:

 

Importing a database

  1. Log in to your control panel with Ultra.
  2. Click phpMyAdmin.
  3. Click on the "Import" tab.
  4. Select the "Choose File" button and browse to the location of the SQL file that you want to import.
  5. Select the "Format" of the file. The most common format is "SQL".
  6. Click on the "Go" button.

Exporting a database

  1. Log in to your control panel with Ultra.
  2. Click phpMyAdmin.
  3. Select the database that you want to export.
  4. Click on the "Export" tab.
  5. Select the "Format" of the file. The most common format is "SQL".
  6. Click on the "Go" button.


Ultra Web Hosting has been around since 2002. Our experience allows us to confidently offer a 45 day money back guarantee. If you need hosting, or help with anything, just let us know!

Click here to view our hosting plans. Click here to reach support.

 

 


 

 
  • 655 Users Found This Useful

Was this answer helpful?

Related Articles

Warning: Unknown(): open_basedir restriction in effect

Basedir restriction is set for security. This most often occurs when you are calling an app...

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following:MySQLDump all databases into a SQL...

What is the path to PHP?

The path to PHP on Ultra Web Hosting is /usr/bin/php.  Ultra runs many different versions of PHP...

When trying to connect to MariaDB or MySQL you receive error 2003 Cannot connect to MySQL on xxxxxx on port 3306 10060

The error 2003 "Cannot connect to MySQL on xxxxxx on port 3306 10060" means that the MySQL...

Disable MySQL strict mode on cPanel server

here are the steps on how to disable MySQL strict mode on a cPanel server:   Log in to your...