Unable to export

[shoppingtelly]

I have had to change hosts as I keep going over the 40g bandwidth, I am trying to move the database but am unable, I thought at first it was too big, but I started off by removing all images, smilies, avatars, it made no difference to the size in phpmyadmin.

So I pruned to posts back so I now only have threads from the past 365 days, went back to phpmyadmin and it is still 58.3MB with posts not going down at all standing at 33.6mb, each time I try to export I get the error message below, PLEASE can anyone help.

Thank u

Warning: MySQL: Unable to save result set in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php on line 120

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/ob.lib.php on line 65

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/header_http.inc.php on line 14

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/header_http.inc.php on line 15

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/header_http.inc.php on line 16

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/header_http.inc.php on line 17

Warning: Cannot add header information - headers already sent by (output started at /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/mysql_wrappers.lib.php:120) in /homepages/33/d39084293/htdocs/shopping/phpmyadmin/libraries/header_http.inc.php on line 20

Database db39550518 - Table post running on db62.oneandone.co.uk:3306
Error

SQL-query :

SELECT *
FROM `db39550518`.`post`

MySQL said:

MySQL client run out of memory

Back