RE: Dumping mass inserts?

2004-06-18 Thread Michael McTernan
-- > From: Michael McTernan > Sent: 09 April 2004 18:30 > To: James E Hicks III; [EMAIL PROTECTED] > Subject: Re: Dumping mass inserts? > > > >> Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm > >> trying to import the data from backup, int

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote: > Ok now I want to "dump" tables with names starting with "phpads" so I can > move them to another db. How is the mysqldump command run then? > > And when I go to move them to the new db, I do use the mysqldump command >

Re: Dumping mass inserts?

2004-04-09 Thread Mark Susol | Ultimate Creative Media
>> Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm >> trying to import the data from backup, into an empty table since the data >> was corrupt. > > Looks like you are on the right track now! :) > > James Ok now I want to "dump" tables with names starting with "phpads" so I

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
On Friday 09 April 2004 11:40 am, Mark Susol | Ultimate Creative Media wrote: > > On Friday 09 April 2004 11:29 am, you wrote: > >> I'm not getting an error..I'm getting inserts that are NOT in the file > >> I'm directing it to dump. Maybe I don't understand the dump function and > >> how it works

Re: Dumping mass inserts?

2004-04-09 Thread Mark Susol | Ultimate Creative Media
> On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote: >> I'm trying only to update one table from a backup. I have the sql file >> stripped down to just the INSERT commands. I have emptied the table from >> phpMyadmin to start. >> >> How do I load this sql file so it runs

Re: Dumping mass inserts?

2004-04-09 Thread Egor Egorov
Mark Susol|Ultimate Creative Media <[EMAIL PROTECTED]> wrote: > I'm trying only to update one table from a backup. I have the sql file > stripped down to just the INSERT commands. I have emptied the table from > phpMyadmin to start. > > How do I load this sql file so it runs all of the inserts in

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote: > I'm trying only to update one table from a backup. I have the sql file > stripped down to just the INSERT commands. I have emptied the table from > phpMyadmin to start. > > How do I load this sql file so it runs all of