August 14th, 2000, 11:05 AM
Okay, I am new to the MySQL arena and I have a question - is there an easy and preferrably graphical interface - anything that is easy - on how I can convert data to a format that is MySQL compatible?
I just seem to not be able to find anything and would appreciate some guidance.
August 14th, 2000, 04:02 PM
Well, this all kind of depends on a couple of things. First and foremost, what format is your data in at the moment? Is it stored in flat files, or another DB, or some other method? Secondly, what do you want to do with your data in MySQL? If you want to do anything more than very simple queries it makes sense to spend some time carefully designing the structure of your DB to ensure that it is easy to maintain.
There are tools available to import data from tab delimited files into MySQL (mysqlimport being the obvious choice), but you generally need a table structure already defined (I think, I've not really used them before). Check the MySQL page for more details.