MySQL的。 加载一个表的转储

Question

I have a big dump MySQL database (1.3 GB). How I may load dump only one table?

Answer 1

If you have access to command-line, best do it that way if you can:

mysql -u #username# -p #database# < #dump_file#

Otherwise use a gui tool like SQLyog (free community edition is available).

Using web-tools will almost definatley prove a huge pain.

To extract a single table, you'll need to manipulate the file, here is a good perl script for it :) http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html which I've used successfully in the past.