Implement database import and export using PowerDesigner

Get the physical model from the existing database 1. Open PowerDesigner, File –> Model –> Create a new physical data model, model name is self-designed, DBMS select MySQL5.0. 2. Database –> Connect, select ODBC established by odbcad32.exe, and enter the corresponding user information to complete the connection. 3. Database –> Updata Model from Database –> Using a data source –> Select the specific table you need to reverse in Database Reverse Engineering. 4. Processing… 5. Reverse success Jump to the result page. Note 1. Modify the name field to comment and double-click the physical model box –> select column –> click customize column and filter –> check the content that needs to be displayed such as comment; 2. Add a template to display the physical model Data 2.1 Select the report button in the menu bar –> click new report,; 2.2 Select the table template (drag the table to Section, and release it when it becomes a plus sign); 2.3 Expand the table template under Sec, except for List of Table Delete templates other than Colum; 2.4 Right-click layout to select the display fields of the output file, and by default only display field comments and field types (Primary primary key, Foreign key, Mandatory mandatory non-empty); 2.5 Right-click format to edit the format of the output table, List Column Header It is to adjust the header format of the list, and List Text is to adjust the content of the list. For example, the editing method for the center of the field is format –> Paragraph –> Alignment –> Select Center 2.6 Right-click Edit Title to modify the name of the data table. Through the existing physical model, the SQL table creation statement is obtained. 1. Select Generate Database… under the database menu. 2. Switch to the Preview tab. You can get the SQL statement. Copy other databases under mysql5 to the local program. 1. Stop the running process of mysql through the program in the control panel. 2. Copy the corresponding table directory and ibdata1 file under the Mysql5/data directory into the corresponding directory of the machine. 3. Start the mysql process. 4. Use related tools to connect and enter to view specific data.