What each table means.

[Bush]

Does anyone have any information on exactly what table is for what..

I'm just trying to figure out how everything works between php and mysql <img>

[found it]

ouch thats a tall order.....

a good place to start is http://www.mysql.com

and set yourself up for a good read.....

[Bush]

okie dokie, now that i got my live site fixed, i think its time to dismantle the test site and figure out how this stuff really works.

[Jason Sanborn]

Bush, if you could, would you mind including info here as you discover it? It will probably help others as well. (Like myself) <img>

[Bush]

Yes sure. <img>

I think it will be a colaberation of all of us though, if we're going to discover as users what each table represents and what data it holds.

I want to know this for backup purpose. If anything goes wrong with my live site, i'd atleast like to be able to restore certain tables in the database (posts/users).

Bush

[Dragonsys]

If you want to know which DB table goes with which section of IM... start by looking in the includes/constants.php file. In that file is where the relationship, between sections of phpBB and the DB, are kept.

For example:

Code: Select all

define('ACRONYMS_TABLE', $table_prefix.'acronyms');

The above line shows that the Acronyms page uses the phpb_acronyms table (assuming that you are using the defualt table prefix of phpbb_)

If you want to know how phpBB (IM) interacts with the database, then you need to understand SQL ([url=http]http://www.mysql.com[/url]) calls and do some reading up on php (http://www.php.net), and look at the files for phpBB, paying attention to anywhere you find SQL or $sql.

Your best bet, if this is just for backup/restore purposes, is to backup and restore the entire IM DB.

[Bush]

It sorta is for backup purposes, peace of mind and actually learning how this thing ticks a little better.

Whenever i've tried to backup/restore a database in myphpAdmin it always gives me execution errors, or some other type of error. I'll have to dig it up so I can show you, but either way I use MySQL Admin which can be found at http://www.mysql.com - Its a great application that you can use to monitor your databases and "mess" around with them.

Overall though, I'd like to be able to know more about how php and sql work together, so that I can better support the growing integramod community. I really like the integration into phpBB that you guys have managed to get together and offer us! I've had many questions that i've needed answers for and the current guys here have been great to lend a hand and i'd like to do the same in return (no matter the differences between IM.com and IM2.com)

Thanks for the info btw DragonSys - That seems like a great place to start!

One last thing, are there any books or tutorial websites you guys could recommend, that contains information about how php and sql communicate, i'm pretty sure that i'm understanding the structure of the database and tables, just not sure what goes where quiet yet. <img>

[Dragonsys]

I can understand all that

[Adrian Rea]

The 2mb limit is really restricting so I recommend mysqldumper. It will perform your backups and and enable you to restore a large dm without hassle. I have just restored a 210Mb db in 12 minutes and no problem.
http://www.mysqldumper.de/en/index.php

A

[Bush]

Thanks A! I have found this program too, [url=http]MySQL Administrator[/url] which was developed by the guys over at mysql.com and it is able to handle a database restore and backup of anysize as well!

Thanks!