RE: microsoft sequel server
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 -Original Message- From: Dan Rossi [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 6:51 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: microsoft sequel server Import via odbc ? I used an app called sqlyog to import via odbc. On 09/06/2005, at 9:45 AM, Kirk wrote: Is anyone familiar with how to dump a database from Microsoft sequel server to mysql? I know nothing about Microsoft products and am looking for a utility or similar to do the conversion. Maybe Microsoft has something built in? Although I doubt it. TIA Kirk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Codes for U.S. Counties
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] Subject: Codes for U.S. Counties I have a big database focusing on U.S. counties. I'd like to assign each county a code for use as a key. I'm thinking of simply using the state postal code, followed by numerals. For example, Arizona's counties would be arranged alphabetically, beginning with az1, az2, az3, etc. I just wondered if anyone on this list has worked with counties in databases and is aware of a pre-existing code system that's in fairly wide use. It would be nice to make a database that's compatible with other databases, if they share a common code for counties. Thanks. __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: Where do exported SQL files go?
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 12:18 AM To: [EMAIL PROTECTED] Subject: Re: Where do exported SQL files go? --- Robert A. Rosenberg [EMAIL PROTECTED] wrote: At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where do exported SQL files go?: (I'm using Mozilla Firefox, which downloads everything to the desktop, though I don't understand why it considers this a download when it's a database on my computer.) Might it be doing this due to PHPAdmin being a WebPage application and thus being served by your Web Server making the file need to be a FTP Download g? Well, that's as good an explanation as any. :) It isn't that big a deal; at least I know where I can find everything I download, and I can always copy and rename them and move them somewhere else if necessary. It just confused me this time around. __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump and auto_increment
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 even though a record wasn't stored. In our case, that causes a situation where we add a row in an agent table, then using the value of the agent-id we create a number of rows in other tables. However, when that gets replayed in circumstances where we restore a mysqldump (effectively placing us at a begin-of-day point), then replay logs, we will link the subsequent records with other people rather than with the agent to whom they are supposed to be linked. It would be nice to have that resolved, but for now we are redesigning some of our processes to avoid the issue. Dave Christensen -Original Message- From: Tucker, Gabriel [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 11:36 AM To: Mysql General (E-mail) Cc: Philip Antoniades (E-mail) Subject: mysqldump and auto_increment Hello I am using MySQL v4.0.18. I am using the mysqldump program to do backups. I was wondering how, if at all, does mysqldump preserver the auto_increment value? When using phpmyadmin, there is an option to preserve the auto_increment value and the resulting file has something like: ) TYPE=MyISAM COMMENT='Defines assignments' AUTO_INCREMENT=15 ; in the create table definition. When I run mysqldump and look at the resulting file, I do not see anything like this. Nor, can I find documentation on what phpmyadmin is doing. Thanks in advance! Gabe Arise Arise A Rose A Rose Gabriel Tucker 609 750 6668 - P 646 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and OpenSSL
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 better) information in one place? Any help would be really appreciated. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED]
RE: Please HELP !!! Can not restart server
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: [EMAIL PROTECTED] Subject: Please HELP !!! Can not restart server Hi, MySQL Gurus, Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I started mysql server with 'safe_mysqld --user=root ' . Then I found some variables needs to be optimized. SO I shut it down with 'mysqladmin -p shutdown' using root. But I was connected to the mysql server at the moment as ginger thru another connection. But the server is down all right (at least to me). Then I logged out in my connection as ginger to mysql server. Then I changed the variables in /etc/my.cnf and try to bring up the server using 'safe_mysqld --user=root '. Here is what I got: /usr/usr/bin/safe_mysqld --user=root /usrStarting mysqld daemon with databases from /var/lib/mysql 040408 08:00:06 mysqld ended [1]+ Done/usr/bin/safe_mysqld --user=root I moved the old mysql under datadir to another place and run 'mysql_install_db'. Then I run 'safe_mysqld --user=root '. Still the same thing. I even tried to restart the server again but it does not work either. I have also tried to restore the my.cnf file and there is no effect. Please help me. I need it to be fixed as soon as I can. Thank you so much ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Configuring SuSE Pro 9.0, MySQL 4.0.18 with ssl
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 install, but cannot seem to have the ssl-enabled show 'yes'. Any help that you can offer would be appreciated very much. David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED]
RE: MySQL on Linux
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 PROTECTED] Sent: Tuesday, April 06, 2004 4:54 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL on Linux I have had this happen on 2 boxes one running Redhat 7.2 and the other running Redhat 8. I can tell MySQL does not like not being able to write to the file anymore. We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing a lot of corruption. In one instance it actually took the table and zeroed it out leaving me with no data, and having to recover the 2 gig table, then watching it happen again. Eric Gunnett System Administrator Zoovy, Inc. [EMAIL PROTECTED] Alan Williamson [EMAIL PROTECTED] 04/06/04 02:47PM dan wrote: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when Apache gets to the 2GB size on its access file, it does indeed stop. This is not old hardware (12months old). So don't be spouting any sweeping statements. If your distribution doesn't have that limitation, then fantastic, good for you. But for others it is indeed a real limitation. The original question was indeed a geniue one, and while the poster accidently typed in the wrong size, i wouldn't be so quick to jump all over him. So the question still remains. What would happen in MySQL when that file isn't allowed to grow any further? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: starting mysql daemon
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 PROTECTED] Subject: Re: starting mysql daemon hi the error mentioned in the file is... fatal error : can not open privilege tables can not find file : './mysql/host.frm' (errno 13) what to do now... regards alqama - Original Message - From: Victor Pendleton [EMAIL PROTECTED] Date: Wed, 31 Mar 2004 16:03:43 -0600 To: muhammad alqama [EMAIL PROTECTED] Subject: Re: starting mysql daemon This file is normally located in the data directory On Wed, 31 Mar 2004, you wrote: hi can u tell me where this file hostname.err lies as i have searched and not found it . - Original Message - From: Victor Pendleton [EMAIL PROTECTED] Date: Wed, 31 Mar 2004 15:17:54 -0600 To: muhammad alqama [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: starting mysql daemon Did you check in the hostname.err file to see why MySQL ended? On Wed, 31 Mar 2004, muhammad alqama wrote: hello i am using slackware linux and i installed mysql server with the installation. now i am trying to start the mysql daemon but it is not being start. i have run mysql_install_db --user=mysql .. it runs successfully. but as i run the command mysqld_safe to run daemon it gives the following output.. i run.. root../usr/bin mysqld_safe --user=mysql the output is [1] 1273 root../usr/bin starting mysqld daemon with database from /var/lib/mysql 040325 01:57:32 mysqld ended (the prompt root../usr/bin is not returned.. i have to press ctrl+c) also if i run root../usr libexec/mysqld the message is fatal error : please read security section of the manual to find out how to run mysqld as root 040325 2:10:39 aborting 040325 2:10:39 libexec/mysqld shutdown complete please tell me what to do to start the daemon -- Are you a Proud Pakistani ? Get your free Pakistani email from http:// www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/ mysql To unsubscribe:http://lists.mysql.com/ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/ [EMAIL PROTECTED] -- Are you a Proud Pakistani ? Get your free Pakistani email from http:// www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- Are you a Proud Pakistani ? Get your free Pakistani email from http://www.pakistans.com Please visit our sponsors www.shopngift.com ( Gifts to Pakistan ) www.cdstore.com.pk ( Buy Online Pakistani and Indian CD) Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqldump error
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 Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
RE: mysqldump error
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 -ppassword --no-data mtweblog mtweblog.ddl mysql -uuser -ppassword mtweblog.ddl mysql -uuser -ppassword bkupmtweblog.sql -Original Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 5:13 PM To: [EMAIL PROTECTED] Cc: mysql Subject: Re: mysqldump error thanks - i ran the command below and it worked. and now I'm trying to import using: 'mysql -u root -p mtweblog Bckupmtweblog.sql' on CLI on different machine and am getting Error 1 at line 11: Can't create/write to file'./mtweblog/mt_author.frm' Errorcode 13. any suggestions here? tait On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote: 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 Message- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog BckUpmtweblog.sql' from CLI it gives Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect. when i log into mysql and do 'mysqldump --opt mtweblog BckUpmtweblog.sql;' it gives Error: 1064: You have an error in your SQL syntax. can anyone help me to dump this databse? tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]
RE: ORACLE to MySQL migration
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 Delphi, or like the EMS DataPump tool. Have fun! :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 9:48 AM To: [EMAIL PROTECTED] Subject: ORACLE to MySQL migration Hello colleagues, I have to migrate a lot of ORACLE 8.1.7 databases to MySQL 3.23 I'm looking for a tool or for an algorithm which fully supports any ORACLE structures ... If needed I may use a commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to MySQL
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 default settings and I now need to create a database and tables. I will be testing all locally on WinXPpro. I would like to use phpMyAdmin but am having some trouble displaying the index.php page. IE shows code, or does not load at all, MacromediaMX is complaining about a server not existing. Or is there another way? I guess I could be missing a few nuts-n-bolts, what services do I need to run on WinXP and their configs? Is there anywhere where I can find some info for absolute beginners to try and shorten the learning curve? Once up and running I expect to be linking using Access 2000 with which I have some experience and hope to port over some tables. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
RE: VB and mySql
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 develope nice looking forms. Which language would be the best to use with mysql to create similiar forms. These forms would be for scrolling through the db, adding, updating, deleteing, printing... Walt
FW: Installation issue on SuSE 9.0 Pro box
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 12, 2004 11:22 AM To: mysql Subject: Installation issue on SuSE 9.0 Pro box Good Morning! I'm trying to get MySQL 4.0.15 running on a new SuSE linux PC. This is my first attempt installing on SuSE after setting up a large number of Red Hat machines without problem. Right now, however, I'm continually receiving errors that I just don't understand where they are coming from. I've even copied the .cnf file from my primary MySQL server (which has been running for months) and get the errors when it's trying to fire up. Errors received are: 040211 17:31:37 mysqld started /usr/sbin/mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/data/mysql/' 040211 17:31:37 mysqld ended To get started, I copied the my-large.cnf to /etc as my.cnf and have edited the file to reflect the directories I'm using to store data and logs. The file I am using is as follows: (See attachment) I just don't get this one. All of the syntax seems okay, and I'm actually using the file on a Red Hat 9.0 machine. Thanks! Dave Christensen # *** # *** MySQL Database Parameters for Brokers International, LX01 *** # *** === *** # *** Author: D Christensen Date: April 2, 2003 *** # *** Production Databases*** # *** # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /var/data/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/data/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=16M set-variable= table_cache=256 set-variable= sort_buffer=16M set-variable= record_buffer=16M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 # log-bin server-id = 1 # basedir = /var/lib/mysql datadir = /var/data/mysql innodb_data_home_dir = /var/data/mysql innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M:autoextend innodb_log_group_home_dir = /var/data/logs/mysql/ innodb_log_arch_dir = /var/data/logs/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high set-variable = innodb_buffer_pool_size=256M set-variable = innodb_additional_mem_pool_size=20M # Set .._log_file_size to 25 % of buffer pool size set-variable = innodb_log_file_size=64M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 # Point the following paths to different dedicated disks tmpdir = /usr/tmp/ log-update = /var/data/logs/mysql/LX01 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: FW: Installation issue on SuSE 9.0 Pro box
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 there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 1:55 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: FW: Installation issue on SuSE 9.0 Pro box Just a guess but do you any space between the key and value? innodb_data_home_dir = /var/data/mysql Original Message dated 2/13/04, 1:21:26 PM Author: [EMAIL PROTECTED] Re: 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 12, 2004 11:22 AM To: mysql Subject: Installation issue on SuSE 9.0 Pro box Good Morning! I'm trying to get MySQL 4.0.15 running on a new SuSE linux PC. This is my first attempt installing on SuSE after setting up a large number of Red Hat machines without problem. Right now, however, I'm continually receiving errors that I just don't understand where they are coming from. I've even copied the .cnf file from my primary MySQL server (which has been running for months) and get the errors when it's trying to fire up. Errors received are: 040211 17:31:37 mysqld started /usr/sbin/mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/data/mysql/' 040211 17:31:37 mysqld ended To get started, I copied the my-large.cnf to /etc as my.cnf and have edited the file to reflect the directories I'm using to store data and logs. The file I am using is as follows: (See attachment) I just don't get this one. All of the syntax seems okay, and I'm actually using the file on a Red Hat 9.0 machine. Thanks! Dave Christensen
RE: MySQL 4.0 Installation Problem -- trying again
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 done both and still got that ... that's why I was asking the questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Charles, First, you need to run the mysql_install_db script. That will create the initial mysql database tables which is where security is tracked. Next, you will need to use the chown command to change the ownership of your mysql data directory (and I would include the logging directory, too) to be owned by mysql both as user and group. Once these two steps are finished, it should run for you. Dave David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Thursday, January 08, 2004 12:22 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 Installation Problem -- trying again OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_install_db will set the initial grant tables for me and I don't need to worrry about that before the server starts. But I still get that error. I am logged in as root. I installed Mysql on NT a long time ago and that was easy. Any help? Thanks. -Original Message- From: Zhao, Charles Sent: Wednesday, January 07, 2004 5:14 PM To: '[EMAIL PROTECTED]' Subject: RE: MySQL 4.0 Installation Problem Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh binary installation of it on my Linux 7, under usr/local/ directory. Followed the manual step by step until I started the server: /bin/mysqld_safe (also tried it with parameter user=mysql), but I got mysql ended ... [1]+ Done./bin/mysqld_safe msg, and I could not run any further commands, failing with msgs like Can't connect to local MySQL server though socket '/tmp/mysql.sock', Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! then I found in the sql log file: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... when starting the InnoDB tables. Both files mysql.sock and host.frm are not mentioned in the manual, and not found in my file system. Any one can point out the problem? Thanks. -Original Message- From: Zhao, Charles Sent: Tuesday, January 06, 2004 4:53 PM To: '[EMAIL PROTECTED]' Subject: MySQL 4.0 Installation Problem I have 3.23 that comes with my Linux distribution, now when I tried to do a rpm installation of 4.0, I got messages like: warning: MySQL-server-4.0.17 ... .rpm: V3 DSA signature: NOKEY, key ID ..., file /usr/bin/mysql from install of MySQL-client-4.0.17.0 conflicts with file from package mysql-3.23.52-3 ... file /usr/shar/man/man1/ ... from install of ... conflicts with file from package mysql-3.23... ... and the conflict list goes on. The installation manual does not seem to discuss about such issues. Do I need to remove my 3.23 before I run the installation? -- but that's not what the manual says, though. The first warning msg, is that a problem, too? Thanks.
Zeos, MySQL problem
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 been studying the documentation and I'm not finding any settings that would stop the timeout from happening. If anyone is aware of what to change, or has experienced the same problem, please let me know. BTW, I wasn't sure that this would be the place to post this sort of question and would appreciate some guidance where I should go instead if necessary. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
RE: Zeos, MySQL problem
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 MySQL server level. You should check the docs to be sure, but I think the relevant variable is wait_timeout -- setting it to 0 should disable connection timeouts. -JF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 12:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Zeos, MySQL problem 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 been studying the documentation and I'm not finding any settings that would stop the timeout from happening. If anyone is aware of what to change, or has experienced the same problem, please let me know. BTW, I wasn't sure that this would be the place to post this sort of question and would appreciate some guidance where I should go instead if necessary. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
RE: Choosing between VARCHAR and TEXT
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 offer more fields as well. -Original Message- From: William Fong [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 10:05 AM To: [EMAIL PROTECTED] Subject: Re: Choosing between VARCHAR and TEXT Will any names or addresses exceed 255 characters? The documentation recommends to use the smallest column size possible. -will Real-time Chat: irc.freenode.net - #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: Paul Fine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 21, 2003 7:34 AM Subject: Choosing between VARCHAR and TEXT Can anyone tell me what is better to use for items such as names and addresses? I suspect VARCHAR(max anticipated length) but why? Is it because Text will pad? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]