Bug #67959 | Upgrading removes content of system tables (and folders) | ||
---|---|---|---|
Submitted: | 21 Dec 2012 14:55 | Modified: | 15 Jan 2013 6:40 |
Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S1 (Critical) |
Version: | 5.5.29 | OS: | Windows (7/64) |
Assigned to: | CPU Architecture: | Any |
[21 Dec 2012 14:55]
Peter Laursen
[21 Dec 2012 15:00]
Peter Laursen
The only good thing is that the isntaller creates a System Restore Point and content of the folders can be recreated from an NTFS 'shadow copy' (provided that System Restore is turned on for the partition where the /datadir resides)
[21 Dec 2012 15:07]
Peter Laursen
Sanitized synopsis!
[21 Dec 2012 15:46]
MySQL Verification Team
I couldn't repeat upgrading from 5.5.28 to 5.5.29 on Windows 7 Pro 64-bits: Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.29-log MySQL Community Server (GPL) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like "%dir%"; +-----------------------------------------+---------------------------------------------------------+ | Variable_name | Value | +-----------------------------------------+---------------------------------------------------------+ | basedir | C:/Program Files/MySQL/MySQL Server 5.5/ | | binlog_direct_non_transactional_updates | OFF | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ | | datadir | C:\ProgramData\MySQL\MySQL Server 5.5\Data\ | | innodb_data_home_dir | D:\innodbfiles\ | | innodb_log_group_home_dir | .\ | | innodb_max_dirty_pages_pct | 75 | | lc_messages_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\ | | plugin_dir | C:\Program Files\MySQL\MySQL Server 5.5\lib\plugin\ | | slave_load_tmpdir | C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp | | tmpdir | C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp | +-----------------------------------------+---------------------------------------------------------+ 11 rows in set (0.00 sec) mysql>
[21 Dec 2012 15:51]
Peter Laursen
.. so what could the culprit be and what more information could I provide?
[21 Dec 2012 16:09]
MySQL Verification Team
My 5.5.28 configuration had the service started manually and the innodb_data_home_dir a custom configured. Now I will try to remove 5.2.29 and install 5.5.28 with defaults and test again.
[22 Dec 2012 13:11]
MySQL Verification Team
seems to be a continuation of http://bugs.mysql.com/bug.php?id=67041 ..
[22 Dec 2012 13:15]
Peter Laursen
Shane is right. The two are duplicates. My fault. The only new thing is that the 'unified' installer is not at all invovled this time - what I suspected last time to be part of the problem.
[28 Dec 2012 8:48]
MySQL Verification Team
Couldn't repeat this either. I followed the instructions exactly, on a clean Windows 7 x64 (never had mysql msi installed). Everything worked fine. o) Installed 5.5.28, checked it was running. o) Stopped the service o) Upgraded to 5.5.29, without running config wizard. Nothing went missing from C:\ProgramData\MySQL\MySQL Server 5.5\data All defaults: mysql> show variables like '%dir%'; +-----------------------------------------+---------------------------------------------------------+ | Variable_name | Value | +-----------------------------------------+---------------------------------------------------------+ | basedir | C:/Program Files/MySQL/MySQL Server 5.5/ | | binlog_direct_non_transactional_updates | OFF | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ | | datadir | C:\ProgramData\MySQL\MySQL Server 5.5\Data\ | | innodb_data_home_dir | | | innodb_log_group_home_dir | .\ | | innodb_max_dirty_pages_pct | 75 | | lc_messages_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\ | | plugin_dir | C:\Program Files\MySQL\MySQL Server 5.5\lib\plugin\ | | slave_load_tmpdir | C:\windows\TEMP | | tmpdir | C:\windows\TEMP | +-----------------------------------------+---------------------------------------------------------+ 11 rows in set (0.00 sec)