Hello to everyone. I have an old flat database with a couple of hundred entries that I want to convert to a relational design. It was a user database for simple login and some preferences. I would like to know if there is a simple way to convert from one to the other. My idea was to dump the database for the data from the couple of tables and apply some presto chango regex and reload into the new table structure.
The way the old design was done was to have multiple tables with all unique information. When you wanted something you just joined them back into the one big flat table that they really were.
My problem is that I'm fine with flat databases. I'm just getting into INNODB. Any advise or sage words of wisdom you can provide will be appreciated. I know very little about triggers and stored procedures. Thanks in advance.