MySQL database import to IPB 3.1 database

[MedfordForum]

My IPB forum (v2. something) suddenly started returning a MySQL driver errors about a month ago. My initial thought was that my host upgraded its MySQL software, which rendered my database useless. I backed up the database (both the info schema and the other part) as an SQL file. It's a good thing that I did.

I thought upgrading to IPB 3 might fix the problem. I moved all of the files for the old forum to an _OldForum folder, and placed all of the install files for 3.0 into the "forum" folder to do the upgrade. The upgrade didn't work. So, I did an install, and figured it would just update the database... . It erased my hosted database and replaced the contents with all-new IPB 3 contents.

I tried to use the merge feature in phpmyadmin with no luck. Two main errors that it gave were that it had a duplicate key, and that it had a 'create database' command at the bottom where the schema portion was.

I got assistance from my host, and they got it all to finish importing. However, it didn't seem to do any good. None of my membership, calendars, topics, forum titles, etc. came through. When I loaded my backup database into a newly created database on the server, it imported fine, and all of the information appears to be in it still.

What do I need to fix it or to get my vital forum info onto the new database so that I can get my forum up and running again. I do not want to start from scratch!


When I first created my database, here was my database header info:


-- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 25, 2009 at 02:18 AM
-- Server version: 5.0.67
-- PHP Version: 4.4.9

Then my IPB forum gave me the driver errors. When I exported my database before the IPB 3 install a few months ago, it exported to a file with this header:


-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 13, 2011 at 11:26 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

My new database for my IPB 3 has this header:


-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 13, 2011 at 10:59 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

Is there a database fixer tool or a way to merge the two databases that will give me my info back?

[Robulosity2]

Well, you probably want to open a ticket with IPS if you still have your database backups,


You can also see what is causing the crash by viewing the sql error logs in /cache/

The only thing I see that's changed there is the PHP Version, I believe that 2.x didn't get along terribly well with some of the higher level php 5.x versions but I could be mistaken

[Guest]

It sounds like you've run the installer, rather than the upgrader. Merging an old IPB 2.x database into the 3.x database won't work either.

The process to fix would be:

1. Drop the database you've manually merged.
2. Reimport your IP.Board 2.x database into a new database.
3. Reupload IP.Board 3.1 to your server.
4. Run /admin/upgrade/ *not* /admin/install/

That will upgrade you, step by step, from IP.Board 2.x to 3.1. :)

[MedfordForum]

Thank you for the replies.
Correct. I ran a fresh install. The upgrade didn't work. I hoped that the installer would magically leave my topics and membership in tact. Good thing I backed it up first.

The errors I was getting on my old forum said "IPS driver error..." The logs, if I recall, mentioned a database access error. This was probably my biggest motivation for upgrading - it is really nice software I'm finding though. I just hope I can get my info back.

How long does a trouble ticket for this type of problem take do you think?

[NenaDice]

Thank you for the replies.

Correct. I ran a fresh install. The upgrade didn't work. I hoped that the installer would magically leave my topics and membership in tact. Good thing I backed it up first.

The errors I was getting on my old forum said "IPS driver error..." The logs, if I recall, mentioned a database access error. This was probably my biggest motivation for upgrading - it is really nice software I'm finding though. I just hope I can get my info back.

How long does a trouble ticket for this type of problem take do you think?

When you run the installer, it will drop the tables that are already in the database and it will recreate fresh ones.

You have installed a new copy of the latest version, right, can you go ahead with restoring the database backup and then run the upgrader. That is to bring the db up to date.

About the db errors, next time, if any will appear, can you copy/paste them here? I mean the full exact errors, blurring out any sensitive data, if any will be reported. You can get them at th esql error logs inside the cache folder.

[MedfordForum]

When I import my old 2x database, I get the following errors:

[ERROR in query 6] Access denied for user 'MyName'@'%' to database 'MyForumsDatabase'

[ERROR in query 7] Access denied for user 'MyName'@'%' to database 'MyForumsDatabase'

[ERROR in query 282] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 284] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 285] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 286] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 287] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 288] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 289] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 290] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 291] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 292] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 293] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 294] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 295] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 296] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 297] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 298] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 299] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 300] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 301] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 302] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 303] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 304] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 305] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 306] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 307] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 308] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 309] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 310] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 311] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 312] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 313] Access denied for user 'MyName'@'%' to database 'information_schema'

[ERROR in query 314] Access denied for user 'MyName'@'%' to database 'information_schema'

Now when I upgrade my forum, everything appears to go fine... (it helps that I actually entered in the info for the conf_global.php file *D'oh!*).

However, when I try to access my forums, log in or access anything, I get "No input file specified." errors. I was really pushing to meet my goal of getting this up and running by the 18th... which ends in 1 hr.

[MedfordForum]

I just reinstalled everything for nothing! It sees the database fine... if I direct it to the right folder for the page. Now then, how to change it from myforum.com/index to myforum.com/forums/index.


ohhh... but IPChat never installed. I tried to add modules manually, but the app still doesn't work right. Is there an instructions page on how to install IPChat?