Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Steps to reproduce:
1. Download MySQL 5.5.x tar.gz file and extract it somewhere
2. Use MySQL to install the database into some directory by using:
cd /path/to/MySQL
./scripts/mysql_install_db --datadir=/path/to/mysql_datadir
3. Download MariaDB 5.3.x tar.gz file and extract it somewhere
4. Start the MariaDB server with the datadir, that you installed MySQL in.
cd /path/to/MariaDB
./bin/mysqld_safe --datadir=/path/to/mysql_datadir &
5. Log into MariaDB
./bin/mysql --user=root
6. Try to execute the following command into SQL:
SET GLOBAL EVENT_SCHEDULER = ON;
Result:
You get the following error: "ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start".
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 881454
Re: MariaDB is incompatible with MySQL system tables when changing EVENT_SCHEDULER
While upgrading/crossgrading from MySQL to MariaDB, the usual upgrade instructions given in MySQL manual still apply.
(see http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html)
This would resolve the problem with the event scheduler which is caused by the difference in table format between versions.