Migrate MySQL databases

A

alessandro123

Verified User
Joined
Sep 11, 2008
Messages
46
Hello,
are there any ways to migrate some MySQL databases from on DirectAdmin host to a dedicated MySQL server?

I know how to dump and restore databases, but are there any script that will migrate even database users?
 
NO there is no script. Use the mysql commands on ssh. If you dump all databases then I guess you have the mysql.user table right :)
 
But manually i'll have to check every mysql users.
Maybe that with a DirectAdmin database backup users will be checked automatically and saved to the dump file?
 
Welll you should backup all user db (each user) delete the database, reocnfigure DA for use external DB and reimport backups so DA will create backups/users/content..
The problem is that you have to make a backup and a restore for each user, cant use admin backup for that.. or well you can but... maybe overload the server

Not sure
 
I have to backup user's db with a standard mysqldump or from DirectAdmin?

I don't think that standard mysql dump will backup even database users, but only databases.
 
alessandro123 said:
I have to backup user's db with a standard mysqldump or from DirectAdmin?

I don't think that standard mysql dump will backup even database users, but only databases.
Click to expand...

Yes it does if you get the mysql db.
 
You must log in or register to reply here.
Back
Top