copying a database from one account to another

[CSS]

Hello,

I have a resseler account. I want to copy a database of about 100MB from one account to another.

I tried to do this with the backup utility (backup db in one acount -> restore db in another account) but it didn't work. I exported the db from phpmyadmin and then I tried to import it from the phpmyadmin of the other account but it doesn't work again. Either id does nothing, or I get a database 300 second execution time out (or something like that).

The only way it work if I enter the INSERT lines a chunk at a time. But this will take ages with a 100MB database...

What is the solution?

[-Oz-]

if you have a .sql file I believe Andrew can load it for you. Not completely sure though. Try submitting a trouble ticket about it.

[james]

The best option would be via the command line (ssh).

mysqldump should do the trick.

You can then use ftp to transfer this between the 2 accounts, then reimport.

I can't remember the exact syntax though.