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: mysqldump -u <username> -p <database> table_name > backup.sql I repeated this for all 3 tables, giving the each sql file a different name. From my understanding, I can call the backup file anything I want. This seemed to work because each sql file I made had data in it, so all seemed well. 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? I am logged on as root on both machines when I do this, and I have the right username and password for the database. Thanks! Aaron --------------------------------------------------------------------- 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
