MariaDB Command to update MariaDB 10.0.x ?

@eva2000 will switch soon to AXIVO MariaDB 10, once he completes the benchmarks.

 

What happens if I lose connection at the point where it is running the upgrade queries? How do I recover to that point?

 

Yea I usually do screen but somehow managed to not do it this time. Got it all sorted out.

 

What does InnoDB = On do in my.cnf? Its auto commented out on upgrades.

 

So having it commented out is the same as having InnoDB = On since it is the default engine in MariaDB right? Is it actually XtraDB?

 

Code:

show engines;

This gives me the following:

Code:

MariaDB [(none)]> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                                      | NO           | NO   | NO         |
| InnoDB             | NO      | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | NULL         | NULL | NULL       |
| ARCHIVE            | NO      | Archive storage engine                                                     | NULL         | NULL | NULL       |
| FEDERATED          | NO      | FederatedX pluggable storage engine                                        | NULL         | NULL | NULL       |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                     | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)

I need to enable Innodb.. I've commented out the skip-innodb by doing:

Code:

#skip-innodb

..I've restart mysql with no luck.

Any ideas?

I'm a newbie, go easy on me!

 

UPDATE:

Fixed it. I had to remove the lb_LogFileXXX under the directory /var/lib/mysql/ and restart MySQL.