RE: microsoft sequel server

2005-06-09 Thread DChristensen
Look at the EMS family of MySQL products. They have a data pump utility that works to move data from lots of sources to MySQL. Also, Borland has a data pump utility packaged with their development tools. There's also a utility called DBScriptor that works well to migrate data. Dave

RE: Codes for U.S. Counties

2004-06-03 Thread DChristensen
You should try the USGS or the USPS sites. I would expect that either of them might offer a set of standard codes for identifying counties from the US. Dave -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 9:22 PM To: [EMAIL PROTECTED]

RE: Where do exported SQL files go?

2004-06-02 Thread DChristensen
You can change the download options so that it will ask you where you want to put the file rather than default to the desktop. Tools/Options/Downloads/Ask me where to put every file. Dave -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004

RE: mysqldump and auto_increment

2004-05-18 Thread DChristensen
Gabe, There are actually some problems caused by how auto increments are tracked in the database. We do our backups by using mysqldump at night and preserving all of the log files that were created during the day. The problem occurs during recovery where auto increment values can be incremented

MySQL and OpenSSL

2004-05-06 Thread DChristensen
We're trying to set up SSL so that we can access our MySQL server from a remote site. I am having a hard time trying to find a HOW-TO that describes the whole process, and am finding instead little snippets scattered all over. Can anyone point me in a direction that might provide more (and

RE: Please HELP !!! Can not restart server

2004-04-08 Thread DChristensen
Please look in your data directory and post the contents of the host name.ERR file that you find there. That will give folks the information they need to help solve your problem. -Original Message- From: Ginger Cheng [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 10:21 AM To:

Configuring SuSE Pro 9.0, MySQL 4.0.18 with ssl

2004-04-08 Thread DChristensen
We have been looking and looking for some guidance for installing MySQL with SSL on a SuSE 9.0 box. By searching the archives, the net using Google, etc., we keep finding pieces of the puzzle, but no single piece that covers all of the ground. The problem is that we seem to complete the

RE: MySQL on Linux

2004-04-06 Thread DChristensen
What we've done on Red Hat 7.3, 8.0 and 9.0 boxes, then on a SuSE 9.0 box is to set up InnoDB and have multiple files defined at 2GB. We just keep adding additional files as we need them and performance seems to be holding okay. -Original Message- From: Eric Gunnett [mailto:[EMAIL

RE: starting mysql daemon

2004-04-01 Thread DChristensen
Errno 13 indicates a permissions error. Please check the ownership of the data directories you're using to make sure that the mysql user group. Dave -Original Message- From: muhammad alqama [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:46 AM To: [EMAIL PROTECTED]; [EMAIL

RE: mysqldump error

2004-03-21 Thread DChristensen
First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example: mysqldump -uuserid -ppassword --add-drop-table mtweblog BckUpmtweblog.sql -Original

RE: mysqldump error

2004-03-21 Thread DChristensen
Errorcode 13 indicates that there is a permissions error of some sort. I'd double check that the mysql user/group own the data directories on the new machine. I've also found that setting up the new database on the new server helps before loading data to it. For example: mysqldump -uuser

RE: ORACLE to MySQL migration

2004-03-17 Thread DChristensen
You have a number of options, but to name a couple you could: .. Use a tool called DBScriptor to export schema/data out of Oracle and with a few tweaks it can generate MySQL DDL/insert statements. .. Use an ODBC pump tool like those included with the Borland tools like

RE: New to MySQL

2004-03-17 Thread DChristensen
Why don't you try MySQLCC from the MySQL site? -Original Message- From: Terry Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 4:25 AM To: [EMAIL PROTECTED] Subject: New to MySQL I have just started having a look at MySQL. I have the server installed and running with the

RE: VB and mySql

2004-03-07 Thread DChristensen
You shouldn't have any problems using VB to write software with MySQL. -Original Message- From: Walt [mailto:[EMAIL PROTECTED] Sent: Sunday, March 07, 2004 11:01 AM To: [EMAIL PROTECTED] Subject: VB and mySql I used to program with VB using MS access as the db. VB was very quick to

FW: Installation issue on SuSE 9.0 Pro box

2004-02-13 Thread DChristensen
Title: FW: Installation issue on SuSE 9.0 Pro box I was curious if anyone has experienced this same error and even more curious to see if anyone might offer some advice. Thanks! Dave -Original Message- From: David Christensen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February

RE: FW: Installation issue on SuSE 9.0 Pro box

2004-02-13 Thread DChristensen
Yes, there are spaces/tabs before and after the equal sign. One interesting thing is that I uncommented the lines in the stock .cnf files for the bdb options and the error moved to the first of the bdb options. That would indicate to me that it's in the datadir line, but I can't see an error

RE: MySQL 4.0 Installation Problem -- trying again

2004-01-08 Thread DChristensen
What does the hostname.err file tell you? -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Thanks ... but yeas, I have

Zeos, MySQL problem

2003-12-15 Thread DChristensen
Good Afternoon! We're building an application with Delphi 7.0, the Zeos controls and MySQL v.4.0.15 which runs on a Red Hat 7.3 server. We are experiencing a problem where when a person lets the application sit for a while, we're losing dataset connectivity that doesn't restore itself. I've

RE: Zeos, MySQL problem

2003-12-15 Thread DChristensen
Thanks, Jon. I'll try that and report back. -Original Message- From: Jon Frisby [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:06 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Zeos, MySQL problem You can disable connection timeouts at the

RE: Choosing between VARCHAR and TEXT

2003-11-21 Thread DChristensen
One additional consideration would be if you're planning on doing a lot of mailing you should consider having some sort of address validation software. Once you settle on that package, it will also help you determine maximum field/column sizes. After looking at the package(s) you may decide to