MySQL Data Migration Question 1

MySQL Data migration problem 1 MySQL Data migration is relatively simple, but there are several points to note :? When the InnoDB engine is enabled, there is a configuration item in my. ini: innodb_log_file_size must ensure that the configuration value is the same before and after transplantation. Otherwise, the service cannot be started. If you do not know the value, view the log? InnoDB: Error: logf

MySQL Data migration problem 1 MySQL Data migration is relatively simple, but there are several points to note :? When the InnoDB engine is enabled, there is a configuration item in my. ini: innodb_log_file_size must ensure that the configuration value is the same before and after transplantation. Otherwise, the service cannot be started. If you do not know the value, view the log? InnoDB: Error: log f

MySQL Data Migration Question 1

MySQL Data migration is relatively simple, but pay attention to the following points:

?

When the InnoDB engine is enabled, there is a configuration item in my. ini: innodb_log_file_size

Make sure that the configuration value is the same before and after migration, or the service cannot be started.

If you do not know the value, view the log

?

InnoDB: Error: log file .\ib_logfile0 is of different size 0 359661568 bytesInnoDB: than specified in the .cnf file 0 56623104 bytes!140525 17:21:20 [ERROR] Plugin 'InnoDB' init function returned error.140525 17:21:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.140525 17:21:20 [ERROR] Unknown/unsupported table type: INNODB140525 17:21:20 [ERROR] Aborting

We can see that the log clearly shows the original innodb_log_file_size and the current innodb_log_file_size, and changes the current configuration to the original one.

?

?