Moving a database to a different user not working

infiltrator

Verified User
Joined
Jun 8, 2006
Messages
41
Hi,

i'm moving websites from server1 to server2 under other resellers / users.

Moving the account to server2 its simply done through the backup/restore function.

Changing the domain to a new user is also easy.
guide http://help.directadmin.com/item.php?id=58

Now i want the database to be owned by the new user, so i can delete the old user.
I tried several things, making a new db user and followed guide http://help.directadmin.com/item.php?id=224

But everytime i delete the old user, the database gets deleted to.

How can move the db from user1 to user2, so the db shows up in the mysql panel and i can safely delete user1 without loss of the db.
 
Hello,

Create a new DB, then you can copy/remove content from one DB to a new one in shell, or in phpmyadmin.

In shell you can use cp/mv to do that, or within mysql session.
 
I tried it that way with a db program, but did not work.

After your reply, i retried it within phpmyadmin, and that worked.

thx
 
Back
Top