MySQL Table Structure

[rpeduzzi]

Hi,

I'm working on moving the content of our current mysql database into Vivvo's mysql table on our server (by way of modifying then restoring the backup file) and, at first, I seemed to be successful. But a couple of glitches (sorting problems) made me look a little more closely at the database and I noted there are at least a couple of tables (articles; users) that are nearly identically structured.

I'm assuming the data for the 'articles' and 'users' tables should be basically the same (respecting their field structure and actual names, of course).

Am I correct in this assumption ... and, are any other areas of the database I should check? I'm just not sure what else I might be missing ...

Advice is welcome! Thanks ...

[utvara]

Database structure hasn't changed that much from 3.5 to 4.0. Major change is that we moved most of the data to UTF-8 encoding, thus mosto of fields now have utf8_unicode_ci collation and use UTF-8 character set.

Have this in mind if you are trying to alter 3.5 tables by hand.

[rpeduzzi]

We're trying to move data from an old, creaky CMS into Vivvo for the first time. We're new to Vivvo, but our deployment schedule has, for better or worse, coincided exactly with the release of the new version (a little bit of a confusing time for newbies). Is there an overview of the v3.5 table structure that I missed?

All I'd really like to know is this: if a field appears in more than one table -- as in these hypothetical examples: table1:article_title and table2:article_title -or - usertable1:name and usertable2:name -- should the data match? I assume it should, but, again, I don't know what I might be missing. :confused:

[rpeduzzi]

With a fresh install -- got it figured out. Thanks.