Move DB to another a/c on same server

[TKD Dude]

Hey,

I'm trying to move a DB that I have on mysql03.powweb.com using phpMyAdmin from one account, to another, on the same server. How this be done!?

I have tried saving the DB and then running a query to upload the dump, but I get a password error, I think this is because both accounts are on the same server...?

Any ideas?

Cheers...

[Pig]

you exported to a .sql file, and then ran that file on the other database? It does not matter which server you are on. There is nothing in the dump file that has to do with servers. What error did you get?

[TKD Dude]

Error

SQL-query :

CREATE DATABASE `yabb2`

MySQL said:


#1044 - Access denied for user: 'airportsql@%' to database 'yabb2'


I'm logged in as airportsql, the database Im trying to import is yabb2 from an account where I'd log in as beaumontsql. I already have a (blank) database in airportsql called 'airporttkd' but that shoudn't matter, should it. I tried to delete that one, but It tells me that ""DROP DATABASE" statements are disabled." when I run DROP DATABASE [IF EXISTS] airporttkd

thanks for the help...

[Pig]

Well this:
CREATE DATABASE `yabb2`
means it's trying to create the database. You got this from the export tab of phpmyadmin? That is bizarre. I have never seen it do that before. Anyway, find that line in the .sql file and delete it.

You cannot create databases from PMA.

[TKD Dude]

cheers Pig,

that worked a treat, I deleted that line and another one below it "use yabb2" and it worked first time!

thanks a mil...