Re: File created by mysqldump cannot be read into MySQL

2002-05-27 Thread Gerald Clark
Don't use 'more'. It adds characters to the output. Instead: mysql --host=host --user=user --password=pwd < error_repeat.sql Elliot Smith wrote: >Description: >I used mysqldump to create an SQL file containing a dump of all databases on >the server, including all tables and data (using --a

File created by mysqldump cannot be read into MySQL

2002-05-24 Thread Elliot Smith
Description: I used mysqldump to create an SQL file containing a dump of all databases on the server, including all tables and data (using --all-databases). However, when I tried to restore from this file, the mysql command line tool reported errors. I guessed that this was due to the --extended-i