| Autor |
Nachricht |
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
 Verfasst am:
Do 26 Sep, 2002 20:10 |
   |
I wanted to transfer my board from one server to another
I download all the board files
but when I upload my board files and I look on the new server he says this 
phpBB : Critical Error
Could not query database for theme info
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near '' at line 3
(this should be the new adress : http://lazy.killerpigs.com/isocenter) |
|
|
     |
|
Google
|
| Verfasst am:
|
|
|
|
|
stefan
Administrator
Anmeldungsdatum: 02.08.2002
Beiträge: 4735
Wohnort: Aachen
|
| Verfasst am:
Do 26 Sep, 2002 20:52 |
 |
|
   |
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
Do 26 Sep, 2002 23:52 |
|
I backupped it through phpmyadmin yes
but could it be that the board is fully modded ????
( I only backupped the structure of the board, to see if it would work but it doesn't ) |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
Fr 27 Sep, 2002 14:02 |
|
But in phpmyadmin you have to backup both, structure and data.
I hope you have done this.
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
Fr 27 Sep, 2002 19:36 |
|
when I do that I get a timeout
(the file is 9 mb)
but I just backupped the structure just to see if the board worked
but it doesn't |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
Fr 27 Sep, 2002 20:03 |
|
that's right, because the board needs more than the structure to run.
Have a look here, how to import the 9mb file in your database:
http://www.phpbb2.de/phpBB/viewtopic.php?t=971
I hope you understand it.
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
Sa 28 Sep, 2002 00:37 |
|
how do I do this
I'm not an expert in these things
<?php
system("/usr/bin/mysql -uUSERNAME -pPASSWORT -hIhr.Datenbank.Server.de DATENBANKNAME < /is/htdocs/kdnummer/www.domain.de/dump.sql", $fp);
if ($fp==0) echo "Daten importiert"; else echo "Es ist ein Fehler aufgetreten";
?> |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
Sa 28 Sep, 2002 11:37 |
|
You create a import.php File on your server with the following content:
| Code: |
<?php
system("/usr/bin/mysql -uUSERNAME -pPASSWORD -hYOUR.DATABASE.SERVER DATABASE < /full/path/to/the/dump-file/on/your/webspace/dump.sql", $fp);
if ($fp==0) echo "Data imported successful"; else echo "An error occured!";
?> |
Then you fill in your database-username, password, the database server and the name of your database.
You upload your dump-file to your webspace an you have to point to it with the absolut path.
Then you run the script from your browser.
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
Sa 28 Sep, 2002 22:02 |
|
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
Sa 28 Sep, 2002 22:17 |
|
it doesn't work
Warning: system() has been disabled for security reasons in /www/J/jvlekken/web/www.itinaris.be/isocenter/import.php on line 2
Data imported successful
when i try to import the .sql I always get PAGE CANNOT BE DISPLAYEd after 5 minutes of uploading |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
Sa 28 Sep, 2002 22:46 |
|
That's Bad. 
Then i think you can only ask your webhoster directly how to import a big dump-file in your database.
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
So 29 Sep, 2002 13:09 |
|
now I've tried it on another server of a friend of me
but there it says AN ERROR OCCURED
so I think I probably made an error in the .php file
could you give me an example (but just input a fictive pass en login  ) |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
So 29 Sep, 2002 13:51 |
|
| Code: |
<?php
system("/usr/bin/mysql -ufabro -pmypass -hwww.server.com fabro_net < /usr/local/httpd/htdocs/import/dump.sql", $fp);
if ($fp==0) echo "Data imported successful"; else echo "An error occured!";
?> |
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
warchild
phpBB2.de User
Anmeldungsdatum: 07.08.2002
Beiträge: 37
Wohnort: Antwerp
|
| Verfasst am:
So 29 Sep, 2002 14:11 |
|
it doesn't work
I think I'm doing something wrong
but do u have a messenger or something (msn, icq, yahoo,... ???)
then u can help me quicker maybe?? |
|
|
|
|
Fabro
phpBB2.de User
Anmeldungsdatum: 02.08.2002
Beiträge: 1172
Wohnort: Bayern
|
| Verfasst am:
So 29 Sep, 2002 15:45 |
|
ICQ: <no_more_plz>
MSN: <no_more_plz>
AIM: <no_more_plz>
Yahoo: <no_more_plz>
Fabro |
_________________
[img]http://cgi.gbgr.de/spruch.png?d=2[/img] |
|
|
|
|
|
|
|
![[netclusive - internet broadcasting]](templates/fisubsilversh/images/phpbb2_logor_01.gif)
