[phpBB Debug] PHP Warning: in file [ROOT]/feed.php on line 173: Cannot modify header information - headers already sent by (output started at [ROOT]/feed.php:1)
[phpBB Debug] PHP Warning: in file [ROOT]/feed.php on line 174: Cannot modify header information - headers already sent by (output started at [ROOT]/feed.php:1)
[phpBB Debug] PHP Warning: in file [ROOT]/feed.php on line 180: Cannot modify header information - headers already sent by (output started at [ROOT]/feed.php:1)
IntegraMOD Home of phpBB Integrated Modifications 2006-04-29T09:35:03-07:00 https://integramod.com/forum/feed.php?f=17&t=441 2006-04-29T09:35:03-07:00 2006-04-29T09:35:03-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3587#p3587 <![CDATA[Re: What each table means.]]>
Thanks!

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


]]>
2006-04-29T03:40:25-07:00 2006-04-29T03:40:25-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3546#p3546 <![CDATA[What each table means.]]> http://www.mysqldumper.de/en/index.php

A

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


]]>
2006-04-28T10:58:24-07:00 2006-04-28T10:58:24-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3470#p3470 <![CDATA[Re: What each table means.]]>

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


]]>
2006-04-28T10:25:48-07:00 2006-04-28T10:25:48-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3461#p3461 <![CDATA[What each table means.]]>
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>

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


]]>
2006-04-28T10:18:32-07:00 2006-04-28T10:18:32-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3457#p3457 <![CDATA[Re: What each table means.]]>
For example:

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


]]>
2006-04-28T10:03:38-07:00 2006-04-28T10:03:38-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3451#p3451 <![CDATA[What each table means.]]>
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


]]>
2006-04-28T09:12:41-07:00 2006-04-28T09:12:41-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3444#p3444 <![CDATA[What each table means.]]> Statistics: Posted Author: Jason Sanborn — Fri Apr 28, 2006 9:12 am


]]>
2006-04-28T09:00:40-07:00 2006-04-28T09:00:40-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3442#p3442 <![CDATA[What each table means.]]> Statistics: Posted Author: Bush — Fri Apr 28, 2006 9:00 am


]]>
2006-04-28T02:24:14-07:00 2006-04-28T02:24:14-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3400#p3400 <![CDATA[Re: What each table means.]]>
a good place to start is http://www.mysql.com

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

:mrgreen:

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


]]>
2006-04-27T14:37:08-07:00 2006-04-27T14:37:08-07:00 https://integramod.com/forum/viewtopic.php?t=441&p=3345#p3345 <![CDATA[What each table means.]]>
I'm just trying to figure out how everything works between php and mysql <img>

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


]]>