PHP Forum

PHP Forum (http://www.selfphp.de/forum/index.php)
-   MySQL (http://www.selfphp.de/forum/forumdisplay.php?f=22)
-   -   Brauche Hilfe (http://www.selfphp.de/forum/showthread.php?t=22699)

Partygirl 16.01.2010 19:39:43

Brauche Hilfe
 
Liste der Anhänge anzeigen (Anzahl: 1)
Hallöchen ich bin Anfänger was PHP Fusion betrifft das Design an sich kann ich ja schon aaaaber ich wollte umziehen auf einen anderen Server hab ein SQL Datenbank Backup gemacht nun wollte ich es exportieren und er schreibt mir diesen Fehler hier in der Datenbank selber

Kann mir da jemand helfen was ich da rauslöschen oder bearbeiten muss den mit Sql bin ich nicht versiert

LG Partygirl

ich hab das Setup mal mit angehängt

vt1816 16.01.2010 19:49:56

AW: Brauche Hilfe
 
Hallo und willkommen hier im Forum.


Zitat:

Zitat von Partygirl (Beitrag 133803)
[...]
und er schreibt mir diesen Fehler hier in der Datenbank selber

Sorry, aber Fielmann hat es mal wieder nicht geschafft mir meine Brille auf Deine Fehlermeldung anzupassen. Wie lautet die/Deine Fehlermeldung?


Zitat:

Zitat von Partygirl (Beitrag 133803)
[]
Kann mir da jemand helfen was ich da rauslöschen oder bearbeiten muss den mit Sql bin ich nicht versiert

LG Partygirl

ich hab das Setup mal mit angehängt

Anhänge - und dann auch noch in dieser Größe - sind PFUI. Den Anhang wird sich keiner runterladen. Bitte kopiere die ersten bzw. einige Zeilen (im Zusammenhang zur Fehlermeldung) hier ins Forum.

Partygirl 16.01.2010 20:19:59

AW: Brauche Hilfe
 
Sorry ähm ja dann hier die ersten paar Zeilen


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__banner`
#
DROP TABLE IF EXISTS `#__banner`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

vt1816 16.01.2010 20:33:49

AW: Brauche Hilfe
 
Zitat:

Zitat von Partygirl (Beitrag 133805)
Sorry ähm ja dann hier die ersten paar Zeilen
...

Könnten es ein paar mehr Zeilen vom Anfang der SQL-Datei sein?

Wie willst Du die Daten importieren (Konsole, phpMyAdmin)?

Partygirl 16.01.2010 20:38:45

AW: Brauche Hilfe
 
Jepp ich will das Backup beim neuen Serveranbieter hochladen also importieren

#
DROP TABLE IF EXISTS `#__core_acl_aro_sections`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_acl_groups_aro_map`
#
DROP TABLE IF EXISTS `#__core_acl_groups_aro_map`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_log_items`
#
DROP TABLE IF EXISTS `#__core_log_items`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__core_log_searches`
#
DROP TABLE IF EXISTS `#__core_log_searches`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__groups`
#
DROP TABLE IF EXISTS `#__groups`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__menu`
#
DROP TABLE IF EXISTS `#__menu`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__menu_types`
#
DROP TABLE IF EXISTS `#__menu_types`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__messages`
#
DROP TABLE IF EXISTS `#__messages`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__messages_cfg`
#
DROP TABLE IF EXISTS `#__messages_cfg`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__modules`
#
DROP TABLE IF EXISTS `#__modules`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__modules_menu`
#
DROP TABLE IF EXISTS `#__modules_menu`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#
# Structure for Table `#__newsfeeds`
#
DROP TABLE IF EXISTS `#__newsfeeds`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual
#

vt1816 16.01.2010 21:01:38

AW: Brauche Hilfe
 
Womit hast Du den Export gemacht? Die Fehlermeldung(en) sind bereits im Export enhalten!

Partygirl 16.01.2010 21:12:40

AW: Brauche Hilfe
 
Ich hab das Backup so von meiner PHP Fusion geladen als zip.gz

Prefix Kerntabellen: fusion_
Totale Tabellengrösse: 570.2Kb (153 Tabellen)
Kerntabellengrösse: 498.82Kb (118 Tabellen)
Backup Optionen:
Dateiname: *
Backup Typ:
Admin Passwort: *

Partygirl 16.01.2010 21:13:10

AW: Brauche Hilfe
 
Zitat:

Zitat von Partygirl (Beitrag 133810)
Ich hab das Backup so von meiner PHP Fusion geladen als zip.gz

Prefix Kerntabellen: fusion_
Totale Tabellengrösse: 570.2Kb (153 Tabellen)
Kerntabellengrösse: 498.82Kb (118 Tabellen)
Backup Optionen:
Dateiname: *
Backup Typ:
Admin Passwort: *

Also sql.gz sorry ;-)

vt1816 16.01.2010 21:40:11

AW: Brauche Hilfe
 
Wie hast Du das Backup erzeugt?

Partygirl 16.01.2010 22:02:04

AW: Brauche Hilfe
 
Also nun nochmal ich habe das PHP Fusion Neu bei dem Webhoster wo wir noch sind damals gemacht das heisst er erzeugte die Datenbank selber so nun möchte ich umziehen und diese Textdatei (Sql Datenbank) zum neuen Webhoster mitnehmen und da hochladen das geht aber eben nicht weil er mir diese Fehler anzeigt. Wie wäre es wenn ich dir das Skript per Mail schicke das du dir das mal in Ruhe anschaust das bringt mir sonst nichts weil es müsste schon schnell gehen


Alle Zeitangaben in WEZ +2. Es ist jetzt 16:05:57 Uhr.

Powered by vBulletin® Version 3.8.3 (Deutsch)
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.