MYSQL DB transfer

[cybercavern]

I have a DB that is over 20 MB that I need to transfer to a new DB name on a new user name.
I have changed the php.ini file
post_max_size
upload_max_filesize
memory_limit
to allow 30 MB for this transfer.
When I upload in phpmyadmin I get.

Fatal error: Allowed memory size of 31457280 bytes exhausted (tried to allocate 22986380 bytes) in /var/www/html/phpMyAdmin-2.6.4-pl1/libraries/read_dump.lib.php on line 23

Any help you can offer will be greatly appreciated.
Thank You

 

[Aspegic]

What I do if I need to do this is just copy the .frm .MYD and .MYI files from /var/lib/mysql/username1 to /var/lib/mysql/username2.
Just make sure that after copying the files keep the same file-access rights (660 if i'm not mistaken) and user/group ownership ("mysql").

 

[jmstacey]

Just remember to shut down MySQL beforehand.

 

[cybercavern]

I have already transfered the files without shouting down the mysql is this going to be a problem??

 

[jmstacey]

If it's working fine then probably not.

I just know it's a problem when doing the same thing through sysbak. (consistency)

 

[cybercavern]

It's working great thank you for your help.