如何在MAMP上导出/导入大数据库 [英] How To Export/Import Large Database On MAMP

问题描述

如何在MAMP上导出/导入大数据库？使用PHPMyAdmin不能正常工作。

How do I export/import large database on MAMP ? Using PHPMyAdmin does not work as it supposed to be.

推荐答案

应该通过终端完成如下。

It should be done via terminal as below.

• 在终端中，使用以下命令导航到$ code> bin MAMP的文件夹 cd /应用程序/ MAMP / library / bin


• 使用此命令导出文件 ./ mysqldump -u [USERNAME] -p [DATA_BASENAME ] [文件路径] 。 EG将是 ./ mysqldump -u root -p my_database_name> /Applications/MAMP/htdocs/folder_name/exported_db.sql


• 行应显示为输入密码： 。这里输入MySQL密码。请记住，这些信件不会出现，但它们在那里。

• In the terminal navigate to bin folder of MAMP using below command cd /applications/MAMP/library/bin
• Use this command to export the file ./mysqldump -u [USERNAME] -p [DATA_BASENAME] > [PATH_TO_FILE]. EG would be ./mysqldump -u root -p my_database_name > /Applications/MAMP/htdocs/folder_name/exported_db.sql
• Line should appear saying Enter password:. Here enter the MySQL password. keep in mind that the letters will not appear, but they are there.

如果您需要导入使用 BigDump 哪个是MySQL转储进口商？

If you need to import use BigDump Which is a MySQL Dump Importer.

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