Error when restoring DA backup from mysql to mariadb

P

peps03

Verified User
Joined
Oct 24, 2013
Messages
192
Location
Amsterdam
Hi,
I'm moving some users to a new vps. The old vps has centOS6 and mysql, latest version. And the new vps has CentOS7 and MariaDB 10.1. Both use custombuild 2.0.

I've exported the users via DA admin and imported them on the new vps also via the DA admin. The files are imported correctly but the database import gives problems:

Error Adding Main Username to database: Can't find any matching row in the user table
Unable to restore database XXXXX&#95wp&#49.sql to XXXXX_wp1 : ERROR 1045 (28000): Access denied for user 'XXXXX'@'localhost' (using password: YES)

When i login to phpmyadmin on the centOS7 vps, the db is created and i can manually import the db and all is ok.
Why isn't the backup restore going correct?

Thanks!
 
OK! Thanks for your reply.
Any idea when the update will be rolled out?
Or could I update this issue manually?
 
Thanks. I see i need a client login for downloading. https://www.directadmin.com/clients/index.php
Where could i find my login credentials? I know my client ID, but i think my vps host is the license holder, so only he would have the pass? Or..?

Any idea when 1.49.2 will be released? (So i can decide if it is worth the time investigating how to fix this manually...)

We have to move many user accounts so this issue being fixed would help us a LOT!
 
Last edited:
I am also facing the same problem on MariaDB 10.1 and have no access to customer panel.

Any chances on making stable release out of 1.49.2?
 
OK. I couldn't wait for the release of 1.49.2 so here's the fix for anyone affected with this problem.

Edit MySQL configuration file /etc/mysql/my.cnf and add just below [mysqld]:
Code: 
sql-mode="NO_ENGINE_SUBSTITUTION"

save the file and restart mysql with
Code: 
service mysql restart

This should fix the problem.
 
Any update to DA 1.492? This bug exists for over a month..

//Edit

Solution that huan posted works perfectly. Thanks.
After the imports i removed the line again and everything is running fine.
 
Last edited:
You must log in or register to reply here.
Back
Top