English version - [General] Can I truncate table phpbb_privmsgs?
evilmc - 27-08-2010, 23:15
Temat postu: [General] Can I truncate table phpbb_privmsgs?
I need to move my forum to another hosting provider, and now we want to be a SQL database as small as possible to transfer data, I can delete private messages: EMPTY?
phpbb_privmsgs 
phpbb_privmsgs_text
Can I do that or not?
Matteo - 27-08-2010, 23:59
Why you want truncate table's responsible for private messages?
If you want slim database you can truncate table's: | Kod: | phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch |
After move db and forum - remember of rebuild search in administration panel.
evilmc - 28-08-2010, 23:37
okey, okey...thanx for help! 
| Matteo napisał/a: | | Why you want truncate table's responsible for private messages? |
I wanted to do truncate, because my database is too large, I truncate php_search and now my database has 260MB ... whether it is a lot to my forum, because my SQL database searching was 470MB?
Matteo - 28-08-2010, 23:50
If you want - you can truncate it, but remember - you and rest of users our forum will haven't a private messages.
evilmc - 28-08-2010, 23:53
I understand you completely, that is normal to be so many great base SQL: 260MB?
Matteo - 29-08-2010, 00:19
| evilmc napisał/a: | | that is normal to be so many great base SQL: 260MB? |
Yes, why not?
If you have maaany posts, users etc it is normal. Give adress forum.
And I think this topic could been useful for you.
| Widmo napisał/a: | Bardzo często pytacie się jak wgrać duże bazy na serwer.
Ja robie cos takiego:
1. Czyszcze:
| Kod: | phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch |
2. Robie kopie GZIP wszystkich tabel OPRÓCZ:
| Kod: | phpbb_posts
phpbb_posts_text |
nazywam to Zrzut_[data]_1.gz.
3. Zrzucam:
nazywam to Zrzut_[data]_2a.gz.
4. Zrzucam:
nazywam to Zrzut_[data]_2b.gz.
<HR>
Teraz wrzucam na 3 wrzuty do innej bazy.
W panelu admina odtwarzam "SZUKAJ"
02:18 Rano - Widmo |
and my noob translate: | Widmo napisał/a: | Very often, you ask how to upload a large database on the server.
I am doing something that:
1. Truncate:
| Kod: | phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch |
2. I am making copies of all tables GZIP EXCEPT:
| Kod: | phpbb_posts
phpbb_posts_text |
call it Dump_[data]_1.gz.
3. Make copy of:
call it Dump_[data]_2a.gz.
4. Make copy of:
call it Dump_[data]_2b.gz.
<HR>
Now I importing it (on 3 time) to another db.T
And in administration panel rebuilding search.
|
:P
evilmc - 29-08-2010, 01:49
thank you very much! This way we work is much easier, and again a big THANK YOU!
Thanks for your support!
Bojan
|
|
|
