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
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
MySQL-4.1.7. After starting the new Apache/PHP (ldd
Hello.
Can you describe your problem more in detail? As I guess 'PPM' - a tool
from Active State Perl for installing additional modules. What steps
did you pass, while installing ODBC?
I am trying to install ODBC and it does nothing. I am running version 4.1.7
on XP Pro.
PPM hangs when
Hello.
What version of MySQL Administrator and operating system do you use? I haven't
found any open bugs similar to yours. Are you sure that your database contains
data?
Steve Grosz [EMAIL PROTECTED] wrote:
I am using the MySql Administrator tool to schedule weekly backups on my
I am trying to install ODBC and it does nothing. I am running version 4.1.7
on XP Pro.
PPM hangs when I query Tk as well.
What is going on?
Thanks,
Jerry
Steve Grosz wrote:
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the tables as well.
How do
I am using the MySql Administrator tool to schedule weekly backups on my
databases. I have defined the databases I want backed up and how often,
plus where to store the data. I ran a sample, but it appears that just
the structure is being backed up, not the data in the tables as well.
How do
Hello experts,
according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as
following:
shell su - enter
shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter
shell cd /usr/sbin/ enter
shell tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar enter
shell rm phpMyAdmin-2.6.0-pl3.tar.tar
This may be a bit off-topic for the MySQL List but see below:
Gunter Götz wrote:
Hello experts,
according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as
following:
shell su - enter
shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter
shell cd /usr/sbin/ enter
shell tar -zxf
You might want to consider the following site and collection of s/w
http://www.apachefriends.org
I have successfully installed XAMPP on both Windoze Linux from their
downloads.
On Wed, 01 Dec 2004 08:44:49 -0500, Jason McKnight
[EMAIL PROTECTED] wrote:
This may be a bit off-topic for the
Hello
I have two problems with latest MySQL (4.1.7) under Solaris 9. I am using
SUN provided C compiler (cc: Sun C 5.6 2004/07/15) to compile packages. I
need urgently to use MySQL, so any fast response will be highly appreciated.
First problem is, that when I try to compile MySQL 4.1.7 from
My master has two databases: channel and hardware. I'm only interested
in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
However, I am having problems because of giant LOAD DATA operations
performed nightly on channel. Replication blows up with max packet
exceeded
i probably should have mentioned: both master slave are running 4.0.20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Drukman wrote:
My master has two databases: channel and hardware. I'm only interested
in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
However, I am having problems because of giant LOAD DATA operations
not changed, so I doubt that there is a problem with it. I
tried recompiling the server without optimiziations as well, just in
case, but that didn't help either.
Has anyone else had similar problems with upgrading mySQL on a FreeBSD
box?
Thanks in advance!
Gustafson, Tim [EMAIL PROTECTED
Hello Group,
I'm desperatly trying to set up a mysql test-environment on my Windows
XP Sp1 system.
Therefore I dumped out the database on a RedHat Linux Server (both are
MySQL 3.23.56) and imported this dump
into the same MySQL DB on the windows System (using mysqldump -u root -p
--opt
UPDATE: Here's what i could figure out till now
A look with a hex editor showed me that there was a change from 0B to
0A and 07 to 20 in the
corrupted files compared with the original ones.
Somebody had the same problem
--
MySQL General Mailing List
For list archives:
I noticed that all mysql client programs i have (cmd line tool mysql and own
applications) block when the connection to a server is physically cut.
1. make connection
2. do some querys
3. line cut
4. mysql_ping() or mysql_query() block the application forever
a strace from mysql cli-tool shows
same configuration for about a year. The
hardware has not changed, so I doubt that there is a problem with it. I
tried recompiling the server without optimiziations as well, just in
case, but that didn't help either.
Has anyone else had similar problems with upgrading mySQL on a FreeBSD
box
Sasha Pachev wrote:
So all I have to do, using the binary, is to take the mysqld file and
replace my old one (from 4.1.3 to 4.1.7, for example).
And for the source, I compile in another directory, then take the
mysqld file and replace my old one?
Is that documented somewhere?
Do not forget
It can be even simpler than that, if you stay withing the same branch.
Just replace mysqld and share/english/errmsg.sys ( or share/your
langauge/errmsg.sys if you want them in your native language) with
the files from the new version.
This is for the source, binary or both? Sorry to ask
Sasha Pachev wrote:
It can be even simpler than that, if you stay withing the same
branch. Just replace mysqld and share/english/errmsg.sys ( or
share/your langauge/errmsg.sys if you want them in your native
language) with the files from the new version.
This is for the source, binary or
So all I have to do, using the binary, is to take the mysqld file and
replace my old one (from 4.1.3 to 4.1.7, for example).
And for the source, I compile in another directory, then take the mysqld
file and replace my old one?
Is that documented somewhere?
Do not forget to replace errmsg.sys
Hi,
I work in an internet company that runs a web site with classifieds.
We have got more than million page views daily and over a half a
million classifieds with 2 weeks long life-cycle on an average. We
use PHP and MySQL 4.0.18. We have got problems with simultaneous
reads and writes
Ugo Bellavance wrote:
Sasha Pachev wrote:
I tested the memory and it seems ok.
I doubt this is an hardware issue, since version 4.1.3 works perfectly.
Ugo:
Do the production and the test server run on the same hardware?
One is a single Athlon XP, the other is a dual Athlon MP.
Are you using the
Sasha Pachev wrote:
Ugo Bellavance wrote:
Sasha Pachev wrote:
I tested the memory and it seems ok.
I doubt this is an hardware issue, since version 4.1.3 works perfectly.
Ugo:
Do the production and the test server run on the same hardware?
One is a single Athlon XP, the other is a dual Athlon
I did compile it from source, with the flags used for the binaries, and
now it does work. I'm totally confused now.
Is it easy to upgrade from source? With the binary, I could have two
separate directories and I would symlink the one I tested (most recent
version) and could get back to the
Sasha Pachev wrote:
I did compile it from source, with the flags used for the binaries,
and now it does work. I'm totally confused now.
Is it easy to upgrade from source? With the binary, I could have two
separate directories and I would symlink the one I tested (most recent
version) and
I tested the memory and it seems ok.
I doubt this is an hardware issue, since version 4.1.3 works perfectly.
Ugo:
Do the production and the test server run on the same hardware?
Are you using the same mysqld binary on both?
What I am suspecting is that the binary on the production system does has
Sasha Pachev wrote:
I tested the memory and it seems ok.
I doubt this is an hardware issue, since version 4.1.3 works perfectly.
Ugo:
Do the production and the test server run on the same hardware?
One is a single Athlon XP, the other is a dual Athlon MP.
Are you using the same mysqld binary on
On Tuesday 09 November 2004 11:49 am, ian douglas wrote:
My bad, I wasn't running START SLAVE to get them going. Seems odd that
this has to be done manually.
I never do.. once its started, it should be fine.. Your just getting errors
making it stop.
Also, overnight, my slaves reported this
If a slave dies, is there any way to determine that state from an
external point of view (ie: via Perl/DBD) so we can write a script of
some kind to either connect to the slave and issue a START SLAVE or
send the last xx lines of the .err log file to our tech staff?
I tried writing a Perl
On Tuesday 09 November 2004 03:23 pm, ian douglas wrote:
GRANT SUPER,REPLICATION CLIENT to 'syscheck'@'mywebserver.domain.org'
IDENTIFIED BY 'mypasswd' ;
I have no idea how this script is gonna help, but your having permission
problems. The last message you wrote was permission problems
At 9:49 -0800 11/9/04, ian douglas wrote:
Except that changes made on the master are not automatically picked
up by the slaves.
My bad, I wasn't running START SLAVE to get them going. Seems odd
that this has to be done manually.
Perhaps you have the --skip-slave-start option in an option file?
Heikki Tuuri wrote:
Ugo,
- Original Message - From: Ugo Bellavance [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, November 05, 2004 3:42 PM
Subject: Re: 4.1.7 serious problems
Gleb Paharenko wrote:
Hi.
There were several posts in list like yours.
Do you use InnoDB
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on RedHat 8.0
On the master system I did this:
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1'
identified by 'repl_passwd' ;
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2'
Answered my own question, sorry for the quick posting...
When I was trying to do the LOAD DATA FROM MASTER, with the master set
as GRANT ALL ON *.* TO 'repl_user'@ ... the slaves were reporting an
error that stated I needed to GRANT SUPER,REPLICATION CLIENT on the
master, which didn't work.
After a little more RTFM-surfing, I found the GRANT REPLICATION SLAVE
for the master, and a LOAD DATA worked just fine.
Except that changes made on the master are not automatically picked up
by the slaves.
Am I missing something?
-id
--
MySQL General Mailing List
For list archives:
Ugo,
- Original Message -
From: Ugo Bellavance [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, November 05, 2004 3:42 PM
Subject: Re: 4.1.7 serious problems
Gleb Paharenko wrote:
Hi.
There were several posts in list like yours.
Do you use InnoDB tables? Try
]
Subject: Re: 4.1.7 serious problems
Ugo,
- Original Message -
From: Ugo Bellavance [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, November 05, 2004 3:42 PM
Subject: Re: 4.1.7 serious problems
Gleb Paharenko wrote:
Hi.
There were several posts
trying to upgrade another server (production) from 4.1.3 to
4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem.
OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone).
First, since I couldn't find a procedure saying how to upgrade a
binary distribution, here
Gleb Paharenko wrote:
Hi.
There were several posts in list like yours.
Do you use InnoDB tables? Try to increase values
of key_buffer_size, read_buffer_size and so on.
InnoDB is enabled but no InnoDB table is used yet (coming soon).
However, it crashes with only 1 client connected. There is
Hello All:
I am trying to configure ODBC for MySQL but have been unable to make
a connection.
We are running MySQL 4.0.15 supplied by Server Logistics on OS X 10.3.5.
I have installed their ODBC Driver and 4 files show up in the
library/MyODBC/Lib/ directory:
libmyodbc3_r-3.51.06.bundle
On 5 Nov 2004 at 10:01, Rick Dwyer wrote:
Hello All:
I am trying to configure ODBC for MySQL but have been unable to make
a connection.
Hi,
I have no experience of Mac OS X, but I believe it is linux-ish which means case-
sensetive path names.
The line below shows library with a lower
On 5 Nov 2004 at 10:01, Rick Dwyer wrote:
Hello All:
I am trying to configure ODBC for MySQL but have been unable to make
a connection.
Hi,
I have no experience of Mac OS X, but I believe it is linux-ish
which means case-
sensetive path names.
The line below shows library with a lower case L:
On 4 Nov 2004 at 0:59, Schalk Neethling wrote:
Since installing the latest 4.1 version of MySQL I have not been able to
run phpMyAdmin.
I have since gathered that the current version of phpMyAdmin is not
compatible. I therefore ran Add/Remove programs on Windows and installed
4.0.22 but
Hi.
First, how can I detect, on localhost, which port MySQL is using?
Look at my.cnf.
Also see:
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html
Schalk Neethling [EMAIL PROTECTED] wrote:
Since installing the latest 4.1 version of MySQL I have not been able to
Hi,
I need to make relationishp between 4 tables in my system.
I just don´t know how to make.
Somebody could help me, please?
The tables are: Order, Employee, ItensOrder and Unit.
My objective: to program a report of Order that appears in the screen the fields (
id_order, name_employee,
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE
I prefer to explicitly declare my INNER JOINs (not to imply them by using
commas to make a list of tables). That way I avoid accidentally creating
any Cartesian products of any tables by leaving out a WHERE condition.
Missing ON conditions are much easier to spot (IMHO).
Hi,
I've upgraded one of my servers (test) to 4.1.7 this week, all went ok.
Now I'm trying to upgrade another server (production) from 4.1.3 to
4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem.
OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone).
First, since I
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
Maybe.
:)
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED] |
|
Anders Green wrote:
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
I don't think so, everything works perfectly on my test server, which is
very similar.
Thanks,
Maybe.
:)
Anders
Since installing the latest 4.1 version of MySQL I have not been able to
run phpMyAdmin.
I have since gathered that the current version of phpMyAdmin is not
compatible. I therefore ran Add/Remove programs on Windows and installed
4.0.22 but nothing is working correctly, the server starts as a
- Original Message -
From: Schalk Neethling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 5:59 PM
Subject: Upgrade - Downgrade problems
Since installing the latest 4.1 version of MySQL I have not been able to
run phpMyAdmin.
I have since gathered
Hi.
What subversion of MySQL have you compiled?
From 4.0.xx and 4.1.xx branches?
MQ [EMAIL PROTECTED] wrote:
Hello,
I was able to compile mysql 4.0 and 4.1 (static) successfully with
intel compiler 8.0 on an IA32 system running redhat enterprise linux
3.0. However when I tried
Hello,
I was able to compile mysql 4.0 and 4.1 (static) successfully with
intel compiler 8.0 on an IA32 system running redhat enterprise linux
3.0. However when I tried to compile with intel compiler 8.1 with the
same options (same as ones used by mysql AB, except i link statically)
I kept
Hello,
I was able to compile mysql 4.0 and 4.1 (static) successfully with
intel compiler 8.0 on an IA32 system running redhat enterprise linux
3.0. However when I tried to compile with intel compiler 8.1 with the
same options (same as ones used by mysql AB, except i link statically)
I kept
See http://dev.mysql.com/doc/mysql/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__
Hello all,
I have a remote server that has a harddrive almost full. Therefore I
need to dump a huge table to my other host.
OK, I've set the permissions so that I can log in to the server as root
from my host. I've try to connect to it and it works.
I have to do the dump to the host because the
At 16:03 -0600 10/16/04, C.F. Scheidecker Antunes wrote:
Hello all,
I have a remote server that has a harddrive almost full. Therefore I
need to dump a huge table to my other host.
OK, I've set the permissions so that I can log in to the server as
root from my host. I've try to connect to it and
When I run top after my server has been running for a few days, Mysql is
using 60 or 70MB of memory. When I restart mysql, it goes back to 3000. Any
idea where I should start to look for a problem? What causes this?
I am running RH 7.3 and php/Mysql combo. I don't expect anyone to fix this,
In the last episode (Oct 05), Doug Wolfgram said:
When I run top after my server has been running for a few days, Mysql
is using 60 or 70MB of memory. When I restart mysql, it goes back to
3000. Any idea where I should start to look for a problem? What
causes this?
What are your mysql memory
In the last episode (Oct 05), Doug Wolfgram said:
At 07:35 PM 10/5/2004, you wrote:
In the last episode (Oct 05), Doug Wolfgram said:
When I run top after my server has been running for a few days,
Mysql is using 60 or 70MB of memory. When I restart mysql, it goes
back to 3000. Any idea
Brian J.S. Miller [EMAIL PROTECTED] wrote:
Does anyone have any ideas? This is killing me!
In this case I may suggest you to buy a support and request a support incident.
MySQL developers will recover your files manually if there is anything possible
to recover.
To buy a support contract,
Greetings,
Am having some problems with phpMyAdmin, GD library and jpegs.
Here is the short version of the story.
I installed phpMyAdmin, modified a database to install a graphic image into one of
the tables and it showed the graphic from within phpMyAdmin - no problem.
I then wrote a very
Sep 2004 15:06:46 -0700, Keith Brownmiller
[EMAIL PROTECTED] wrote:
Greetings,
Am having some problems with phpMyAdmin, GD library and jpegs.
Here is the short version of the story.
I installed phpMyAdmin, modified a database to install a graphic image into one of
the tables and it showed
Hello there,
I was wondering how I could make a specific type of search when the string has more
than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green Apple%')
At 04:17 PM 9/22/2004, you wrote:
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type
I'm trying to use C API to MySQL.
MySQL Version: 4.0.20a
Distribution Windows Binary
Machine: P IV on intel 845GL board, 256 MB Ram, Win98se
Compiler: Digital Mars C/C++ Compiler Version 8.40
(ftp://ftp.digitalmars.com/Digital_Mars_C++/Patch/dm840c.zip)
WHEN I COMPILE
Hi,
I have just finished installing MySQL, Apache and PHP on a Windows
platform and have tested my Apache and PHP installations without
problems.
My issue now is that when I log in using just -u root I can get
through but I just can't seem to be able to set a password. It keeps
giving me an error
Did you run mysql_install_db?
http://dev.mysql.com/doc/mysql/en/Post-installation.html
Michael
FayeC SQL wrote:
Hi,
I have just finished installing MySQL, Apache and PHP on a Windows
platform and have tested my Apache and PHP installations without
problems.
My issue now is that when I log
On Sep 20, 2004, at 00.06, FayeC SQL wrote:
Hi,
I have just finished installing MySQL, Apache and PHP on a Windows
platform and have tested my Apache and PHP installations without
problems.
My issue now is that when I log in using just -u root I can get
through but I just can't seem to be able
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination, and
lists the add/mod/del permissions for that module. So, for example, user 'bob'
might have add and del rights for 'module1', add only rights for
On Fri, 17 Sep 2004 11:33:04 -0700 (PDT), David T. [EMAIL PROTECTED] wrote:
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination,
You didn't say, but if you're using PHP you might find this of use:
- Original Message -
From: David T. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 17, 2004 2:33 PM
Subject: Problems with Left Join query
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module
First, you want to get an answer for every module, so you must use
modules LEFT JOIN permissions
to get a row for every module. You see? The table with missing rows (no
row for Bob/module3 in permissions) goes on the right.
When the table on the right does not have a matching row, the LEFT
Hi,
I have one problem with service MySQL on Windows XP Home Edition.
I use unzipped version of MySQL. Problem occurs in version 4.1.2 alpha,
4.1.2b alpha, 4.1.3 beta, 4.1.3b beta.
Let me explatin:
I unzipped mysql into c:\mysql. Set some variables in my.ini (only
default-character-set), install
Dear,You must run mysqld.exe start
--- Stano Paska [EMAIL PROTECTED] wrote:
Hi,
I have one problem with service MySQL on Windows XP
Home Edition.
I use unzipped version of MySQL. Problem occurs in
version 4.1.2 alpha,
4.1.2b alpha, 4.1.3 beta, 4.1.3b beta.
Let me explatin:
I unzipped
C:\mysql\binmysqld.exe start
C:\mysql\bin\mysqld.exe: Too many arguments (first extra is 'start').
Use --help to get a list of available options
I wrote:
When I reboot computer, service in Service manager
is up and running,
Problem is not in starting service (service started correctly), problem
is
Andrew Wheeler [EMAIL PROTECTED] wrote:
I am not sure that this is the correct list. I did not
see any list that seemed more appropriate.
Private email answered here.
Well if it compiling is not a configure, make, make
install job perhaps you could point me in the
direction to learn the
Hi Guys,
I'm having the same problem with SQL_CALC_FOUND_ROWS
Any query involving SQL_CALC_FOUND_ROWS takes ages!! All my tables are normalized,
indexed, and optimized and the query uses the indices correctly. Many people
responded to my previous thread (when I though it was a fulltext issue
Hello!
I am having a problem retrieving the number of records matching a certain condition
from the database.
I have a large table of about 3 millions records
A simple query like the one below returns me the results
select * use index(category) from books
where category=1 limit 0,10
This
2004 14:23
To: [EMAIL PROTECTED]
Subject: problems counting the number of returned rows
Hello!
I am having a problem retrieving the number of records matching a certain
condition from the database.
I have a large table of about 3 millions records
A simple query like the one below returns
where category=1 limit 0,10
ie change * to category (which can be read from the index)?
Andy
-Original Message-
From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 14:23
To: [EMAIL PROTECTED]
Subject: problems counting the number of returned rows
[mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 15:03
To: Andy Eastham; Mysql List
Subject: Re: problems counting the number of returned rows
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which makes about the same thing like
using count() so this still
-Original Message-
From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 15:03
To: Andy Eastham; Mysql List
Subject: Re: problems counting the number of returned rows
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which
Andrew Wheeler [EMAIL PROTECTED] wrote:
I am not sure that this is the correct list. I did not
see any list that seemed more appropriate.
I have RedHat 8:
gcc-3.2-7
You'd better take the binary distribution from www.mysql.com
Compiling MySQL is absolutely not a configure; make; make
--prefix is the only option you passed to configure? You must have missed
the recommendations in the manual. Take a look at how MySQL builds their
official binaries http://dev.mysql.com/doc/mysql/en/MySQL_binaries.html.
There is also a section on building and other issues under Linux
I am not sure that this is the correct list. I did not
see any list that seemed more appropriate.
I have RedHat 8:
gcc-3.2-7
I run ./configure --prefix=/usr/local/mysql
which according to the log exited with code 0
Then when I run make I get the following errors. My
question is what is the
Sergei Skarupo wrote:
Hi Donny,
Thanks for your reply. This table only uses ints and floats, but the
floats are allowed to be null, which means, as far as I understand,
that it's not a fixed row length...
What makes you think that? VARCHAR, TEXT, and BLOB are the variable-length
column types
Greetings,
I have a couple of questions that were not covered in the upgrade documentation.
1) The documentation discusses creating the new mysql database with the new
privledges incorporated. Not a problem with that concept.
2) I can move my other database directories to the new data
At 17:06 -0700 8/27/04, Keith Brownmiller wrote:
Greetings,
I have a couple of questions that were not covered in the upgrade
documentation.
1) The documentation discusses creating the new mysql database with
the new privledges incorporated. Not a problem with that concept.
You don't need to
Hi all,
Started a conversion from MyISAM to InnoDB; it's been almost two days and the
statement is still executing...
The (MyISAM) data table size is almost 4G. There were two reasons for this conversion:
to start supporting transactions and to avoid the 4G limit of MyISAM tables; this
:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 8:36 PM
To: Mysql List (E-mail)
Subject: table conversion problems
Hi all,
Started a conversion from MyISAM to InnoDB; it's been almost two days and
the statement is still executing...
The (MyISAM) data table size is almost 4G. There were
:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 6:37 PM
To: Sergei Skarupo; 'Mysql List (E-mail)'
Subject: RE: table conversion problems
Sergei,
I don't know much about innodb, but myisam doesn't have a 4 gig limit unless
you are using a dynamic type of table. If you are using a fixed table
Greetings All,
A seemingly strange problem.
If I go to the mysql prompt on a linux server - mysql version 3.23.14-alpha.
I can issue the command create database .
I can then issue the command use .
No problem.
However, if I type use mysql for the mysql database.
If I do a
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a free
floating database that nobody (except root) has permission to access
until you issue the grant statements to make someone own it. But
nobody actually owns
Has anyone ever encountered a problem where replication stops due to a
partially completed query on the master?
I am currently encountering this problem on my server and was wondering if I
need to resync the slave server to the master by copying all the data files
to the slave and then restarting
701 - 800 of 2763 matches
Mail list logo