Couldn't be all good right?
The table names and column names are, in fact, different.
I can now see the options, and now it will be a question to dig in and do some tries.
MySQL Migration Toolkit could also be a possibility?
For some weird reason that I cannot explain, it hasn't been granted access to me on phpmyadmin webapplication.
edit: assuming that I will, by hand, take care of all fields and table name differences. (they are not to many).
I will also need to populate some fields with random data (depending on the field, the values could be numbers only or alphanumeric).
Can we accomplish this on the mysql query as well, or a php functions needs to be used? (this is a more specific question that I can later on see, but still... if it is a quick answer, please let me know).