load fasta and gff3 file into mysql

Question

[82101202089]

Recently, I needed to make a database --MySQL.

I need to import the FASTA file and annotation file for the reference genome into the database.

But I can't find a good way. I hope I can give you some suggestions. Thank you

[Pierre Lindenbaum]

load fasta and gff3 file into mysql

what's your aim with such database ? because a simple LOAD local DATA INFILE "the.gff" INTO TABLE gff COLUMNS TERMINATED BY '\t' IGNORE 1345 LINES would work?