Phpmyadmin and other admin tools also have those features, but web-based tools may not handle such a large table properly.
Dump your big table from your old server to a file on your desktop machine. Restore it to the new server. It may take overnight. So what? You only have to do it once (unless you mess it up the first time). Side benefit: you'll have a backup of your old table that you can put onto a DVD-RW and throw in your desk drawer.
You might have to segment the dump process by selecting rows a few million at a time. That's probably a good idea, because then you can restart the process if it crashes.
There are some tools (sqlyog) that can copy data from one server to another directly, as well.
发布评论
评论（1）
MySQL Workbench（像啤酒一样免费，像演讲一样免费）具有转储和恢复功能。
http://dev.mysql.com /doc/workbench/en/wb-manage-server-data-dump-tab.html
Phpmyadmin 和其他管理工具也具有这些功能，但基于 Web 的工具可能无法正确处理如此大的表。
将旧服务器中的大表转储到桌面计算机上的文件中。将其恢复到新服务器。可能需要过夜。所以呢？你只需要做一次（除非你第一次搞砸了）。附带好处：您将拥有旧桌子的备份，可以将其放入 DVD-RW 中并放入办公桌抽屉中。
您可能必须通过一次选择几百万行来对转储过程进行分段。这可能是个好主意，因为这样您就可以在进程崩溃时重新启动该进程。
有一些工具（sqlyog）也可以将数据从一台服务器直接复制到另一台服务器。
快乐的数据争论。
MySQL Workbench (free as in beer, free as in speech) has dump and restore features.
http://dev.mysql.com/doc/workbench/en/wb-manage-server-data-dump-tab.html
Phpmyadmin and other admin tools also have those features, but web-based tools may not handle such a large table properly.
Dump your big table from your old server to a file on your desktop machine. Restore it to the new server. It may take overnight. So what? You only have to do it once (unless you mess it up the first time). Side benefit: you'll have a backup of your old table that you can put onto a DVD-RW and throw in your desk drawer.
You might have to segment the dump process by selecting rows a few million at a time. That's probably a good idea, because then you can restart the process if it crashes.
There are some tools (sqlyog) that can copy data from one server to another directly, as well.
Happy data wrangling.