Perhaps you mean 'sed'.
Filipe Tomita wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
