How to upgrade mysql database script production process sharing

Database script is a collection of statements used to perform various operations on database objects. The purpose is to quickly and conveniently formulate operations on the database.

1. Before making a script, you need to install the mysql database and text comparison software BeyondCompare. Database installation tutorial, please download and install .beyond compare from Baidu. After the two software installations are completed, you can start making the database upgrade script

2. Follow the steps as shown in the figure to export the database and database of the official server. Test the server database and name it according to the specified format.

##3. Open the Beyond Compare software, as shown in the figure, select text comparison, and enter the main text comparison interface, such as Select the sql file to be compared, and then the software will show the differences in the database structure as shown in the figure.

#4. Even after comparing the different structures of the two databases, it is difficult for novices in SQL statements to write an upgrade script to upgrade the database. Below we will explain how to use mysql workbench to help You write sql.

5. First, create the test and release databases in the local database. The creation steps are as shown in the figure. Then, import the databases exported in the second step into the newly created database, and then you can start working on the release database.

#6. The following takes adding a field in the database table as an example to explain the generation of sql statements. From the 7 steps in the figure, you can get the sql statement for adding a field to a table, adding, deleting, and modifying table fields, adding, deleting, and modifying table contents, and deleting a table. Let's talk about how to get the sql statement to create a new table.

#7. As shown in the figure, you can get the statement to create the table.

8. The above set of sql statements is the database generation script. The script is usually edited and viewed in the workbench. For execution, the use of several basic buttons is shown in the figure.

9. After executing the above sql script, the database structure of the official server and the test server except the primary key auto-increment value , except for the host difference, the rest of the content should be the same. If not, adjust the script content until the structure of the two databases is the same.

10. The database upgrade script at this time is still a temporary database upgrade script, and the temporary script needs to be handed over to the project leader After the review and inspection, save it as: project name + version + time + official + database upgrade script.sql, and upload it to svn for new version release.

NotesBe sure to back up the data content and structure of the database before execution in order to avoid execution errors. Restore data.

Try to upgrade the database late at night when there is no data operation.

The above is the detailed content of How to upgrade mysql database script production process sharing. For more information, please follow other related articles on the PHP Chinese website!