How To Import Mysql Database Table On Cpanel - FreeCodeBlog

Last updated: Dec 11, 2021

Want to import MySQL database table on cpanel? Yes. Do you have any existing database? Yes. Good, If you have an existing MySQL database with tables in xampp on your local server then you can easily import MySQL database in cpanel. So if you want to import existing MySQL database tables to cpanel MySQL then you should need to read this import database on cpanel tutorial carefully. Wait a minute, Do you have a cPanel to import the database? Yes. Cool, You may need to create database on cpanel to import existing MySQL database with tables. I will also help you to create database on cpanel in this tutorial to import database on cpanel.

 

How To Import Mysql Database Table On Cpanel
How To Import Mysql Database Table On Cpanel

 

Remember: I have created a MySQL database with lots of database tables in xampp. Now I want to move this database with table to cpanel database. So I will explain to you how we can transfer or import database to cpanel.

 

1. Create MySQL Database On Cpanel.

Before importing MySQL Database Table into cpanel you need to create a new database in cpanel. If you do not know how to create a new database on cpanel then read how to create mysql database on shared hosting cpanel tutorial. In this tutorial I have not explained to you how to create a MySQL database on cpanel. I hope you can create a MySQL database on cpanel by read our database created tutorial.

 

2. Create MySQL Database On Xampp.

I hope you have a created MySQL database on your xampp application. So open your xampp control panel and click on the Apache and MySQL start button. Now open any web browser and click on enter phpmyadmin URL.

 

localhost/phpmyadmin/  

 

Now click your created database to open it. next click on export button from top menu bar. you will see Exporting tables from "created-database" database line on exporting page. now click on go button. It will return an popup menu form to save created database SQL file. finally click on save button to save SQL file.

 

3. Import Mysql Database Table On Cpanel.

First login cpanel dashboard then find phpmyadmin option on cpanel dashboard and click it to go database admin panel. now click on created database and next click on import button from top on menu bar. I hope you will be see like Importing into the database "created-database" after click on import button. Now click on browse your computer: browse.. button and select your exported SQL file from your computer. Finally click on go button to import MySQL database table on cpanel. If you get error while importing MySQL database table then follow next step.

 

4. Solve Mysql Database Table Importing Error.

You may get error while importing database table on cpanel for many reason like format, charset, collation.

 

Format: Make sure your exported file format is the same as your imported file format. don't forget to select imported file format on Importing into the database "created-database" page. please scroll page to see format selecting option on import page.

 

created-database.sql

 

Charset: Make sure your exported file charset is the same as your imported file format.

 

utf8mb4

 

Collation: Make sure your exported file collation is the same as your imported file format.

 

utf8mb4_unicode_ci

 

Okay so this is for today. See you again next tutorials. Thanks

Post Tags
Post Writer
masum7323
Masum Biswas (@masum7323)

My name is Masum Biswas. I'm a full stack developer. I live in Bangladesh and I love to write tutorials and tools that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, MySQL, VueJS, Tailwind CSS and Bootstrap from the early stage.

Follow Me On
Related Posts
Upload Laravel Project To Shared Hosting Using Public Github Repository

Want to use GitHub public repository to upload laravel project to shared hosting cpanel? Public GitHub repository for laravel project uploading on... Read More

How To Create Ftp Accounts On Cpanel Shared Hosting

Want to create a FTP account from cpanel? Yes. Create and configure FTP Accounts to get your website on the internet fast. You can use an FTP clien... Read More

How To Deploy A Laravel 8 Project On Namecheap Shared Hosting Cpanel

Today I will explain you, how we can easily deploy a laravel 8 project on namecheap shared hosting cpanel. If you have a namecheap shared hosting s... Read More

Laravel Mail Configuration On Shared Hosting Cpanel

Want to configuration laravel mail on cpanel shared hosting? Actually after successfully deploy laravel project on shared hosting cpanel you need t... Read More

Change Laravel Mysql Database Connection On Shared Hosting Cpanel

Want to change local to cpanel MySQL database connection in laravel on cpanel? Yes. Well, You need to change laravel MySQL database connection on s... Read More