Re: Restoring a table with a different name

Mike Nolan said:

> I have a 600K row table on my production system (running 7.3.3)
> that I dump and load on my development system (7.4.1) every night using
> cron jobs.
>
> I would like to be able to restore the table under a different table name
> without first having to play games with the development copy of the table.
>
> If I edit the dump file with 'sed' to change the table name, I get
> 'invalid command \N' errors trying to reload it.

What sed syntax are you using?

Best,

Jim Wilson