changing server with accounts with databases

[hires]

Hello,

If I create backups and restore them, then te databases are not restored. I saw some other threads about this, but I don't get it completely. I googled on this matter: how to transport complete directadmin accounts which contain one or more databases to another server. I founded related information, but it didn't give me the complete (understandable) information or howto for doing this.

Is it just that I hve to make a complete backup, restore it on the new server and do the same with the databases; so: just make a database backup and restore it on the new server within the account the database belongs to? Or am I missing some relevant and important details here?

Best regards and thanks in advance.

 

[floyd]

If you do admin level backups it should backup and restore everything including databases. You have not given us any details about how you are doing the backups. I can think of at least 4 different ways of doing backups in DA. But in fact we don't even know that you are doing backups from within DA.

 

[hires]

I am sorry Floyd, I realize now that the amount of information I gave was a bit small. Here is my situation:

I have a reseller account and would like to transfer the accounts within the reseller account to my own new server. So I probably cannot create admin backups within the reselleraccount. On the new server I have admin rights en my own license and can do everything needed. I can make backups within the reselleraccount under 'Manage User Backups' but the database seems to be unreachable when I restore the account on the new server.

So what I would like to know is how to backup the account completely, including the database(s), or how to create two databases: one for the account and one for the database, and then find a method to restore both in one account on the new server.

Thanks in advance.

 

[floyd]

Manage User Backups will also backup the databases. Still lacking a lot of information.

Are you getting an error when doing the restore? How do you know the databases are not there? Did you look in /var/lib/mysql to see if they were there? Are you switching from an old version of mysql to a much newer version in which the way they manage passwords has changed? Did you open the backup file manually to see if the sql files are in there? Do the databases appear in the user accounts created? Where is the error you are seeing leading you to believe the databases are not there?

On the new server you have to create the same reseller account first and then restore the backup from that reseller account.

On the old server you can always use phpmyadmin to backup the databases and use phpmyadmin on the new server to import the databases. But that is pretty much what the DA backup/restore system does.

You keep asking the wrong question. You ask about how to backup an account completely. The answer is what you are already doing. Now you have to ask what is happening that is making it appear that it is not working.

 

[hires]

Thanks for your message Floyd. Your tips forced me to look into the situation again and cleared up some things for me. After all I got it all working. First of all I guess I restored some old backups in the beginning; a backup of an account which didn't have the database created yet at that time. Also I mixed up the admin and a reseller account. Then I didn't see the backups in the 'Manage backups' menu, probably because I mixed up the admin and reseller accounts again.

It's clear now and after all it was pretty simple and it all works fine.

Thanks for your help; the information was probably not complete because the lack of knowledge in the first place. Now I know.