[ Note to list admin, you are blocking messages from gmail.com ]
MySQL List,
I have a large MySQL database (around 20 gigs in total, some tables
>=3gigs. All tables are MyISAM. We have replication setup to a
number of slaves including one dedicated for backups.
All are running some semi-recent
odbc driver for your MySQL database on your windows machine.
export tables in access to odbc source that you created
On Mon, 11 Jul 2005, nephish wrote:
Hello there
i need to import an entire database or find a way to get all the info in
a microsoft access .mdb database into a MySQL database
Hi All!
I have a MySQL database (I have them using MySql at work for more stuff
now!), and the definition is as follows:
uid mediumint(6) NOT NULL auto_increment,
ym varchar(6) default NULL,
fileid varchar(8) default NULL,
off char(3) default NULL,
PRIMARY KEY (`uid`)
TYPE=MyISAM
uid is not re
Hello there
i need to import an entire database or find a way to get all the info in
a microsoft access .mdb database into a MySQL database.
here is another trick, the access database is on an WinXP computer, the
MySQL database is on a debian linux computer. They are on the same
internal network t
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
OK. I'm responding to my own post since I figured out the syntax.
This allowed me to figure out how to compute the ties as well as the
wins. How to I compute the losses. I can't use the same technique
because I'd be looking for '0' in the standingpts column and that
column defaults to '0'.
Maclen Marvit wrote:
1. The pexports did not find _mysql_server_init
That function is only needed when using the embedded MySQL server. It's
probably an optional configuration setting, so it's no big suprise that
you don't have that function. If you're connecting to a separate MySQL
serve
Howdy all,
I've noticed some strange behavior with the way that
mysql is choosing indexes with a particular query I'm
trying to optimize.
First off, I'm using MySQL 4.0.24 on MAC OSX.
I've got a table that I'm searching on based upon a
set of preferences. From one query to the next the set
of pr
Shawn,
Thank you. I've been working with what you provided learning as I
figure out the why of each step.
One thing I don't understand is the syntax of these 2 lines:
, sum(if(`standingpts`=3,1,0)) as wins
, sum(if(`standingpts`=3 AND `home_vis` = 'H',1,0) as wins_at_home
Specifically the
First of all, I heard that Mysql does not perform very well when
tablesize goes above 1 Gb. Is this a myth?
I don't have much experience with individual tables being that large,
though I have used MySQL databases with >100G total data with no
problems at all. Based on my experience, it's not th
Hello.
> Is there a way to determin what connectiions to MySQL are being used by whom?
SHOW PROCESSLIST could be helpful. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
[EMAIL PROTECTED] wrote:
> Howdy Folks,
>
> I have an app that cannot get information from mysql d
Hello.
It seems a bug for me. Any columns in the subquery select list
must have unique names according to:
http://dev.mysq.com/doc/mysql/en/unnamed-views.html
I've reported a bug. You could add your comments at:
http://bugs.mysql.com/bug.php?id=11864
Richard Cyganiak <[EMAIL
Albert Padley <[EMAIL PROTECTED]> wrote on 07/11/2005 02:30:51 PM:
> First, I have spent hours searching the web and the list archives and
> can't find anything helpful.
>
> Second, I'm using MySql 4.0.24
>
> Third, I'm still a novice at query formulation, so be kind.
>
> The Problem---
>
> I
See comments inline below...
However also note that it now turns out after more testing that the new
user is having the same issue "some of the time". Sometimes the replace
does not cascade other times it does. Every single time in the binary
log it properly lists the SET FOREIGN_KEY_CONSTRAINT
Some additional info would probably be helpful:
What version of mysql are you running?
On what platform?
For the sake of comparison, what does SHOW GRANTS say for your "brand new user"?
Finally, did you 'SELECT CURRENT_USER()' to verify that you were logged in as
'scopeuser'@'10.254.%' when i
First, I have spent hours searching the web and the list archives and
can't find anything helpful.
Second, I'm using MySql 4.0.24
Third, I'm still a novice at query formulation, so be kind.
The Problem---
I'm working with a new youth soccer league. I need to generate weekly
standings that
Ok, So I recreated a brand new user in our production server and it now
works correctly. However, I still have no idea why the old user did not
work. Here is the permission info for the old user:
mysql> show grants for 'scopeuser'@'10.254.%';
+
Howdy Folks,
I have an app that cannot get information from mysql database for some reason.
Here is an query which application is trying to run but after some timeout
(something about 2-3 minutes):
11 Jul 2005 03:32:18,485 DEBUG [Thread-20] (PressReleaseDAO.java:328) -
sqlselect prd.press_release
On Monday 11 of July 2005 16:24, Gleb Paharenko wrote:
> Hello.
>
> I've tested your solution. It doesn't work for users which have SUPER
> privilege. This mentioned at:
> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> However, it works with with ordinary users which don't hav
> > hmm! mysql.sock was created at var/lib/mysql.
> > owner=mysql, permissions=777
> > So again, is there paths/permissions problems?
> >
> >
> Since this is where your my.cnf says to put it, it would be a problem if
> it was not there.
> If you are going to override the default location of the
Warren Young wrote:
> I believe people have gotten MySQL to build under Cygwin, but you should
> be aware of another option: Cygwin's build system can link against
> Microsoft C libraries, so you could just use the regular Win32 binary
> distribution and link your program against that.
That sound
Tim Johnson wrote:
* Gleb Paharenko <[EMAIL PROTECTED]> [050711 07:17]:
Hello Gleb:
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysq
Oh, I should also mention we have binary logging on and I verified by
looking at the binary log that the commands are being excuted and logged
with an error code of 0. So the obvious thought of the codes broken and
not running them is unfortunately not the problem. It seems to be some
sort of leg
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
Hey,
I have an application using the C API that is doing a REPLACE command
into an innodb table that has other tables with cascading deletes
relying on it's entries. Rather than use an UPDATE/Check
affected/Insert/Check success/repeat method we have wrapped the REPLACE
query in a SET FOREIGN_KEY
* Gleb Paharenko <[EMAIL PROTECTED]> [050711 07:17]:
Hello Gleb:
> Check that you have correct permissions set on MySQL datadir.
> See:
> http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
I will add to the comments above. I had to set the owner
and group to mysql as per my redhat s
Hello.
Please, could you provide more information about versions of MySQL
Server, .NET connector and operating system which you have used.
You could report a bug at:
http://bugs.mysql.com
Specific list related to MySQL and .NET exists:
http://lists.mysql.com/dotnet
>
>
>
Hello.
First read:
http://dev.mysql.com/doc/mysql/en/charset.html
mysqldump could put SET NAMES 'utf8' at the beginning of the dump
file, check it and remove or perform a dump using --set-names=gbk.
Use --defaults-character-set=gbk for mysql client (or put correct
values for character_s
Thanks to all,
As you says me, the solution was the indexes. I didn't have an index
in results.sample_id. Now the query returns succesfully in a few
seconds, regards
Juan P. Espino
On 7/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Juan Pablo Espino <[EMAIL PROTECTED]> wrot
Hello.
I've tested your solution. It doesn't work for users which have SUPER
privilege. This mentioned at:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
However, it works with with ordinary users which don't have SUPER
privilege. Here are pieces of my my.cnf (the init_co
Hi,
Suppose I have two tables Tbl1 and Tbl2. Both have a column called A.
MySQL 5.0.7 rejects this query as ambiguous:
SELECT A from Tbl1, Tbl2;
But it accepts this and returns the A column from Tbl1:
SELECT A FROM (SELECT * FROM Tbl1, Tbl2) AS foo;
But this query is rejected again:
SELECT *
Juan Pablo Espino <[EMAIL PROTECTED]> wrote on 07/08/2005 03:37:14 PM:
> Hello all!
>
> I have two tables in my database: results(20 000 rows) and
> data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
> I need to find the samples of data_lab1 table that they are not in
> resul
Scott Hamm ha scritto:
I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical)
for personal use. Do anyone use it and how does it fare in your opinion?
Yes I use it. It's a good sw, little bit better vs phpMyAdmin (IHMO) but
only under win :-(.
It's a better choice to s
>Description:
There appears to be a type promotion problem involving sql statements which
include a 'between' comparison and a decimal type field is one of the operands.
>How-To-Repeat:
CREATE TABLE `foo1` (
`test1` decimal(7,2) NOT NULL default '0.00',
`test2` decimal(7,2) NOT NULL defau
I'm contemplating buying SQLyog Enterprise for $49 dollars (non-commerical)
for personal use. Do anyone use it and how does it fare in your opinion?
--
Power to people, Linux is here.
I'm looking for comments/suggestions on the best method to
migrate multiple databases from one machine to another. It has been
requested that both machines be placed into production and that a slow
migration occur of services and databases over a period of time. I
realize that mysql doe
Dear all,
I am a Chinese and using Chinese in my MySQL databases.
On my old server, the version of MySQL is 3.23.58. And my new MySQL is
4.1.7.
On my old server, the MySQL works well with my Chinese contents.
However, after I transfer tables to the new server using:
mysqldump --opt database | m
Hi.
This is Sinyavin Anatoly from Intel (Moscow department).
I attempt to use MySQL benchmark. ( Version 05 July 2005,
http://linux.dell.com/blog ).
I want to complain of MySQL .net connector. :-)
I describe symptom.
I launch MySQL benchmark with parameters
ds2.exe
Yep. That was it. No firewall rules needed to change.
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 07, 2005 1:24 AM
> To: mysql@lists.mysql.com
> Subject: Re: telnet localhost 3306 Connection refused
>
> Hello.
>
>
>
> Are you sure tha
Cabbar Duzayak wrote:
> So my questions are:
>
> 1. The main question is, do you guys have any experience with this
> much binary and regular data? Do you think Mysql can handle this much
> data in a reliable manner (without corrupting data and/or
> degrading/terrible performance) ?
I would say
Sometimes, the easiest way to do this is to use the file system of the linux
machine to store the files, and make reference to them in the DB...storing
not data in the DB and getting rid of all your possible problems.
Thanks,
Matt Babineau
Criticalcode
858.733.0160
[EMAIL PROTECTED]
http://www
Hi Everyone,
I will be starting a project for which I will need to store about 1
million image files all of which are about 50-100K in size. I will be
using Linux for this project. The database won't be very busy, there
will be batch image uploads 1-2 times a day, and around 100-200
concurrent use
Hello.
[EMAIL PROTECTED] gleb]$ perror 13
OS error code 13: Permission denied
Check that you have correct permissions set on MySQL datadir.
See:
http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
Tim Johnson <[EMAIL PROTECTED]> wrote:
> Using 4.0.20 on Slack 10.0
>
>
Hello.
Check that MySQL doesn't hang, and that your system doesn't swap.
You can connect to MySQL server and check with 'SHOW PROCESSLIST'
states of MySQL threads. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
Juan Pablo Espino <[EMAIL PROTECTED]> wrote:
> Hello all
On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote:
> Hello.
>
>
> For a pity, I could give explanations only for your query about
> selecting @@global.xxx variables. I think server returns correct
> results, because you're selecting global variables, while
> character_set_client, character_se
Is there any command to list all the datatypes available on mysql? I can get
the information about datatypes from mysql manual as well but I need to get
them from mysql command line. Is there any such command available?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Just to make things REALLY messy... try setting the default character
set of a 4.1 server to utf8, and then importing your data from 4.0...
your mysql usernames are in real trouble now, because utf8 considers
itself to be multi byte and takes more space, cutting down on the 16
characters by
47 matches
Mail list logo
