How to use foreign_key_check=0 at shell prompt level?

Hi, all, sql, query. I try to use a mysqldump file from development database and insert back into production database on another server. bkp_dbname.sql is copied over to prodution, and I am using the following command at production. shell> mysql -ujqu -pjqu1234@ dbname < bkp_dbname.sql File

How to get mysql owner password?

Hi, all, sql, query. I started working on an old MySQL 3.23.47 database server on SunOS 5.7, but I only have a regular user account. I cannot access "mysql" database. I tried to use OS user "root" and "mysql" to login without password, but it failed. No one at my company knows other username a

MySQL security vulnerabilites question

Hi, all, sql, query. Greetings. I got the following information. Does any one of you know whether it will impact my MySQL db server or not: Version 3.23.53 with InnoDB on Mac OS Darwin Kernel Version 6.2. If it does, what's the solution? Thank you, Jann

multiple references

mysql, query Hi, all, I have a development table which is created using the following commands on 3.23.53-log mysql server on MAC 10 CREATE TABLE web_transaction_item( trans_item_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, trans_id INT UNSIGNED, prod_id INT UNSIGNED, INDE

How to generate my.cnf based on existing configuration?

sql, query Hi, all, I started to support on an old mysql production database on SunOS 5.8 and mysql version 3.23.47 with only MyISAM type of tables. I take a look on /etc/init.d/mysql file, and in this file, it will refer /etc/my.cnf. But there is no my.cnf file at that directory. I cannot sh

mysql backgroup process refers to nonexisting my.cnf file

Sql, query, Hi, all, I found on our clients mysql database machines, there is no my.cnf file by doing a global search, but when I did the following command, it seems that mysql process is referring to this file (--default-extra-file=/export/mysql/data/my.cnf ). Do you think it's normal? Than

Is rename table to another database safe for INNODB tables

sql, query, Hi, all, As you may knew, mysql will implement "rename database" in version 4.1 Right now, I need to rename a database, what I plan to do is rename each table (INNODB type, version 3.23.53 on MAC OS) to another new database. RENAME TABLE current_db.tbl_name TO new_db.tbl_name; Do y

mysql upgrade from 3.23.47 to 3.23.55 on Sun OS 5.8

sql, query. Hi, group, Greetings! I'd like to hear your advice about "what's the best way to upgrade 3.23.47 to 3.23.55 on SunOS 5.8 with less downtime"? Thank you, Jannie _ Add photos to your e-mail with MSN 8. Get 2 months

upgrade Patch?

sql, query Hi, group, Do you know whether there is an upgrade patch for 3.23.47 to 3.23.55 on SunOS 5.8 rather than a new installation? Thank you, Jannie _ The new MSN 8: advanced junk mail protection and 2 months FREE* http

Migrate mysql from SunOS 5.8 to Windows 2000

Hi, group, Greeting. We will migrate MySQL 3.47 from SunOS to Windows 2000. (I guess I have to use mysqldump). Well, I wonder any one of you who knows whether there is any forseeable problem of using production/busy mysql database on windows 2000 operating platform? Thank you, Jannie ___

Re: Migrate mysql from SunOS 5.8 to Windows 2000

ROTECTED]> To: "Jannie Qu" <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: Migrate mysql from SunOS 5.8 to Windows 2000 Date: Thu, 3 Apr 2003 14:15:29 -0700 Not if 0)strong processor (at least 2GHz) 1)you have enough RAM (1GB will do) 2)have enough SCSI or RAID D

About mysql ER diagram

Hi, all, I tried to use ERwin "reverse engineer" to automatic draw ER model diagram for mysql database tables. Some of the tables have foreign key constraints. But ERwin is not able to draw the line between parent table and child table. Any one of you know how to solve this problem or any other

Create child table question

sql, query, mysql Hi, all, I met a problem with creating the following table: pub_user. -- Parent table CREATE TABLE pub_access_type( access_type_id INT UNSIGNED NOT NULL, access_type_name VARCHAR(25), PRIMARY KEY(access_type_id) ) TYPE=INNODB; -- Child table CREATE TABLE pub_user( user_id INT UNS

Mysqlhotcopy dyld: perl Undefined symbols:

:( Thank you, Jannie Qu _ Unlimited Internet access for only $21.95/month.  Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp - Before posting

How to setup autocommit off in my.cnf?

Hi, all, Greetings. sql, query. Anyone of you know the parameter for my.cnf to turn autocommit off for innoDB transaction-safe tables? Thank you, Jing _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.m

mysqlhotcopy point-in-time recovery

Hi, all, sql, query. I use mysqlhotcopy to backup innodb tables and I tried to find how to recovery database point-in-time with the help of binary log. I had tried "mysqlbinlog --user-jqu --password=1234 Host-bin.[0-9]* | mysql" without success. Anyone of you know how to recovery database poi

mysqldump performance

Hi, all sql, query. Does anyone of you know the performance of mysqldump to backup tables? Thank you, Jing _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail --

Re: Windows cnf file location

Hi, John, my.cnf is used as config file on windows. By default it is at, e.g. c:\winnt your boot system directory. It's not a log file. From: John Chang <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Windows cnf file location Date: Tue, 12 Nov 2002 15:27:05 -0500 Where is the config fil

How to direct mysqldump error to a file?

Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output > /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb > bkp1.sql 2> err.log Ambiguous output redirect.

Re: How to direct mysqldump error to a file?

ot;bash-2.05a$" is PS1 setting. From: Paul DuBois <[EMAIL PROTECTED]> To: "Jannie Qu" <[EMAIL PROTECTED]> Subject: Re: How to direct mysqldump error to a file? Date: Tue, 19 Nov 2002 16:12:53 -0600 At 22:09 + 11/19/02, Jannie Qu wrote: Hi, Paul, Here is more mea