Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export all tables in separate sql files

I have to upload my database on godaddy host but it restricted to upload more than 8 MB file. So I have decided to upload my table one by one. I am looking for a query or a way to export each table one by one, is there any way available to do this job easily? That I get each table sql with the data?

I am using PHPMyAdmin.

like image 600
Muhammad Faizan Khan Avatar asked Jun 15 '17 05:06

Muhammad Faizan Khan


People also ask

How do I export an entire MySQL database?

Steps to Export your MySQL Database Using phpMyAdmin Click phpMyAdmin in the database section of the cPanel home screen. In the left pane of the phpMyAdmin page, click on the database that you want to export.


1 Answers

You can import tables from phpmyadmin as follows :

importing table wise

You also get option to include data along with table schema.

like image 63
Prabhat G Avatar answered Sep 23 '22 18:09

Prabhat G