--- "W. D." wrote: > I am a relative newbie to MySQL and PHPmyAdmin. I > tried adding > 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 > go berserk. > > 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: shell> mysql db_name < backup-file.sql Or: shell> mysql -e "source /path-to-backup/backup-file.sql" db_name More info here: http://www.mysql.com/doc/en/mysqldump.html olinux __________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
