Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user creation.
3. Exit
My script file should have
mysql -u root
create database mnms;
user creation command
The script
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do
Hi,
I have mysql-4.0.18 installed and entered data with UTF-8 characters.
When I use a Select command, mysql doesn't sort the data correctly which
starts with native Turkish letters. Is there a way to fix it?
Thanks..
--
Erol YILDIZ
HEV Schools Kemerkoy
http://www.kemerkoy.k12.tr
--
MySQL
Erol YILDIZ wrote:
Hi,
I have mysql-4.0.18 installed and entered data with UTF-8
characters. When I use a Select command, mysql doesn't sort the data
correctly which starts with native Turkish letters. Is there a way to
fix it?
MySQL 4.0.x doesn't support UTF-8, you need MySQL 4.1.x (4.1.8 is
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user creation.
3. Exit
My script file should have
mysql -u root
create database mnms;
user creation command
The
Hi all,
from time to time I have a huge number of DELETEs or/and UPDATES
processed by MySQL at noon and 8pm. The trouble is that I didn't send
those queries to MySQL !
i don't have any crons running.
Is this an automated MySQL procedure ? Is there any automated procedure
within MySQL?
thanks
Hi All,
I run a website, and am having a problem w/ corrupt databases..
I was runnig MySQL v3.23 previously, and my db dumps worked fine .. However, I
have since upgraded to v4.1.8a-log and I am having problems getting completed
(or non corrupt) backups.. The problem is pretty big..
My
The -e option with mysql allows you to run queries and would allow doing
user creation etc as well.
Aman Raheja
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
It's probably your JOIN on shipped items producing a cross product with
your JOIN on ordered items. What happens if you take the entire
shippeditems JOIN out of your statement? Are your numbers still off?
Since your query is not using data from that table you should be able to
eliminate it
Raj Shekhar wrote:
Mark Maggelet wrote:
Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext
index on it. The table gets corrupted every 1 week or so and I have
to repair it. I've tried upgrading to newer versions of mysql 3 times
but the problem persists. I think it may have
Hello.
As of MySQL 4.1, ISAM support is included in the source but not enabled in
binary distributions.
[EMAIL PROTECTED] wrote:
hello
i hope im correct here
i have a problem, after upgrade 4.1 from 4.0 one table is away (index)
i have table.ISM,.frm and .ISD.
when i try to
Hello.
Use --log and --log-long-format (if your MySQL version below 4.1) to
determine who makes these queries.
Dilipan Sebastiampillai [EMAIL PROTECTED] wrote:
Hi all,
from time to time I have a huge number of DELETEs or/and UPDATES
processed by MySQL at noon and 8pm. The trouble
Hello.
In what way have you upgraded? How do you dump the data? Is everything fine,
execept the database dump? As of MySQL 4.1, --opt command line option is on by
default, so it can produce a smaller output. The definions of tables
which stores Avatars are also absent in dumps? May be you
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
Hi everybody,
I want to connect with people who have experience in modeling/building a
MySQL DB where most of the data are measured timeseries, structured by
physical/geographical locality of the measuring equipment and different sets
of
measured values (attributes, ie. sci-tech data, no
All,
I found my database hung this morninig on a Linux
system.
I could not connect locally to /tmp/mysql.sock or
remotelly.
I tried to do a mysqladmin status; but that hung
too.
Linux was reporting high CPU utilization.
The proces infromation is as follows:
Name: mysqld
State: T (stopped)
Thanks for the reply.
My original install was w/ an RPM from the Redhat Network, I uninstalled all
RPM's associated w/ MySQL, Apache, and PHP and downloaded the latest of
everything and compiled it. After I did an updatedb on my box, I searched for
mysqldump and mysql to confirm it was gone --
This is using MySQL version 3.23.49
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE
`jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES
TERMINATED BY '\\r\\n';
is getting
I think I'm bringing this up again but with different errors.
This: $sql = LOAD DATA INFILE '$file' REPLACE INTO TABLE
`jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '' LINES
TERMINATED BY '\\r\\n';
is getting the error Access denied for user:
Hi! We're setting up a Solaris system which is behaving poorly, very slow
disk performance. The nice folks at Sun have suggested a mismatch between
the block size MySQL is writing to disk and the block size the the Operating
System is writing to disk.
While we can see the logic in the argument, I
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the
When I look at the dump file, I see that one of the invalid characters is
represented as /226 I'll have to look to see if it is consistent, and just
replace it.
Thanks.
Quoting [EMAIL PROTECTED]:
are you sure that the single/double quotes in your original data were
actually the standard
I would suggest using Reply All.
I can not figure out anything with the information here, and I have not
used this linux version and kernel with mysql.
Slow queries: 2 - that might mean something here - the info is at
http://dev.mysql.com/doc/mysql/en/Slow_query_log.html
This could have cause
On other instances, are escaped as \...I would think that should translate
correctly?
Thanks
Quoting Andrew Mull [EMAIL PROTECTED]:
When I look at the dump file, I see that one of the invalid characters is
represented as /226 I'll have to look to see if it is consistent, and just
I somehow managed to download and install MyODBC 3.51.10 on my XP box, and
it connects with no problems to my database server running version 4.1.7.
However, it seems that MySQL is only allowing downloads for 3.51.9, and when
I installed it on my Server 2003 and attempted to connect, I get the
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the
my.ini file.
Set-variable = old_passwords=1
It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password
hashing, 4.1.x uses a
more secure one that will be covered in MyODBC 3.53 (coming soon...).
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the
my.ini file.
Set-variable = old_passwords=1
It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of
password hashing, 4.1.x uses a more
secure one that will be covered in MyODBC 3.53 (coming
4.1 auth is not supported until MyODBC 3.51.10. I don't know why the win
binaries are not on the download page anymore, though the source is there.
Here is a mirror with the windows binaries.
http://mysql.netvisao.pt/Downloads/MyODBC3/MyODBC-3.51.10-x86-win-32bit.exe
---
Tom Crimmins
Interface
While the advice on the problem may be correct, their explanation of
the culprit I think is incorrect. Applications don't care about the
block size, that is abstracted out by the file system. Typically the
block size defaults to 4k, but that is changeable to a wide range to
suit your data
See below:
mysql (SELECT avg FROM event_log_5minute_20050104 WHERE
monitor_id=479139 AND monitor_server_id=1 AND timestamp =
2005010408 AND timestamp 2005010508 order by avg);
+-+
| avg |
+-+
|NULL |
|NULL |
|NULL |
|NULL |
|NULL |
| 55854.1 |
|
- Original Message -
From: John McCaskey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 04, 2005 5:22 PM
Subject: not all rows returned when using order by and null values?
See below:
mysql (SELECT avg FROM event_log_5minute_20050104 WHERE
monitor_id=479139 AND
Hello,
I downloaded and installed MySQL 5.0. But I could not run declare cursor
features in 5.0.
Is the cursor implementation present in 5.0 ?
Thanks,
S. Sarkar
[EMAIL PROTECTED]
On Tue, 2005-01-04 at 17:43 -0500, Rhino wrote:
- Original Message -
From: John McCaskey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 04, 2005 5:22 PM
Subject: not all rows returned when using order by and null values?
See below:
mysql (SELECT avg FROM
Hi,
I've got an odd setup that I need to diagnose. The customer won't
allow us to upgrade very far with the OS or MySQL.
Its currently on a BSD/OS 4.0.1 system, and 4.2 is the highest we
could possibly be allowed to go.
We have upgraded to mysql-3.23.58 (Customer won't
FYI, I have now verified this bug (?) occurs in 4.0.23 as well.
On Tue, 2005-01-04 at 15:03 -0800, John McCaskey wrote:
On Tue, 2005-01-04 at 17:43 -0500, Rhino wrote:
- Original Message -
From: John McCaskey [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 04,
I have a simple table in SQL Server that doesn't have
any BLOB field (no text or image columns). Only char,
varchar, bit, and int columns. I created a DTS package
that uses a simple select to copy the contents of this
table into an identical table created in MySQL through
MyODBC 3.51.
Whenver I
Even more interesting...:
mysql (SELECT avg FROM event_log_5minute_20050104 WHERE
monitor_id=479139 AND monitor_server_id=1 AND timestamp =
2005010408 AND timestamp 2005010508) order by avg;
+-+
| avg |
+-+
|NULL |
| 43282 |
| 55854.1 |
|
OK, I figured out what was going on. When I created a
varchar(256) in the MySQL destination table, MySQL
silently converted to it text (instead of protesting
that varchar maxes out at 255), and I just found the
problem by executing show create table MyTable.
--- Homam S.A. [EMAIL PROTECTED]
Hi everyone, I've always had a challenge working with dates. I'm building an
app that needs to query a range of dates. I'm using ASP (for the first time,
I usually write in Java). Anyway my date column uses the -00-00 format,
which I think is the default format? Is it?
I've read different
Hi list,
I am thinking of upgrading to MySQL v4.1.8, I installed on my local
machine(Windows XP). Copied tables from MySQL v3.23.xx to MySQL 4(eg,
mytest.MYD, mytest.MYI, mytest.frm), it works just fine, query,
sorting as usual.
I created a new table (say 'newtest') with exactly same structure
FYI, I created a bug for this (http://bugs.mysql.com/bug.php?id=7672) which has
now been updated to verified. So it looks like it is in fact a mysql bug.
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Tue 1/4/2005 3:59 PM
Cc: mysql@lists.mysql.com
Subject:
hello,
i m using mysql 4.0.18-standard version
it is not accepting subqurries.
problem is:
i have 2 tables: First(id,Flower,Color); = color is char(2);
Second(Shop,Date,Flower,Color);
first table will contain only unique flowers , and colors, id is
autoincrement.
second
select * from secondtable left outer join second.flower=first.flower
and second.color=first.color where first.flower is NULL
N. Kavithashree wrote:
hello,
i m using mysql 4.0.18-standard version
it is not accepting subqurries.
problem is:
i have 2 tables: First(id,Flower,Color); = color is
Hello:
We have multiple web sites hosted on a virtual web server. Many of the web
sites are using MySQL databases. Recently we are having problems with the
CPU load due to mysql processes. We are not able to track the corrupted
database or script (PHP). There are many databases on the server.
SELECT s.* FROM Second s LEFT JOIN First f USING (Flower,Color) WHERE
f.Flower IS NULL;
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: N. Kavithashree
Sent: Tuesday, January 04, 2005 11:17 PM
To: mysql@lists.mysql.com
Subject:
If I understand correctly, this is what you want:
SHOW PROCESSLIST
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:40 PM
To: MySQL Masters
Subject: MySQL Load on
Dear Tom,
Thank you very much. Is there a way to log all the processes on the MySQL
server to analyze later.
At 09:48 AM 1/5/2005, Tom Crimmins wrote:
If I understand correctly, this is what you want:
SHOW PROCESSLIST
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original
In you're my.cnf file (in /etc by default on a linux box) add under [mysqld]
the option log for text logging.
for example
[mysqld]
log=mylogfile
Whatever user mysqld is running as must have write perms to the log file.
You can then anaylze this as it will contain connections and queries.
---
hello,
if a progm read difft tables for some 10 times for one run each
day..how will be the load on mysql server.
usually how many table accesses per run will be there if a company is
maintaining an export business and daily read and write will be there on
tables.
Dear List Members
Can anybody give me a hint about how to compile mysql-python on a 64bit
opteron system (see the error below) with mysql tarball?
- Fedora Core 3 x86_64
- python-2.3.4
- MySQL-python-1.1.8
- mysql-standard-4.1.8-unknown-linux-x86_64-glibc23.tar.gz
Thanks in advance
Marc
python
Brian Menke wrote:
Hi everyone, I've always had a challenge working with dates. I'm
building an app that needs to query a range of dates. I'm using ASP
(for the first time, I usually write in Java). Anyway my date column
uses the -00-00 format, which I think is the default format? Is
it?
52 matches
Mail list logo