Stuck with Impex

[ringnews24]

Im currently on a free forum, I bought the database and its sitting on my PC. The Free Forum sent me a tar.gz file.

####
#
# SOURCE - The source is the old forum database (where the  data is coming from)
#
####

# mysql / mssql
$impexconfig['source']['databasetype']    = 'mysql';  // mysql OR mssql
$impexconfig['source']['server']        = 'localhost';
$impexconfig['source']['user']            = '***************';
$impexconfig['source']['password']        = '********************';
$impexconfig['source']['database']        = 'source';
$impexconfig['source']['tableprefix']   = '';

Im not sure what to type here as the files are sitting on my desktop

[BirdOPrey5]

You need to import the database file into a real database on your server.

If it's not too big you may be able to import directly from phpmyadmin. If it's too big to upload via PHP however you would need to use a utility like bigdump (google it) to import the data.

[ringnews24]

zip file 27.7 mb
Uzipped 88.5 mb


What should I use Joe, BigDump or Phpmyadmin?

Thanks

- - - Updated - - -

I tried to install via myphpadmin and got the following error

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 'budweiserboxing_attachments_config.sql' at line 1

[BirdOPrey5]

I would try via bigdump at that size.

You may need to create a specific database or possibly edit the SQL file before importing if the database name you are trying to import to can't be created on your host.

[ringnews24]

Im trying Big Dump but after a few seconds the page says

"The connection to the server was reset while the page was loading."

- - - Updated - - -

After it not working via the web browser, I decided to do it via the bigdump FTP option and got the following error

Error at the line 22: DROP TABLE IF EXISTS `budweiserboxing_attachments_config`;
Query: budweiserboxing_attachments_config.sql0000644000000000000000000000552312044053165017422 0ustar rootroot-- MySQL dump 10.11
--
--
--
DROP TABLE IF EXISTS `budweiserboxing_attachments_config`
MySQL: 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 'budweiserboxing_attachments_config.sql' at line 1

[BirdOPrey5]

It seems like the .SQL file is not formatted correctly to be uploaded to your server. We could go back and forth on this a dozen times with little changes but if you can PM me FTP access so I can download the .SQL file I can take a look and see if I see the real problem.

[ringnews24]

Thanks Joe, Ill pm you the FTP info just now

[BirdOPrey5]

OK, I had to combine the SQL files and clean them up a little- responded back- you should be set now.

[ringnews24]

Replied, Thanks Joe.

Ill give it a bash :-)

- - - Updated - - -

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

---

Apache Server at www.ringnews24.com Port 80

I tried to import the database via the online url option. It came up with that error within seconds.

- - - Updated - - -

-------------------------------------------------------------------------------------------------------------------------------------------------

I then tried to upload it via Myphpadmin and it said

Error

SQL query:
--
-- Table structure for table `budweiserboxing_attachments`
--
DROP TABLE IF EXISTS `budweiserboxing_attachments` ;


MySQL said:
#1046 - No database selected

[ringnews24]

OK, I had to combine the SQL files and clean them up a little- responded back- you should be set now.

The Server did the import for me Joe, thanks for your advice.

However when I log into my Admin CP, and run Impex i get the following error.


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 references 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 original 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
filedata - importfiledataid Completed

---

Testing source against : phpBB2 ::2.0.22


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 :

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

[Hartmut]

Sounds like you missed to enter the prefix 'budweiserboxing_' in your config file?

[ringnews24]

How do i sort that? I named the db budweiserboxing not budweiserboxing_

[BirdOPrey5]

In the ImpExConfig.php file for impex, for the source data there is a line for the table prefix. Put budweiserboxing_ as the table prefix.

[ringnews24]

I changed the source - $impexconfig['source']['tableprefix'] = 'budweiserboxing_';

Do I also change the target file $impexconfig['target']['tableprefix'] = 'Boxing_Forum_'; ??

[Hartmut]

If you used that prefix in the database for that: yes.