Moving files from phpbb2

[doemasters]

New to the forum and vbulletin and seem to be having trouble moving my old database from my old server space on siteground to the one on reasyhosting using the impex program.

I keep getting the error message
Connection to source server failed. Check username and password.

Is there anyway of me backing up the database to my harddrive and loading it that way?

Thanks for your time
Lance

[snakes1100]

Are you putting the correct info in the impex config file?

The error stated incorrect info.

[doemasters]

i thought I was but no idea, trying to make sure i have all of the onformation right from the old server place but they are not being much help so far

[snakes1100]

export the db from the old host and import it into a new db on the new host, then correct the config file and then do the impex merge.

[mescalin]

hello,

First of all i have to warn you about Siteground never work with them they are not hosting sites they are stealing money.. And also i experienced the same problem they want about $50 for your db backup, they suspended my site because of heavy traffic, about 15-20 person in the same time and they reject to refund..

Anyway first go to your cpanel ---> mysql databases (create a new db called bckup) ---> phpmyadmin then select your db, go to operations and copy your existing db to bckup..

then open bckup click export, select all tables and at the bottom of the page tick save as then go..

The reason why i said you to create a new db and copy your existing db to backup is, if you try to download existind db it keeps corrupting db and premature ends..

I have worked with more than 7-8 hosting comp and siteground is the worst. Never work with them..

[doemasters]

thanks and i figured that about siteground as well, all i was doing once was hosting pictures on the site which did get some traffic and they told me i needed a dedicated server if i planned on having that many people come in. They actually shut my site down for a few days even though it hadn't went over the bandwidth. Also i have noticed on all their extra items they include for some reason the spy bots are always there within a day or so which make them useless

Thanks for the help and I will try what you suggested

lance

[doemasters]

i finally got the database over to my server but when i start the mudule for check and update database i get this information below and it want let me go any more. Any ideas on what I did wrong?

Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :

Possibly custom tables or incorrect prefix :

attachments NOT found.
attachments_desc NOT found.
auth_access NOT found.
banlist NOT found.
categories NOT found.
config NOT found.
confirm NOT found.
disallow NOT found.
forum_prune NOT found.
forums NOT found.
groups NOT found.
posts NOT found.
posts_text NOT found.
privmsgs NOT found.
privmsgs_text NOT found.
ranks NOT found.
search_results NOT found.
search_wordlist NOT found.
search_wordmatch NOT found.
sessions NOT found.
smilies NOT found.
themes NOT found.
themes_name NOT found.
topics NOT found.
topics_watch NOT found.
user_group NOT found.
users NOT found.
vote_desc NOT found.
vote_results NOT found.
vote_voters NOT found.
words NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :

phpbb_ Failed Check database permissions and connection, or table prefix to ensure its correct