How Upload And Download Word Document From Phpmyadmin

Are yous planning to share a locally-developed database from your web server? Mayhap you're migrating a database for WordPress or another content direction arrangement (CMS) for development purposes. Whatever the case, phpMyAdmin has a unproblematic procedure for importing a database file after creating the database in cPanel.

In this tutorial, we will show y'all how to import a MySQL Database using phpMyAdmin in cPanel.

Avant-garde users can create and import the database using SSH.

Prerequisites
Import Database
Troubleshooting

Prerequisites

We'll presume that you've already exported your database, and it is either a .sql, zip, or tar.gz file.

If needed, you can make changes to the file using a text editor – east.k. Notepad++ and Atom.io and file pinch tools like vii-Aught and The Unarchiver.

You should accept already created the new database that you're importing into equally well.

Import Database

Log into cPanel.
Under Databases, open up phpMyAdmin past clicking the phpMyAdmin icon.
On the left, select the database that you volition be working with.
Click Import in the top menu.
Under File to Import, click Scan and select the fill-in file y'all previously created (information technology will either exist a .sql .cipher or .tar.gz file).
Click Go at the bottom right to import the database file.
When the database has been imported successfully, you lot should see a message at the top of the folio similar to: Import has been successfully finished, ## queries executed.

Congratulations, you have only imported a database!

Troubleshooting

#1044 – Access denied

If you get the post-obit fault when importing a database via PhpMyAdmin, you will demand to edit the SQL file yous're trying to import.

CREATE SCHEMA IF NOT EXISTS `DataBaseName` DEFAULT Character Ready utf8 COLLATE utf8_general_ci; MySQL said: Documentation #1044 – Access denied for user 'userna5'@'localhost' to database 'DatabaseName'

PhpMyAdmin does not let yous to CREATE databases due to security reasons. In order to go your SQL file to load you will need to remove the CREATE SCHEMA line at the beginning of your code. You can use our MySQL – 1044 Access Denied Fault Message tutorial and a text editor such as Notepad++ or Atom.io to accomplish this.

50+ MB databases

The process for uploading databases over 50 MB differs depending on your InMotion Hosting plan.

Shared Servers

For databases over 50 MB, you can simply import the database via SSH. Alternatively, yous tin install a phpMyAdmin example to import it to your server.

VPS / Dedicated Servers

VPS and Dedicated server users with root access can increase the max upload size equally needed in WebHost Director(WHM) Tweak Settings section.

Advanced users with root access tin import a database larger than 50 MB by logging into MySQL in SSH. For more details on the mysqlimport command, go to Dev.mysql.com/md.

Note: If you need assistance with importing the procedure, you lot can electronic mail our technical support a verified ticket asking with the file and database name.

We too have articles to assist you manage your databases and troubleshoot errors – e.g. MySQL Error 1064: You have an error in your SQL syntax . If yous take whatever issues upon importing your database, trying running a check and repair using cPanel or phpMyAdmin.