IntegraMOD

Re: What each table means.

2006-04-29T09:35:03-07:00

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!

Statistics: Posted Author: Bush — Sat Apr 29, 2006 9:35 am

What each table means.

2006-04-29T03:40:25-07:00

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

Statistics: Posted Author: Adrian Rea — Sat Apr 29, 2006 3:40 am

Re: What each table means.

2006-04-28T10:58:24-07:00

I can understand all that

Statistics: Posted Author: Dragonsys — Fri Apr 28, 2006 10:58 am

What each table means.

2006-04-28T10:25:48-07:00

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.

Statistics: Posted Author: Bush — Fri Apr 28, 2006 10:25 am

Re: What each table means.

2006-04-28T10:18:32-07:00

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:

Line number On/Off | Expand/Contract | 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.

Statistics: Posted Author: Dragonsys — Fri Apr 28, 2006 10:18 am

What each table means.

2006-04-28T10:03:38-07:00

Yes sure.

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

Statistics: Posted Author: Bush — Fri Apr 28, 2006 10:03 am

What each table means.

2006-04-28T09:12:41-07:00

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

Statistics: Posted Author: Jason Sanborn — Fri Apr 28, 2006 9:12 am

What each table means.

2006-04-28T09:00:40-07:00

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.

Statistics: Posted Author: Bush — Fri Apr 28, 2006 9:00 am

Re: What each table means.

2006-04-28T02:24:14-07:00

ouch thats a tall order.....

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

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

Statistics: Posted Author: found it — Fri Apr 28, 2006 2:24 am

What each table means.

2006-04-27T14:37:08-07:00

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

Statistics: Posted Author: Bush — Thu Apr 27, 2006 2:37 pm