mysql import hell

Anon

So I'm trying to import data from the main server to my local server and I still haven't been able to get it to work smoothly. First the main server is a freeBSD box and everything works wonderfully but here I'm running a W2K server.

Problem #1: I try using the mysqlimport command. I use mysqlimport -u user database news.sql and it imports just line id numbers with no data. I've tried lots O switches and none of them seems to work. Also it's a hassle because it wants the table already to be created which I do in phpMyAdmin or it fails on the insert and you have to have the .sql file in the mysql/data folder for it to work also. I also make the import statement include all the field names and it still doesn't work

Problem #2: I move over to phpMyAdmin. I can't cut and paste the whole insert statement into the SQL query box because it's to big and it freezes my machine. So I try the file upload feature and get the notorious:

Warning: fopen("\php2","r") - Unknown error in D:\Inetpub\wwwroot/phpMyAdmin/db_readdump.php3 on line 46

Warning: Unable to find file identifier 0 in D:\Inetpub\wwwroot/phpMyAdmin/db_readdump.php3 on line 46

error. Any ideas? Am I missing some switch in the mysqlimport function? By the way the command works great on the freeBSD box. I don't care which way to do it I just need it to work...

Anon

Hello,

I have same problem with phpmyadmin when i try to upload on a Win machine.

If it's possible, connect W2K MySQL Server via phpmyadmin on a Linux system. You can define W2K MySQL Server as a secondary server in config.inc.php3 file. Then try upload it with this phpmyadmin. I am not sure, but it can work.

Anon

Using mysqldump and mysqlimport at the comand line is the only way.

After many hours wher the table would be created BUT only one(or few) records would go at the time. When I did it at the console NO problem the Entire table when up in only one trial.