How to export all tables in separate sql files

Question

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.

I mean are you using shell command to access MySQL or via PHPMyAdmin? — ajreal, Jun 15 '17 at 06:01
@MohammadFaizanKhan are you importing from phpmyadmin only ? or from mysql workbench ? — Prabhat G, Jun 15 '17 at 06:24

score 7 · Answer 1 · edited Jun 20 '20 at 09:12

7

You can import tables from phpmyadmin as follows :

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

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 15 '17 at 07:01

Prabhat G

2,846
1
20
31

1

which version you are using? it is not available – Muhammad Faizan Khan Jun 15 '17 at 09:55
@MohammadFaizanKhan : Phpmyadmin-4.6.5.2, MySQL-10.1.21-MariaDB – Prabhat G Jun 15 '17 at 09:57
1

i have mysql 5.6.12 and this option is not available – Muhammad Faizan Khan Jun 15 '17 at 12:04
@MohammadFaizanKhan : try this - https://stackoverflow.com/questions/9359053/mysqldumper-dumping-each-table-separately – Prabhat G Jun 15 '17 at 12:50

How to export all tables in separate sql files

1 Answers1