MySQL Dump Fehler
-
- Posts: 8
- Joined: 2004-12-19 21:08
MySQL Dump Fehler
Also ich hab folgendes Problem ich hab meinen Server neuinstalliert aber vorher n Datenbankdump erstellt. Jetzt würde ich gewissen Datenbanken gern wieder herstellen. Allerdings funktioniert das nicht über die "SQL" Funktion bei phpMyAdmin. Er lädt zwar scheinbar die gzipped datei ein wenig hoch aber im endeffekt hört er irgendwann auf zu laden und springt zur nächste seite. legt allerdings auch keine tabellen an. Die Dumpdatei ist nur mikrige 150kb groß... maximal darf ich 2mb uploaden. Meine Frage:
Wie lade ich das Dump wieder in die Datenbank?!
mfg mirCo ;)
Wie lade ich das Dump wieder in die Datenbank?!
mfg mirCo ;)
-
- Posts: 41
- Joined: 2004-06-28 13:20
- Location: Münster
Re: MySQL Dump Fehler
mysql -uUSER -pPASS -hlocalhost DB-Name < path/*.sql
-
- Posts: 8
- Joined: 2004-12-19 21:08
Re: MySQL Dump Fehler
h8342:# mysql -ublablubb -ptollespasswort -hlocalhost mgroesch < /home/i/immx.de/public_html/dbs/mg_groesch.sql
ERROR 1153 at line 477: Got a packet bigger than 'max_allowed_packet'
-
- Posts: 218
- Joined: 2004-09-15 10:14
-
- Posts: 8
- Joined: 2004-12-19 21:08
Re: MySQL Dump Fehler
merkwürdig das dump ist gerade mal 150kb groß :(
-
- Project Manager
- Posts: 11182
- Joined: 2003-02-27 01:00
- Location: Hamburg
Re: MySQL Dump Fehler
Code: Select all
cat /etc/my.cnf
PayPal.Me/JoeUser ● FreeBSD Remote Installation
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
-
- Posts: 8
- Joined: 2004-12-19 21:08
Re: MySQL Dump Fehler
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
-
- Project Manager
- Posts: 11182
- Joined: 2003-02-27 01:00
- Location: Hamburg
Re: MySQL Dump Fehler
Zur Konfiguration siehe: http://www.rootforum.org/forum/viewtopic.php?t=36343
Last edited by Joe User on 2005-08-27 20:14, edited 3 times in total.
PayPal.Me/JoeUser ● FreeBSD Remote Installation
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
-
- Posts: 8
- Joined: 2004-12-19 21:08
Re: MySQL Dump Fehler
joa hab 1gb ram ;)
danke habs so übernommen funzt einzigartig gut :)
vielen dank ...!
danke habs so übernommen funzt einzigartig gut :)
vielen dank ...!
-
- Posts: 10
- Joined: 2005-07-11 10:34
Re: MySQL Dump Fehler
und welche Einstellungen würdet ihr empfehlen für Systeme > 1GB?
eher gesagt für 2GB RAM und MySQL 4.1 !?
Danke schon mal!
Gruß
Stefan
eher gesagt für 2GB RAM und MySQL 4.1 !?
Danke schon mal!
Gruß
Stefan
-
- Project Manager
- Posts: 11182
- Joined: 2003-02-27 01:00
- Location: Hamburg
Re: MySQL Dump Fehler
Für Systeme mit 1GB bis 2GB RAM (MySQL 4.x):
Code: Select all
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
user = mysql
socket = /var/run/mysqld/mysqld.sock
bind-address = 127.0.0.1
port = 3306
server-id = 1
skip-locking
skip-networking
skip-name-resolve
skip-external-locking
local-infile = 0
key_buffer_size = 128M
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 16M
max_allowed_packet = 16M
net_buffer_length = 8K
thread_stack = 128K
thread_cache = 8
table_cache = 256
query_cache_type = 1
query_cache_size = 16M
query_cache_limit = 1M
thread_concurrency = 2
#skip-innodb
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
#no-auto-rehash
#safe-updates
[isamchk]
key_buffer_size = 128M
sort_buffer_size = 8M
read_buffer_size = 2M
write_buffer_size = 2M
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 8M
read_buffer_size = 2M
write_buffer_size = 2M
[mysqlhotcopy]
interactive-timeout
PayPal.Me/JoeUser ● FreeBSD Remote Installation
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.
Wings for Life ● Wings for Life World Run
„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.