Impex stuck in error message

[webananda]

I'm trying to import a phpBB database from one server onto another different ISP's server.

Installed 3.0.7 without a hitch.
Installed impex, option appears in the admin panel.
Selected my source board, began import, then got this:

Connection to source server failed. Check username and password.

I tried a few changes, not really sure how to specify the sourceserver, kept getting same error message, so logged out and back in again.

Now I am unable to return to the starting Impex screen, logging out and back in as Admin just gives me this message instead of the Impex panel to choose my source board from.

I ran this query agains my vB database:
DELETE FROM datastore WHERE title='ImpExSession';
0 rows deleted.

Reinstalled Impex, same problem.



From my ImPexConfig.php:sourceexists = true
sourcedatabasetype = mysql
sourceserver = host156.ipowerweb.com:2082 (http://host156.ipowerweb.com:2082/)
sourceuser = "circular_xmb2"
sourcepassword = "*********"
sourcedatabase = circular_xmb2
sourcetableprefix = phpbb_
Can sombody tell me please what I'm doing wrong?
Thanks.

[Steve Machol]

You cannot connect to that server:

sourceserver = host156.ipowerweb.com:2082 (http://host156.ipowerweb.com:2082/)

In order for this to work, that server will need to be configured to allow MySQL connections from your server. This is only something the host can do.

Otherwise what you need to do is backup and restore the phpBB database on your vB server, then modify the sourceserver to 'localhost'.

[webananda]

...backup and restore the phpBB database on your vB server
Do you mean use phpBB's backup utility or do a mySQL dump of the phpBB database? Or does it matter?
I have both, approx. 250Mb. each.

So, if I understand, I take one (which one?) of these backups, and put it into another dummy database on my new server? Then refer to it via 'localhost'?

Not sure such a large database will work in the cPanel SQL Query box. ?

[Steve Machol]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

[webananda]

Thank you...I will RTFM next time first.

It all worked splendidly! I was able to do a cPanel sql dump on my old server with the phpBB database, and use ssh access on the new server to run the mysqldump command. Then Impex worked flawlessly...great utility!

Thank you for your help. vB looks great!