You may want to check your /tmp partion. it may be creating some temp tables.
-t, --tmpdir=path
Path for temporary files. It may be useful if your default /tmp directory
resides on a partition too small to hold temporary tables.
Byron
[EMAIL PROTECTED] wrote:
> Hello All,
>
> Background:
> -Site has 8000 uniques per day, average of 300 online at once hammering the
> forums.
> -POST table has over 350,000 entries
>
> When doing a backup with mysqldump and then trying to re-import the data to a
> test
> server, we keep getting:
> ERROR 1030 at line 207477: Got error 28 from table handler - No space left on
> device
>
> Is there an way to remedy this problem? Obviously we have a
> setup error or something as there is a 20gig drive in the mySQL
> server.
>
> mysql database
> Mike(mickalo)Blezien
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225)686-2002
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
