PDA

View Full Version : user table export/import


Rich
09-06-2004, 10:44 PM
Hello,
I know this is possible,but I need some guidance. I have a version of VB that has some corrupt tables. (Don't bother asking about the backup...it isn't working either.) Anyhow,I went into phpmyadmin and I can see that the user table is still intact. What I would like to do is take the user table,and send it to a clean install of VB. I would also like to do the same for the threads and posts on my site.
I need some serious direction with this. I am new to phpmyadmin. If you know of a script that will allow me to do so,send it along. otherwise,directions to do this manually would be a godsend.

Thanks.

rake
09-06-2004, 11:47 PM
Have you tried repairing the tables first?

Rich
09-07-2004, 12:19 AM
Hello,
If I had access to my site and I could repair them,I would. Currently,all I get is the error page. If you have a suggestion,I am open to it!

rake
09-07-2004, 10:04 AM
Ask your host for SSH access, and then use myisamchk to repair the corrupt tables. Or, i'm pretty sure some repairing options are also available in phpmyadmin.

Dean C
09-07-2004, 11:23 AM
Backups should be made periodically to prevent problems like this ever occuring. Nevertheless, there needs to be a lot more tables than the user/post/thread table to get your board fully functioning again. I don't really know what to suggest. What tables are corrupt?

This is untested, I've only just noticed this in the vB3 zip file. There is a folder called do_not_upload. Inside of it there is a file called tools.php. Try uploading it to your admincp directory and see if it loads. If it loads we can go from there.