Re: lug-bg: mysql stranen problem sas importa
- Subject: Re: lug-bg: mysql stranen problem sas importa
- From: kolp <kolp@xxxxxxxxxxx>
- Date: Thu, 2 Oct 2003 01:30:19 +0300
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thursday 02 October 2003 12:25 am, emo terziev wrote:
> zdravejte,
> imam stranen problem sas mysql i ne moga da nameria
> reshenie.
> znachi nesto savsem prostichko kogato napravia
> mysqldump na edna baza v koiato ima tablici sas
> auto_increment poleta sled tova kato iskam da ia
> importna sas mysql <database> < sql.file
> mi dava vinagi
> Duplicate entry '1' for key 1
>
>
> znaeli niakoj reshenie na problema ?
>
e ne e tolkova stranen problema :-)
tova e obiknovena greshka; opitvash se da insertnesh veche
syshtestvuvashti rows, pri polojenie che auto_increment
entrytata se povtariat. napravi si korektno dumpa na tablicata,
dropvash ia i posle vyzstanoviavash ot dumpa. inache
pri podoben problem e dobre pyrvo da se puska `mysqlcheck'
da analizira struktura, index, etc. i da i pravi recovery ako e
neobhodimo.
kp.
- --
Key Server: pgp.ai.mit.edu
Key ID: 0xB304804D
Key Fingerprint: DA0C 2A46 5D50 0932 73C2 BD9E A25A A5BB B304 804D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQE/e1V8olqlu7MEgE0RAh/5AJ4i99e2/U/pK/vE4rpQWoWME+quAQCfSb2a
hzf7FKmfxp3ENo9l/ZY1FCE=
=sfUU
-----END PGP SIGNATURE-----
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================
|