Odd thing

2003-06-19 Thread Christensen, Dave
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 open them

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 open

RE: Odd thing

2003-06-19 Thread Christensen, Dave
To: 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 are created

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

RE: Odd thing

2003-06-19 Thread Matthew Smith
: 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 [mailto:[EMAIL PROTECTED

RE: Odd thing

2003-06-19 Thread Dickey, Dallas
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 working with the smaller files

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 to set

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 mysqldump

RE: Odd thing

2003-06-19 Thread Christensen, Dave
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] Sent: 19 June 2003

RE: Odd thing

2003-06-19 Thread Christensen, Dave
] mailto:[EMAIL PROTECTED] ] Sent: Thursday, June 19, 2003 10:10 AM To: Dickey, Dallas; Christensen, Dave; [EMAIL PROTECTED] Subject: RE: Odd thing [snip] mysqldump AgentAdminDB activitylookup -u UserName -pPassword //var/data/mysql/activitylookup.sql mysqldump AgentAdminDB agencies -u UserName

RE: Odd thing

2003-06-19 Thread Christensen, Dave
, 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 the file. At least in these instances we can

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]' Subject: RE: Odd thing Importance: High

Re: Odd thing

2003-06-19 Thread gerald_clark
: Odd thing Importance: High When I run this script file, I receive errors like this: [EMAIL PROTECTED] work]# ./BackupByTable.bat mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist when doing LOCK TABLES -Original Message- From: Christensen, Dave [mailto:[EMAIL

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 trailing

RE: Odd thing

2003-06-19 Thread Christensen, Dave
- 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 script file. -Original Message- From