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
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
___
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
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
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
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
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, 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
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
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
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
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
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.
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
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
--
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
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
:(
Thank you,
Jannie Qu
_
Unlimited Internet access for only $21.95/month. Try MSN!
http://resourcecenter.msn.com/access/plans/2monthsfree.asp
-
Before posting
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
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
20 matches
Mail list logo