Clever Geek Handbook

How can I create a new MySQL table with the results of "myisam_ftdump -c"?

I am using myisam_ftdump -c

to dump occurrences of words in my full text column. What's the easiest way to insert this information into a new MySQL table?

Thanks for any help, he appreciated.

+1


source to share


1 answer


Dump the results> to a file and use LOAD DATA INFILE Query to import the content back into the new table.

Note:



For security reasons, when reading text files located on the server, the files must either be in the database directory or be readable by everyone. In addition, to use LOAD DATA INFILE on server files, you must have the FILE privilege.

+1


source






More articles:


All Articles