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.
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.
You can import tables from phpmyadmin as follows :
You also get option to include data along with table schema.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With