Is it time to shift on VPS from shared hosting for my site?

[bxflow]

those tables are corrupted

[SuicidalMedia]

If you read his whole thread you would have know that he couldn't repair it too. So InFlames dropped those 4 tables from his current database, and imported those 4 tables from a database of fresh installed vBulletin.

[Arthur]

I was having that error jason, but then i replaced that file with old database the this error was fixed but these new errors occured

those tables are corrupted

how to fix that tables then?

If you read his whole thread you would have know that he couldn't repair it too. So InFlames dropped those 4 tables from his current database, and imported those 4 tables from a database of fresh installed vBulletin.

well jason I got it but look there are three fields for this table



which one should be imported?

[bxflow]

"If you read his whole thread you would have know that he couldn't repair it too. So InFlames dropped those 4 tables from his current database, and imported those 4 tables from a database of fresh installed vBulletin"


import the ones that show corrupted

[SuicidalMedia]

It's not about the file replacing, It's about tables. And replace those 4 tables. And your problems will be fixed.

[Arthur]

jason why don't u solve this issue?
take my team viewer id and solve it as am not good in SQL

[SuicidalMedia]

I don't have TeamViewer, neither I have any vBulletin installation on my laptop. So I couldn't provide you those 4 fresh tables.

Basically, the all magic of that is:

- Login to "PHPMyAdmin"
- Select the current database
- Click on those tables that have to be replaced, one by one. There is a "Drop" button in the navigation when you click on some table. Click it. When you finish all install a fresh copy of vBulletin on your localhost.
- Login to "PHPMyAdmin"
- Select database.
- Click export.
- Select those tables you need to have imported, save it as .sql , or just copy/paste it as text, and paste it to execute it as a query in PHPMyAdmin.

Again login to the PHPMyAdmin, but this time on your hosting. Select the current database, click "Import" , It's in navigation. Import that .sql file, it will automatically create those tables in that database. Or just click "SQL" and paste the text to execute it as a query, and it will create the tables in the database just as importing it as .sql file.

[Arthur]

Ok i try this then let you know guys

[intellecthost]

arthur i can try to resolve that

give me ur teamviewer id Pm me that

[Arthur]

Ahhh at last i did it.
There is no error Jason. I did as it is like you said and now there is no table error
thank you so much for your great help
Thank you so much

@ bxflow and others
Thanks to all of you again
you guys fixed my most horrible problem

Thanks once again