资 源 简 介
MySQL database management — clean, import and export data
Purpose
Command-line utility to create a hot backup of databases with the possibility of subsequent recovery.
The script is a high-level wrapper for a mysqldump and mysql programs.
Features and advantages
Export-Import works at 20—35% faster than using a single large *. sql file that combines the structure and data.
Data of tables are stored in *. txt files (tabular format, binary charset). The file names match the names of the tables.
Description of tables stored in two *. sql files (UTF8 charset). dump1.sql — table structure, functions and procedures; dump1.sql — triggers.
Export InnoDB tables is performed in a single transaction. This ensures data integrity and does not lock the database during export.
In Russian
Назначение