在phpmyadmin中导入/导出非常大的mysql数据库 [英] import/export very large mysql database in phpmyadmin

问题描述

我有一个db在phpmyadmin有3000000记录。我想导出到另一台pc。现在当我导出这个只有200000条目导出到.sql文件，也不导入在其他pc。

i have a db in phpmyadmin having 3000000 records. i want to export this to another pc. now when i export this only 200000 entries exported into .sql file and that is also not imported on the other pc.

推荐答案

这对任何人谁到这里。如果你只能使用phpMyAdmin，因为你没有SSH访问MySQL服务或不知道如何使用命令行工具，那么这可能有所帮助。但是如上面的注释建议，导出这种大小的数据库将是更容易与mysqldump。

Answering this for anyone else who lands here. If you can only use phpMyAdmin because you do not have SSH access to the MySQL service or do not know how to use command line tools, then this might help. However as the comment above suggest, exporting a database of this size would be far easer with mysqldump.

phpMyAdmin（我使用v3.5.6）允许表导出个人喜欢：

phpMyAdmin (I'm using v3.5.6) allows tables to be exported individually like so:

1. 选择要查看/编辑的数据库。


2. 在表格列表中，勾选要导出的表格
   左侧的复选框。


3. 在表格列表底部，从With
   Selected：选择框中选择导出。


4. 。通常，快速导出将工作，
   将其保存为SQL格式。

1. Select the database to view/edit. A list of all the tables should appear.
2. In the list of tables, tick the checkbox to the left of the table you want to export.
3. At the bottom of the tables list, select 'Export' from the 'With Selected:' select box.
4. The export screen appears. Often a 'Quick' export will work, and save it as 'SQL' format.

phpMyAdmin还允许记录可以单独或成组导出，例如，您可以从100,000个表中导出10个记录。

phpMyAdmin also allows records to be exported individially or in groups, so you could for example, export just 10 records from a table with 100,000.

1. 按照步骤1到3


2. 在行下选择转储某些行。
>

3. 然后输入要导出的行数和起始行数。


4. 在导出屏幕底部的数据转储选项请检查
   创建的查询的最大长度是否足够大。


5. 注意：如果您要导出大型BLOB数据，可能需要提高此数字。 li>
   

1. Follow steps 1 to 3 above.
2. Instead of 'Quick' select 'Custom'.
3. Under 'Rows' select 'Dump some row(s)'
4. Then enter the number of rows you want to export, and the starting row number.
5. Under 'Data dump options' at the bottom of the export screen, check that 'Maximal length of created query' is large enough.
6. Note: If you are exporting large BLOB data for example, this figure might have to be raised.

希望通过网络帮助新用户加入phpMyAdmin或DBA。

Hope that helps someone new to phpMyAdmin or DBA via the web.

这篇关于在phpmyadmin中导入/导出非常大的mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！