Maria DB to mysql

[djscooby]

Hi guys

Im facing a big issue with databases, i installed kloxomr today on another machine with all defaults.(mysql)
the problem is that none database backup works, databases restored all empty!

My previous kloxomr used mariadb as database engine with aria
1)i converted database to innodb and then took backup from old and restored to new.. still empty
2)Manually exported from php-myadmin from old to new and have errors like :

Code: [Select]

CREATE TABLE IF NOT EXISTS IF NOT EXISTS  `wp_xxxxxxxx_xxx` (

 `id` INT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 `bg_type` VARCHAR( 10 ) NOT NULL ,
 `bg_url` VARCHAR( 255 ) NOT NULL ,
 `bg_thumb_url` VARCHAR( 255 ) NOT NULL ,
 `bg_position_y` VARCHAR( 10 ) NOT NULL ,
 `bg_position_x` VARCHAR( 10 ) NOT NULL ,
 `bg_repeat` VARCHAR( 10 ) NOT NULL ,
 `bg_attachment` VARCHAR( 10 ) NOT NULL ,
UNIQUE KEY  `id` (  `id` )
) ENGINE = INNODB DEFAULT CHARSET = latin1 PAGE_CHECKSUM =1 AUTO_INCREMENT =34;

MySQL returned error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1 AUTO_INCREMENT=34' at line 17

What can i do ? Any idea ?
i thought MariaDb is compatible with mysqli ?

[MRatWork]

It's ok with mariadb.

To make sure, no 'skip-innodb' inside /etc/my.conf or /etc/my.cnf.d/my.cnf.

[djscooby]

Thanks MR for answering.. i folowed this viewtopic.php?f=5&t=2158&p=5109&hilit=Aria+Engine#p5109


returned to mysql and now backups works...