RE: Dumping mass inserts?

2004-06-18 Thread Michael McTernan
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, into an empty table since the data was corrupt. Looks like you

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 the

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 this

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 all of

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 with a sql

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 can move them

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 since I