RE: Odd thing

2003-06-19 Thread Christensen, Dave
al Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:19 PM To: Christensen, Dave Cc: '[EMAIL PROTECTED]' Subject: Re: Odd thing Christensen, Dave wrote: >Oops! Sorry. Deleted that 'temp' table and didn't remove it from my

Re: Odd thing

2003-06-19 Thread Don Read
On 19-Jun-2003 Christensen, Dave wrote: > We're trying to set up some scripts that will run mysqldump to create > export > files for each table in a database that can be downloaded to a test > server > and reloaded. What's weird is that the files are created with the "?" > character as the traili

Re: Odd thing

2003-06-19 Thread gerald_clark
essage- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave; '[EMAIL PROTECTED]' Subject: RE: Odd thing I've also tried creating the script manually (script follows) and all that&#

RE: Odd thing

2003-06-19 Thread Christensen, Dave
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:34 AM To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]' Subj

RE: Odd thing

2003-06-19 Thread Christensen, Dave
Sent: Thursday, June 19, 2003 10:58 AM To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave; '[EMAIL PROTECTED]' Subject: RE: Odd thing I've also tried creating the script manually (script follows) and all that's being created is a text header with nothing else in

RE: Odd thing

2003-06-19 Thread Christensen, Dave
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB users -uroot -ppano4577 > users.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB usertypelookup -uroot -ppano4577 > usertypelookup.sql + -Original Message- From:

RE: Odd thing

2003-06-19 Thread Christensen, Dave
d'; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing Hi, are you using MSDOS/Windows anywhere here - it might be a trailing ^M which Windows uses before ^J as the end of line character. Regards Matthew -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sen

RE: Odd thing

2003-06-19 Thread Jay Blanchard
[snip] mysqldump AgentAdminDB activitylookup -u UserName -pPassword > //var/data/mysql/activitylookup.sql mysqldump AgentAdminDB agencies -u UserName -pPassword > //var/data/mysql/agencies.sql mysqldump AgentAdminDB agentdocuments -u UserName -pPassword > //var/data/mysql/agentdocuments.sql mysqldu

RE: Odd thing

2003-06-19 Thread Dickey, Dallas
Delphi is being used to create a file with a mysqldump command per table -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:43 AM To: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] We're trying t

RE: Odd thing

2003-06-19 Thread Dickey, Dallas
Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:52 AM To: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] Just creating shell scripts with one line creating each file. This is our first attempt to see how workin

RE: Odd thing

2003-06-19 Thread Matthew Smith
PROTECTED]' Cc: Dickey, Dallas Subject: RE: Odd thing Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. -Original Message- From: Jay Blanchard [mai

RE: Odd thing

2003-06-19 Thread Jay Blanchard
[snip] Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. [/snip] It sounds as if (based on past experience) that the filename is being created with an additional charac

RE: Odd thing

2003-06-19 Thread Christensen, Dave
: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files a

RE: Odd thing

2003-06-19 Thread Jay Blanchard
[snip] We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the "?" character as the trailing character in the file name and we can't ope