Ms./Sir,
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name > database_name.backup
2. stop mysqld if is running. Then start it with "--log-bin"
According to the docs http://www.mysql.com/doc/en/MERGE.html:
A MERGE table (also known as a MRG_MyISAM table) is a collection of
identical MyISAM tables that can be used as one.
The disadvantages with MERGE tables are:
You can only use identical MyISAM tables for a MERGE table.
I have neve
I know that in 4.11+ you can preload your MYI index file into the key cache
using LOAD INDEX (http://www.mysql.com/doc/en/Index_preloading.html), but is
there a way to configure MySQL to do this whenever the MySQL service starts?
I'm willing to write .sql batch statements, but is there someway to
c
I've got on that really has me stumped ...
I've modified tha analog web stats program before to use a mysql database
before and I'm trying to do it again on a new system. I have this
function:
void db_connect(){
printf("start connect\n");
mysql_init(&dbh);
if (!mysql_real_connect(&dbh,"
> What I am trying to do is to enter a genome sequence which has around
> 175 characters. the file size is about 1.5MB which is well within
> the longblob size. I am using python to enter the sequence from a file
> to the database and the while i am running the python program ,the
>connection t
At 17:58 -0800 2/24/04, Danny Pudianto wrote:
Hello,
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen " ERROR 2003 : Can't connect to MySql Server on
'localhost' (10061)
Did you start the server (mysqld) first?
--
Paul DuBois, MySQL Document
Hello,
I am from Indonesia and newbie in Mysql.
Why if I execute command MySql in dos prompt,
appear in screen " ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061)
Thanks
Dani
-
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
Hi!
I started to write a little open-source (GPL) frontend for editing data
in mysql-databases.
http://www.scheinwelt.at/~norbertf/dabaxs/
The most important features of the first release:
* xml-configuration file to specify queries, fields etc...
* foreign-key mapping (dropdowns)
I have seen t
At 9:12 +1300 2/25/04, Chris Hellberg wrote:
Hi,
Is there a useful list of updates that have gone in to Mysql since
late 3.0 releases? I'm always having to manually coax replication
between a couple of servers and was wondering if replication has
become more resilient in later releases.
If you
Kirti S. Bajwa <[EMAIL PROTECTED]> wrote:
>Worked like a charm.
>
>Thanks. You are a life saver.
>
>> The easiest way to do this would be to move the data directory and
>>all its contents onto the RAID disks. Then symlink to that directory from
>>the original location. Example only from basic
You can do a simple if statement. Instead of using a foreach I would use a
while with list
Example in pseudocode:
(while(list($col1, $col2, $col3) = @mysql_fetch_row($resultID))
and then
if ($col3 == value1)
echo "td stuff with bgcolor = whatever";
else
echo "td stuff with bgcolor = somet
On Tue, 24 Feb 2004, Paul DuBois wrote:
>
> There are different RPMs containing different parts of the installation.
> You just need to install the client RPM and you should be fine.
Thanks! (Dooh! :)
lk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
There are excellant tutorials at www.codewalkers.com under the
tutorials/basics section. Most people start with the "Creating Dynamic
Websites with PHP and MySQL" tutorial. There are also many various forums
to go to with coding problems or questions. I personally use
www.phphelp.com.
Respectfu
90% of the time you forgot the ";" on the line before the parse error. if
not then I would need to see the code to help you.
Respectfully,
Ligaya Turmelle
""Nitin Mehta"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
there must be some problem in concatenation of strings and number
On 02/24/2004 04:45 PM Michael Johnson wrote:
Can MySQL store German characters such as ä, o, u and ß
Yes it can. It can store anything digital. It's what you program that
counts. :)
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
You also need to install the rpm for mysql-client.
Bernard
On Tuesday 24 February 2004 16:37, Database Administrator wrote:
> I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
> that comes with it). I decied to install 4.0 and used
> this command to install it:
>
> rpm -Uvh --nodeps MySQL
hi,
I am using mysql 4.0.14. I have a table where one of the fields has a
datatype longblob. What I am trying to do is to enter a genome sequence which
has around 175 characters. the file size is about 1.5MB which is well
within the longblob size. I am using python to enter the sequence
I am beginning the process of moving an exising MySQL/Apache server, (or
rather, several of the sites there) to a new machine, to spread the
load, and allow us to upgrade the servers bit by bit.
Versions of MySQL are both 3.23.58
Apache and PHP, etc, is set up and humming along nicely, doing mostl
Worked like a charm.
Thanks. You are a life saver.
Kirti
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 2:21 PM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: Re: How to install data on a RAID HDD??
>I have
Paul, your guess was absolutely correct. Looking at the information
pointed to by the URL you sent, seems it's pretty easy to switch to the
old format. That's good. Thanks for the heads-up!
Bing
> At 15:46 -0600 2/24/04, Bing Du wrote:
>>Greetings,
>>
>>I used the 'scp' command to copy the fil
On 24 Feb 2004 at 22:01, Alison W wrote:
> Yes: MAX_ROWS is a *guidance* to the system in setting up the table
> and not a *limit* in any way.
Well, it is a limit in one way. MySQL uses it (in MyISAM tables) to
calculate the size of the pointer used for positions within the data
file. If the
Hill, Keith wrote:
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber, ManualChecksPrinted.A
At 15:37 -0600 2/24/04, Database Administrator wrote:
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm
I didn't see any obvious errors thereafter. After reboot
At 16:26 -0500 2/24/04, Tristan Fiedler wrote:
Hi All,
Thank you very much for the kind and ample help !
I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.
I manually start the server now via :
sudo mysqld_safe --user=mysql
> I wanted to test how the max_rows parameter works. I set it to 3 on a
> table. And, I was able to add 33 records [I stopped at this point]. It
> never prevented me from adding more records. The result is NOT what I
> expected. I expected that upon attempting to add the 4th record, I would
>
At 15:46 -0600 2/24/04, Bing Du wrote:
Greetings,
I used the 'scp' command to copy the file.MYD, file.MYI and file.frm files
from one linux box to another linux box.
On the source linux box, the table is like this:
mysql> desc file;
+--+---+--+-+-+-
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default
that comes with it). I decied to install 4.0 and used
this command to install it:
rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm
I didn't see any obvious errors thereafter. After rebooting
noticed that looks like the mysql daemon is runni
Greetings,
I used the 'scp' command to copy the file.MYD, file.MYI and file.frm files
from one linux box to another linux box.
On the source linux box, the table is like this:
mysql> desc file;
+--+---+--+-+-+---+
| Field| Type
Hi All,
Thank you very much for the kind and ample help !
I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.
I manually start the server now via :
sudo mysqld_safe --user=mysqladm
I have two questions :
1. Why does 'mysq
Hello
OS: Unix MySQL:4.0.16
OS: Linux MySQL:4.0.17
I am trying to limit the size of the MyISAM tables in a MySQL database. As far as I
can tell, my only option is using the MAX_ROWS parameter on a table. I am not looking
to do this limit at the OS level.
I wanted to test how the max_rows
Hi,
Is there a useful list of updates that have gone in to Mysql since late 3.0 releases?
I'm always having to manually coax replication between a couple of servers and was
wondering if replication has become more resilient in later releases.
I've reloaded the database on the slaves and once th
>I have no problem installing MySQL on the main HDD but can not figure out
>what changes are needed so all the data goes to RAID disks. I am a newbie so
>please, give direction!!
The easiest way to do this would be to move the data directory and
all its contents onto the RAID disks. Then sym
Configure your my.cnf data_dir parameter to point to the raid Hard Drive.
>> Original Message <<
On 2/24/04, 12:44:13 PM, Kirti "S." Bajwa <[EMAIL PROTECTED]> wrote regarding
How to install data on a RAID HDD??:
> Hello List:
> First my apology: I have previous
MySQL is designed to do that. If no data is changed, then MySQL will not
perform the update.
>> Original Message <<
On 2/24/04, 11:36:39 AM, Jacque Scott <[EMAIL PROTECTED]> wrote
regarding Updating a Record:
> I am converting from Access 2.0 to MySQL and I am
What is being logged to the *.err log in the data directory?
>> Original Message <<
On 2/24/04, 12:42:19 PM, Dale Goolcharan <[EMAIL PROTECTED]> wrote
regarding Fresh/New install of MySql 4.1 :
> Hi,
>I am currently running mysql4.0 and I will like to upgrad
[EMAIL PROTECTED] wrote:
I think you may have introduced the >From typo
! Try looking at a mailbox in a text editor -- you'll notice that
the string 'From ' occuring at the beginning of a line is used as
the message separator.
Thus when that string occurs within a message body, it needs to be
es
Mike Koponick wrote:
The idea is that if someone stole the hard drive or computer, it would
be hard for someone to break into the database. It seems to me the best
way would be to encrypt the drive space, and use the login to
authenticate the encryption space on the hard drive.
How about sth like
Mail messages start with "From". When you begin a line with "From" in
the body of your message, your mailer, like most, prepends a ">" to
prevent it from being interpreted as the start of another message. You
can usually avoid this yourself by prepending a space.
Michael
[EMAIL PROTECTED] wr
Hello List:
First my apology: I have previously asked this question and saved the
response. But we lost our Win NT server and all the saved data, so I ask the
same question again. I have looked in archives for the last three months and
have not been able to find my previous Q/A. I will be setting
Hi,
I am currently running mysql4.0 and I will like to upgrade to 4.1 to
support unicode for languages such as korean, Japanese, Spanish and so on.
I do not want to upgrade but simply perform a fresh install and create
new databases to support unicode. When I perform this upgrade, the MYSQL
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I
encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber,
ManualChecksPrinted.AccountID, ManualChecksPr
Hello everyone,
I'm new to the list and did a little searching on the archives but
wanted to ask my question to the group.
I have a requirement to encrypt all data stored into a database. I was
wondering if there was a different way of doing this or should I use the
encrypt/decrypt functions?
Th
Hi!
On Feb 23, Gelu Gogancea wrote:
> Hi,
> TABLE CREATE DESCRIPTION :
> CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC
> INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC));
>
> RUNNING CONDITIONS:
> -use persistent connection.
What do you mean "persistent connection" ?
Persistent PHP conne
At 15:06 -0300 2/24/04, Tenchi Muyou wrote:
Sorry guys, i only seen i sent directly to Paul
after i sent it ... Forwarding to the list.
Original Message
Subject: Re: Inserting values with ";". How?
Date: Tue, 24 Feb 2004 15:05:59 -0300
From: Tenchi Muyou <[EMAIL PROTECTED]>
To:
Sorry guys, i only seen i sent directly to Paul after i sent it ...
Forwarding to the list.
Original Message
Subject: Re: Inserting values with ";". How?
Date: Tue, 24 Feb 2004 15:05:59 -0300
From: Tenchi Muyou <[EMAIL PROTECTED]>
To: Paul DuBois <[EMAIL PROTECTED]>
References:
I'm not 100% sure, but this type of programming would seem to be opening the
doors for bugs down the road that get difficult to trace and to track. If
you are using a multi-threaded app, then you have to make sure that you
prevent any mods to the DB after your insert and before your select. If yo
At 9:36 -0800 2/24/04, Jacque Scott wrote:
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an U
Might sound like a silly question, but have you checked the write
permissions to the data dir? Am not sure if it is the mysql daemon that
needs write access or if it is the user logged on
"Colin O'Connor" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I'm bundling My
I think you may have introduced the >From typo, but it is one regardless. I
don't think the parens are necessary. Try it out.
Ted Gifford
-Original Message-
From: Gregory A. Swarthout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 9:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROT
At 14:30 -0300 2/24/04, Tenchi Muyou wrote:
Hello there guys,
I needed to transfer my db from one MySql
server to another, and exported the table in a
.sql file. The problem is that when i try to
import it gives an error. Here is the code that
is giving the error:
INSERT INTO `phpbb_posts_te
Thanks Sasha. It helped trim down my table a bit
Eric
"Sasha Pachev" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Eric B. wrote:
> > Sure! Here it is:
> >
> > CREATE TABLE `index2` (
> > `id` varchar(50) NOT NULL default '',
> > `recordid` varchar(20) NOT NULL default '',
>
I attempted to create a merge table across two identical InnoDB tables
and it seemed to work without error. But when I went to use the table I
got a file not found my_table.MRG (error number 2) error. The file does
in fact exist, but it is only 54 bytes.
I'm guessing that I can only create a
Quoting [EMAIL PROTECTED]:
>
> Sounds like you want to do:
>
> Select store_name, t1mgr.manager_name as 'type_1_manager',
> t2mgr.manager_name as 'type_2_manager'
> >From (keystone_stores ks left join managers t1mgr on ks.id =
> t1mgr.store_id
> and t1mgr.manager_type = 1)
> Left join managers t2
I am converting from Access 2.0 to MySQL and I am going through all of
my code to make it compatible with MySQL. I was testing my Update for
one of my queries and I don't know if I found a bug or if MySQL was
designed to do this.
In my program I pass an UPDATE string to MySQL. There can be time
Hello there guys,
I needed to transfer my db from one MySql server to another, and
exported the table in a .sql file. The problem is that when i try to
import it gives an error. Here is the code that is giving the error:
INSERT INTO `phpbb_posts_text` (`post_id`, `bbcode_uid`, `post_subject`,
hi,
what's about http://bugs.mysql.com/bug.php?id=2915 [Bug: Installation of
Grant Tables failed!] ??
I have the same problem, how it described in this bug report. but nobody
could say me if this is a bug or merely a mistake on my part.
I would be really great if anybody could answer, because I
Thanks for your help... appreciate it...
MERGE table type is what I searched for :-)
Thanks
-Lorderon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:25 -0700 2/24/04, Jeff Mathis wrote:
but there are ways to get this value. The Java API handles this case
just fine, and I'd be willing to bet other API's do it as well.
I know that, but that isn't what he asked.
here's some simple code to do with the Java API:
String sql = ;
Statement st
but there are ways to get this value. The Java API handles this case
just fine, and I'd be willing to bet other API's do it as well.
here's some simple code to do with the Java API:
String sql = ;
Statement stmt = getConnection().createStatement();
stmt.executeUpdate(sql, Statement.RETURN_GENERA
Sounds like you want to do:
Select store_name, t1mgr.manager_name as 'type_1_manager',
t2mgr.manager_name as 'type_2_manager'
>From (keystone_stores ks left join managers t1mgr on ks.id = t1mgr.store_id
and t1mgr.manager_type = 1)
Left join managers t2mgr on ks.id = t2mgr.store_id
and t2mgr.mana
At 19:18 +0200 2/24/04, Lorderon wrote:
"Paul DuBois" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
At 19:04 +0200 2/24/04, Lorderon wrote:
>Is there a way to make concat 2 tables together without using UNION ?
>The tables are EXACTLY SAME, but they sit on 2 different DBs.
>And I
At 12:07 PM 2/24/2004, Keith C. Ivey wrote:
Sounds like it's your operating system's caching of the disk reads.
Yikes... that would explain it.
um... anyone know how to disable disk caching on Linux 2.6 kernel?
-bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Would creating a merge table be a solution for you?
>> Original Message <<
On 2/24/04, 11:04:53 AM, Lorderon <[EMAIL PROTECTED]> wrote regarding
Union EXACT Tables:
> Hello All,
> Is there a way to make concat 2 tables together without using UNION ?
> The table
You could try creating a function in Java or C/C++ or whatever your
preference is that wraps the select statements up for you and returns the
insert ID.
>> Original Message <<
On 2/24/04, 11:02:51 AM, David Scott <[EMAIL PROTECTED]> wrote regarding
INSERT return
"Paul DuBois" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> At 19:04 +0200 2/24/04, Lorderon wrote:
> >Is there a way to make concat 2 tables together without using UNION ?
> >The tables are EXACTLY SAME, but they sit on 2 different DBs.
> >And I want to run the SAME where clause on
At 17:02 + 2/24/04, David Scott wrote:
Hi list peeps
In many of my projects I have the need to insert a new record into a
table and then later on in the script update this record, Right now
I am doing this by doing the insert, then immediately doing a Select
to return the latest id (uniq
At 19:04 +0200 2/24/04, Lorderon wrote:
Hello All,
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want to run the SAME where clause on both tables...
What's the problem with using UNION?
--
Paul DuBois, MyS
Suppose I have two tables like this:
keystone_storesmanagers
=
id | store_nameid | manager_name | manager_type |
store_id
+---
+---+---
On 24 Feb 2004 at 12:00, Bill Marrs wrote:
> Actually, I just noticed that even after I restart mysql, the speed
> stays. That doesn't make any sense, maybe there is some other unknown
> factor influencing this.
Sounds like it's your operating system's caching of the disk reads.
--
Keith C. Iv
Nope, this would yield a 'Column: 'avg' in field list is ambiguous'
error. I'm still trying to work out a better way of doing this. I also
need to get standard deviations now, and the method I mentioned in my
original post doesn't even work for that. So now I'm left with actually
getting all the
Hi list peeps
In many of my projects I have the need to insert a new record into a table and then
later on in the script update this record, Right now I am doing this by doing the
insert, then immediately doing a Select to return the latest id (unique id) which I
store later for my update.
At 11:35 AM 2/24/2004, Mike Johnson wrote:
It sounds like query caching is working against you.
There are a variety of ways to get around it. While it'll be a PITA, you
may want to have you script call `RESET QUERY CACHE` at the begining, and
then include `SQL_NO_CACHE` in your SELECT statement(
Hello All,
Is there a way to make concat 2 tables together without using UNION ?
The tables are EXACTLY SAME, but they sit on 2 different DBs.
And I want to run the SAME where clause on both tables...
Thanks in advance,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.
Hi Beau,
basically, you can use anything from MySQL 3.x, as you like it. I'm on an
Internet Newsboard System for a while and switched that to UTF-8 for all
data handling, display and storage. (Even sending out UTF-8 e-mails and
Jabber messages...) You just have to give MySQL the UTF-8 encoded stri
(Asking again)
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with 'mysqldump --opt' began failing with the
message: 'mysqldump: Error 1030: Got error 12 from table handler when
dumping table `reference` at row: 255233'. The table has about 265,
Are you logging slow queries? Have you run an explain plan for the
queries in question?
>> Original Message <<
On 2/24/04, 10:29:33 AM, Bill Marrs <[EMAIL PROTECTED]> wrote regarding
disabling optimizations to identify slow queries:
> I've found a performance i
From: Bill Marrs [mailto:[EMAIL PROTECTED]
> I've found a performance issue with a series of mysql queries
> that I make to generate a web page. But, when I go to
> investigate it, reloading the page a few times, I find the
> performance of the pages within a couple tries becomes very
> fast.
I've found a performance issue with a series of mysql queries that I make
to generate a web page. But, when I go to investigate it, reloading the
page a few times, I find the performance of the pages within a couple tries
becomes very fast.
So, it's hard to track down and work on the queries t
Hi
I have an application which uses Mysql 3.23 and a latin1 character set.
In a near future I will have to deal with texts in french, italian,
korean and japonese. I'm looking into UTF-8 for mysql.
I did not see anything which enable UTF-8 for mysql 3.23 or 4.0 :
character set list does not in
Can MySQL store German characters such as ä, o, u and ß
Thinking the Problem all the way through
Michael Johnson
Managing Director Humphrey Consulting Limited BPEnet
13 Austin Friars
London
EC2N 2JX
[EMAIL PROTECTED]
tel:
fax:
mobile:
Jim Austin wrote:
Hello Folks,
Am trying to upgrade MySQL with rpms. rpm -Uvh
MySQL-shared-compat-4.0.17-0i386.rpm worked fine. When I try to upgrade
the client or server I get warnings that the files conflict with the
older versions that are currently installed. I've tried to erase the
olde
Colin O'Connor wrote:
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database ("CREATE DATABASE
mydb") I get the error: "ERROR 1006: Can't create database 'mydb'. (er
[EMAIL PROTECTED] wrote:
I wrote a cold fusion script to migrate data from an access 2000 db to a
mysql 4.0.18 db and when I display the data with cold fusion I see these
little box characters in different spots.
I'm assuming that it's an issue with the encoding. How do I correct this?
Looks li
embedding PHP scripts in between your HTML tags .. use vi or emacs
editor
:-)
sree
On Tue, 2004-02-24 at 11:44, Togochog Enhebatu wrote:
> hi,
>
> I am new in PHP, and I would like to create some user interface with PHP.
> Could anyone tell me what is the easiest way to do this?
>
> than
Mark Maunder wrote:
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
There is:
REPAIR TABLE t1 USE_FRM
--
Sasha P
Hi list,
I'm trying to get mysql replication set up for a distributed development
environment. The master is the production server, whereas the slaves are
part of the developers' sandboxes (on their own machines).
The master machine is using MySQL 4.0.15, the slaves a nice mix of 4.0.15+
and 4.
"Rughwani, Devashish (Devashish)" <[EMAIL PROTECTED]> wrote:
>
> Is it possible to make a column of TEXT data type as PRIMARY key ?
>
> How to give the lenght for the below error ?
> "ERROR 1170 (42000): BLOB/TEXT column 'colname' used in key specification
> without a key length"
>
For BLOB/TEX
Thanks for the help, changing the privileges and resetting the root
password I managed to log in.
Best Regards
/Maria Yndefors
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: den 24 februari 2004 14:14
To: [EMAIL PROTECTED]
Subject: Re: install problem
"Mari
"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> Hi,
> No I have not have MySql installed before and I am using version 1.4,
> but I used an my.cnf from another host with mysql 3.x
>
> Now I can't even manage to start it I get the following in the log file
>
> 040224 14:39:01 mysqld started
> 04022
Hi
Is it possible to make a column of TEXT data type as PRIMARY key ?
How to give the lenght for the below error ?
"ERROR 1170 (42000): BLOB/TEXT column 'colname' used in key specification
without a key length"
Thanks
Devashish Rughwani
--
MySQL General Mailing List
For list archives: http:/
Fantastic! This was indeed the problem and has solved it. Many thanks!
On Tue, 24 Feb 2004 13:14:51 +0100, Jigal van Hemert wrote:
>> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
>> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
>> and \'$Date2\
Hi,
No I have not have MySql installed before and I am using version 1.4,
but I used an my.cnf from another host with mysql 3.x
Now I can't even manage to start it I get the following in the log file
040224 14:39:01 mysqld started
040224 14:39:04 InnoDB: Started
040224 14:39:04 Fatal error: Ca
The following works on 4.0.16, for those of us who'd like to stick to the
stable release:
update controltable set nextid = 1 + (@prevval := nextid)
Note. There was a problem with this in 4.0.13--namely, the value of
@prevval sometimes was garbage. I reported this via the list, but got no
re
MySQL baby <[EMAIL PROTECTED]> wrote:
> Anyone using TONS of Query Cache for a high-traffic site?
>
> Our search server is really sweating.
> I was about to jump through a LOT of software loops to program
> query caching at the app level, when I realized that MySQL had
> it built-in already. (We'
> $sql = 'SELECT Username, Count( Username ) FROM MainDetails, Usernames
> WHERE MainDetails.UserID = Usernames.UserID and Date Between \'$Date1\'
> and \'$Date2\' GROUP BY Username';
>
> The strange thing is if I replace the $Date2 variable with a date manually
> it works -. i.e.
Not a MySQL issu
hi,
I have created the COBOL coding to test those C API from
MySQL. Upon executing this COBOL program too hangup the server
but here using mysql_error() I got the error message in a
variable as
*Can't open shared memory. Request event don't create (2)*
These Error I captured after running the
SQL
Hi, All!
Is 4.1.1 replication compatible with 4.0.x?
I have problem to replicate data from 4.0.17 to 4.1.1
show slave status show all are OK
perlicate position and the exec position are the same.
But if I update data on master, slave is not update own data :(
Best regards.
Hello All,
I have a very strange problem which makes no sense to me whatsoever.
I am trying to find the number of queries that the people have dealt with
in a database between two dates. The dates are generated from some drop
down boxes and dropped into a variable. This is the code for the query.
hi,
I wish to provide some more information too regarding MySQL
Server hangup.
Once after I execute the C sample program, WinMySQLAdmin tool
and query commands from *mysql>* console never responds.
During this time if I try to start mysqld from another console
produce the following error mes
"Randy Paries" <[EMAIL PROTECTED]> wrote:
> Hello
>
> I have a number of servers.
>
> I have one running RH7.3 with mysql-3.23.56-1.73
> one running RH9 with mysql-3.23.58-1.9
>
> My question is when i do a ps -ef
>
> on RH7.3 a get a number of /usr/libexec/mysqld
> on RH9 i only get one.
>
>
1 - 100 of 115 matches
Mail list logo
