On Wed, Aug 21, 2002 at 11:37:57AM -0700, abw wrote: > Hello, > > Having a problem here. I'm trying to get a Mysql 3.23 database from a Red > Hat 7 machine over to a Mysql 3.23 on a Solaris Sparcstation. > > I was able to dump the database using the mysqldump command. The database > has 3 tables, and I used the following syntax:
[...] > I copied the files to the sparc server and did a mysqlimport. I tried: > > mysqlimport -u <username> -p <database> table_name > > I am told that it cannot find the ISM (I think that was the name) file. > Well, nowhere for the mysqldump that I could find did it mention anything > about this. > > Clearly I am doing something wrong. I searched for hours yesterday and > searched google for different was to use these commands, but couldn't find > anything other than the documentation and the syntax used above. > > Any suggestions? Am I using mysqldump and mysqlimport correctly? mysqlimport is not the opposite of mysqldump; mysqlimport is used to bulk-read the contents of textfiles into a MySQL database. If you have a mysqldump-generated file of SQL statements, you read it back into a database with the mysql command, e.g. mysql -u <username> -p database < backup-file.sql Jesse Sheidlower --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
