MySQL Dump Fehler

MySQL, PostgreSQL, SQLite
huukay
Posts: 8
Joined: 2004-12-19 21:08

MySQL Dump Fehler

Post by huukay » 2005-05-12 00:08

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 ;)

kawfy
Posts: 307
Joined: 2002-08-08 23:45

mysql

Post by kawfy » 2005-05-12 00:29

-- auf den Server einloggen und mit mysql (1) arbeiten. Phpmyadmin ist doch ein wenig ... eingeschränkt.

padi
Posts: 41
Joined: 2004-06-28 13:20
Location: Münster

Re: MySQL Dump Fehler

Post by padi » 2005-05-12 08:02

mysql -uUSER -pPASS -hlocalhost DB-Name < path/*.sql

huukay
Posts: 8
Joined: 2004-12-19 21:08

Re: MySQL Dump Fehler

Post by huukay » 2005-05-12 10:31

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'

snowball
Posts: 218
Joined: 2004-09-15 10:14

Re: MySQL Dump Fehler

Post by snowball » 2005-05-12 10:59

Hi,

hier steht was darüber:
http://www.mysql.com/news-and-events/ne ... 00216.html

greets
Jochen

huukay
Posts: 8
Joined: 2004-12-19 21:08

Re: MySQL Dump Fehler

Post by huukay » 2005-05-12 17:01

merkwürdig das dump ist gerade mal 150kb groß :(

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: MySQL Dump Fehler

Post by Joe User » 2005-05-12 17:03

Code: Select all

cat /etc/my.cnf
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings 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.

huukay
Posts: 8
Joined: 2004-12-19 21:08

Re: MySQL Dump Fehler

Post by huukay » 2005-05-12 17:11

# 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

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: MySQL Dump Fehler

Post by Joe User » 2005-05-12 18:31

Last edited by Joe User on 2005-08-27 20:14, edited 3 times in total.
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings 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.

huukay
Posts: 8
Joined: 2004-12-19 21:08

Re: MySQL Dump Fehler

Post by huukay » 2005-05-12 19:48

joa hab 1gb ram ;)

danke habs so übernommen funzt einzigartig gut :)

vielen dank ...!

st3fan
Posts: 10
Joined: 2005-07-11 10:34

Re: MySQL Dump Fehler

Post by st3fan » 2005-08-25 11:03

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

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: MySQL Dump Fehler

Post by Joe User » 2005-08-25 11:53

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/JoeUserFreeBSD Remote Installation
Wings for LifeWings 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.

st3fan
Posts: 10
Joined: 2005-07-11 10:34

Re: MySQL Dump Fehler

Post by st3fan » 2005-08-25 13:17

^^Danke! werds mal testen!