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

[NTLDR]

Do you have SSH access to the server? Its much easier and faster to do a reliable backup via the command line.

[shoppingtelly]

Yes was all going well via SSH till asked for password, phoned 1&1 Internet and they said, we don't support it used phpmyadmin but would not help any further. No idea why 1&1 offer SSH when they will not support, supose that another issue and will be away away from them as soon as I can move the database.

[NTLDR]

Sound odd, give this a shot in an SSH window:

mysqldump --opt -uUSERNAME -p DB_NAME > backup.sql

Replace USERNAME (note the lack of space after the -u) with the username you have entered in your vB config.php and do the same for DB_NAME with your database name, when it asks for a password enter the one thats in config.php.

Is the servername in config.php localhost? If not thats probably why it doesn't work.

[shoppingtelly]

Not its not set to loaclhost, does that mean I will just have to beg 1&1, they sounded as if they didn't care less this afternoon.

Who would have set the SSH password 1&1?

Thank you again

[NTLDR]

If the value isn't localhost then its probably because the server with the database is different to the server with your website and SSH access.

vB has a built in backup option to generate a DB backup, try using that, but make sure you keep your database intact as sometimes the backups it produces are not 100% reliable.

In vB3 its under Import & Maintenance in the ACP menu, and in vB 2 (IIRC) its somewhere near the bottom.

[shoppingtelly]

Sorry have tried that as well and just times out.

[NTLDR]

Do both options for it time out? There should be an option to download it, or backup to the server. If they both time out as a last and unpractical resort you can try downloading a table at a time via vB's ACP (it lists each table and if you want to back it up or not).

[shoppingtelly]

They all time can do each individualy except the posts and they time out, time to beg top 1&1 I think.

Thank you for the advice, think this is down to 1&1