From: W. D.
Date: March 18 2004 8:21am
Subject: Re: Large lists of SQL commands choking PHPmyAdmin?
List-Archive: http://lists.mysql.com/mysql/162013
Message-Id: <5.1.0.14.2.20040318021959.05d62ab0@209.152.117.178>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


At 02:03 3/18/2004, olinux wrote:
>--- "W. D." wrote:
>> I am a relative newbie to MySQL and PHPmyAdmin.  I
>> tried adding=20
>> data into an existing table by 'uploading' a file in
>> PHPmyAdmin.
>> I know the INSERT INTO commands are valid, since I
>> can import
>> several hundred records using PHPmyAdmin.  However,
>> when I
>> try to import a few thousand records, everything
>> seems to=20
>> go berserk.
>>=20
>> Does anyone have a simple way of adding a 5 or 10
>> thousand
>> records at a time?
>
>
>You can read the dump file back into the server with:=20
>
>shell> mysql db_name < backup-file.sql
>
>Or:=20
>
>shell> mysql -e "source
>/path-to-backup/backup-file.sql" db_name
>
>More info here:=20
>http://www.mysql.com/doc/en/mysqldump.html
>
>olinux

Thanks, O.

Is the dump file all SQL statements?  The file that I am importing
is all INSERT INTO statments.


Start Here to Find It Fast!=99 -> http://www.US-Webmasters.com/best-start-pa=
ge/