Layout And Copy Data Schema
I have a dedicated server with multiple MySQL and PostreSQL databases. Four of these databases are large and these are the three this project is for. Over the last couple of years I have had numerious database administrators and programmers optimizing the structure of these databases. As a result I have no documentation showing the table layout structure or anything related to the data schema. You may be able to pull this from phpmyadmin and do the backups from WHM – cPanel. I have no idea but if you reading this I assume you would know.
I would like to know the exact database layout structure (schema) of the following:
http://www.salesdatainc.com/list.php?page=members&action=consumers
http://www.salesdatainc.com/list.php?page=members&action=buy
http://www.salesdatainc.com/list.php?page=members&action=consumers_new
http://anybirthday.info/xuid
I would like to have the database and structure saved to an external drive that is connected to the server. This is to assure I have a copy of the database and structure as I will be moving it to another server in the near future.