Yes, The prefix path I used below is the path to the source
distribution. Should it not be?
Eric
Mohamad Ilhami wrote:
>
> On Wed, 14 Mar 2001, Eric Morgan wrote:
>
> > I configured and compiled mysql-3.23.34a without even a warning:
> >
> > ./configure --prefix=/usr/local/mysql-3.23.34a
> Is
Hello list!
The question should be simple.
Does koi8_ru stands for koi8 RUssian or is it koi8 Russian/Ukrainian.
The reason I am asking is that I remember the days when RU was used for
letter.
But it does not seem to support Ukrainian characters. I could use koi8_ukr
but I do not know if it will
I configured and compiled mysql-3.23.34a without even a warning:
./configure --prefix=/usr/local/mysql-3.23.34a
make
but when I do a make install I get errors listed below. I included the
mysqlbug output if needed below that.
I dont know what the install is trying to do here (newbie :). I have
Hello,
I have one SQL question:
I do:
SELECT geo_continents.name, geo_countries.name from geo_continents,
geo_countries WHERE geo_continents.id=geo_countries.continent;
what gives me:
+---++
| name | name |
+-
On Wed, Mar 14, 2001 at 03:44:34PM +0700, Mohamad Ilhami wrote:
>
> Hi, after a few days, mysql take too much memory and sometimes
> causing swap memory exhausts. I'm sure that only one client
> accessing mysql server, but I see too many threads. So I shutdown
> MySQL periodically. I use mysql-lar
On Wed, Mar 14, 2001 at 09:10:42AM -0800, Bryan Coon wrote:
>
> We are implementing a linux cluster, and rather than get gouged by
> oracle (in performance and licensing) would much rather use
> MySQL.
A common solution to a common problem, I suspect.
> If I understand correctly, replicatio
The "trick" is that while an autoincrement field is a nice thing to have as
a primary key, is to put a timestamp field in each MySQL table (in
addition to the primary key).
-
Before posting, please check:
http://www.mysq
One more suggestion is, using LIKE to search (whatever your column is
indexed or not) is definitely slow than using "=". I try it in 0.38 M
records before.
-Original Message-
From: Tony Shiu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 11:21 AM
To: [EMAIL PROTECTED]
Hi Hannes
Several approaches to achieve your work. One is upgrade your resource i.e.
CPU, memory... I do not take this. Another is check all columns used inside
WHERE clause whether they are indexed. If not, pls create indexes for them.
it will definitely smooth better.
Programmatically, I sugg
I want to load data to mysql.
Does mysql has any tools like sqlload in oracle?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
Please example DAO!!
ADO
When you are coding with the ADO API and MyODBC you need to put attention in some
default properties that aren't supported by the MySQL server. For example, using the
CursorLocation Property as adUseServer will return for the RecordCount Property a
result of -1. To h
I've been running Redhat 7.0 for 5 months now on my production server,
haven't had any trouble with it.
I had trouble with the rpms for 3.23.34 that were on mysql.com's download page.
The server was getting intermittent signal 11's with blown stacks. I
assume a shared library mismatch.
My gue
well, i use mysql_query as ported from libmysql.dll
function mysql_query(_mysql:pmysql;const query:
pchar):integer;stdcall;external 'libmysql.dll';
this function is supposed to return non-zero on failure and zero on succeed
( includes select/update/delete/insert/show etc.etc).
This function beh
On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote:
> We recently moved our hardware inventory database off of access (yay!)
> over to mysql. During it's days as an access database it aquired a
> numbered of duplicate entries. In every case (or at least the ones I'm
> working on) the s
Select serialNo, count(serialNo) serNoCount from table group by serialNo
order by 2 desc
This will give you a list of all the unique serial numbers in your table.
The ones with serNoCount>1 are your duplicates. Without the capability to
do subselects (yes, we all know...it's coming in the mythic
We recently moved our hardware inventory database off of access (yay!)
over to mysql. During it's days as an access database it aquired a
numbered of duplicate entries. In every case (or at least the ones I'm
working on) the serial numbers will be the same but likely all other info
will be slightl
Hi,
Here is the way I would fix that problem
(assuming you're a programmer)
write a simple function check_connection(MYSQL **conn) for example.
that will issue a query "SELECT NOW()" to mysql, if that query fails
that means connection to mySQL has gone away and the function has to
reconnects
> We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end
> system. The DAC 960 SCSI controllers proved to be fairly problematic in this
> environment. Sometimes updating the drivers helps. We have a couple of
> systems that run much better when we do not use one of the C
Since you say you're new to this stuff, let's start with the very basics.
RH7.0, I thought, was done poorly with many bugs. You can download their
latest RPM patches from their ftp server which will fix up a lot of these
bugs. With MySQL, my advice is to download the latest and greatest RPM
dir
Rolf,
i asked my college "did you use the original ini" ? "yes, i did." he said,
" i only changed some layout".
for myself i changed some parameters on this .ini file like max execution
time and max upload time, nothing more.
excuse me for not verifying further but as far as i see this php.ini
- Original Message -
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 4:05
Subject: Mysql.sock Question
> I hate to ask this question but I have tried everything. I am installed
> mysql on a new server and everything seems to be OK except i
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; "Eric Fitzgerald"
<[EMAIL PROTECTED]>; "Randy Johnson" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 18:48
Subject: Re: apostrophe
> tx Rolf!
>
> Yes, inde
"Jeremy D. Zawodny" wrote:
>
> On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> > 2- I have to design a database for all universities of my country ,
> > Is it better to consider one database for each university or one
> > database for all universities . Note that a query
I've ran into some problems when connecting to a mysql server over a
long-distance connection (i.e.: the internet). The first time a client
reconnects from a idle connection this reconnect fails, only the second time
it succeeds.
The main problem is that i've written a win32 app that connects to t
I have recently had to do something like this.
1) I have many clients who use the same set of
HTML/PHP scripts
2) Each client has a seperate database with
seperate usernames/passwords for each
database
So, i basically made a master database with client
symbol, database name, db user, db
I don't think that works across platformsits better to use
the mysqldump command.
Brian
-Original Message-
From: René Tegel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 5:09 PM
To: rozakdemir; [EMAIL PROTECTED]
Subject: Re: win to linux
use ftp to copy your database/t
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> I want to ask you :
> 1- How many rows does a mysql table can hold?
Millions. Probably billions. I've heard of someone putting 2 billion
rows in a table before (if memory serves).
> 2- I have to design a database for all uni
Hey everyone,
I just went through a new setup of Information Resource Manager scripts
under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25,
all of this stuff except the Resource Manager come standard with RedHat 7.0.
After creating the database for the set of php scrip
ahhh.. ok, I understand.. So the moral of the story is the mysql process
itself touches the local filesystem. It's NOT the UID of the person running
the command that matters, it's who the daemon is running as.
Hence the reason the help page says "this only works when running on the
same machine t
Hi,
I am a newbie... so please excuse me if the question
is a bit wacky ;-)
I was trying to write a database system using C with
embedded mysql.. could you please help me by providing
me with any links to anysites where I can get help in
the form of
1. Sample code.
2. Tutorial on how to do the
I've run into a situation where i need to split an enormous database (only say a
million rows but oh so long possibly many K)
Using JDBC and prepared statements this could be facilitated if we could have the
driver implement a setSQL(int x, "--text--") function which could replace a '?'
placeh
Hi,
But is your mysql server run by root, or, as advised, by 'mysql'?
Quentin
-Original Message-
From: Joel Caturia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 10:56 a.m.
To: Gerald L. Clark
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump Error
ah but I do.. Allow me to prov
use ftp to copy your database/table files :)
- Original Message -
From: "rozakdemir" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 10:05 PM
Subject: win to linux
Hello,
I am using MySQL on windows platform. How can I port mt datas from MySQL
server on wind
Hi,
Error 13 is permissions. Your server has to have permission to write to the
directory, and over-write any existing file of the same name.
Regards
Quentin
-Original Message-
From: Joel Caturia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 10:07 a.m.
To: [EMAIL PROTECTED]
>Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
>seems limited.
>
>Is there an HTML GUI for MySQL?
Check out MysqlTool at ...
http://dajoba.com/projects/mysqltool/
... it's a web-based interface implemented in Perl. If you prefer one
written in PHP, have a loo
> Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
> seems limited.
>
> Is there an HTML GUI for MySQL?
You could try "MysqlTool". It's a Perl program. Haven't really used it yet, but it
looks good.
Adam
--
Adam Stein @
> "JC" == Joel Caturia <[EMAIL PROTECTED]> writes:
JC> I've searched around a bit, and haven't been able to find what an
JC> errcode 13 is, so I'm out of ideas.
mysql comes with a program called perror. Run "perror 13" and see
what it has to say.
Also, what are your mysql permissions (from
ah but I do.. Allow me to prove it..
drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work
[root@fugu work]# touch this_works
[root@fugu work]# ls -la
-rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works
And, as I stated before, the Calls.sql file IS being created in this same
directory.
rozakdemir wrote:
>
> Hello,
>
> I am using MySQL on windows platform. How can I port mt datas from MySQL server on
>windows to MySQl server on Linux?
>
> Thanks for all.
You should search the sarchives and manual, this is a very FAQ...
tables extension is like .MY* you can just copy them, i
> "MW" == Mark Worsdall <[EMAIL PROTECTED]> writes:
MW> When I do this:-
MW> my $types = $sth->{TYPE};
MW> #
MW> if ($$types[0] = &Mysql::FIELD_TYPE_STRING) {
MW> print "Type is a SRING";
MW> }
Perhaps you mean
if ($$types[0] == &Mysql::FIELD_TYPE_STRING)
you are doing an assignme
Joel Caturia wrote:
>
> I'm trying to use mysqldump to dump a database (obviously).
>
> Here's the commandline I'm using:
> [root@fugu work]# mysqldump --tab=. wonderdesk
>
> mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode:
>13)
>
> The interesting thing, i
I've found that past versions of MySQL ship with a version of safe_mysqld
that reads the config file itself and only passes on a few of the parameters.
We had to rewrite our own version to allow mysqld to actually parse the stuff
on its own. Note that the my.cnf file that ships often seems to
Yes, but I'm really lazy and changing one connect string is easier than going through
200,000 lines of code and changing table names. ;)
That's a good spin on it. Thanks.
--James
---
>From your message of Wed, 14 Mar 2001 14:09:30 -0600:
>Or, you could use one database, a
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it
seems limited.
Is there an HTML GUI for MySQL?
--
Charles L. Hagen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I am using MySQL on windows platform. How can I port mt datas from MySQL server on
windows to MySQl server on Linux?
Thanks for all.
I'm trying to use mysqldump to dump a database (obviously).
Here's the commandline I'm using:
[root@fugu work]# mysqldump --tab=. wonderdesk
mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode:
13)
The interesting thing, is that is IS creating Calls.sql, but it
Nope, no luck. I double-checked the code and it is doing the SQL_BIG_TABLES
for the database handle that was created. /var/tmp has about 8gigs available
in it. I also did the --big-tables on the command line for starting up mysql
as well as bumping tmp_table_size from 1gig to 2gig, but no luck.
I
Marcus Ouimet wrote:
>
> I hate to ask this question but I have tried everything. I am installed
> mysql on a new server and everything seems to be OK except it never created
> mysql.sock? Here is how I installed it:
>
> cd mysql-3.23.29a-gamma/
> groupadd mysql
> useradd -g mysql mysql
> ./conf
In message <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes
>$sth->{TYPE} returns a reference to an array of types.
>
>$types = $sth->{TYPE}
>
>if ($$type[0] = &Mysql::FIELD_TYPE_STRING)
>
>(I don't know about the Mysql::FIELD_TYPE_STRING, but $$type[0] is the
>type of the first field.)
>
When I do
Hello again.
A few thoughts - nothing certain, and all derived from the fine manual,
which you have already read, I'm afraid:
Are you issuing the SQL_BIG_TABLES=1 in the same connected session as the
query?
Is there enough space in '/var/tmp'? However, if that was filling up, mysqld
would wait
In the last episode (Mar 14), abdelhamid bettache said:
> "In some circumstances it can be beneficial to split into two a
> table that is scanned very often" I found these sentence in the mysql
> manual , section 12.3:Get your Data as small as possible
>
> Does every body know what are th
Or, you could use one database, and lookup the clients table names, and
use a merge table for reports.
James Blackwell wrote:
>
> I have a similiar situation where I've got a huge database that maintains data for
>quite a few clients. Queries have gotten extremely sluggish.
>
> What I'm worki
I hate to ask this question but I have tried everything. I am installed
mysql on a new server and everything seems to be OK except it never created
mysql.sock? Here is how I installed it:
cd mysql-3.23.29a-gamma/
groupadd mysql
useradd -g mysql mysql
./configure --with-named-curses-libs=/usr/lib/
Yes. There are several Win32 clients such as the urSQL Utility
(www.urbanresearch.com/ursql) that can be used to access and/or maintain
MySQL databases via Windows.
On Wed, 14 Mar 2001, G&B Net wrote:
> can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
> win nt ?
> t
Wow...thanks for the quick response...
The mysql variables are:
+-+---+
| Variable_name | Value |
+-+---+
| ansi_mode | O
Hi,
The output from
mysqladmin variables
would be useful.
Quentin
-Original Message-
From: Dave Camarillo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 7:42 a.m.
To: [EMAIL PROTECTED]
Subject: Full tables...
Hello all,
I've run into a minor problem with my schema/mysql.
Dear Ruby,
Thank you very much for your earlier response! We have downloaded the
mm.mysql.jdbc driver as you have specified and placed it in the lib
directory of Tomcat server!
We tried placing the same in jdk and mysql lib directories too! Still we are
not able to connect it!
We are not clear as
is there any newsgroup or a forum that i may join?
sorry here is great but i cant handle with this maling list.
i believe a forum or a news server will be great.
thx in adv.
-
Before posting, please check:
http://www.mysq
I have a similiar situation where I've got a huge database that maintains data for
quite a few clients. Queries have gotten extremely sluggish.
What I'm working on right now is to have a control database with a single table that
contains a unique identifier for each client and a database name.
In the last episode (Mar 14), abdelhamid bettache said:
> "In some circumstances it can be beneficial to split into two a
> table that is scanned very often" I found these sentence in the mysql
> manual , section 12.3:Get your Data as small as possible
>
> Does every body know what are these
Hello all,
I've run into a minor problem with my schema/mysql. I have a table with 64
columns (varying data-types) and about 7 indexes (some multi-column indexes)
containing roughly 19 million records. Were running Solaris 2.8 on Sparc
with mysql 3.23.33 with raid-tables and large files compiled
can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
win nt ?
thank you in advance.
regards.
Andrea GIGLIOTTI
G&B Net S.n.c.
Via Bagni Caldi, 11
55021 Bagni di Lucca (LU)
Tel. 0583-805533 Fax 0583-807912
http://www.g-bnet.com
--
Hi:
I am upgrading MySql from 3.22 to 3.23 on Sun solaris box.
After download, unzip (GNU), and untar (GNUtar), I tried to configure and
run it.
It failed. Below is the message from error log.
010314 11:14:16 mysqld started
ld.so.1: /home/lu/MySql/mysql-3.23.34-sun-solaris2.7-sparc/bin/mysql
Hello Christopher,
CL> Is anybody aware of a problem when connecting Microsoft Access to MySQL
CL> 3.23 where records with AutoIncrement fields claim to be deleted after
CL> entry? Here's what I have:
Yep!
[...]
CL> autoincrement field, it will not have this problem. Is there anything I
CL
Hello ramamurthy,
rr> hi,
rr> We are using mysql as back end in our server.We are getting an problem with Mysql
.the problem is mysqld is going down wiht out any error messages.in the log file it
has writted as mysql deamon
rr> ended no other messages is thr.but we are getting problmem recentl
Hi,
I posted before but the help did not yield any success, sorry but
thanks.
Any one else help?
In message <[EMAIL PROTECTED]>, Mark Worsdall
<[EMAIL PROTECTED]> writes
>Hi,
>
>I am trying to read the field types (as well as 1 row of data and the
>field names), but I cannot seem to manage it.
Hello guys
Does anyone ever work with Macromedia Dreamweaver Ultradev 4.0 and MySQL?
I've just started a project and would like to work with MySQL on a RH6.2
box. The goal is to have UltraDev easily working on a Windows PC but
managing the data bases store on the RH box. I guess I must start by
What am I missing?
cvs login had succeded.
[martin@bart work]$ cvs -d
:pserver:[EMAIL PROTECTED]:/cvsroot/mysql co mysql-4.0
cvs server: Updating mysql-4.0
cvs [server aborted]: cannot stat /home/cvs/locks-master: No such file
or directory
cvs [server aborted]: cannot stat /home/cvs/l
Hi,
We are implementing a linux cluster, and rather than get gouged by oracle
(in performance and licensing) would much rather use MySQL. I searched
through the archives and found several references to failover and
replication but still have some questions.
If I understand correctly, repl
In section 12.2.2.1 of the manual it states that MySQL will
allow one to move a table and symbolically link it. Then MySQL
uses realpath() to find the absolute path.
I have done this and all is fine until someone does a DELETE FROM
or a ALTER TABLE . When these are done the symbolic links are
hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello Dan,
Peter> Tuesday, March 13, 2001, 6:37:16 PM, you wrote:
DN> In the last episode (Mar 13), Peter Zaitsev said:
>>> Well guys mysqldump have one serious problem - the speed.
>>>
>>> The backup speed is quite upsettin
rpm -Uhv ...
Yes bring it down or it will not upgrade properly.
You may need to upgrade Apache etc too. Need to check with your OS vendor
on this.
Charles Hagen
On Thu, 15 Mar 2001 [EMAIL PROTECTED] wrote:
> Sorry for the basic-ness of my questions, but...
>
> What's the best way to upg
"In some circumstances it can be beneficial to split into two a table that is
scanned very often"
I found these sentence in the mysql manual , section 12.3:Get your Data as small as
possible
Does every body know what are these circumstances?
__
Ge
i have a table with a FULLTEXT index that correctly matches certain words:
mysql> select title from movie where title like 'little%';
++
| title |
++
| Little Fugitive|
| Little Kidnappers, The |
| Little Mermaid, The|
|
Sorry for the basic-ness of my questions, but...
What's the best way to upgrade an RPM installation of MySQL? Can I just run
rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there
another way? Also, should I bring down the server before attempting an
upgrade? Is it likely I'll hav
Ryan,
>How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The
>examples I have seen are like:
>BEGIN;
>statement 1;
>statement 2;
>statement n;
>COMMIT;
>Does this imply that if any of the statements fail then a ROLLBACK will be
>called, otherwise it will COMMIT?
you have to
Is anybody aware of a problem when connecting Microsoft Access to MySQL
3.23 where records with AutoIncrement fields claim to be deleted after
entry? Here's what I have:
MySQL 3.23.32
MyODBC 2.50.36
Microsoft Access 2000
Some of my tables have an AutoIncrement Integer field as the primary key
I want to ask you :
1- How many rows does a mysql table can hold?
2- I have to design a database for all universities of my country , Is it better to
consider one database for each university or one database for all universities .
Note that a query on a table "student" would be more quick if I u
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
I want to ask you :
1- How many rows does a mysql table can hold?
2- I have to design a database for all universities of my country , Is it better to
consider one database for each university or one database for all universities .
Note that a query on a table "student" would be more quick if I u
Duncan Hudson wrote:
> $sth_backup = $dbh->prepare("BACKUP table ? TO ?");
You cannot embed table names or column names with the
placeholder. If you do, that will not be mapped to
BACKUP table foo
but to
BACKUP table 'foo'
which will most probably fail.
Use
p
You have provided absolutely no useful information for anyone who may
wish to help you.
ramamurthy rajeshkumar wrote:
>
> hi,
>
> We are using mysql as back end in our server.We are getting an problem with Mysql
>.the problem is mysqld is going down wiht out any error messages.in the log file
Enabled the binary log seems to have helped fix the data loss somewhat...I definetly
don't loss it all, but I still get those restarts when I shutdown and sometimes, but
now less often, I find the last few rows gone.
/etc/my.cnf
[mysqld]
user=sql
datadir=/usr/local/mysql/data
socket=/tmp/mysql
On 13.03.2001 23:37:20 Kevin Price-Ward wrote:
> > You can NOT use gcc-2.96.
Why not? Compiling works fine, without a problem - anything else that I'm
missing?
-
Before posting, please check:
http://www.mysql.com/manual.
Run isamchk on your tables.
mohamed Abd El-Samei Mohamed wrote:
>
> Dear all i need help
> i have mysql-3.22.26a over unix solairs 7
> when i try to apply query from the console to retrieve some information
> i got that error
>
> ERROR 1030: Got error 127 from table handler
>
> please help ..
Hi, I'm trying to write a Perl script that will automate the backing up of
the tables in my database. I'm building an array of the tables in the
database, using show tables, and then I step through the array with a
foreach loop. I've setup the SQL statement (to do the backup) as follows:
$
If all the data will be used by the same application then I would suggest
that you stick with a single database.
Cal
http://www.calevans.com
-Original Message-
From: abdelhamid bettache [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 8:11 AM
To: [EMAIL PROTECTED]
Subject: use
Hi,
Can anyone shed any light on this?
I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and
GNU Make version 3.79.1.
The makefiles were created using ./configure --prefix=/nipweb/mysql. No
other configure paramaters were used.
The compile keeps failing with the following e
We had similar problems with version 3.23.33. For us, the fix was to move
the errant tables to MyISAM. We did not need transaction support for those
tables. We have since moved the tables back to BDB with MySQL version
3.23.34a. The problem seems to have been resolved in this latest update.
Cedr
Hi,
you have to create an exportfile with ACCESS separated with colons for
example.
Then import this textfile in your mysql-database.
It looks like this:
LOAD DATA LOCAL INFILE "C:\\name_of_your_file.txt"
INTO TABLE name_of_your_table
FIELDS TERMINATED BY 'your_separator for example ,'
ENCLOSED
Hello,
I have to design a huge database for all the universities , is it better to consider
a database for each university or one for all universities ..
If I consider one database so I'll have one table for all students wich contain
about 30 rows .
thank you
___
Hi I'm newbie but see a PHP GuestBook in PHPBuilder.com
Bye
javier
Dear All,
Can someone recommend a PHP/MySQL script for managing membership forms using
PHP and MySQL?
I need something like a dbmanager which was available by Selena, but it was
in perl with flat text database.
In
Dear Colleague,
Easily, install myODBC on your Windows PC, then export table to the ODBC
source. To do this, in the Access DB window, select the table you want to
export, right-click on it, select save/export, choose the ODBC source. Table
is created automatically in mysql, values are exported.
Hello,
I have to design a huge database for all the universities , is it better to consider
a database for each university or one for all universities ..
If I consider one database so I'll have one table for all students wich contain
about 30 rows .
thank you
___
Hi
Does anybody know how to import MDB's into MYSql.
Thanks
Javier
At 01:23 PM 3/14/2001 +0100, René Tegel wrote:
>you chowned mysql.cnf to owner/group mysql ?
I hadn't, but mysql is reading some other options properly from my
/etc/my.cnf file.
Actually, I did some more searching and I found this command:
/usr/libexec/mysqld --print-defaults
It seems to show
you chowned mysql.cnf to owner/group mysql ?
- Original Message -
From: "Bill Marrs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 1:16 PM
Subject: setting simple mysqld options in /etc/my.cnf
> Hi,
>
> I like to run mysqld with these 3 options:
>
> --log-s
Hi,
I like to run mysqld with these 3 options:
--log-slow-queries
--delay-key-write-for-all-tables
--skip-networking
But, so far, I've been unable to get mysqld to read them out of /etc/my.cnf.
Here's what's inside my /etc/my.cnf:
[mysql.server]
log-slow-queries
delay-key-write-for-all-tables
I've ran into some problems when connecting to a mysql server over a
long-distance connection (i.e.: the internet). The first time a client
reconnects from a idle connection this reconnect fails, only the second time
it succeeds.
The main problem is that i've written a win32 app that connects to t
Hello Dan,
Tuesday, March 13, 2001, 6:37:16 PM, you wrote:
DN> In the last episode (Mar 13), Peter Zaitsev said:
>> Well guys mysqldump have one serious problem - the speed.
>>
>> The backup speed is quite upsetting and loads system much, but the
>> worst thing is recovery speed.
>> In my case
1 - 100 of 109 matches
Mail list logo
