Click to See Complete Forum and Search --> : html to mysql - PHP forum migration


A2day
10-23-2006, 04:18 AM
Hi!

I'm not sure if I'm posting on the right section, but here it goes.

I have a PHP forum (phpBB), with the backups restriction activated.
I need to migrate all the posts to a new PHP forum. I can retrieve all the HTML pages from the forum, but I do not know how to collect the information I need from the html.

My idea was to collect the user id, text, and topic id, to a text file, and then import it into my new database.

Can you help on this?
Thanks for any information you may have on this.

Cheers,
A2day

bathurst_guy
10-23-2006, 04:27 AM
Are you moving servers or changing forum packages?

A2day
10-23-2006, 04:28 AM
Hi!
Just moving servers...

Cheers,
A2day

bathurst_guy
10-23-2006, 04:32 AM
the phpbb knowledge base (http://www.phpbb.com/kb/article.php?article_id=212) would probably be the best place to find such an answer - dont you think?

A2day
10-23-2006, 04:39 AM
Perhaps....
I made my question here since, "Administration Control Panel > Backup Database" is not active on my forum.

So, my idea was to build de DB from the HTML files...

If this is not the proper place to question this, please can someone clean this topic?

Thanks.
Cheers,
A2day

bathurst_guy
10-23-2006, 04:40 AM
You could do a manual backup with something like phpMyAdmin.

A2day
10-23-2006, 04:48 AM
Is that a stand-alone program?
I've got access to the mysql db and my admin permission have the backup disabled. :(

bokeh
10-23-2006, 05:13 AM
I'd use SQL yog and select copy DB to another host. It couldn't be simpler.

A2day
10-23-2006, 05:41 AM
Sorry, i've a typo on my previous post:

"I do NOT have access to the mysql db and my admin permission have the backup disabled."

bokeh
10-23-2006, 06:09 AM
Sorry, i've a typo on my previous post:

"I do NOT have access to the mysql db and my admin permission have the backup disabled."Well you must have PHP access if PHPBB works.

A2day
10-23-2006, 07:18 AM
My forum is hosted on a free forum provider.
They allow all the admin stuff except the backup functionality...

But you are saying that there is a way to collect the data on the db, without going through the admin backup???

bokeh
10-23-2006, 08:55 AM
If you can read the DB with PHP you can read it with SQL yog.