如何附加mysql数据库文件 [英] How to attach mysql database file

问题描述

我已经安装了 mysql 和 mysqlworkbench 5.2 CE，我想附上 mysql 数据库文件.我试图用 phpmyadmin 附加它，但数据库文件太大.谁能告诉我如何附加或提供此答案的链接，...谢谢

I have installed mysql and mysqlworkbench 5.2 CE, i want to attach mysql database file. I was trying to attach it with phpmyadmin but the database file is too large. Can anyone tell me how to attach or provide the link for this answer,...thanks

推荐答案

使用命令行客户端.最简单的形式:

Use command line client. In the simplest form:

mysql -h [hostname] -u [username] -p [dbname] < [db_file_name.sql]

要获取有关命令用法的更多信息，只需输入:

To get more information about command usage, just type in:

mysql --help

这篇关于如何附加mysql数据库文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！