Thanks, worked nicely.
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 14:52
+1000 6/8/03, JeRRy wrote:
> >Hi,
> >
> >I have a text file with all my database information
> to
> >create databases to setting up tables. I have
> looked
> >throught the mysql docs onto how to load these on
> from
> >
Yep...figured that out.
Thank You
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 6:48 PM
Subject: Re: Can't insert data from Apache/PHP
> That points to a fault in your coding because phpMyAdmin *is* PHP running
vi
At 14:52 +1000 6/8/03, JeRRy wrote:
Hi,
I have a text file with all my database information to
create databases to setting up tables. I have looked
throught the mysql docs onto how to load these on from
the mysql prompt. But all I can find is:
load data infile "filename.txt" into table whatever
Greetings
I have MySQL 4.0.13 installed on WinXP machine. From
the DOCS I read that support for SSL is provided with
MySQL 4.x. The doc says that I need to install the
library from openssl.org ( which I did ) and then
configure mysql with --with-vio and --with-openssl?
Does it mean that I have co
Greetings
If you are on Windows then you can try out SQLyog at
http://www.webyog.com/sqlyog . It has GUI interface
for many ways to import data in MySQL whether CSV, SQL
Batch file etc.
Karam
--- JeRRy <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a text file with all my database information
> to
I installed the version 4.1.0-alpha of mysql in
Windows XP. At the beginning and in general everything
works very well. But I have a problem of
incompatibility (I guess). When users are created with
passwords, those users cannot be connected. Mysql
says: "Client don't support the authentication
pro
I am having a nightmare of a time getting a single transaction across
multiple tables to work in Borland's Kylix3 with MySQL. It appears that
the Borland driver is saying that the MySQL database only supports a
single active statement per connection.
When I issue an explicit begin
Hi,
I have a text file with all my database information to
create databases to setting up tables. I have looked
throught the mysql docs onto how to load these on from
the mysql prompt. But all I can find is:
load data infile "filename.txt" into table whatever
But this is not what I am looking
What you want is usually coded into your application. Pick your language
and have fun. :-) Sorting is done via the query that you use against
your db.
Curtis
On Fri, 6 Jun 2003, David Blomstrom wrote:
> I joined this list some time ago, but I still haven't had time to really
> start learn
On Fri, 6 Jun 2003, Bruce Feist wrote:
> Heikki Tuuri wrote:
>
> >InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of
> >x86 Assembler.
> >
> >
> Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms.
It does. I'm sure the x86 assembler is replace
That points to a fault in your coding because phpMyAdmin *is* PHP running via
the web server.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "ComCity" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 07 June, 2003 21:09
Subject: More: Can't i
It looks like I can insert data through phpMyadmin without issue. The only
place I can't insert data is through PHP running via the web server.
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 07, 2003 5:03 PM
Subject: Can't insert data from Apache/PHP
> I've had to reinstall Linux/Apache and mySQL
I want to be able to get all table names in a database and all the
column names and associated data type from a particular table. I wonder
how to do that in MySQl. I understand I can use "show tables" to see the
table info, but I want to be able to do 'select' in order to get the
results back. I wa
I've had to reinstall Linux/Apache and mySQL. The databases are restored,
the data looks to be there, the permissions look to be there. However, I
can't seem "INSERT" data into the tablesits the only thing I can't
do...and I don't see a problem with the permissions. Don't get any errors
on t
> chances are they wouln't upgrade until 4.0 has been in use a while.
Version 4.0.1 has been out since December 2001. Tell them that and you just
might luck out.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Try running a phpinfo() page. This might tell you if some of your settings are
a bit off. Also, check your permissions on the remote DB. Lack of them is a
common issue.
FWIW, you might have better luck with this on the PHP-DB list. You can
subscribe by sending a message to the address below.
[
On Sat, 7 Jun 2003 15:33 , Paul DuBois <[EMAIL PROTECTED]> sent:
>
>This is a problem that is fixed in MySQL 4. If you can upgrade, that
>should help you a lot.
>
>http://www.mysql.com/doc/en/News-4.0.0.html
>
That explains that. I was relying on the online docs and it didn't even
occur to me
I hope this is the correct place to ask for help on this matter. Please
bear with me for not using the correct terms and for over-explaining.
THE BAD: I am having an incredible amount of trouble getting php scripts
to populate the mysql database ROWS within tables created by the
scripts.
THE GOO
At 22:29 +0200 6/7/03, <[EMAIL PROTECTED]> wrote:
Hello everyone,
I'm working with MySQL 3.23.41-log developing a chat application. I
need to run a query, order the results in
descending order, then get the last 0-15 entries that are less than
20 minutes old. The query and tables in question
a
Hello everyone,
I'm working with MySQL 3.23.41-log developing a chat application. I need to run a
query, order the results in
descending order, then get the last 0-15 entries that are less than 20 minutes old.
The query and tables in question
are explained at the bottom of this posting. In
Thank you Bruce and Paul,
Your explanation help clear a lot of doubts.
So If i create another two tables, let say INVOICE2
and LINEITEM2 with the same construct, when i specify
the index for the foreign key and referenced key,
MYSQL will create a separate index for these two
tables even i only use
At 11:40 -0700 6/7/03, Titu Kim wrote:
Hi,
I have search the mailing list about the
explanation for foreign key in Innodb. I also search
goole groups. I have the following doubts.
1. From the documentation i read about the following.
===
Both tables
Titu Kim wrote:
1. From the documentation i read about the following.
===
Both tables have to be InnoDB type and there must be
an index where the foreign key and the referenced key
are listed as the FIRST columns.
===
Hi,
I have search the mailing list about the
explanation for foreign key in Innodb. I also search
goole groups. I have the following doubts.
1. From the documentation i read about the following.
===
Both tables have to be InnoDB type and there mus
At 10:27 -0700 6/3/03, Dylan Pham wrote:
Hi,
I am new and am wodering if anyone can point out how
to make AUTO_INCREMENT readjust the numbers so that
when you delete a row it will go back to using the
next number after the last row in the table?
If you're new, you may be thinking that there is some
Dingfelder Andy schrieb:
Hi,
I?ve forgot to say, that i?m a newbie to linux.
So, what do you want to say, with these lines?
That the 'mysql' user is not a shell user?
yes
i am no expert too
a daemon should run as a unprivileged user, if possible
# ps auxw | less
for this you need an account
t
Have You deleted or updated te my.cnf file?
It seems to me that MySql is looking in the wrong dir or it dosn't
have permision in data dir ( user mysql.mysql rw permission).
Santino
At 16:46 +0100 7-06-2003, David Leader wrote:
First could I apologize for joining a mailing list primarily to ask
First could I apologize for joining a mailing list primarily to ask
for help. However I am not a professional Unix or MySQL manager and
am supporting an installation to allow Masters students in
Bioinformatics to do summer projects. Last year I managed to install
v. 3.23 of MySQL on a Sun box r
The linking table adds more flexibility at the cost of complexity. In this
case, I see absolutely no reason for it as it only serves to muck up your data.
As Jeff mentioned, a linking table is great for many->many relationships, but
otherwise it's just a pain.
Edward Dudlik
Becoming Digital
www.b
Hi,
I?ve forgot to say, that i?m a newbie to linux.
So, what do you want to say, with these lines?
That the 'mysql' user is not a shell user?
Greetz
Andy
> -Ursprungliche Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 6. Juni 2003 17:01
> An: [EMAIL PR
script this <[EMAIL PROTECTED]> wrote:
> Anyone know if there is an option in mysql 4.0 to turn
> off foreign key checks at the db level rather than
> session level?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://w
Hi
Im running mysql 4.0.12-embedded, a simple query - 'show proceslist'; returns an
empty set ? Is this a bug ?
thx
G
hi
you can reset the counter yourself with the following sql statement
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
best regards
benny
- Original Message -
From: "Dylan Pham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 7:27 PM
Subject: AUTO_INCREMENT
> Hi,
>
The InnoDB manual (below) doesn't mention it. Why not try and let us know?
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "san" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 06 June, 200
Stefan,
> That will set the communication buffer to a maximum of 16 MB, but Brad
> wants more than that ...
I know. I was offering the notation, not the exact number. I thought it was
implied, but I often take my implications for granted.
> protocol limits for max_allowed_packet is 16M in MySQ
Brad, Edward,
> Try using 'max_allowed_packet=16M' instead of your current value. You may also
> find help by reviewing the below.
> http://www.mysql.com/doc/en/Packet_too_large.html
That will set the communication buffer to a maximum of 16 MB, but Brad
wants more than that ... From the manual:
36 matches
Mail list logo
