mysql < your_script.sql
or
cat your_script.sql | mysql
This assumes you have your username and password set up in your my.cnf or
.my.cnf (home directory). If not, add the -u[username] -p[password]
switches.
--jeff
- Original Message -
> From: "Chetan Lavti" <[EMAIL PROTECTED]>
> To: <
hi,
I have written a script for database creation and table creation. Now I
want to run this script from the MySQL prompt. How can I do this..?
Please , anybody know about this , so that I can create my database by
simply running that script.
Thanks and regards,
Chetan Lavti
-
hi,
I have written a script for database creation and table creation. Now I
want to run this script from the MySQL prompt. How can I do this..?
Please , anybody know about this , so that I can create my database by
simply running that script.
Thanks and regards,
Chetan Lavti
-
Hello every one...
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buffe
Hello every one...
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buffe
Hello every one...
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buffe
Hello every one...
We are going into making the final changes to our production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buffe
I am brand new to MySQL, and trying to get up to speed as fast as possible.
I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
using VB6 and ADO in combination with MyODBC to connect to a database I have
already created. However, I keep getting the following message:
I am brand new to MySQL, and trying to get up to speed as fast as possible.
I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
using VB6 and ADO in combination with MyODBC to connect to a database I have
already created. However, I keep getting the following message:
I am brand new to MySQL, and trying to get up to speed as fast as possible.
I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
using VB6 and ADO in combination with MyODBC to connect to a database I have
already created. However, I keep getting the following message:
At 21:48 22/02/02 -0800, vijay khanna wrote:
Hi!
>Hiya forum..
>
>I have my site powered by MySQL server running on
>FreeBSD.
>The site is facing problems when the traffic
>increases.Database connectivity is through JDBC.My
>poolman is managing the
>database connections with 30 connections set, an
> So i issue the following commands:
>
> c:\> cd mysql\bin
>
> start the serverc:\>mysqld
That would start the server.
> set the variablec:\>mysqld -O back_log=200 --help
That doesn't set the variable. It just shows what the variables would be
like if you had started mysqld with
Hiya forum..
I have my site powered by MySQL server running on
FreeBSD.
The site is facing problems when the traffic
increases.Database connectivity is through JDBC.My
poolman is managing the
database connections with 30 connections set, and is
growable.People have started getting error when t
On Sat, 23 Feb 2002, Jon Shorie wrote:
> I am working on a perl application that manages a database created in Mysql.
> I am having trouble with the delete statement. Here is a portion of the
> perl code
> that is being executed:
>
> $dbh=DBI->connect("dbi:mysql:clientdb:localhost","web","web
At 06:18 AM 2/23/2002 +0100, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the enti
I am working on a perl application that manages a database created in Mysql.
I am having trouble with the delete statement. Here is a portion of the
perl code
that is being executed:
$dbh=DBI->connect("dbi:mysql:clientdb:localhost","web","webpassword");
###
# Delete Routine
Hello, MySQL users,
We have discovered several issues with our 3.23.49 x86 Linux binary, and will
be releasing 3.23.49a as soon as they are resolved. This time we will do a
more thorough testing before the release takes place. If somebody wants to
help us test 3.23.49a Linux binary before it i
I suggest you install a MySQL Database on a local machine and do
development there. When you want to push this stuff to the remote
machine use mysqldump to pull the contents out of the local database. I
don't think it would be appropriate for this but you might consider
database replication if y
I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20).
The MySQL-shared-3.23.49-1.i386.rpm package does not install since
it's compiled using GLIBC 2.2.
I've tried to build binary packages from MySQL-3.23.49-1.src.rpm
as suggested. The compilation fails:
[..snip...]
creating libmysqlclient
Hi,
> -Original Message-
> From: Bill Adams [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 22, 2002 2:04 PM
> To: MyODBC Mailing List; MySQL List
> Subject: RE: MySQL + Access + MyODBC + LARGE Tables
>
>
> All, there were many emails posted about this on the MyODBC list which,
> o
Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a
remote hosting server, and I have only limited access to the database at
that server. I want to populate my database off-line at my home machine, and
then upload the whole thing (100s of lengthy entries) to the server.
This should probably be on the main MySQL list.
I think I'd use the one minute load average from the servers (assuming
they were all on the same OS/version), and cache it for a minute (you
don't want your pings to add to the load). That is, if you don't need <
1minute resolution. The load is a go
Hmmm. Wonder if this would be why MySQL-Max failed to install on my new
Penguin Computing server... It's running RH7.1
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 5:32
Hi all,
The latest rpms for mysql 3.23.49 produce a signal 4 error when
attempting to run the installed mysql server.
on all our servers running redhat 7 thru 7.2.
Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x.
I've tried multiple installs now with no success on any of ou
Actually, upgrading the kernel is /not/ hard. Simply follow the
instructions in the INSTALL file inside the tarball. Many people have a
fear of doing this, but if you read the instructions, and know your
machine, it's a simple matter.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
Joedilson,
the syntax for specifying a password to mysqladmin is
--password=my_password, or -p if you want it to prompt. (Notice that it
says, "Using password: NO" .. thats because it doesn't realize you're
trying to use a password).
You also need to specify the password when you're using mysql
Try www.mysql.com/doc
www.php.net/manual/en/ref.mysql.php
Warren Stringham
-Original Message-
From: Luie [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 5:04 PM
To: [EMAIL PROTECTED]
Subject: quick reference guide
hello all,
anybody know where to find a quick reference gui
On Friday 22 February 2002 5:03 pm, Luie wrote:
> hello all,
>
> anybody know where to find a quick reference guide for mysql
> commands/functions?
If you are looking for an SQL quick reference guide, check out SQL Instant
Reference (2nd Edition) by Martin Gruber, published by Sybex. Very good
>Description:
The new POSIX standard is now official (IEEE Std 1003.1-2001),
and it has removed support for some obsolete utility options
that mysql uses in a few places. Basically, the new POSIX
has removed digit-string options (e.g., "tail -1") and options
hello all,
anybody know where to find a quick reference guide for mysql commands/functions?
TIA,
luie
__
www.edsamail.com
-
Before posting, please check:
http://www.mysql.com/manual.php (t
On Sat, Feb 23, 2002 at 12:39:43AM +0100, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to
apologies for the sorry mail formatting...the whole link should be
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
l#Post-installation
> -Original Message-
> From: Gregory Junker
> Sent: Friday, February 22, 2002 6:22 PM
> To: Joedilson B. Azevedo; [EMAIL PROTEC
Hello SqlFolk ;
I'm trying to install mysql the latest version of mysql (client,
server, devel, bench, shared)
on Red Hat Linux 7.0 (kernel = 2.2.16-22). After downloading the
RPMs, I get a signal
4 error on the server install and notice complaints concerning
threads. Perusing the my
did you follow the instructions in the link below?
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
l#Post-installation
> -Original Message-
> From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 22, 2002 6:08 PM
> To: [EMAIL PROTECTED]
I posted a problem I was having with this, but unfortunately nobody
responded. Regardless, here are the methods I've used:
1) using LOAD_FILE():
INSERT INTO table_name (column_name)
VALUES(LOAD_FILE('/absolute/path/to/file'));
In windows, of course, the path to the file should p
Hi, I installed the BD mysql and I am some problems.
# /usr/local/mysql/bin/safe_mysqld &
It's ok.
Here:
# mysqladmin password my_password
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
And when I
Hi Alastair,
Yip somebody pointed me towards the address from the returned mail ;-p. Now
for the answers to your questions:
1. I did create a user and a group for mysql by using:
shell> chown -R root /usr/local/mysql
shell> chown -R mysql /usr/local/mysql/data
shell> chgrp -R m
On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote:
> I posted a question but received a message stating the file was to large?
>
Look at the message. Some idiot's mailbox is over the limit. Anytime I
post to this list I get 2 return mails bounced from lusers.
With regards to yo
Can I have different indexes on the tables in my master and slave? I
want to use the slave strictly for reporting and the master for inserts, so
I'd like to index the crap out of the slave and leave the master relatively
index free.
Will that work?
Thanks,
--jeff
P.S. -- how 'bout adding some w
I need to store large files in a MySQL database (in Windows). To do
this, I have created a table that has a BLOB column. How can I insert
the files into this table?
Thanks,
Ron
-
Before posting, please check:
http
All, there were many emails posted about this on the MyODBC list which,
of course, can be viewed via the archive on the mysql.com site. For the
most part I will neither quote nor repeat the information from those
emails here.
The conclusion is that MySQL + Merge Tables is perfectly capable of
b
Hi all,
I try to compile ezmlm with mysql see what I have got with the compilation
phase :
www:~/qmailnco# rpm --rebuild --clean --target i686
ezmlm-idx-mysql-0.53.324-4md
k.src.rpm
here it crashs
./load ezmlm-gate subdb.a getconf.o slurpclose.o slurp.o \
getopt.a getln.a auto_bin.o env.
I posted a question but received a message stating the file was to large?
G
(mysql, query)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Sorry to double post to the list. Is there anybody out there using SuSE7.3
with the downloadable 4.0.1 max version of mysql? I truly want to start
exploring mysql but I cannot get it to run (see below for first post).
Thanks in advance for any advice
G
Hi,
I am running SuSE 7.3 Professional
Anyone seen this before?
"Server configuration denies access to data source"
I'm using the mm.mysql driver and attempting to connect from my java
classes with the ip of the server (from the server) as root.
The server itself only has two users, root & mysql.
_
"The troub
Hi All,
Let's say I'm creating an affiliate program to track surfer clicks to sales.
I have a question on indexing that's always bothered me. I'm hoping an index
guru can help me out. Here's an example click-recording table:
CREATE TABLE clicks (
clickID int unsigned NOT NULL auto_increment,
Yes, but how to get ONLY the 3 records you need ?
Because often in an application, you don't care about the other records.
In this case AFAIK, there is no other solution than issuing at least two
queries :
SELECT * FROM table WHERE field<='ID00025' ORDER BY field DESC LIMIT 2
SELECT * FROM table
Yes, but how to get ONLY the 3 records you need ?
Because often in an application, you don't care about the other records.
In this case AFAIK, there is no other solution than issuing at least two
queries :
SELECT * FROM table WHERE field<='ID00025' ORDER BY field DESC LIMIT 2
SELECT * FROM table
> It seems worst to me because in your case mysql has to retrieve all the
> rows. If it's a table with 1 million records or more, this should hurt ;)
As I said, it was pseudo code. Now, imagine that you were just
getting the records for a particular user? a particular application?
Where there w
Hi,
It seems worst to me because in your case mysql has to retrieve all the
rows.
If it's a table with 1 million records or more, this should hurt ;)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Raymond Gubala" <[EMAIL PROTECTED
Hi,
Yes, just write :
perror 124
>perror 124
>Error code 124: Wrong medium type
>124 = Wrong index given to function
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Christian M. Stamgren" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 11
> Is there a list off MySQL error-codes avalible?
> Something like Oracle's oerr. program?
perror
> We are having trouble with one of our MySQL databases. The error is:
>
> "Got error 124 from table handler."
chris@entropy:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index g
What does this quote from the manual mean:
"If you do not have any GRANT statements done, MySQL will optimise the
permission checking somewhat. So if you have a very high volume it may be
worth the time to avoid grants. Otherwise more permission check results in a
larger overhead."
By not having
At 13:13 -0600 2/22/02, Craig Westerman wrote:
>I have a table that has following fields
>
>id (auto increment)
>date
>appleprice
>orangeprice
>pearprice
>
>When I try to LOAD DATA INFILE with this file using comma as field delimiter
>and newline as end of row
You need to add the column list:
.
One thing that has always puzzled me is how poeple are
gaurding against duplication in columns where people's
names are stored.
For example this table has a persons's first and last name.
Stars:
starID
starFirstName
starLastName
1
Vanna
White
2
Bob
Marley
problems begin to arise
You need to specify the columns you're loading, if they aren't all the
columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice)
at the end of your LOAD DATA INFILE statement.
As for only loading one row, I'd guess your input file line endings don'
http://www.mysql.com/doc/J/O/JOIN.html says that "INNER JOIN and , (comma)
are semantically equivalent. Both do a full join between the tables used.
Normally, you specify how the tables should be linked in the WHERE
condition."
So you could use this instead:
SELECT FORUMCAT1.LASTPOST, USERS.USER
You cannot do nested JOINs. Try:
INNER JOIN FORUMCAT1 ON USERS.ID = FORUMMSG1.AUTHORID
INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER
-Original Message-
From: Mat Murdock [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: Re:
I have a table that has following fields
id (auto increment)
date
appleprice
orangeprice
pearprice
When I try to LOAD DATA INFILE with this file using comma as field delimiter
and newline as end of row
"2000-01-04","281.08","5.27","430.05"
"2000-01-05","280.06","5.14","421.98"
"2000-01-06","279
Ok, so I updated the statement like the past few posts have directed so the
statement looks like this:
SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC,
FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS
FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUM
Each slave can only have one master. If you want to have one box be a
slave to multiple masters, you have to set up a mysqld for each master
on the slave box, each with a different port and socket.
Now, if this is on Linux, you also can't have the multiple servers share
data on this one box, si
From: Mat Murdock <[EMAIL PROTECTED]>
> ... Like "*java*"
Try:
Like "%java%"
I would bet the the aseriscs are some non-SQL extention of MS Access.
---
Rodney Broom
Programmer: Desert.Net
-
Before posting, please check:
I have this query that works just fine in msacess agains some linked mysql
tables, but if I run this statement in php or in mysqlfront it doesn't work.
I belive it's because there is two joins in it but i'm not sure. If that is
the problem then what is the work around? Here is the statement:
SE
DoH!
I'm bein a moron here :)
Guy, thanx :)
On Fri, 22 Feb 2002, havoc wrote:
> Date: Fri, 22 Feb 2002 12:32:10 -0600 (CST)
> From: havoc <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Running Without TCP Port
>
> Just for my clarification, "--skip-networking" will disable TCP/IP,
Just for my clarification, "--skip-networking" will disable TCP/IP, but
still allow mysqld to use a unix socket as specified by "--socket=PATH",
correct?
On 22 Feb 2002, Guy Davis wrote:
> Date: 22 Feb 2002 11:28:35 -0700
> From: Guy Davis <[EMAIL PROTECTED]>
> To: havoc <[EMAIL PROTECTED]>
>
On Fri, 2002-02-22 at 11:09, havoc wrote:
> Is it possible to run mysqld without binding to a TCP port?
> As in run using only unix sockets?
Start with --skip-networking:
http://www.mysql.com/doc/C/o/Command-line_options.html
or put skip-networking into your my.cnf file.
--
Guy Davis
Hello good people,
Okay I don't mean to offend anyone. I'm a newbie but I have managed to do
courier-imap-authmysql today.
I can add/remove/changepasswd for users comfortably. Command line is no problem.
However, this is a bit slow and I was wondering if anyone out there already invented
the GUI
* Roger Baklund
> It is even possible to do this with one select statement and four
> left joins to the same table, but it is a bit complicated:
>
> select table.*,next.id as next,prev.id as prev
> from table
> left join table as prev on
> prev.id < table.id
> left join table as prev2 on
Is it possible to run mysqld without binding to a TCP port?
As in run using only unix sockets?
- Jonathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Fromt the mysql.com site: http://www.mysql.com/doc/I/S/ISAM.html
for all the limits.. Remember that your files sizes may be smaller
because of your OS.
On Fri, 22 Feb 2002, Brian Warn wrote:
> Date: Fri, 22 Feb 2002 09:11:07 -0800
> From: Brian Warn <[EMAIL PROTECTED]>
> To: 'Gurhan Ozen' <[E
You, like me, are using 3.22 which does not have the myisam table type
(or others for that matter). ISAM I believe, has a lower limit. They do
support sizes less that 4GB (up to the OS file size limits). The three
file extentions total do constitute the total table size, but I believe
that e
That's pretty strange in this situation, we have three slaves being updated
from the master, the other two are moving along just fine.
This one however can't seem to get past these "duplicate entries". I tried
skip_counter=2 and got a different duplicate entry, the possition moving
forward
again.
On Fri, Feb 22, 2002 at 08:46:37AM -0800, Tim Allwine wrote:
>
> So it appears there is a maximum of 32 keys (indexes) that can be
> created on a table. Is there any way to increase this? If so how?
I seem to remember it being a simple soure code change. Check the
mail archives (if you haven't
I did see that reference, but found that myisamchk wasn't an option
either. I did find isamchk is available and have been seeing what
information it is able to provide. I'm wondering now whether summing
the table.ISD, table.ISM, and table.frm filesizes that I get from a
simple ls -l output will
Hello all.
I'm using Debian 2.4.x
I was trying to upgrade mysql.3.22 to 23 by removing default packages and
after debianizeing rpm's with alien I installed them with dpkg.
After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared
Do someone know how to properly upgrade 22 to 23
Quoted from http://www.mysql.com/doc/T/a/Table_size.html is:
"By default, MySQL tables have a maximum size of about 4G. You can check the
maximum table size for a table with the SHOW TABLE STATUS command or with
the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. "
Gurhan
-Original
Luc,
The problem is that in the replication somewhere an update was taken twice.
Adjust the skip to according to the position of the duplicate entry. I have had to
skip 100 before in order to get the slave started.
First check the binary log and see how many insert statements aft
So it appears there is a maximum of 32 keys (indexes) that can be
created on a table. Is there any way to increase this? If so how?
-Tim
sql,query??
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
As show table status doesn't appear to be supported in this older version
I'm using, how did you who used this version get max table size information?
I haven't been to find anything from the list archives/manual about this.
Brian
sql,query
---
Chad, this did not work. Though it did do something, the Position jumped
ahead
mysql> show slave status\G
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
thx
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 7:30 AM
Subject: mysql error
>
> theOtherOne,
>
> Saturday, February 23, 2002, 1:52:20 AM, you wrote:
> t> Hi,
>
> t> I've got this problem when i try to connect to a
The solution I have been using is to do three queries similar to the below
SELECT * FROM table WHERE field='ID00025'
SELECT * FROM table WHERE field<'ID00025' ORDER BY field DESC LIMIT 0,1
SELECT * FROM table WHERE field>'ID00025' ORDER BY field ASC LIMIT 0,1
If you whish more row returned cha
* Mark Lo
> Row 10ID00010need this value
> Row 11ID00025have this value on hand
> Row 12ID00063need this value
>
> The questions is how do I find out the values in Row 10 and Row 12, if and
> only if I only have one data that is "ID00025" (select * from table where
> field=
At 04:38 PM 2/21/2002 , you wrote:
>At 22:15 + 2/21/02, DL Neil wrote:
>> >MySQL by Paul DuBoise
>>>
>>>Paul monitors this mailing list, so if you have questions concerning what
>>>you've read, he may answer.
>>
>>You added an "e" to my name deliberately just to see if I'd reply,
>>didn't you
> The solution I have been using is to do three queries similar to the below
> SELECT * FROM table WHERE field='ID00025'
> SELECT * FROM table WHERE field<'ID00025' ORDER BY field DESC LIMIT 0,1
> SELECT * FROM table WHERE field>'ID00025' ORDER BY field ASC LIMIT 0,1
> If you whish more row return
On Sat, 2002-02-23 at 01:52, theOtherOne wrote:
> Hi,
>
> I've got this problem when i try to connect to a mysql server with a PHP
> code
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/tmp/mysql.sock' (111)
[mle@hal9000 data]$ perror 111
Error code
Thank you for your very detailed reply. This was my understanding of it too.
I guess I was hoping that I had missed something!
Do you know when will this happen? (I hate to ask but since I know I will be
asked this, I feel I should ask you. My crystal ball is broken!)
Is it going to be in 4.x? O
Hi,
Does anybody know how to copy an existing mySQL table schema with varchar datatype
my sql statement is:
CREATE TABLE new_table AS SELECT * FROM old_table where 1=0;
All the text columns in the old_table are in VARCHAR datatype, however,
after I copy to a new_table, all columns change to CH
theOtherOne,
Saturday, February 23, 2002, 1:52:20 AM, you wrote:
t> Hi,
t> I've got this problem when i try to connect to a mysql server with a PHP
t> code
t> Warning: MySQL Connection Failed: Can't connect to local MySQL server
t> through socket '/tmp/mysql.sock' (111)
It means that you are u
On Friday 22 February 2002 00:03, Colin Dewey wrote:
This is an example of a class of problem that crops up in a lot of
applications, like GIS systems all the time.
Unfortunately B-Tree type indexes, like RDBMS systems generally use are just
not well adapted to this type of query. I know Infor
Chris,
Friday, February 22, 2002, 3:51:39 PM, you wrote:
CG> Hello
CG> I would like to know how to use different languages in different tables (one
CG> language/character set per table). The idea being users can view web page
CG> data in their own language. Some of this content will need to be s
> How do I find out a next and preview row values by using PHP and MYSQL. For
> examples,
Take a look at the function
mysql_result();
Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Dear All,
I am using PHP + MYSQL. I have a question that I need some expert
to help. That is:
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063
Dear All,
I am using PHP + MYSQL. I have a question that I need some expert
to help. That is:
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063
It can be done. The slave server needs to hold mutiple slave databases corresponding
to the masters. Each slave instance needs to be start separately. For example, each
database wil need it's own my.cnf file holding with port the master is connecting to.
I have seen this done with full dat
Hi,
I've got this problem when i try to connect to a mysql server with a PHP
code
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
hope you can help me
regards
theotherone
---
query
Is it possible to set one SLAVE to handle two or multiple MASTERS???
For example if I want to replicate one table from one MASTER and
second table from another.
Thanx a lot
-
Before posting, please check:
http://www.my
My vote is have the 'mySQL Cookbook' get out the door first, give Paul a
quick respite, and then put his nose to the grind stone for 'mySQL version
4'. 8-)
-Original Message-
From: Anthony W. Marino [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 7:30 AM
To: Simon Green; [EMAIL
Can anyone point me to a comparison of +'s and -'s with each Transaction
enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote:
> Hi Alec,
>
> On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
> > > Is there a timeline/status for 4.x functionality available?
> > > I would like to use MySQL 4.x, however, I'm looking for some of the
> > > highly requested functional
1 - 100 of 127 matches
Mail list logo
