Problem with restoring database

[Lesane]

I am busy with restoring my database to a new server, i use the command what it says on the movingservers.html page:

from the root, type mysql -uUSERNAME -pPASSWORD newdbname < /path/to/dump.sql

when i type that in telnet i receive this error:

"ERROR 1030 at line 55178: got error 122 from table handler"

When i try 2 check my database thru phpadmin, to c what he did then i c the tables till the attachment, so it went wrong in the attachment table.

Does anyone have a solution?

[Lesane]

is it possible to backup the database without the table "attachments"?? (The backup @ the admin dont works.)

[Steve Machol]

bash:~$ perror 122
Error code 122: Disk quota exceeded

You need to free up some space.

[Lesane]

thanks for the reply and probably the solution. I start with making some free space.

[Lesane]

i checked but the disk quota is 1gig
and i just get told that this is a mysql error and not a prompt error, not a bash error. Its not related.

Do you have any other solutions because my board is offline now and i'm waiting till i can restore my database to my new server.

[Steve Machol]

I'm out of ideas. I think you should enter an official support request.

http://www.vbulletin.com/support/

[Lesane]

aight, thanks. I will fill that official report in but one question: Is it a problem if i drop the table "attachments", backup the database and try 2 restore the database to the new server, so without that table "attachments". ?

I already disabled attachments on my board.

[Steve Machol]

If you drop 'attachments' then all the existing attachments will be deleted. Is this what you want? Either way, I'd make a backup before and after dropping this table - just in case!

[Chen]

If you are dropping the 'attachment' table you will also need to run this query:

UPDATE post SET attachmentid=0

[tubedogg]

Few things to keep in mind...

The quote that Steve posted is of how the nature of the error is determined, and has nothing to do with bash (that is merely the command prompt). The error is that you are out of disk space. Despite what your quota is, the partition that MySQL is using is either very close to or completely out of space and this will likely not be helped by you freeing up space as it is probably on a different partition than you.

You will need to contact your host.

You can verify the problem by loggin in via telnet and running the following command:
df
If any come back as 100% (or close to that) you indeed have a space issue. Particularly you are looking for one labeled
/var

[Lesane]

Thanks for the replies. I dropped the "attachment" table but still received that error.

I contacted the host from my new server with the problem about that freespacing and they cant fix it. They suggest me to make a zip from /home/mysql/vbthing of my currently server/host and put it then @ their server, but i have 2 contact my host first , because i have no permission to do that.

The command df in telnet gave this answer:

Filesystem 1k-blocks Used Available Use% Mounted on
/dev/hda1 743466 591474 151992 80% /
/dev/hda3 198601 16928 181673 9% /var
/dev/hda4 17671528 647603 17023925 4% /home