Hi
This is not a response to Malcolm, but rather a query.. if the CSV file
to be imported into a MySQL table using LOAD DATA command had ASCII
char(13) and/or ASCII char(10) in it, would this interfere with the
usual behavior of LOAD DATA?
If so, is there a workaround for this problem? (In Oracl
Hi all,
I am having 5 rows in a mysql database related to five
different users. these rows contains their firstname,
lastname and details of scenes 1 to 5(these details
are numeric values from 1 to 3). if any of these
fields from scenes 1 to 5 are empty that will be
detected from the firstname of
Hello Michael,
Friday, January 26, 2001, 12:20:43 AM, you wrote:
MW> Hi!
>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello monty,
Peter>> As I remember according to documentation MYSQL should support check
Peter>> table on BDB tables:
Peter>> `CHECK TABLE' only wo
Dear All,
I was installed MySql 3.22.32 with PHP and Apache and I decide to upgrade
to 3.32.32. Could I only install New version of MySql or reinstall all of
related software (PHP & Apache)??
Thank you,
Sommai Fongnamthip
--
I'm loading a large csv file and get the following result:
mysql> LOAD DATA LOCAL INFILE "kanji_all.csv" INTO TABLE kanji_all
-> FIELDS TERMINATED BY "," ENCLOSED BY "\"" IGNORE 1 LINES;
Query OK, 6355 rows affected (1.27 sec)
Records: 6355 Deleted: 0 Skipped: 0 Warnings: 49821
The resul
When you already creating database , use the mysql database :
1. Insert the user in table 'user' and also the user's host in table
'host'.
2. flush hosts.
3. grant the user.
4. flush privileges.
Hope this will help.
--Andy--
-Original Message-
From: Mac Martine [mailto:[EMAIL PROTECT
would you mind going into a little more detail...i'm near clueless about all
this..thanks-
mac
- Original Message -
From: Dominggus Andy A <[EMAIL PROTECTED]>
To: 'Mac Martine' <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 12:38 AM
Subject: RE: accessing
> It should work. Anyway ha
First off, I'd like to thank everybody whos helped me here in the past few daysi'm
getting there...
So, i am now able to access a database i created through mysql locally. then i granted
all privileges to myself
then i uploaded the database pages to my remote domainand made a p
Hi,
It looks like if no C / C++ compiler is installed and if it is, it's not in
your path. Please tell us what OS is this and also send us the output of
the PATH environment variable.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Con
On Fri, Jan 26, 2001 at 11:50:56AM +0900, °´ëö wrote:
> HI
> I am installing mysql now.
> But I got an error below.
> Could you help me this problem.
Do you have a C compiler in your path?
> **Error Message**
>
> root@localhost mysql-3.22.32]# ./configure --prefix=/usr/local/mysql --with-ch
>
On Thu, Jan 25, 2001 at 07:13:54PM -0600, Mac Martine wrote:
> how do i set up another mysql account after setting up the root
> account. i used mysqladmin to set up my root account, now i want to
> set up a remotye account to access files on my remote server, right?
> so i cant figure out how t
On Thu, Jan 25, 2001 at 10:01:59PM -0600, Patrick Goetz wrote:
>
> Currently, every system I've set up is small enough so as to have
> the web server and the database server on the same machine.
> Consequently, loss of security due to packet-sniffing can be
> completely controlled by using, say,
Currently, every system I've set up is small enough so as to have the web
server and the database server on the same machine. Consequently, loss of
security due to packet-sniffing can be completely controlled by using,
say, apache-ssl, since communications between the web server and the
database
how do i set up another mysql account after setting up the root account.
i used mysqladmin to set up my root account, now i want to set up a remotye account to
access files on my remote server, right?
so i cant figure out how to set up another account. i even tried uninstalling and
re-installing
Oh...Yeah I forgot to mention it.
It's Red Hat kernel 2.2.16.
Apache x.x.19. Browser Mozilla/Netscape.
I would like also to verify all users to give their Username/Password to
access my database.
This Computer gonna be both Server for my team project and Client for me.
I mean I'll test and man
HI
I am installing mysql now.
But I got an error below.
Could you help me this problem.
**Error Message**
root@localhost mysql-3.22.32]# ./configure --prefix=/usr/local/mysql --with-ch
arset=euc_kr
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checki
What you want to accomplish CAN be done but I'm not sure if it can be done
with one SQL statement at all.
What you want could be done within code.
> Thanks for your reply. Believe I'm thristy two and if I ever get this
> thing to work I'm going to pub crawl all the way home.
>
> What I am tryin
how do i set up another mysql account after setting up the root account.
i used mysqladmin to set up my root account, now i want to set up a remotye account to
access files on my remote server, right?
so i cant figure out how to set up another account. i even tried uninstalling and
re-installing
Hello,
I'm new with mysql and I've got a little problem. Somebody gave me a dump of a
database made with postgresql. So I can't dump it it in my mysql database. Is
there a utility that can convert a dump postgresql into a dump mysql? If not,
where can I find the rules to convert it by hand.
Tha
Thanks for your reply. Believe I'm thristy two and if I ever get this
thing to work I'm going to pub crawl all the way home.
What I am trying to do is display the beginning and ending points for
each pub crawl effedtively leaving out any intermediate stops so that
the summary of the pub craw occu
On Fri, Jan 26, 2001 at 09:41:09AM +0800, Sam Wong wrote:
> I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2
> Xeon 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
>
> The traffic of it is about 300 queries/second on average, and keep
> staying at around 400 q/s at night. The probl
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
Your Query is making me thirsty ;-)
Unfortunately your tables got garbled so I had to improvise.
Next time don't paste the tables beside each other...
Also, I'm not sure if I understand your problem or what you are trying to
accmplish.
Are you trying to de-normalize your data and display the Be
James R. Butzen ([EMAIL PROTECTED]) writes:
> Hi All,
>
> We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one
> experienced any unexpected problem due to upgrade.
We upgraded our production and development servers from 3.23.7 to 3.23.32 today. The
only thing we've see
Jarmo Paavilainen ([EMAIL PROTECTED]) writes:
> I could answer "read the manual", "look it up in the FAQ" and so on.
>
> But add "-lz" to you list of libraries to link in (ie libz.so).
I couldn't find it in the manual, where did you find it hiding? Thank goodness for
this list!
--
Ed Carp, N7
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traf
Alexandre STEFANI ([EMAIL PROTECTED]) writes:
> Each time I develop a tiny program using mysql I have this mistake, then I
> remember : it uses the zlib.
> So in Your Makefile, there is a "LIBS = ..." line somewhere ; just
> append "-lz".
Hmmm...when did this start? I just upgraded the server f
Hi All,
We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one
experienced any unexpected problem due to upgrade.
Thanks in advance for any comments.
James R. Butzen
NEBIS Tech. Support
http://www.nebis.com
PUB TABLEEVENT TABLE
|p_id|pub_name |address ||eventid|date
|host_id|
|13 |John Barleycorn's |1800 N. Lincoln ||321|2001-01-27 |
32|
|26 |Harry Carry's |300 N. Dearborn ||198|2001-02-21 |
As I understand it, search engines use a "special" type of database
structure.
They have a special table for common words/phrases and another one with all
the data.
They link theese together by a third one that contains only the id´s from
the other two, thus making the search much faster.
How do t
Hello there,
I was hoping you guys could help me with a little problem I'm having with
MySQL.
I'm trying to dump the contents of one field of a multi-field table to a
text file. The table is on the large side (about 3 million rows).
Whenever I run:
SELECT rowname FROM table INTO OUTFILE somef
mysqldump --tab=/tmp --no-create-info --fields-terminated-by=',' database
table
Should do the trick. This will create a file called /tmp/table.txt,
containing the data. Use --where=".." to select from fields.
For more complext selects, look at
select field1, field2 into outfile '/path/to/file'
Hi,
I wonder if any of the mySQL people have any guesses or real stats about the
number of people using each version of mySQL.
I am wondering if I develop a tool that only supports the latest 3.23
version will I cut out a whole lot of people?
How long does it tend to take for most people to upg
Hi,
how about
select fname, c1.cname, c2.cname, c3.cname from
firms,
cityname as c1,
cityname as c2,
cityname as c3
where
first.city0 = c1.id and
first.city1 = c2.id and
first.city2 = c3.id;
CC'ing the dialogue to the list lets us know that you have received the
first reply, and what you made
As will the urSQL Utility (MS Windows):
http://www.urbanresearch.com/ursql
urSQL can export query results in a variety of formats:
-> HTML
-> CSV
-> Excel
-> Word
-> Text
Depending on your data, you might also be able to use the SELECT INTO
OUTFILE syntax:
select * into outfile "tableout.tx
On Thu, Jan 25, 2001 at 05:17:03PM -0500, Gary Lyons wrote:
> Hi all,
>
> If I have an insert statement that adds data to a table that contains an
> autoincrement column, is there a way to get the value of the auto
> increment column without doing an additional query in JDBC ? . I am
> using the
gt;FROM ArgumentCalendar
> > >, CaseID
> > >, Parties
> > >LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
> > >WHERE CaseID.DocketNumber = ArgumentCalendar.Docket
> > >AND Parties.CASEID = CaseID.CASEID
> > >AND '20010125&#
Hello,
I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ...
I have a Table:
CREATE TABLE groupbyTEST (
fldNAME varchar(20) NOT NULL,
fldMONTH tinyint(4) DEFAULT '0' NOT NULL,
fldSALARY decimal(10,0) DEFAULT '0' NOT NULL,
fldDATE datetime DEFAULT '-00-00 00
If you're running windows go to
my.anse.de his client will do it.
Scott
At 02:54 PM 1/25/2001 -0700, Jason Terry wrote:
>Anybody have a quick way to make a CSV dump of a SELECT?
>
>If MySQL can't do it directly is there an easy way in PERL?
>
>
>-
Hi all,
If I have an insert statement that adds data to a table that contains an
autoincrement column, is there a way to get the value of the auto
increment column without doing an additional query in JDBC ? . I am
using the org.gjt.mm.mysql driver .
Thanks
no.
You can do:
SELECT sum(length(Something)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
But you will have to specify that for each field you want...then add them
all up to get the length.
Cal
http://www.calevans.com
-Original Message-
From: Jason Terry [mailto:[EMAIL PROTECTED]]
Se
Anybody have a quick way to make a CSV dump of a SELECT?
If MySQL can't do it directly is there an easy way in PERL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Yes, but does it get cleanly stopped when you shutdown? put the start
command in /etc/rc.d/rc.local, fine, but I think there needs to be a
kill link added to /etc/rc.d/rc.3 dir.
I like the link from apachectl to /etc/rc.d/init.d/ idea:
ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd
> "AH" == Alan Halls <[EMAIL PROTECTED]> writes:
AH> Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an
AH> error during the make command.
Using extreme powers of mental telepathy, we might be able to guess
your problem. However, if you told us exactly what the erro
I have a column that is defined as a SET. For simplicity's sake,
let's say the column is defined as:
set_col SET ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'Z')
After entering a few hundred rows, I know that some but not all
values of the SET have been used at least once. How can
Hi!
> "Jonathan" == Jonathan Roy <[EMAIL PROTECTED]> writes:
Jonathan> Hi all. I had the OpenBSD problems others have reported, with slow
Jonathan> response, high load/cpu usage, crashes, etc. Sinisa reported a month or
Jonathan> so ago it was a bug in the 2.8 threading library. I wrote t
Hi Alan,
I have uploaded a binary distribution to mysql.com, but they have not
yet had time to post it.
Here are my instructions for MySQL, Good Luck:
My notes on building mysql
gunzip
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 3:25 PM
Subject: BSDI 4.2?
> Anyone have a
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> As I remember according to documentation MYSQL should support check
Peter> table on BDB tables:
Peter> `CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM'
Peter> tables it's the same th
I don't know why you'd really want to store numbers that big. Since
mysql's aggregate functions wouldn't work on them anyway, just store the
numbers as strings.
At 03:53 PM 1/25/2001 -0500, Ashutosh Somani wrote:
>Hi,
>I am working on an application where I need to be able to store 96 bit
>nu
Y') AS formatted_date
> >, CaseID.CASEID
> >, CONCAT(Party1, ' v. ', Party2) AS name
> >, Blurb
> >FROM ArgumentCalendar
> >, CaseID
> >, Parties
> >LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
> >WHERE CaseID.DocketNumber = Arg
gt; FROM
> ArgumentCalendar LEFT JOIN CaseID on CaseID.DocketNumber =
> ArgumentCalendar.Docket
> LEFT JOIN Parties.CASEID = CaseID.CASEID
> LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
> WHERE
> '20010125' <= ArgumentCalendar.Date AND
> Ca
I have a need for a SELECT query...
I don't really want any of the data from the select...
Rather I need the size of the data
basically I need
SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
-
Before posting
Hi,
I am working on an application where I need to be able to store 96 bit
numbers. As I understand it, however, the largest size that can be stored
in MySQL is 2^64 using Big Integer. Has anyone run into this problem
before? Does anyone know of an easy work around for this? Thanks!
Please CC
Scott Baker recommended the http://www.sqlcourse.com/ URL. I've just
completed an overview/review of the course and have recommended it to
several people here where I work in response to recent "How can I learn SQL"
questions.
Good reference. Many thanks.
J.T.Fowler
512-326-6371
[EMAIL PROTEC
I remember that one. It wasn't terribly helpful.
On 25 Jan 2001, at 10:19, Derek Almond wrote:
> [EMAIL PROTECTED]
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
-
Before posting, please check:
http://www.mysql.com/ma
You didn't say which operating system you are using, but I take it is
a Unix type. I had a programmer install mysql on a Redhat Linux 6.2
system, but I ran into significant bugs while attempting to install
php. I wanted to get phpMyAdmin installed, because myODBC proved
seriously unreliable fo
I asked a week ago if BDB tables had ever been tested by the MySQL team on
RedHat 7. Any ideas?
-
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone: 281-544-5092(WCK)
/ Fax:281-544-2646(WCK)
/ email: [
On Thu, Jan 25, 2001 at 12:52:11PM -0600, Gerald L. Clark wrote:
> I would suggest not having 2 cities in your firm record, and making
> fname,city your key.
>
> select * from firms order by fname,city would give you.
> A+B company Dallas
> A+B company London
> New systems Ltd New York
Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an
error during the make command.
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
mentCalendar
> , CaseID
> , Parties
>
> LEFT JOIN Preview ON Parties.CASEID = Preview.CASEID
>
>WHERE Preview.CASEID IS NULL
>AND CaseID.DocketNumber = ArgumentCalendar.Docket
>AND Parties.CASEID = CaseID.CASEID
>AND '2001012
, Parties
>LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
>WHERE CaseID.DocketNumber = ArgumentCalendar.Docket
>AND Parties.CASEID = CaseID.CASEID
>AND '20010125' <= ArgumentCalendar.Date
>
>On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote:
>
> &
This is really more of a PHP question, than it is a MySQL question
mysql_query returns an integer which is the identifier that you will use to
call other mysql functions which utilize the results from your query.
For example:
$row_count = mysql_num_rows($result) ;
...this will set $row_co
Sorry Guys + Gals,
My last message was meant for another list. Please disregard...
thanks
randy
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 2:38 PM
Cc: [EMAIL PROTECTED]
Subject: Resource id #2
When I run any kind of query this
The answer to your question depends upon depends on the nature of the text
information you are going to store:
- The length of text you want to store.
- Database size and fragmentation considerations.
- Uppercase/Lower case significance
- Indexing (prior to 3.23).
> I am trying to determine w
Karen McAdams wrote:
> Is a space between characters considered a character
> in both column types or does one handle it
> differently?
Yes, it is a char.
>
> When I use a varchar I have to define its maximum
> length. I don't have to declare max length in
> tinytext. does this make a differen
When I run any kind of query this is the value of result Resource id #2
Example
$result= mysql_query (" Select * from ACCT_TBL ") or die
("Error".mysql_error());
print result;
any ideas?
randy
-
Before posting, please chec
The socket is not running because mysqld returns : daemon ended as he wrote
;P
try either: safe_mysqld
or uninstalling: rmp -e doesn't work? maybe you installed an rpm for
another distribution (i did the same last week ;)), try to remove it via
yast (if you got SuSE). It didn't work for me, but g
Hi,
- Original Message -
From: Michael Widenius <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: Steven Roussey <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 9:28 PM
Subject: Re: parallel Mysql ?
> We plan to use the following algorithm on top of our
current
>
Hi,
I'm running linux, mysql 3.23.32 (latest stable)
I have 2 servers running a circular master-slave.
Server1 has:
log-bin=/var/lib/mysql/binary_log
master-host=
master-user=
master-password=
log-slave-updates
Server2 has:
log-bin=/var/lib/mysql/binary_log
master-host=
master-user=
master-pas
I am trying to determine when it is best to use
varchar and when it is appropriate to use tinytext. I
have looked at the manual and have read the difference
between them but would like to have an understanding
of this in more practical, real-life terms.
Is a space between characters considered a
lendar
, CaseID
, Parties
LEFT JOIN Preview ON Parties.CASEID = Preview.CASEID
WHERE Preview.CASEID IS NULL
AND CaseID.DocketNumber = ArgumentCalendar.Docket
AND Parties.CASEID = CaseID.CASEID
AND '20010125' <= ArgumentCalendar.Date
> Hi. I have a qu
lkeeton wrote:
>
> I am very frusturated as of right now. I have a mysql database that doesn't
> work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock
> file isn't there and ther server gives me this error when starting:
>
> Starting mysqld daemon with databases from /va
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> Sorry for the possible offtopic question I'm going to ask.
>
> I have got something similar (this is very simplicated situation of
> my problem but this is the core of my headache):
>
> CREATE TABLE cityname (
> id BIGINT NOT NULL AUTO_INCREMEN
LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
WHERE CaseID.DocketNumber = ArgumentCalendar.Docket
AND Parties.CASEID = CaseID.CASEID
AND '20010125' <= ArgumentCalendar.Date
On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote:
> Hi. I have a query which works and is quick, but it misses
Don't you hate it when someone just tells you to read the man files?
They seem to be written for C programmers with Unix background.
Essential System Administration from O'Reilly has a pretty good
tutorial. I just got through researching crontab to set up automatic
backup on a new tape drive.
CREATE DATABASE command is not replicated in the slave server. The database
is created on the master but not on the slave. The SQL statement does not
appear in the replication log file on the MASTER.
I have set the master to ignore replicating one database on the master. Is
this causing MySQL
Hi.
I find that 1-to-1 relationships are often useful & appropriate, and they
would help you reduce the number of columns per row.
For instance in some db of people, addresses, salary info, medical info,
&c, --although they could be jammed into one giant row per person, make
perfect sense
review.CASEID = Parties.CASEID
WHERE CaseID.DocketNumber = ArgumentCalendar.Docket
AND Parties.CASEID = CaseID.CASEID
AND '20010125' <= ArgumentCalendar.Date
The second query works correctly with the left join, but now mysql looks at
all 19000 records in Parties (according to EXPLAIN)
Sir,
What OS are you running?
What version of MySQL are you trying to install?
What RPMs are you trying to install?
- Scott
> -Original Message-
> From: lkeeton [mailto:[EMAIL PROTECTED]]
> Sent: January 25, 2001 10:56 AM
> To: [EMAIL PROTECTED]
> Subject: Uninstalling and Troubleshoo
Hi,
Sorry for the possible offtopic question I'm going to ask.
I have got something similar (this is very simplicated situation of
my problem but this is the core of my headache):
CREATE TABLE cityname (
id BIGINT NOT NULL AUTO_INCREMENT,
cname CHAR(50),
INDEX i
I am very frusturated as of right now. I have a mysql database that doesn't
work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock
file isn't there and ther server gives me this error when starting:
Starting mysqld daemon with databases from /var/lib/mysql
mysqld daemon
Well, I loaded mySQL 3.23.32 onto my RedHat 6.2, kernel 2.2.14-5.0 box, and
the installation appears to have gone well. I ran through the problem
selects in the tutorial and of course it works properly. (Tutorial steps at
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Ex
Harja Robert writes:
> I'd like to know if is possible to use Berkeley Tables under MySql Nt
> version and if the answer is YES, I'd like to know how do I install and use
> these facility!
> Thanks!
Hi!
This feature for Win32 is in the works.
Regards,
Sinisa
__ _ _
see LDIF parsing.
Derek Sivers wrote:
> I've got a quickie project here, that's over my head, that I could pay a little
>something for:
>
> Can you set up a script that will take flat text files, (one file per record, many
>files per directory) - and do some sed/regex conditional replace, and
Hi all. I had the OpenBSD problems others have reported, with slow
response, high load/cpu usage, crashes, etc. Sinisa reported a month or
so ago it was a bug in the 2.8 threading library. I wrote to the OpenBSD
developers, and they had made changes to libc_r which solved mysql
problems for ano
ALTER TABLE $old_name RENAME $new_name
Boril
- Original Message -
From: "Don" <[EMAIL PROTECTED]>
To: "msql list" <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 4:59 PM
Subject: Changing a Table name
> Hi,
>
> Is there a quick and simple way to change the name of a Table that i
Dear All
Here is a quick / obvious hack to supportfiles/mysql.server.sh to add
restart command.
I added this as I sometimes do a hard restart, and thought it may be of
use to others.
Can this be patched to the one in the source by someone with CVS rights
- it should not break anything ;-)
Gre
Hi,
I have been designing a database in a computer 'A' with MySQL, now i've
finished and i need to copy the database to the computer 'B' which is also
with MySQL.
The computers operating system is Linux Mandrake 7.2.
Where does it store the MySQL databases? , the name of the database is
'Adminis
Hi!
> "Jeremy" == Jeremy D Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Wed, Jan 24, 2001 at 10:04:36AM -0800, Steven Roussey wrote:
Jeremy> I'm not sure that this discussion belongs here anymore, so I'll set
Jeremy> the reply-to and hope the list software respects it.
>> What about scal
Of course there is...
ALTER TABLE name RENAME newname ;
Of course you can find this sort of thing in the manual of even on Quetin
Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/
Cheers,
Mikel
Don wrote:
> Hi,
>
> Is there a quick and simple way to change the name of a Tab
Woops! Sorry, but I somehow missed the version number. Yes. You could probably
shutdown the server, copy the relevant files making sure the permissions are correct
and then restart the server.
I would rather upgrade to 3.23.x though!
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> [EMAIL PROTECTE
I'd like to know if is possible to use Berkeley Tables under MySql Nt
version and if the answer is YES, I'd like to know how do I install and use
these facility!
Thanks!
-
Before posting, please check:
http://www.mysql.com/man
Hi Yuri!
When I try the following on our remote mysql server:
E:\Files\MySQL\bin\mysqldump.exe -C --host=www.diotec.com
--user=Wdiotec --password=secret --add-drop-table diotec webdistri
I get this error msg:
>
> # MySQL dump 8.11
> #
> # Host: www.diotec.comDatabase: diotec
> #
Is /usr/local/mysql/bin/ within your PATH environment? What happens when you
type the full path to the command: /usr/local/mysql/bin/mysql ?
Jonathan
- Original Message -
From: "Evan James Dembskey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 9:24 AM
Subje
Hi,
Is there a quick and simple way to change the name of a Table that is
contained within my database?
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
hi,
i've been asked to design a for a new web-based system which stores lots of data on
it's members. There are currently about 500,000 member records.
the problem is that i have to store at least 248 pieces of information on each user.
i've made the system as relational as possible so that
Ade,
Try: http://www.ocsny.com/main/index.ocs?url=osl
It should have what you need.
Cheers,
Mikel
[EMAIL PROTECTED] wrote:
> Hi,
>
> I`ve been searching for hours now so I thought I`d ask some lists I belong
> to, does anyone know of a decent CRON tutorial???
>
> TIA
> Ade
>
> --
Ade,
Try: http://www.ocsny.com/main/index.ocs?url=osl
It should have what you need.
Cheers,
Mikel
[EMAIL PROTECTED] wrote:
> Hi,
>
> I`ve been searching for hours now so I thought I`d ask some lists I belong
> to, does anyone know of a decent CRON tutorial???
>
> TIA
> Ade
>
> ---
On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote:
> What is wrong with the
>
> CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
> [(create_definition,...)]
> [table_options] [select_statement]
>
> syntax. Note that you can append a SELECT statement to a CREATE
> statement to
What is the CORRECT syntax for the mysqladmin command to start the slave
thread at a particular position in the log?
Here's the situation I ran into.
I got an error message in the slave's .err file that said the following:
010125 9:11:16 Error running query, slave aborted. Fix the problem
1 - 100 of 145 matches
Mail list logo
