如何在独立的sql文件中导出所有表

时间:2021-07-07 20:15:04

I have to upload my database on godaddy host but it restricted to upload more than 8 mb file. So I have to 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 data?

我必须上传我的数据库在godaddy主机,但它限制上传超过8 mb的文件。所以我决定一个一个地上传我的表格。我正在寻找一种查询或一种方法来逐个导出每个表,有什么方法可以轻松完成这项工作吗?我用数据获取每个表sql ?

I am using PHPMyAdmin.

我用PHPMyAdmin。

1 个解决方案

#1


2  

You can import tables from phpmyadmin as follows :

可以从phpmyadmin导入表,如下所示:

如何在独立的sql文件中导出所有表

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

您还可以选择包含数据和表模式。

#1


2  

You can import tables from phpmyadmin as follows :

可以从phpmyadmin导入表,如下所示:

如何在独立的sql文件中导出所有表

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

您还可以选择包含数据和表模式。