tks for reply but i dont have acces to original database... the dump file not generated from me.. Someone tell me about "SAD" command to replace table name to correct name but i dont find anything about it.
On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Filipe Tomita <[EMAIL PROTECTED]> wrote on 09/09/2005 04:37:01 PM: > > > Hi people, > > > > I having problems to import a dump generated via mysql dump in mysql > > 4.0.20slackware version to a mysql > > 4.1.14. > > The dump generated with other table name (Insert into temp, temp2 , > temp3) > > in 20 sql large (420mb.) sql files. > > I tried LOAD DATA INFILE but data not inserted correctly, someone > help-me?? > > > > tks. > > > > Tomita > > If you look at the output from mysqldump, you will realize that it is just > a series of SQL statements. Execute them with your command line client just > as you would any other SQL script file. > > mysql database -u username -p < dumpfile.txt > > or use the source or . commands if you are already in the CLI > > mysql>source dumpfile.txt > > > Where you will run into problems is if you didn't specify a > max_packet_length WHEN YOU MADE THE DUMP. That option tells mysqldump just > how long the longest single statement can be. If you try to run a dump file > that contains a statement that exceeds the max_packet_length setting on your > server, it will fail silently (server gone away). > > If you failed to dump with a maximum set, your options are to increase the > MAX_PACKET_LENGTH on the server to accept the longest single statement in > your dump file or to edit your dump by hand and break your long statements > into shorter ones or both. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine >