Zobacz temat - How to upload a large database?

To jest tylko wersja do druku, aby zobaczyć pełną wersję tematu, kliknij TUTAJ
	phpBB2 by Przemo Support forów phpBB2 modified by Przemo

F.A.Q. - Read it first! - How to upload a large database?

Matteo - 08-09-2010, 21:19
Temat postu: How to upload a large database?

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:

Kod:

phpbb_posts

call it Dump_[data]_2a.gz.

4. Make copy of:

Kod:

phpbb_posts_text

call it Dump_[data]_2b.gz.

Now I importing it (on 3 time) to another database and in Administration Panel rebuilding search.

(original content)