Just installed the mysql binary. It runs fine.
However the only way i can administrate it is if I use
the root account which is fine. But when I try to
Grant other users any privilages the following
happens:
My Query: Grant ALL on dbName.* to userName
Response: Query Ok, 0 rows affected.
Hi,
I'm useing the latest productive release of mysql with InnoDB Tables
which feature transactions and foreign keys. I also use the latest
ODBC-Driver for Windows. The server is running on a linux system. I'm
supposed to write the GUI with M$ Access.
Before I start I'd like to know if I can
Have you considered writing your own DBMS as well?
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: 29 July 2003 23:03
To: Dan Nelson
Cc: mysqllist
Subject: Re: Transactions
Well said Dan. While foreign keys, cascades and built-in transactions are
convenient, atomicity
Hello
I have a table with an intger column called ID. I have
an index on it.
Now I want to get a result with all the rows whos ID
values start with lets say 12i.e. I want all the
IDs with data -
12
123
1234
..
I am using this query
select * from tablename where id like '123%'
I used the coammand rpm -i also.Like that
rpm -i MySQL-server-4.0.13-0.i386.rpm but it gives the mesaage
error : MySQL-server-4.0.13-0.i386.rpm cannot be installed
please help
- Original Message -
From: Matthew [EMAIL PROTECTED]
To: sanjay gupta [EMAIL PROTECTED]; [EMAIL
Hello,
Is prepared statement compatible with multiple query executilng?
Best regards,
Vladimir Zheleznyak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Asif,
since you did not have any my.cnf, ibdata1 is an auto-extending data file
(initially 10 MB) in the datadir of MySQL. And there are two 5 MB
ib_logfiles in the datadir.
If you specify the last data file with the autoextend option, InnoDB will
extend the last data file if it runs out of
Hi,
Following statement was working fine untill recently when someone entered specail
characters in insert statement.
eg
insert in db (col1,col2) values('a1','a2');
where a1=Here's
a2=Your's
thats is when apostrope is applied.
Thanks
Adamji
Hi,
i have download all the versions of mysql from 3 to 4 in rpm format
. but could not install any of them on my red hat 6.2 machine When i
installing using rpm -i it gives me the message error
MySQL-server-version number .rpm cannot be installed
do anybody have installed the mysql
LIKE is a string comparison. In order to do it, MySQL has to convert the
integer column into a string *before* it can test the string for a match.
MySQL is not clever enough to know that a string consisting entirely of
digits is compatible with an integer - as far as it is concerned 123% is
the
Hi,
where a1=Here's
You need to escape the ' character with a backslash before you send the
query to the server.
If you develope with C this link might be useful:
http://www.mysql.com/doc/en/mysql_real_escape_string.html
If you develope wit perl + DBI there comes a quote methode with the DBI
(B[EMAIL PROTECTED](B
$B%D%?%M%9([EMAIL PROTECTED](B
(B
(BSEND-PR: -*- send-pr -*-
(BSEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
(BSEND-PR: will all comments (text enclosed in `' and `').
(BSEND-PR:
(BFrom: dtutanes
(BTo: [EMAIL PROTECTED]
(BSubject: [50
J Wadsworth [EMAIL PROTECTED] wrote:
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets
Did you build mysql yourself, or did you install it along with Suse?
If it's installed with suse, start the mysql service via the suse method
(not sure what that is, on RedHat, one would simply say service mysqld
start).
If you built it by installing the binary, then your mysql should be
located
Hi ,
I am trying to export a database from one machine ie linux, and import
the same database to another machine ie ,solaris .
I exported the database using the following command .
mysqldump -c -u vidhya ifmonitor $HOME/ifmonito.backup.
this is ok , ifmonitor-backup has the table creation info
Try using MySQL-Front.
-Original Message-
From: Vidhya CS [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 7:17 PM
To: [EMAIL PROTECTED]
Subject: Import databse ?
Hi ,
I am trying to export a database from one machine ie linux, and import the
same database to another machine ie
I'm reticent to consume any more of this lists bandwidth and trust this will
end the thread, but here is my point. There are many 'gotchas' to consider
when developing an application that uses any dynamic file structure from
simple flat ascii
files to engorged dbms's. Add multi-user and
Hi!
On Jul 29, Niels Larsen wrote:
Sergei,
Will a future MySQL version combine the current nice and fast word-search
with ability to add data in finite time? I saw Make all operations with FULLTEXT
index faster on the TODO list .. are you able to say what is in the pipe?
Not really. Some
Hello again all,
I have created an account in the particular database that I was trying
to backup Using PHPMYADMIN and I also created the same user account on
the OS side. I still got the same 1064 message afterwards. I am still
relatively new to Mysql and my adding user only works when I use
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I
also suspect that the default field separator in Solaris is not a Tab character. Check
these out. If these are in fact true, then it might go a long way in explaining why
your import failed.
Vidhya CS [EMAIL
Hi all
I am getting the error message like this frequently. We are using mysql
production version 4.0.12.
[Tue Jul 29 22:00:11 2003] [error] SPFC: ERROR: _init: can't connect from
192.168.20.83 to 192.168.20.66:3306 as spfclogin:spfcpw/vconfig: MySQL
returned: Can't create a new thread (errno 11).
I'm having a problem similar to one I mentioned last week. I'm trying
to retrieve the number of posts a selected user has made on a selected
forum, plus details of the record of his/her latest post (date and
subject).
SELECT COUNT(*) AS postcount, m.user_id, m.subject, m.posting_date,
I am new to mysql . I was not aware that the default separator in Linux is tab .
if so it should be changed to what in solaris .
and how I do it , any commands for this or should it be edited manually
Thanks
Vidhya.
If I have to change the default field separator from tab
Kenneth Illingsworth
Hello gang,
This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
The line separator isnt the problem ,
I used mysql -u vidhya ifmonitorifmonitor.sql instead of mysqldump
now all the records got inserted properly.
Thanks .
Vidhya.
Kenneth Illingsworth wrote:
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I
also suspect
Where can I find more information about the exact format of the InnoDB
tables and the file format of .frm other than looking at the source code for
MySQL and the InnoDB engine?
Thanks
Franz Klein
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
my query:
SELECT * FROM `links` WHERE MATCH ( KEYWORDS ) AGAINST ( 'paper' );
I have a table with 4 records in it of links to various newspapers, paper
and newspaper are both in the keywords field.
The keywords field has a fulltext index on it. Did I totally miss a step
somewhere? The query
Hi folks
I need a MySQL statement that will calculate a new unique identifier for
each record in a table.
The identifier format is -888 where the letters are the first four
letters of the company's name and the 3 digit number is accounts for
each occurrence of the letters.
E.G. MadMax
Thanks guys.
I wasn't very clear in my original email. I already
had a business section table (with a primary key). My
problem was, I couldn't figure out how to accurately
store (for information retrieval purposes) information
about business sections that use particular
applications. I was
Hi
I am trying to save bitmap images in a InnoDB table in a field that is
declared a lonblob. I am using the ODBC API of Microsoft Visual Studio 6 and
saving it to MySQL via the MyODBC Driver version 3.51. The MySQL version is
4.0.12-nt. Seems like I can only save four bytes and retrieve bytes
You didn't miss a step, everything is working as it should be. Meaning,
MySQL will classify your search results as irrelevant if it matches
more than half of the records. If you only have 4 records, chances are
your search is matching at least two. Put a few more records in your
database and
Don't stare too long at the Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) , it will blind you after a
couple of minutes ;p
Seriously, the fact that the sock file is not there simply tells me that
mysql is not running, ie, even if you could copy a mysql.sock
Vidhya CS wrote:
Hi ,
I am trying to export a database from one machine ie linux, and import
the same database to another machine ie ,solaris .
I exported the database using the following command .
mysqldump -c -u vidhya ifmonitor $HOME/ifmonito.backup.
this is ok , ifmonitor-backup has the
Iulian,
this is in the manual. Look at
Database Administration
Localisation
Character arrays
Regards,
Thomas Spahni
On Wed, 30 Jul 2003, Primaria Falticeni wrote:
I can copy the latin2.conf into new one, but I need to know what each code
from the conf file represents and
At 14:55 + 7/30/03, Thierno Cissé wrote:
Hi Paul Dubois,
Please reply to the list, not just to me directly. Thanks.
we late to answers due to administration problems.
MySQL doesn't have anything to do with HTTP connections.
Next is an extract of MySQL documentation (MySQL reference manual
Hi Paul Dubois,
we late to answers due to administration problems.
MySQL doesn't have anything to do with HTTP connections.
Next is an extract of MySQL documentation (MySQL reference manual up to
Version 4.1.0-alpha).
...In other words, this value is the size of the listen queue for
incoming
On Wednesday, July 30, 2003, at 11:21 AM, Paul DuBois wrote:
Please reply to the list, not just to me directly. Thanks.
Is there ever a time when it is *not* appropriate to send your
response to the list instead of the individual?
If not, why is the list not setting a Reply-To: header? Yes,
Colt Brunton wrote:
Hi folks
I need a MySQL statement that will calculate a new unique identifier for
each record in a table.
The identifier format is -888 where the letters are the first four
letters of the company's name and the 3 digit number is accounts for
each occurrence of the
At 14:07 +0100 7/30/03, [EMAIL PROTECTED] wrote:
Where can I find more information about the exact format of the InnoDB
tables and the file format of .frm other than looking at the source code for
MySQL and the InnoDB engine?
Looking at the source code is how you do it, at least for the .frm
file
At 11:32 -0400 7/30/03, Ed Leafe wrote:
On Wednesday, July 30, 2003, at 11:21 AM, Paul DuBois wrote:
Please reply to the list, not just to me directly. Thanks.
Is there ever a time when it is *not* appropriate to send
your response to the list instead of the individual?
Sure, however, I'm not
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory system. The
system contains:
Items
Kits(Made from a collection of Items and/or other Kits)
Now my question is:
Is there any way to structure this in a
Hi all ,
I miss attention when I reply, nothing else .
Sorry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: mercredi 30 juillet 2003 15:42
To: Ed Leafe; [EMAIL PROTECTED]
Subject: Re: how listen queue size affect MySQL on RedHat
At 11:32 -0400 7/30/03, Ed Leafe
I try a solution like this. It's kind of a tree [so your warned that this
structure will be a waste of time if you have a subkit to a subkit to a... ]
KITS
kt_id int
kt_things.
parent_kt_id_fk int
constraint fk_KITS foreign key (parent_kt_id_fk) references kits(kt_id)
For details consult
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress database
Will write to a
Excellent are there any doc pointers describing how to set this up?
/Joe
Jeremy Zawodny wrote:
On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote:
Currently we have a web based application that is mostly reads (4:1
r/w). It is using a single MySQL database server. Is there any way
Sorry for was sending HTML. I didn't noticed it. My default was TEXT and now
I found HTML in the settings ... maybe because of international chars. I
turned it back to TEXT.
Hello,
I installed MySQL 4.0.14 on a new Linux machine unde the form of two
servers: one master and one slave.
I met
At 9:25 -0400 7/30/03, Chad Day wrote:
my query:
SELECT * FROM `links` WHERE MATCH ( KEYWORDS ) AGAINST ( 'paper' );
I have a table with 4 records in it of links to various newspapers, paper
and newspaper are both in the keywords field.
The keywords field has a fulltext index on it. Did I
sorry, again
maybe the stress
I take remarks in a friendly (mysql) way !
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: mercredi 30 juillet 2003 15:55
To: Thierno Cissé
Subject: RE: how listen queue size affect MySQL on RedHat
Hi all ,
I miss attention when I
At 0:52 -0400 7/30/03, J Wadsworth wrote:
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets
Has anyone written a perl script to get records from another
database and write it to a file on mysql's LOAD DATA INFILE
format? I just need some pointers in perl so a LOAD DATA
INFILE will be read correctly.
You might want to check out Perl's DBI module at search.cpan.org
I use that all
Howdy List!
A couple questions about finding the disk space used by a table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE 'wild';??
If so how can I do a query like the one above
How can I make hotcopy of my database if it have many tables (more than 1000) ???
mysqlhotcopy failed when it try to lock all tables ...
How many tables can I lock at one time ?
Can I increase this limit ?
Working system:
RedHat 7.3
MySQL 3.23.56 (compiled manualy)
Perl 5.6.1
Hello gang,
This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
Howell, Scott wrote:
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress
Hi,
I used the command similar to the following to dump out both the structure and
contents of my database:
mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql
I got an error half way through restoring the database into another test database
using the following command:
mysql -u
Hello,
I installed MySQL 4.0.14 on a new Linux machine unde the form of two
servers: one master and one slave.
I met many unsynchronized events so it was appears conflicts from this late
of the changes from master to slave. I put the master-connect-retry to 2.
Now it seems to work clearly but I
Hi guys and gals,
I'm a complete newbie to mysql, so please bear with me.
Today I downloaded mysql4.0 binary distribution and installed it on my
SuSE Linux 8.1 box. I've unzipped it and put it in:
/usr/local/mysql-standard-4.0.14-pc-linux-i686
and I've created a symbolic link to give me
Hi,
It sounds like you're more interested in the number of active
connections that can be
maintained, in which case the max_connections variable is likely to be
of more use to you.
I set the variables max_connections to 700 and back_log to 600. My
server can maintain it.
The problem that I
Can I get a unique identifier using the mysql_connect command by connecting
to the same host, same user but different database during the life time of
one script?
I currently do a
$conn_id = mysql_connect ($host_name, $user_name, $password);
Then call a,
mysql_select_db ($db_name,$conn_id)
But
Sorry forgot to cc to the list.
Hi Mike,
Hmmm. Don't think so. /tmp is drwxrwxrwt
Cheers
Peter
On Wed, 2003-07-30 at 18:43, O'K Web Design wrote:
Hi Peter
It sounds like you have a directory permission problem. I had one just
this week. Just make sure that mysql can write to
Hi again Mike,
thanks for your help, but no luck there either. the permissions are 755
with mysql as owner and daemon as group
cheers
Peter
On Wed, 2003-07-30 at 18:52, O'K Web Design wrote:
Hi Peter
It might not be the /tmp directory. This is taken from your original
post.
I
Hello gang,
This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie I still cannot execute certain
commands from my dos prompt, but I can run queries easily using
Hi Sanya
Don't appear to have a file called my.cnf anywhere on my system. Should
I have? If so how should it be formatted, and what should be in it?
Peter
On Wed, 2003-07-30 at 18:42, Sanya Shaik wrote:
You need to set the sock in usr/local/mysql/data/my.cnf to /tmp/mysql.sock
Hi guys/gals, the problem is directory perms but not in the tmp. And yes
you should have my.cnf in your /etc (can change this location but cant
remember where), and there are sample cnf files in the support-files
directory of mysql.
As far as the directory issue goes simply run:
chown -R mysql
In the past I have developed MS-SQSQL ASP
applications and handed the ASP parts to a junior
programmer knowing well that he wouldn't be able to
wreck the database (given the triggers, Keys,
constraints, indexes and stored procedures that were
involved).
Yes I agree with you that clients
Ha! Nice one Nick.
Changed the user to mysql, but there's no mysql group, so changed the
group to daemon (sounded right). Anyway mysql is now up and running.
Just out of interest, the owner of all the directories in
/usr/local/mysql is '503'. Grepping /etc/passwd for '503' returns
nothing.
Greetings...
I have a double column (id) that has data like -
-123.123
1.1
0.001
200.001
-123.4
Is there any query wherein I can get formatted
resultset like -
-#123.123#
+###1.1
+###0.001#
+#200.001#
-#123.4###
Any MySQL function or a workaround
Thanks in advance?
Karam
[snip]
I have a double column (id) that has data like -
-123.123
1.1
0.001
200.001
-123.4
Is there any query wherein I can get formatted
resultset like -
-#123.123#
+###1.1
+###0.001#
+#200.001#
-#123.4###
Any MySQL function or a workaround
[/snip]
Start here
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a query. To
complicate matters, what constitutes a duplicate record is a match on
several fields, but not all fields. I have been successful in matching
all
If all these fields are defined as not NULL, simply
use alter table with the ignore option to add a unique key on all
pertainant fields.
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a
Donald,
I've done this before - it wasn't nice. The best solution I came up with
was to store the kits in the item table as though they were items. So
the structure is: (Lets call a 'Product' an Item or a Kit depending on
the 'prod_type')
PRODUCT KIT CONTENTSPRODUCT
Unfortunately this is not the case.
Any other ideas?
Kim
If all these fields are defined as not NULL, simply
use alter table with the ignore option to add a unique key on all
pertainant fields.
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
I want to remove the old 2.50 myodbc driver. I installed a new version
of myodbc, and the old driver is still being diplayed in the list...
I know this is not really a mysql problem, but I'm not much of a windows
user and google didn't return good results this time... maybe someone
here could
At 11:52 PM 7/29/2003, you wrote:
I am attempting to use the LOAD DATA feature. At the end it reports
that I have several warnings but there does not appear to be a way to
determine what the warnings are. I installed V4.1 which has the SHOW
WARNINGS feature, but, it returns empty sets after the
Is this even possible with mysql then?
Howdy List!
A couple questions about finding the disk space used by a
table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS
FROM db_name LIKE 'wild';??
Is there any means of running MySQL (3.23, mostly MyISAM tables running on
Win2k Server) so that escaped character sequences (those preceded by a
backslash \) are _not_ interpretted as anything other than literals? We're
trying to port a large number of web applications that previously used MS
Hi all,
I am using DBI and DBD::mysql to connect to a MySQL database from perl and I
would like to get the execution time period after a query, like MySQL
standard client shows.
Sometimes when I work in the standard console client it tells me that there
are x wornings.
How can I see which are
hello,
MySQL lets CURRENT_TIMESTAMP tick on inside transactions. I'm
wondering why? doesn't this violate the atomicity of transactions?
thank you,
Lodewijk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Ok at least could someone tell me if the SHOW TABLE STATUS
fields 'Data_length' and 'Index_length' are in bytes and
added together would make the disk size that that table
is using up?
Thanks a bunch
Dan
-Original Message-
From: Dan Muey
Sent: Wednesday, July 30, 2003 4:24 PM
Gustavo,
At this moment this is the only way I know how to remove the old ODBC
driver. Run regedit go to My
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI.
Find the folder with the old MySQL driver name (most likely just MySQL).
Open up that folder and you should see a couple files
I have a program that I am writing in PHP/MySQL. I have made some upgrades
to the database and like an idiot, forgot to write down the changes or to
make the changes in several other databases for the other clients that are
using the program also. What I am trying to do is to have a program,
Hi,
I have a database with 5 teams and each team has 'n' categories and each
category has 5 sub-categories.
i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals,
assists, ppg, gwg, points.
Team0ne
Category 1
Sub 1
Sub 2
I have a database, about 12 fields per record and roughly 100,000
records per month.
I would do the following query:
select count(*), type from TABLENAME where field0='23-23-23' group by
type;
the query would run an average of about 2secs. Not bad until I am
running the same query about 1400
Everytime I post to this list I get a message from
AntiSpam UOL [EMAIL PROTECTED]
My message is getting to the list ok I keep getting this annoying
message.
Kim Mackey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 21:35 -0400 7/30/03, Kim Mackey wrote:
Everytime I post to this list I get a message from
AntiSpam UOL [EMAIL PROTECTED]
My message is getting to the list ok I keep getting this annoying message.
Kim Mackey
I reported this to [EMAIL PROTECTED]
That subscriber's been removed.
--
MySQL
I wrote to the [EMAIL PROTECTED] and told him if he didnt stop sending
me messages I would fly to Brazil and handle the matter personally.
That worked...
very Very annoying...
-M
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Kim Mackey [EMAIL PROTECTED]; [EMAIL PROTECTED]
www.kapadiaz.com = download free movies songs and also free 5 gb hosting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there an equivalent to transact-sql or pl-sql with
mysql. I realize that one could right functions in C
and compile it in with the server. However, no hosting
company will allow its clients to do this. So is there
a way to create function the way one creates a table
without having to have
On Wednesday, July 30, 2003, at 09:09 PM, woody at nfri dot com wrote:
I added an index for field0...with:
alter table TABLENAME add index (field0);
Now those same queries run about an average of 1/10th of a sec!! My
question is, is there a negative effect by indexing this field?
Obviously you
At 18:01 +0100 7/30/03, Gilbert Wu wrote:
Hi,
I used the command similar to the following to dump out both the
structure and contents of my database:
mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql
I got an error half way through restoring the database into another
test database
At 12:43 -0700 7/30/03, Grant Cooper wrote:
Can I get a unique identifier using the mysql_connect command by connecting
to the same host, same user but different database during the life time of
one script?
I currently do a
$conn_id = mysql_connect ($host_name, $user_name, $password);
Then call a,
On Wed, 30 Jul 2003, Paul DuBois wrote:
What I'd do if it were me in your situation:
- Remove the innodb_data_file_path line from your my.cnf file
done
- Restart the server; it should come up normally now
done
- Perform a complete dump of all your databases (just in case)
(use
Does anyone know how or better still can point me in the right direction on testing a
newly install MySQL application server. We would like to run some tests to see what
needs tweaking if any.
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
Hi.
With MySQL 4.1.0 alpha when I try to set default character set to tis620
MySQL start OK but have crash every time when perform to tun query (with
default_character_set=latin1 it never got error) and with MySQL 4.0.14 it
can do with out any error.
With MySQL 4.1.0 alpha what GUI to use for
I know this is the mysql mailing list but I have tried the Fuse mailing list
and no one will help well what im wanting to know is how could I get more
avatars show in a room like I already have it where all users that are
logged in control this 1 avatar im trying to make it where every user has
innodb_data_file_path = ibdata1:1266M;ibdata2:10M:autoextend
might work. But best to make a backup of the MySQL datadir first, just in
That did it. However I could not put ibdata2. It was saying no access rights to
file ibdata2. Once I removed the ibdata2 entry it started fine.
Another thing
Hello List,
How can I see the value of master-connect-retry? show variables doesn't work
on it.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
97 matches
Mail list logo
