Hello,
I am a software developer,
I am using Mysql-4.1.3b-beta-nt,
ODBC3.5.1 driver on windows PC for an
application development.
the application which i am developing is a
client-server architecture based,in which we have to
store data of the BSM(Base Station Manager of CDMA
network).
the
Hi,
After I installed rpm packages on my system, I am unable to connect to the
databse. I have installed in the following order
1)Server
2)Client
3)Devel
4)Shared Compat
After starting the databse with:
/etc/rc.d/init.d/mysql start
I am unable to login as:
/usr/bin/mysqladmin -u root
Hello,
I recently upgraded the MySQL server from 4.0.15 to 4.1.7, without
significant problems. But I continued to use PHP-4.3.9 linked against
the old MySQL 4.0.15 on the webservers for some time. Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
Description:
OPTIMIZE TABLE on a table will sometimes destroy a table with non ascii
characters (e.g. Norwegian letters).
mysql optimize table feil;
crashtest.feil | optimize | error| 127 when fixing table
crashtest.feil | optimize | error| Can't copy datafile-header to tempfile,
error
Ziggy,
I'm not sure what you need help with.
If you want to get data into MySQL from Excel, consider saving the data (I
assume it is a table) as a CSV then using the LOAD DATA command to bring the
data into a temporary table in MySQL. Take a look at the command in the help
pages.
Regards,
Adam
Hi,
Most likely your MySQL has no password for root in the default instalation.
Try:
# mysql -u root -p
and simly press enter when asked for the password.
Worked ?
Alright, so now it's time to give root a password:
# mysqladmin -u root password 'my_secret_password'
That's all that there is to it
Hello.
It seems to be a bug:
http://bugs.mysql.com/bug.php?id=6353
Sanjeev Sagar [EMAIL PROTECTED] wrote:
Hello Gleb,
My question was related to LOAD DATA INFILE, not LOAD DATA FROM MASTER.=20
LOAD DATA INFILE work those slaves which are not using
--replicate-rewrite-db.
On Tuesday 07 December 2004 20:02, Eric Bergen wrote:
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table in
cheers guys, i have managed to change
David,
In the load data infile command you can specify the delimiter character (see
manual). It is a comma in CSV files, but I think it defaults to the TAB
character in load data infile. You can specify the delimiter to be comma in
the load command.
However, I prefer to export from Excel as
David,
Please provide the complete LOAD DATA INFILE command you used.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
- Original Message -
From: David Ziggy Lubowa [EMAIL PROTECTED]
To: Eric Bergen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 08,
David Ziggy Lubowa wrote:
cheers guys, i have managed to change my excel file into a .csv and done a
LOAD DATA INFILE and dumped the data in the mysql db the only problem though
that all the data is going into one field in the table yet it is comma
separated with the exact columns.
How can i
Hi all;
I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2
version downloaded from Mysql.com). The system is a Ultra-250 server
with multiple CPUs and 2G RAM. There are many databases but they're not
large and the load on the system is not high at all. We're using this
older
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wu_Yang_SKZ, JPcommon wrote:
java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
at
Eric Bergen wrote:
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
Tells the slave to restrict replication to statements where the
default database (that
Hi!
I'm running a system that will have fairly high demands in uptime (24/5)
soon. It would be ok to be down on the weekends but during workdays it must
be running.
Right now we stop the server during nights but it will not be possible soon
so we are looking into replicate our server to a
I have 2 tables, identical in fields. One is an 'archived items' table, the
other is a live items.
I want to run a query that will grab the sum of all products in both tables,
like:
The results would display the total qty by item:
QTY NAME
The logic is something like:
sum(table1.qty) +
[snip]
I have 2 tables, identical in fields. One is an 'archived items' table,
the
other is a live items.
[/snip]
Are they also identical in record count?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a sub query in oracle, I want to convert it into Mysql
4.0.21 compatible
SELECT PAGE_SERVICE.TIMEOUT, PAGE_SERVICE.PAGE_SERVICE_COMMENT,
PAGE_SERVICE.NUMERICMSGMAXSIZE, PAGE_SERVICE.ALPHAMSGMAXSIZE,
PAGE_SERVICE.PASSWORD, PAGE_SERVICE.PHONE_NO, PAGE_SERVICE.NAME,
Mike Morton wrote:
I have 2 tables, identical in fields. One is an 'archived items' table, the
other is a live items.
I want to run a query that will grab the sum of all products in both tables,
like:
The results would display the total qty by item:
QTY NAME
The logic is something like:
Emmett,
if you have an index on a column, say
c CHAR(10)
and the index contains adjacent records 'aabbaguu' and 'abbaguu', then a
'gap' is the gap between those values in the alphabetical order. If you try
to insert, say, 'aac' to the index, it would fall in the 'gap'.
Note that the 'next-key'
[snip]
No, they have different record numbers...
[/snip]
a. Always reply to the list. I just happened to spot this in my spam
folder while cleaning.
2. You're getting Cartesian results, so your query needs to be a little
more specific
Your original query --
select (sum(table1.qty) +
Since 4.0.22 does NOT have subqueries, you will have to use a JOIN
http://dev.mysql.com/doc/mysql/en/JOIN.html
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
... as in this example
SELECT PAGE_SERVICE.TIMEOUT
, PAGE_SERVICE.PAGE_SERVICE_COMMENT
,
Hello
Usually error log is located in data directory. You may manually specify
the location of error log with --log-error[=file] or use --console command
line option for mysqld to see error messages. Or just start it with -V
command line option to make sure that it at least can start.
note: this is this message's second sending after some snippage to meet
the 3 character limit for the list and other mild editing.-- SG
This is the query you would like to optimize:
select Sum(m0),Avg(m1),Max(m5),Min(m6) from
ind_kar_bng_robocop_bsc_0_pm_ipc_0 where
bsc_id = 0 and
Hello all,
Recently, I have been seeing some strange behavior from a particular query on
my 4.0.21 mysql server. Here is the query in question:
SELECT size_id, sum(imps) imps, sum(clicks) clicks, sum(convs) convs,
sum(imp_revenue) imp_revenue, sum(click_revenue) click_revenue,
Hello.
I didn't find any similar problem in bugs.mysql.com and bugs.php.net. To
exclude inconsistence with Apache compile PHP as a command line program and
check your queries. May be you should turn to PHP developers.
I recently upgraded the MySQL server from 4.0.15 to 4.1.7, without
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote:
Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows
'/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a
whole lot of
Hello,
I am new to mySQL. Someone gave me a dump file and i need to do an
import from linux. How can i go about doing this can someone help me?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I didn't find any similar problem in bugs.mysql.com. To exclude inconsistence
with Apache compile PHP as a command line program and check your queries. May
be you should turn to PHP developers.
Bogdan TARU [EMAIL PROTECTED] wrote:
Hello,
I recently upgraded the MySQL
Hello.
Very often similar symptoms causes various lock problems. Do you use
InnoDB? Try log_slow_queries to find hung queries.
Paul Smith [EMAIL PROTECTED] wrote:
Hi all;
I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2
version downloaded from Mysql.com). The
Sorry this meant to be follow-up to Bogdan Taru post.
Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
I didn't find any similar problem in bugs.mysql.com and bugs.php.net. To
exclude inconsistence with Apache compile PHP as a command line program and
check your queries. May be
I guess that all depends on the nature of your dump, doesn't it?
Database administrators call any transfer of data to a separate file a
dump and they come in all shapes and formats.
What can you tell us about the file you received?
Where did the data come from (what database system)?
What
Joshua J. Kugler wrote:
Take a look at http://mysql.he.net/doc/mysql/en/Upgrade.html
Hmmm... Can 4.1 mirror a 3.2 server? That might be a good deal easier.
--
A. Clausen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-Original Message-
From: Max Michaels [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 08, 2004 8:32 AM
To: [EMAIL PROTECTED]
Subject: slow query issues
Hello all,
Recently, I have been seeing some strange behavior from a particular
query on my 4.0.21 mysql server. Here is the
Hi,
If I remember correctly, if table is ok, then if one does a table
repair, the command should return immediately. I have a table with 14
million rows, and I repeated table repair (quick) 3 times, it took the
same amount of time (55 min). It is almost the same time as if I built
the index from
%% Gleb Paharenko [EMAIL PROTECTED] writes:
gp Very often similar symptoms causes various lock problems. Do you
gp use InnoDB? Try log_slow_queries to find hung queries.
I'm using MyISAM tables. When I wrote this application InnoDB wasn't
even an option :-).
I don't think it's hung
When the database is in a `hung` state, is the file system where the
MYI, MYD and frm files accessible?
Paul Smith wrote:
%% Gleb Paharenko [EMAIL PROTECTED] writes:
gp Very often similar symptoms causes various lock problems. Do you
gp use InnoDB? Try log_slow_queries to find hung queries.
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp When the database is in a `hung` state, is the file system where
vp the MYI, MYD and frm files accessible?
Definitely. I can log in, see the files, run the mysqladmin commands,
etc. The databases live on the local disk, not a remote server
What state are the queries in while they are hung? What command or SQL
are they executing?
Paul Smith wrote:
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp When the database is in a `hung` state, is the file system where
vp the MYI, MYD and frm files accessible?
Definitely. I can log in,
Sure enough... I just installed the latest 4.1 linux binaries, I didn't
realize that the server itself had to be compiled with the debug enabled
(although now that I realize that it makes complete sense). It would be
nice if the documentation for mysqlimport would at least make note of this.
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp What state are the queries in while they are hung? What command or
vp SQL are they executing?
Unfortunately I lost the output of the processlist command. Whenever
the server hangs it's always a crazy race to get it back up again.
Next time
Understandable. The state, command and info values from `show
processlist` could shed some light on what is occurring.
Paul Smith wrote:
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp What state are the queries in while they are hung? What command or
vp SQL are they executing?
Unfortunately
Hello.
Manual doesn't have any objections:
Another benefit of using replication is that you can perform backups
using a slave server without disturbing the master. The master continues to
process updates while the backup is being made.
Roland Carlsson [EMAIL PROTECTED] wrote:
On Dec 8, 2004, at 9:12 AM, Jay Ess wrote:
I am not using cross database updates. It is all on one database but
the update uses two tables.
The query update content_review_site as a,site_rating_factors as b
set a.overall_rating = 77 where a.content_id=243 is a stripped down
version of a bigger
The MySQL Query Browser online documentation clearly mentions that it
runs on 32-bit Windows operating systems, including Windows 95, 98 and
Me. However, while installing it on WinME, I get the following error:
The Operating System is not adequate for running MySQL Query Browser 1.1
Can anyone
hi,
i compiled mysql-4.1.7 from source. actually, i want to configure a
mysql cluster. from the documentation, i need to add some flag into a
file called my.cnf. i searched through the files. it consisted of
my-small.cnf, my-medium.cnf, my-huge.cnf. but, i cant see the file
my.cnf file. where
46 matches
Mail list logo
