Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi!
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 08, 2002 5:07 AM
Subject: Re: transaction isolation level
Jianliang Zhao wrote:
...
I am connecting to MySql 3.23(innodb) with
Hi,
When one is doing a GRANT statement at the database level the database name is stored
in mysql.db in lowercase letters only, regardless of the upper/lowercase characters
used for the database name at the GRANT statement.
Example:
GRANT SELECT ON SYSMON.* TO theUser@%
results in having
### CHANGES ###
--- version 16.6 ---
- moomps version 2.0: implemented data cells history feature where
cell values are stored in a database (MySQL or PostgreSQL via ODBC)
over time, so that for example, common spreadsheet software can be
used for presentations, ...
- added Edit/Database
Hi
I've been using mysql for a couple of years now, and until now had no real
need of transactions.
The could list recommend BDB or InnoDB to implement transatcions.
On a small system, which one is faster, and handles load better ?
Do they both offer foreign key constraints ?
Do they fix
* Dragos Madalin Popa
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Use the CONCAT function:
URL:
On Mon, 2002-10-07 at 17:40, Victoria Reznichenko wrote:
MJF One of the machines is simultaneously slave to one server and master to
MJF two others; on that machine, if a RESET MASTER or PURGE MASTER LOGS
MJF is executed while its slave thread is performing a query, mysqld
MJF reproducibly
* Soheil Shaghaghi
Hello everyone,
Can someone please tell me how I can do the following:
From the query below, I want to get the details of the header of
the message and display them on a page, one per line.
If I just query the Header field, it displays them in one long line.
What can I do
I have tried upgrading using the, rpm -Uv MySQL-4.0.3-0.i386.rpm
but the following was given:
error: failed dependencies:
MySQL-server conflicts with mysql-server-3.23.41-1
libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-1
libmysqlclient.so.10 is needed by
how to install mysql in linux using userid and passwoed
__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos More
http://faith.yahoo.com
-
Before posting, please check:
* David M. Gonzalez Salinas
Does anybody knoy what is equivalent stmt in MySQL?
select * from table1 where col1 in (select col1 from table2)
This is called a subselect, and it is explained in the manual:
URL: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
Roger
.Dear Sir,
When Iam trying to connect remote mysql database Using
JSP on LINUX Os (6.2/7.2)it is giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad
handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
files in
schmid n dean .
fellaz .
i AM using mysql for UNICODE data
all my database is unicode
its all stored there i retieve all my unicode data n play round with it all
the time
n so far i ve had NO problemx .
:D
any more questions id b glad 2 help all i can
good luck
toby
Yeah, I've used Unicode with MySQL as well. All I was saying is that
you can't sort on Unicode fields. And I have a feeling they might not
be indexed correctly, either.
Dean Harding.
-Original Message-
From: toby gibbson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 8 October 2002 8:28
Daniel,
Tuesday, October 08, 2002, 2:18:31 AM, you wrote:
DM I have been trying to install the
DM mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
DM Everything seems to be going smoothly until I entered the command
DM ./scripts/mysql_install_db
DM I got this output which
hi guyz
i ve these images of text n i ve to store em in mysql database
ALONG WITH some TEXT
n im storing the text in a longtext field
vat do i do
can n will some1 plz help ?
thnx a million guyz
toby ..
_
Join
David,
Tuesday, October 08, 2002, 2:01:46 AM, you wrote:
DMGS Does anybody knoy what is equivalent stmt in MySQL? select * from table1
DMGS where col1 in (select col1 from table2)
You can re-write without subselects:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
--
For
Dragos,
Monday, October 07, 2002, 7:30:47 PM, you wrote:
DMP I am trying to run this update statement, but I got an error syntax...near
DMP offsetCould You please point out what is wrong?
DMP Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
DMP ABBREVIATION is null;
Hello Les,
Tuesday, October 8, 2002, 9:13:22 AM, you wrote:
LF I am having a problem getting any kind of remote connections. Connections
LF to localhost work just fine.
LF The platform is Linux 7.3
LF Installed RPMs are;
LF mysqlclient9-3.23.22-6
LF mysql-server-3.23.49-3
LF mysql-3.23.49-3
Alec,
Saturday, October 05, 2002, 5:14:59 PM, you wrote:
Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a
global level privilege:
http://www.mysql.com/doc/en/News-4.0.2.html
AdCaQdC Thank you. That page says that To use these, you must have run the
AdCaQdC
Nestor,
Tuesday, October 08, 2002, 12:58:25 AM, you wrote:
NF OK now I am getting this error:
NF
NF Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
NF /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36
NF Warning: MySQL Connection Failed: Access
Sean,
Monday, October 07, 2002, 10:11:51 PM, you wrote:
SM I seem to have run into a rather peculiar problem. I was attempting to load
SM data into a table from a file. I checked with the online documentation and
SM found the following syntax:
SM LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet;
Moestl,
Tuesday, October 08, 2002, 10:42:09 AM, you wrote:
MW When one is doing a GRANT statement at the database level the database name is
stored in mysql.db in lowercase letters only, regardless of the upper/lowercase
characters used for the database
MW name at the GRANT statement.
MW
Hi
I hope I am not being lazy here. I want to use the SQL date_add
function on a value from one of my column values but I can't seem to
figure out the syntax.
This works:
select 2002-10-08 09:35:10 + interval 7 hour;
but how do I change 2002-10-08 09:35:10 to current_date or feed
the
I am not sure, But maybe you can convert images to mime formart (which is
text actually),
Browsers can view mime format, and most email clients,
There is PERL module called MIME::Lite that can do the conversion.
Maybe there is other ways too I am not sure.
- Original Message -
From:
Sorry for the resubmission but I thought I would try
again to get a tip on how to do this. I am a newbie,
so thanks for any help.
I'm Running RedHat Linux 7.3 - Apache - MySQL
scripting with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specified records
Dear Sir,
When Iam trying to connect remote mysql database Using JSP on LINUX Os it is
giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
2).MySQL-client-3.23.40-1.i386.rpm
files in to my
Greetings,
I just installed mySQL Server 3.25.52 on my internet connected PC ( which
makes Internet gateway via Internet Connexion Sharing ) using Win98SE.
I have created a VB program which attacks the mySQL Server using ODBC.
Over LAN and Localhost, everything works just fine.
I am trying
Veronica,
That's maybe true, I'll check it. As it's the default setting on Windows and I've
never changed it I guess it's on.
If the flag lower_case_table_names is turned on, I would expect that SHOW DATABASES
os SHOW TABLES is returning lowercase-only names as well?
I do get back the exact
Sherif D Mohamad wrote:
I am not sure, But maybe you can convert images to mime formart (which is
text actually),
Just to be picky; MIME format just describes how to seperate sections of
a mail message, the 'text format' version of the image is described in
the Content-Type: header of the
Hi everyone,
I have recently moved my mysql server from a win98 machine to a win2000
machine. After running the self extracting setup for mysql, I copied my
existing my.ini file over from the win 98 box, made neccesary changes to
start mysqld-max-nt from correct dir, I copied the my.ini file
kusuma guntupalli wrote:
.Dear Sir,
When Iam trying to connect remote mysql database Using
JSP on LINUX Os (6.2/7.2)it is giving an error...
Remote system is Windows NT.
java.sql.SQLException: Communication link failure: Bad
handshake
I loaded
1).MySQL-3.23.40-1.i386.rpm
ok guyz more trouble
now im supposed to convert all the text (from ms word) to PDF and put the
pdf files in mysql db
now i ve really got myslf stuck havent i
can anyone plz hlp
thnx a million
stuck az usual
toby .
Here's a query for ya:
SELECT products.product_name, products.fg_number,
products.product_description, specs.spec_name, specs.spec_value FROM
products LEFT JOIN specs ON products.fg_number = specs.fg_number WHERE
products.fg_number='fg00914';
and here's the result:
After reading the mysql documentation, I am not sure to get correctly
the pros and cons of the VARCHAR type.
My understanding is that it is useful when a text field
has a length that may vary a lot.
For example I am thinking using it for a description field
where users will put nothing or a
awww jeeez.
tell me bout dat
i still ve to work on the indexing n sortin
toby
From: Dean Harding [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Unicode Support with MySQL
Date: Tue, 8 Oct 2002 20:47:17 +1000
Yeah, I've used Unicode with MySQL as well. All I was saying is that
you
* tmb
I'm Running RedHat Linux 7.3 - Apache - MySQL
scripting with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specified records of an mysql db to the line printer
several times a day...
OK, let's see if we can break this down into smaller tasks:
1)
On Tue, 8 Oct 2002, Steve Bradwell wrote:
Hi everyone,
I have recently moved my mysql server from a win98 machine to a win2000
machine. After running the self extracting setup for mysql, I copied my
existing my.ini file over from the win 98 box, made neccesary changes to
start
Hi All
I had created a DataSource in Tomcat Admin Console.
But i am not getting a connection
ds.getConnection()
results in error.
The error is java.sql.SQLException : cannot load JDBC Driver class null
But while creating the datasource i had given the driverclassname as
01) at the setup, how do i do to install the software at
drive c: and the database files at drive d:?
02) How do i install INNODb at Windows 2000 server with MySql
3.23?
Thanks
Jacob - Brazil
---
UOL Eleições 2002 - Todos os lances da disputa política
http://eleicoes.uol.com.br/
robert_goetz,
Monday, October 07, 2002, 4:51:02 PM, you wrote:
raWSdd i am a trainee at westlb-systems in duesseldorf, germany and it's my task
raWSdd to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP
raWSdd DB and Oracle
raWSdd well i searched the web and various
Hi!
I corrently working with a project to build a web based calendar with alarm
(reminder for each event).
table 'calendarEvents'
start datetime NOT NULL default '-00-00 00:00:00'
remindTime tinytext NOT NULL
The column 'remindTime' specify the time before an event the alarm will go
off.
Jon,
So how do I optimize memory usage? Where to start ?
If your server is compiled with debug=full, the command
mysqladmin proc stat
shows you total server memory use. Look in the manual at
How MySQL uses Memory
SHOW VARIABLES (for all vars that control server memory use)
Last time I saw this error, it was due to an authentication issue. Try
adding the user you have for the JSP pages or the user who is used for
Apache to your domain controller or to the administrative user list
under the NT users dialog. If you add this to the domain controller
make sure
Ross,
Monday, October 07, 2002, 8:14:09 PM, you wrote:
RR We am having a problem with the encode() and decode() functions. When
RR the second argument to the functions is a quoted string, the functions
RR return values as expected. When the second argument to the functions is
RR another
I'm sure this is a common requirement, but the only thing I could
find in the docs or in a book or two was an unanswered version of
the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html .
I'm setting up MySQL on a small ISP and would like to be able to
restrict the size of
Before I forget: SQL, QUERY ... going write a filter for these some day ...
christophe barbe wrote:
What are the disadvantages of using VARCHAR instead of CHAR.
Is it going to be considerably slower?
It really depends on your table, but if you find it slower, break down
into multiple
hi,
2 ways to do this:
a) don't store the file actually in the db but store the path to it.
b)use the function LOAD_FILE(filename) to get the contents of a file as
a string value and store as a blob.
decide which to use depending on how many pics you have
cheers
Rich
toby gibbson wrote:
Michael Knauf/Niles wrote:
I get 7 rows of data I don't want, then the 7 rows of data I do want... and
after scratching my head for awhile, I've come to the conclusion that I do
not understand the query structure. (the query came from multiple
suggestions in response to my last posting on this
Dear Sir, Madam,
I was trying to make a comparison on you website between the mysql server,
acces 2000, microsoft sql server and interbase. Crash-me however does not
return any information, it does not work. Is it possible that you can provide
me with this information? I hope to hear from
Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit :
Before I forget: SQL, QUERY ... going write a filter for these some day ...
I don't get what you mean by SQL, QUERY
I know how to write a SQL QUERY.
I am looking about experienced pros and cons on the use of VARCHAR. My
understanding
Christophe Barbe wrote:
Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit :
Before I forget: SQL, QUERY ... going write a filter for these some day ...
I don't get what you mean by SQL, QUERY
I know how to write a SQL QUERY.
I was making sure I'd get past the spam filter.
Christophe Barbe wrote:
I am looking about experienced pros and cons on the use of VARCHAR. My
understanding is that, except if you know that each time the text will
have the same length, VARCHAR is better. This seems a bit too perfect to
be true.
You do not have to use all the chars ... if you
Please cc me as I'm not on this list. Thanks.
root[csh]@amber1[15]# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for sun-solaris2.9 (sparc)
root[csh]@amber1[16]# /usr/local/mysql/libexec/mysqld --version
/usr/local/mysql/libexec/mysqld Ver 3.23.52 for sun-solaris2.9 on sparc
Scripts are
What I _really_ want is the combination of your two querys, that is,
product_name, product_description, from the product table + all the specs
related to the product from the specs table , based on the fg00914 number.
I should get 7 rows in this example
I'm using this query in a php web page
You need to Install MySQL as a service.
Use the following steps on the DOS command prompt:
1. cd \your-path-to-mysql\bin
2. mysqld-max-nt --install
You could then start the service from Services in Control panel or use NET
START mysql on the command line.
Regards
'Gbamila
- Original
VARCHAR basically sets a maximum length for the field and only stores
the data that is entered into it, thus saving on space. The CHAR type
has a fixed length, so if you set CHAR(100), 100 character worth of
space will be used regardless of what the contents are.
The only time you will gain a
Michael Knauf/Niles wrote:
What I _really_ want is the combination of your two querys, that is,
product_name, product_description, from the product table + all the specs
related to the product from the specs table , based on the fg00914 number.
Are you sure? :-)
As I pointed out, if the first
i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Check your ini file to make sure the path reflects the proper location of
the database.
Bruce
- Original Message -
From: Steve Bradwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:14 AM
Subject: startup on win2000 as service not working.
Hi everyone,
I
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your
Thanks, your comments are very helpful, especially the info that if I
have already a not-fixed field in a table the performance cost of adding
a VARCHAR (instead of a CHAR) is 0.
NOTE for the Mailing-list Admins: There is a 1 hour (at least) between
the post and the availability of the mail in
thnx rich
but u see the problem iz my clients want their text IN pdf format to be
displayed with all these colors on the page in other words they want
their sites layout to be maintained on the pages showing this pdf text
as they are pretty concerned bout security
so what do i do now
Hello all...
What is the maximum value of an AUTO_INCREMENT field? I am currently
running into a maximum value of 296,995,724 on Solaris 8 using MySQL
3.23.42 - the field has been defined as an INT(11), which should be able
to handle a value bigger than what I am seeing - The DuBois MySQL
It seems that you have two entries in the products table for the same
fg_number, one with the values:
'SPKR,CM8HD', 'FG00914', '8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER'
And a second one with the same fg_number but in this case with a
lowercase F.
'', 'fg00914', ''
Is this rigth?
Please, if
Thanks for all your help. Then it's more confusing to me. I opened two MySql windows
and set autocommit=0 and then update one column and then issue the command COMMIT in
one window, in the other MySql window, I queried the column and saw the change
immediately.
I also did the same thing with
Hello All.
I hope you are all having a great day. ;)
I am trying to query MySQL using PHP and I would like the results to display
on multiple pages.
I would like to display only 20 results per page and allow the user access
to the other pages by clicking next or an index of numbers 1 2 3 4 5 6
Hello Philipp,
Monday, October 7, 2002, 7:02:18 PM, you wrote:
PS Can't create a new thread (errno 11). If you are not out of available
PS memory, you
PS can consult the manual for a possible OS-dependent bug
errno 11 may also mean that ulimits are exhausted.
PS debian 3.0
PS kernel 2.4.19
On Mon, 2002-10-07 at 22:02, Jeremy Tinley wrote:
The problem isn't so much with the failover. It's with data integrity.
Binlogs control replication. You can place a failover master in between
the master and slaves. In the event of a master failure, you eliminate
the loss of writes by
I have a database with a table called targetTsObj, and I want to perform
many queries from it, such as this one:
select run,rerun,camcol,field,id,ra,decl,r from targetTsObj where ra
between 255.84730673785904 and 256.31969326214096 and decl between
58.7494108 and 58.9577892
Jianliang,
I tested that with two mysql clients, and it appeared to work ok. Check with
SHOW CREATE TABLE tablename
what is the type of your table. Is it MyISAM?
Also put the line
log
to the [mysqld] section of your my.cnf and restart mysqld. Then you will see
all received queries in the
I have Mysql set up on the same machine as the apache server. There is a
database name inventory_db with a table product_info which have the two row
id and name. I know there are three records in the table. However when ever
I place this script below into a webpage I get just a blank page. What
Description:
Compilation fails with subject configuration due to missing typecasts
in sql/mini_client.cc and sql/mysqld.cc
How-To-Repeat:
./configure --prefix=/usr/local/mysql --with-innodb
make
Fix:
apply supplied patch which simply provides neccessary
I have downloades the last version of your software, but when I try to
connecto to the mysql server remotly, the server crash, and safe_mysqld
restar it. Your software reports lost connection to MySQL dureing query
And the safe_mysqld reports dureing the crash:
bash-2.05#
Hello,
I'm fairly new to mySQL and the list, so this might have been discussed in the past,
but i couldn't find anything that helped.
I'm trying to search for a part of an email adress, either name or domainname or
either part of it. If I use match... against, it only lets me search for the
Thanks Heikki,
My testcase is not valid. After I get the connection, I didn't set auto commit to
false on the connection object, so I was unable to see the committed data. I saw the
REPEATABLE READ behavior now, but it's unfortunate to know READ COMMITTED is not
supported yet...
--Jianliang
I think I'm sure, wont I get better performance from one query than two?
Michael
Michael T.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've started doing some work of porting MySQL 4.0 to the QNX operating
system. The patches are already part of the source tree and MySQL currently
compiles and runs, but we have not done any thorough testing yet. One of
the known bugs is that
Hello everyone,
Can someone please tell me how I can do the following:
From the query below, I want to get the details of the header of the message
and display them on a page, one per line.
If I just query the Header field, it displays them in one long line.
What can I do to display the
I am currently try to set up mysql on my computer and I'm running into a
few bugs. I'm using the book PHP fast easy web development. I've
run into a problem when I type the command mysqld --standalone into the
prompt. I get the following error:
Can't initialize InnoDB as
I've been using MySQL now for around a month. I also administer the system
where our MySQL implementation is installed. Each night, we perform a full
file system backup around 11:50PM. I just noticed that our MySQL root data
directory is filling up with binary data files named so:
On Tue, 8 Oct 2002, Jesse Sheidlower wrote:
I'm sure this is a common requirement, but the only thing I could
find in the docs or in a book or two was an unanswered version of
the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html .
I'm setting up MySQL on a small ISP and
I had the same problem happen to me. Go in to services and right-click
on the mysql service and check the properties. Check that the service
is assigned to the right executable. Mine was not so I had to start it
manually every time I restarted.
Steve Bradwell [EMAIL PROTECTED] 10/08/02
Thanks for your response.
I tried to connect to the server via telnet as you suggested with the
following result.
telnet my.machine.ip 3306
Trying my.machine.ip...
Connected to my.machine.ip.
Escape character is '^]'.
Connection closed by foreign host.
Is this the behaivior
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your
I had the same thing happen to me. Go in to services and right-click on
the mysql service. Go to properties and verify that the service is
assigned to the right executable. Mine was not so I had to start MySQL
manually every time I restarted.
(MySQL, query)
Steve Bradwell [EMAIL PROTECTED]
Hi
I have set up the MySQL database to run locally on my Mac. I have set
the privilege for the root user. However, when I log in as the root user
I am still unable to create a new database
mysql CREATE DATABASE master;
ERROR 1006: Can't create database 'master'. (errno: 13)
Please tell why
Hi,
I checked the path, it is correct. I also tried from
c:\mysql\bin\mysqld-max-nt --install
and got the following,
The service already exists!
The current server installed: C:/mysql/bin/mysqld-nt.exe
So what I can tell is I am not running mysqld-max-nt like I thought I was,
but my.ini has
Hi,
First run 'mysqld-nt --remove'
then
'mysqld-max-nt --install'
This removes the old installation of the service and then inserts a new
InnoDB-enabled registration.
Iikka
On Tue, 8 Oct 2002, Steve Bradwell wrote:
Hi,
I checked the path, it is correct. I also tried from
That was it! Thank you all for your help.
Steve.
-Original Message-
From: Iikka Meriläinen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 2:21 PM
To: Steve Bradwell
Cc: [EMAIL PROTECTED]; Oluwagbamila Oyekanmi; Bruce Lewis
Subject: RE: startup on win2000 as service not
Apologies to the list. Apparently the question I asked regarding binary
data dumps is an issue involving a MySQL startup parameter: log-bin.
Apparently this is the redo-log facility of MySQL for all successful
updates. This can be turned on or off. Question answered.
Thanks,
Rob
Robert Fox
Is it then correct that VARCHAR(255) and TINYTEXT are strictly
equivalent?
If no, where is the difference?
Thanks,
Christophe
NOTE: I understand now the sql,query stuff. Strange idea.
--
Christophe Barbé [EMAIL PROTECTED]
GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E
i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
Here is what I use which is pretty straightforward unless I am missing
something.
d:\mysql\bin\mysqldump -u root --password=password --opt -A
Dear Sir, Madam,
I was trying to make a comparison on you website between the mysql
server, acces 2000, microsoft sql server and interbase. Crash-me
however does not return any information, it does not work. Is it
possible that you can provide me with this information? I hope to hear
On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan Louou wrote:
what is the index max size for mysql 4.0?
What's the largest file your operating system will let you create?
is it possible to do replication with a master on linux and a slave
on windows?
Yes.
if yes, how can I make the slave
If you want to stay with 3.23 then download the max version. Install
the max version. Look at one of the .cnf files in the main mysql
directory. Uncomment the lines having to do with innodb. Change the
innodb_data_home_dir variable to be the path you want d:\mysql for
instance. When you are
The only time you will gain a speed advantage is if you have no variable
length fields in your record (varchar, text, etc.). You may notice that
all your CHAR fields are changed to VARCHAR as soon as a variable length
field type is added. CHAR is less efficient from a space storage point
Todd,
i would like to know how to write batch script for dumping schema and
data into a sql file. This script should dump the whole database and
data
Write this in a batch file:
mysqldump [options] dbname somename.sql
where dbname is the name of the db. See the manual for mysqldump
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan
Louou wrote:
what is the index max size for mysql 4.0?
What's the largest file your operating system will
let you create?
Is your answer related to the index size meaning that
it is limited
I have am having problems getting the MySQL server to start running, please help me,
here are my problems, I have also displayed my error logs below, at least I hope they
are the error logs;
I have been trying to install the
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
Everything seems to be
1 - 100 of 133 matches
Mail list logo
