upload databse problem

[TsUyOi]

hi, here is my problem.
let say my old database name is tsuyoi_1 and i would like to change tht databse name to tsuyoi_2, but as we know we jz can change db username and pass. So i create a new database name tsuyoi_2 ... i download tsuyoi_1 databse to my computer. Then i try to use upload system under MySQL Management. Whats my problem is when i upload it appear >The page cannot be displayed my db about 85++mb. what should i do now?

[Webcart]

Originally posted by TsUyOi
hi, here is my problem.
let say my old database name is tsuyoi_1 and i would like to change tht databse name to tsuyoi_2, but as we know we jz can change db username and pass. So i create a new database name tsuyoi_2 ... i download tsuyoi_1 databse to my computer. Then i try to use upload system under MySQL Management. Whats my problem is when i upload it appear >The page cannot be displayed my db about 85++mb. what should i do now?

If you have SSH access to the server, you can dump the whole database into a file and then import it into the new database - all from the command line.

Web based tools aren't really suitable for managing database files of this size.