Import SQL backup file?

[SloppyGoat]

Is this the oldest version that will import? Maybe that's my problem? I'm still running 2.3.0. Do I have to upgrade to this version before importing?

[SloppyGoat]

Nope, I just tried it. Same error.

[SloppyGoat]

Since I can't seem to get any help on this, is it possible to import from an SQL backup file? Come on vBulletin people!!! Help me out here!!! I'm not getting any helpful solutions to getting my database imported! I'm beginning to get irritated.

[SloppyGoat]

Or how about this? Can I copy the entire database folder to this server and somehow add it to MySQL, run it tandem, and import it directly from there? Come on!!! Give me some answers! There has to be a way to do this, right? I'm not feeling too supported right now. :(

[SloppyGoat]

I can't even get to a mysql prompt on this install. Will someone enlighten me for crying out loud? It never allowed me to create a user, like I remember the last time I installed MySQL years ago.

[SloppyGoat]

Why do none of my users seem to show in member list or member count? Are they there somewhere? How do I get them to show up?

Nevermind. I finally found it. Lots of editing to do.

[Mitrofan]

I think so. I still have 2.2.8, so I downloaded the 2.3.10, ran seveal upgrade scripts to get my vb to 2.3.10, then installed the latest 3.6.2, installed ImpEX and started importing. Everything seems to work without any problems exept for the way mysql handles the query with LIMIT clause. Read my post "Important Issue with ImpEX" and if you have a very large tables (over couple million posts) then you should change a couple of lines in 000.php but only when you get to the importing posts stage. It's not absolutely necessary but without it it may take a couple days to complete the import and will overload your server.

[SloppyGoat]

Nope, it didn't matter. I was finally able to import it from 2.3.0.

[SloppyGoat]

Ok, so now that I finally got everything imported, I have some extra usergroups that really don't need to be there. I have default groups and custom groups, some of which are the same....like Registered Users. Is there a way to delete the unused usergroups? Surely I don't need two usergroup ID's for the same usergroups.

[edit] I see I can delete custom usergroups, but is there a way to transfer the users in some of my custom usergroups to the default usergroups? Unless I can do that, I guess I'll always have two sets of registered users?

[SloppyGoat]

My imported smilies don't have the correct path. Instead it says images/smilies/images/smilies. Well, that's easy enough to fix. I created a custom smilie folder and uploaded all my smilies to that folder. I can edit the path for each individual smilie, but that's going to take a long time. Is there someplace I can change this path globally, so I don't have to edit them one at a time? Also, that's the path of every image in the forum threads. Those will need to be corrected too.

Actually, the generic smilie path isn't correct either. They have the same double path for some reason.

Please advise.

[SloppyGoat]

Is this something I can change in the database that would reflect globally? Is there any support team here?

[SloppyGoat]

Nevermind. Support here is so slow, I can figure it out myself before anyone even replies, most of the time. Anyone else having this problem, this is the answer...

http://www.vbulletin.com/forum/showthread.php?t=143122&highlight=smilie+path

[Steve Machol]

Please follow the 'After the Import' instructions here:

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

This should solve those issues.

[SloppyGoat]

I see. So basically, if I delete any group besides Registered, I have to reconfigure any other groups, such as mods?

[Steve Machol]

Sorry, I don't understand what you mean:

"if I delete any group besides Registered, I have to reconfigure any other groups, such as mods?"

Please explain.

[SloppyGoat]

It puts any users from any custom group into Registered users, including mods, supermods, admins, and any other groups.

[Jerry]

Since I can't seem to get any help on this, is it possible to import from an SQL backup file? Come on vBulletin people!!! Help me out here!!! I'm not getting any helpful solutions to getting my database imported! I'm beginning to get irritated.

No it isn't, ImpEx imports from a database not a SQL backup file, you will have to restore the database.

Also stick to one and your own thread.

[SloppyGoat]

Yeah, it's a moot issue now. I figured it out by myself, with days of frustrating research.

[Jerry]

Yeah, it's a moot issue now. I figured it out by myself, with days of frustrating research.

ImpEx says it imports from a database, not by parsing a SQL file that is designed to be used to restore a database.

I recommend you stick to your own thread and keep everything here.

[SloppyGoat]

Why did you delete my post? :confused: I found out it did actually work, but the changes did not show until the user went and resaved his sig. In the sig field, the slashes were gone, but not under any posts.

[Jerry]

Why did you delete my post? :confused: I found out it did actually work, but the changes did not show until the user went and resaved his sig. In the sig field, the slashes were gone, but not under any posts.

Because I have asked you to keep to your own thread so support and I can follow the issue and respond accordingly, hence why I merged your six threads into one, as they are issues with the same import, keeps all the information needed in one place.

[SloppyGoat]

Yes, I know. I was having trouble getting it to work due to mysql privileges, but like I said, it's sorted now. You can even del this thread if you want. I wish you were around when I was trying to figure it out.

[Jerry]

Yes, I know. I was having trouble getting it to work due to mysql privileges, but like I said, it's sorted now. You can even del this thread if you want. I wish you were around when I was trying to figure it out.

This thread is the collection of the others you've started; I don't think that would be wise if you still have questions.

[SloppyGoat]

Well, when someone has already explained a problem completely, it's usually the proper place to post about that same issue, is it not? Otherwise, I'd just have to retype everything he just typed above. Seems kind of goofy. Most forums operate on the concept that if there is a thread that already is discussing the topic you want to post about, it's better to use the existing thread than to create a new (and almost duplicate) thread. When I do a search and find someone that has/had the exact same problem, it seems only normal to post in that thread. But ok.

[SloppyGoat]

Nope, I've solved all the problems in this thread. You can del it. If I come up with any new questions, I'll start a fresh thread. (after searching, of course)

[SloppyGoat]

Is there some way to make cleaner only apply to one forum id? I need to remove all the url tags, but only in one forum. Surely this can be done? Mucho gracias to the one who knows how. ;)

[Colin F]

There's no such function, you'd have to manually adjust the cleaner.php file to limit it to a specific forum.
You might receive help with this on www.vbulletin.org

[SloppyGoat]

You guys should clean this up and make a nice GUI with some options like that. It would be very useful for some people. Being able to choose what to replace, in which forum(s) would definitely be a nice utility. It's not far from that, if someone would just finish it, right? I know there were similar hacks for earlier versions.