PDA

View Full Version : Unfortunalty Deleted my Attachment Table in Database

chennairam
10-03-2009, 01:39 PM
Hi Members

I am not Expert in mysql

fortunately I drop the attachment table in my forum

Now how to Reload that attachment table

Can any one help me please
Angel-Wings
10-03-2009, 01:43 PM
Oh - that data should be gone :(

Maybe there's a way, dunno

No backups made ?
chennairam
10-03-2009, 02:17 PM
I have a another forum

I made a Backup attachment table

it is possible to restore Database
Angel-Wings
10-03-2009, 02:21 PM
If you made a backup of the attachment table of your forum - yes - you can restore it. Just reimport the Database - being more specific - just the "attachment" table.

http://www.vbulletin.com/docs/html/maintenance_phpmyadmin_restore

Might be required to reparse all attachments but yes - this should work.
Lynne
10-03-2009, 02:22 PM
You can't just take some random attachment table from another site and import it to your other site (is that what you are saying you are going to do?). You would have to revert to a backup of the site you dropped the table on in order to get them back.
chennairam
10-03-2009, 02:50 PM
You can't just take some random attachment table from another site and import it to your other site (is that what you are saying you are going to do?). You would have to revert to a backup of the site you dropped the table on in order to get them back.

Actually My old attachment table size is 2.9Gb So .. shared hosting Told me To Delete attachement table

So i deleted
Lynne
10-03-2009, 02:51 PM
You realize you can store attachments in the filesystem and reduce the size of the database that way, right?
snakes1100
10-03-2009, 06:51 PM
Actually My old attachment table size is 2.9Gb So .. shared hosting Told me To Delete attachement table

So i deleted

Your host, to say the least about them and to be nice, they are MORON'S for telling you to do something like that, get a NEW host.
chennairam
10-04-2009, 02:33 AM
You realize you can store attachments in the filesystem and reduce the size of the database that way, right?

Right know no backup i have


Your host, to say the least about them and to be nice, they are MORON'S for telling you to do something like that, get a NEW host.

is there any possible to restore that attachment table
Dismounted
10-04-2009, 02:48 AM
If you dropped the table and don't have a backup - it's gone...
Adrian Schneider
10-04-2009, 03:42 AM
Your host, to say the least about them and to be nice, they are MORON'S for telling you to do something like that, get a NEW host.
Yep.

Switch hosts. They are morons and obviously do not care about what is in your best interest.