PHP/mysql Forum problem

[matauri]

I have a prob I am having problems nutting out, so hoping someone can figure out whats wrong for me.

I am in middle of transferring my site to another server. On the old one I have been hosting some external & internal forums done in phpbb with a mysql 4.0 (I think). They all work fine on old server..no probs.

Prob I have had so far, and expect to have maybe with others being transferred......

The new db has been setup on clients new server (at least I am pretty sure it is), and the forum works fine. I have backed up the old db & tried to restore it on clients new server. When we try to restore it, this error keeps coming up.......

Error importing backup file DEBUG MODE SQL Error : 1048 Column 'group_id' cannot be null INSERT INTO fox_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

Any ideas?


Cindy

[matauri]

Just a footnote to above.....

Client is having concerns about the db names. The db he has set up has one name, and when he goes to restore he is saying old db has diff name (which I kinda figured it would).


Cindy

[cyanide]

The name of the database doesn't really matter.
There is a config file in the program that points to the database, you just have to re-name it.

Now, what I would suggest when moving a program from one domain(server) to another, is:
On the new server, install phpbb as a new install. Because it has an auto-installer it will make the connections (username/password/database name) automatically.

Then go into phpMyAdmin of the new install and dump the data of all tables. Not the structure, just the data.
Then on the old domain, go into phpMyAdmin and export only the data of all tables and import that into the new database.

does that make sense?

[redcircle]

how are you exporting you database. My advice is to use a current version of phpMyAdmin some of the older versions had some real bugs in them and cause flakey results. On the new site make sure the database is created but no tables and import it in. It should work like a charm.

If you think it's a problem with the db names then check to make sure your configuration is correct.

Column 'group_id' cannot be null

The index cannot have a null value that's what that error means (assuming group_id is the index)

[matauri]

Thanks guys. Finally got db going ok ! Now I jsut gotta figure out some wrong php pathway with the login, but thats prob a pathway I missed somewhere. Will scour thru them.

But thanks for help so far :-)


Cindy