XF 1.4 importing our vb3.7 to xf1.4.2

[Ian S]

hello again doing alot with this atm so please forgive me for all the questions lol
right i tried to us the importer i read how to do it, but i cant get it to import as i get a error, we had a import done ages ago but i want to get it more update date, i filled all parts in ie database name, sysql user, pass etc didnt put anything in table prefixs or bottom line but it says this

Error
The source database connection details are not correct: No such file or directory

both sites share the server and phpmyadmin, the database for xf is there and vb is there but they both seperate

any help apprec

 

[Ian S]

thanx mike ive just found them on the server and im making a zip as there not currently in the db, so once zipped i simply import into the root of the main forum in the vb db??

i wanted to use the offline version to test 1st but get a error it states this

Error
The table prefix or database name is not correct.

i cant import the full db into the offline mysql as i get another error, its a file which has a big name i think as ive changed all the setting so no file is to big and it dont timeout either

 

[Ian S]

ok the zip failed through the host panel getting access denied so im downloading from ftp and ill zip them after

 

[Ian S]

ok that failed to access denied too

 

[Mike]

In terms of copying your database or attachment files, your host should be able to help with that if you're having problems. Unfortunately there isn't really anyone else that can properly help with that.

In terms of the error you received above, you seem to imply that you couldn't import the DB so the error is really just a testament to that. If you sort that, you should be able to get further in the import process.

 

[Ian S]

the error above is from my offline copy of the live site using xmapp, you told me to use 127.0.0.1 on the live site which worked but i cant get it to work on the offline version at all, the error on post 12 i still get on the live site, think i need to email the host as i need to try and import our current vb site over, someone did a import when the site was put up online, but we are using the main vb site until we are happy with the xf site, im not sure how they imported it tbh but i need a recent import really, i may need to email host to get more access, i though that ftp would let me do it but it dont

 

[MattW]

If it's xamp, try setting localhost as the database host.



That's one of my test installs in xamp on my laptop.

 

[Ian S]

If it's xamp, try setting localhost as the database host.

View attachment 88854

That's one of my test installs in xamp on my laptop.

its on both mate, atm the main prob im getting is in post 12, id like to try on xmapp and then live but im having major probs atm now also with access to the attachments in vb, i get access denied and cant copy

 

[Ian S]

ok guys hosts disabled open_basedir and now i get this

Error
The attachments directory could not be found.

its checking the correct location on the server here:

Configure Importer: vBulletin 3.7/3.8
MySQL Server:
localhost
MySQL Port:
3306
MySQL User Name:
forum
MySQL Password:

MySQL Database Name:
forum
Table Prefix:
Force Character Set:
Attachments or avatars are being stored in the file system. Please confirm the path to these.
Attachments Directory: /var/www/vhosts/****.org/httpdocs/attachments

 

[Paul B]

The error suggests the path you have entered for the attachments directory is incorrect.

 

[Ian S]

thats what i though mate but thats where they are, we share the server, our vb and our xf sites, on ftp if i login to admin (root) this is the correct location, if i login to the vb site its in httpdocs/attachments which i tried too and that didnt work either im confused.com

 

[Ian S]

ok ive asked the host to zip up the attachments folder in vb and they have done this, i now have the attachments.tgz is there any way i can import directly to the xf db ?? where would they need to be or do they need to be in the vb forum database, please help otherwise ill need to submit a ticket for help thanx

 

[Paul B]

They need to be handled during the import process.
You can'd do it manually post-import.

If you are having problems locating the path you should consider moving attachments to the database.

 

[Mike]

It may be a permissions issue as well (depends a lot on server configuration and how PHP is running). Copying the files over (ensuring correct ownership/permissions and entering the new path) or moving attachments to the DB would be the best way to workaround it.

 

[Ian S]

im still confused im really sorry im currently downloading the zipped attachments folder what should i do next thanx in advance

 

[Paul B]

Copy them to a directory within your XF installation directory.
Then it should be a simple matter of entering the relative path.

 

[Ian S]

unzip first brogan??? so for instance the in the root of the xf install, so there will be a attachments folder,data,install,library etc and then the usual php files all in the same directory, then when asked the path on the import where shall i direct it?? thanx again

 

[Paul B]

Yes, unzip the attachments to a temp directory so the directory structure is the same as it is in your vB installation.

Do not put them in the data and intenal_data directories.

 

[Ian S]

so put them in the root alongside data etc

 

[Ian S]

also the attachments folder is about 4gb is that ok?? also when the it asks the path to the attachments the it will be /httpdocs/attachments correct?? the dev xf site is located on the server in httpdocs

 

[Mike]

/httpdocs is unlikely to be the correct base path -- there's probably something beyond that (the path you see in FTP is not the full path). Your host would be able to tell you that, though it may also be in cPanel. That's why @Brogan mentioned the relative path (from the XF root directory).