Reseller level backup does not include Mysql user information (DA v. 1.23.0)

[eroloz]

Hi,

I should move all accounts from one server to another as soon as possible.

Old server is RH 8 with DA 1.23.0
New server is RH 9 with DA 1.25.4

My plan is to backup all user accounts in Reseller Level, and then restore them to the new server in Reseller level again.

My problem is with the accounts which contain MySQL database. When I create a backup for a user, and then try to restore it to the new server, old to the old server (for testing), I get the error "Unable to restore database the_db.sql to the_db : ERROR 1045: Access denied for user: 'the@localhost' (Using password: NO)
".

I have searched all the forum but could not find any hint.

Then I have examined the backup file (tar.gz) created by old server. The result is that:
There is no user information in backup archive. There should be entries for user/password info in the_db.conf, I think. The only entry in it is accesshosts information.

Can anyone give me hint on it, how can I fix it to craete proper backups.

 

[nobaloney]

If you've not yet done so you should:

If you're a sytem administrator, contact DA support.

If you're a reseller, contact your provider.

Jeff

 

[eroloz]

Thanks Jeff,
I am the system admin.
I am leaving that version, and I have 10 databases on it.
So, I decided to add that information manually. It worked.

 

[harro]

hi Eroloz,

this is quite an old post, but I have the same problem with restoring user backups on a new system. How did you fix this, in the end?

Thanks for your feedback!

Harro

 

[eroloz]

Hi harro,

It was long time ago, and I cannot remember exactly what I've done.
Generally speaking, I have:
- extracted the backup archive
- edited the file "*_db.conf" under the folder "backup"

I have no sample file to recall what was the problem with that file. If you paste content of your *_db.conf file here, maybe I can tell you what to do.