Phpmyadmin data backup and Restoration Methods

Phpmyadmin data backup and Restoration Methods

Data backup:

Open the Forum database in phpmyadmin and click "Export" in the menu bar. In the export box on the left, select all the tables and in the "structure" column on the right, select "add drop table", "add AUTO_INCREMENT value", and "use quotation marks in TABLE name and field name", and select "Save As file" at the bottom of the point for execution, save the backup file to the backup location. For example:

Data Recovery:

You can use phpmyadmin to restore data as follows:

Open the Forum database in phpmyadmin, click "import" in the menu bar, and click "Browse" in the "text file location" to import the exported backup data text file and execute the file. For example:

Note: This backup and recovery method is suitable for forums where the data volume is not large. When importing data in phpmyadmin on the new server, note that the database character set on the new server must be consistent with the database character set on the original server. Otherwise, garbled characters may occur. Discuz! A simple method to prevent garbled characters is to set the configuration when installing the Forum in the new space. inc. set the dbcharset in the php file to the same database character set as before migration, and then start to install the forum.