vB 3.54 > vB 3.54

[mredwardlee]

Ok

I would just like to make sure.
I have to install the IMPex on both databases?
Or just the one I'm Importing in onto?
To get the Export File, it is the one that you get when you backup the database?
Because all I want to do is import the threads, posts and settings from my old forums to a new one on a new domain. They are the same versions...

Although I don't even know if I'm supposed to use IMPEx

Any Help ? Thanks!

[Scott MacVicar]

You dont need to import, you can just backup the old database and restore to the new database.

See http://www.vbulletin.com/docs/html/moving_servers If you are on the same server you still follow the steps here you just dont need to transfer the backup between the boxes.

[mredwardlee]

Hello, I just installed that Putty thing.
I entered my domain. and left the rest intact
I enter a username (assuming its the database username)
but once I get to password I cant type anything... try anything else Access Denied...

I am lost now. And they are different servers, since they are different hosts. I've installed vB on both also. I just want the posts, threads, and settings along with the users and all...

Oh and I got lost at step 1... how do I type those commands?
I assume I cant because i cant log in?

[Steve Machol]

You need to login with your web hosting name and password, the same one you use to manage your account and to log into FTP.

Please see:

http://www.vbulletin.com/forum/showpost.php?p=602709&postcount=7

or

http://www.vbulletin.com/forum/showthread.php?postid=394378#post394378

[mredwardlee]

Alright I tried to use the Telnet/SSH, but the PuTTy thing now just closes the window if it is a successful login...

So now I gave up on that and tried to use the phpMYADMIN.

So I Export the files to my desktop ( I don't know if the settings are correct)


I Import it to the new one.


Then I get No SQL Query


Not sure what I did wrong...

[Zachery]

The file is too large to restore via phpmyadmin and needs to be restored in chunks (PITA) or have your host restore the file for you.

[mredwardlee]

Hi,

I tried to send in chunks...
So I selected only the A's...

http://img111.imageshack.us/img111/8588/16uo3.th.jpg

And I upload the A's in the new one. And I got this...
http://img228.imageshack.us/my.php?image=26sv.jpg

Maybe I just don't know what PITA is???

***Edit*** Image doesnt seem to show properly so...

img.lightbulb { cursor: pointer; }

[Zachery]

Pain in the Ass

You'd have to copy and paste large chunks of the file that all relate to each other and make sure you get full lines.

If you ask your host to restore the file for you (upload it to your ftp) it should take 2-3 min, instead of a few hours.

[mredwardlee]

Sorry, it seems the image didnt appear properly?



Anyhow, that's what it said:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 20, 2006 at 09:43 PM
-- Server version: 4.1.11
-- PHP Version: 4.4.3-dev
--
-- Database: `Forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `access`
--
CREATE TABLE `access` ( `userid` int( 10 ) unsigned NOT NULL default '0',
`forumid` smallint( 5 ) unsigned NOT NULL default '0',
`accessmask` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `userid` , `forumid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 24

So I just upload the .sql file right?
Then the host should be able to do the rest... like you said.
Yes! Pain in the ass! I was remaking the settings, categories using copy paste until I said that you can move them...

[Zachery]

Your sql backup file is in 4.1.x format, and it probally needs to be in 4.0 or 3.x format.

How big is the backup file?

[mredwardlee]

I know why the Telnet/SSH didn't work... its a freehost, so they dont give u that access...


Anyhow, the whole thing is 11.5MB, which I find is ridiculously low?

And just the A's the one that gave the error above is 256kb

Oh and I dont even know if the settings are the proper ones either...

[Zachery]

Yes because that error is because your backup file is not in the correct format for that server...

anyway, you are on a free webhost? I'd seriously considering find a real webhost. Not paying for your hosting could be the worst mistake you make.

[mredwardlee]

Yes, that is why I want to port it to the one I bought but I am having difficulties...

[Zachery]

Sorry, I thought you were going to a free host?

Anyway, can you upload that to somewhere I could download it? I'll go ahead and covert it and make it avaible for you to download.

You can send me the details in a PM, or open a support ticket and flag it with my attention.

[mredwardlee]

Hi, I changed the version... but now...
I installed vB into the new database. Was I supposed to?
Should I delete it?
Because now it works but it says...
File already exists, since I already installed vB, but just wanted to port settings posts,etc....