Schalk Neethling wrote:
Have you tried DBDesigner4 by fabForce?
I'm working with it at the moment. As far as I see, it doesn't
work on Mac and unfortunately DBDesigner manages to trash my
foreign keys definitions from time to time.
Regards,
A.
--
MySQL General Mailing List
For list archives:
for 12 units @
US$14 ~ US$16.
Order quantity must be atleast USD$5000++.
IT company to IT company.
*/
Mulley, Nikhil wrote:
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to Index them ,
can anybosy help me on this please
I am starting out a Online Photo
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to Index them ,
can anybosy help me on this please
I am starting out a Online Photo Gallery and want to share them , and I want to
make the search available, Does anybody has already done
, Nikhil [mailto:[EMAIL PROTECTED]
Sent: 02 November 2004 05:05
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: How can I store Images in the MySQL Database
Hi Lists ,
My Query is How Can I store Images in the MySQL Database , and how to
Index them , can anybosy help me
Hello,
You might try MySQL's inbuilt replication feature.
If you want a more simple approach, might take a look
at SQLyog's Data Sync Wizard. More information can be
found at http://www.webyog.com
I think they have a article on the same subject in
SitePoint. You might google it.
Karam
---
: synchronizing mysql database in two diferrent places
Hello,
You might try MySQL's inbuilt replication feature.
If you want a more simple approach, might take a look
at SQLyog's Data Sync Wizard. More information can be
found at http://www.webyog.com
I think they have a article on the same
Hi.
MySQL replication currently does not support any locking protocol between master and
slave to guarantee the atomicity of a distributed (cross-server) update.
See:
http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
Eko Budiharto [EMAIL PROTECTED] wrote:
Hi,
I a facing a
Hi,
I a facing a situation where I have two database server in two different
places that has exactly the same database. The thing is if the database
is modified in either one of the places, both database has to be updated
lively.
Can someone tell me who done this already? Please help.
I am
David,
- Alkuperäinen viesti -
Lähettäjä: David Griffiths [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Tuesday, October 19, 2004 9:33 PM
Aihe: Re: MySQL Database Corruption (InnoDB), according to Innodb Hot Backup
No worries about
..
From: David Griffiths ([EMAIL PROTECTED])
Subject: MySQL Database Corruption (InnoDB), according to Innodb Hot Backup
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-09-30 12:23:37 PST
I went to do some work on our database
locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http://www.mysql.com/support/index.html
..
From: David Griffiths ([EMAIL PROTECTED])
Subject: MySQL Database
Do MYsql require something similiar to compacting a database in Access ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I went to do some work on our database last night (dropping large
indexes, which can be time consuming). I checked to ensure that the
backup of that evening had run, but noticed that the size of the backup
was too small compared to previous days (I'm kicking myself for not
emailing the results
I could write the statement for you if you could answer these three
things:
1) which user account would you like to modify the permissions of.
2) which database are you granting access to
3) what permissions do you want the user account of 1) to have on the
database of 2)
Respectfully,
Shawn
If you do not use the GRANT, REVOKE, and DROP USER statements to create
and destroy user accounts, you must manually FLUSH PRIVILEGES. It's all
documented in the manual:
http://dev.mysql.com/doc/mysql/en/GRANT.html
and in even more detail here:
Greetings All,
A seemingly strange problem.
If I go to the mysql prompt on a linux server - mysql version 3.23.14-alpha.
I can issue the command create database .
I can then issue the command use .
No problem.
However, if I type use mysql for the mysql database.
If I do
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a free
floating database that nobody (except root) has permission to access
until you issue the grant statements to make someone own it. But
nobody actually owns
Hi, all:
I use root login to create a new databse in the existing server.
Then I use the existing user name in the mysql user table as user name,
add the database and username .. info into mysql db table. Then
mysqladmin to load the table. When I login the database using the
existing user
--- [EMAIL PROTECTED] wrote:
I posted this a little while ago, but it faded out
with very few responses
due to my not posting the necessary information, so
I seek to rectify my err
now.
Info:
OS: Windows XP
PHP: 5
Use: I'm looking for something that can easily
create and manage
I posted this a little while ago, but it faded out with very few responses
due to my not posting the necessary information, so I seek to rectify my err
now.
Info:
OS: Windows XP
PHP: 5
Use: I'm looking for something that can easily create and manage databases,
doing stuff like creating and
Take a look at SQLyog ( http://www.webyog.com )
Karam
--- [EMAIL PROTECTED] wrote:
I posted this a little while ago, but it faded out
with very few responses
due to my not posting the necessary information, so
I seek to rectify my err
now.
Info:
OS: Windows XP
PHP: 5
Use: I'm
I am using MySQL 4.1.3 and wondering if there is any way to get binary log, and
general log location by querying database.
I've checked
mysql show variables;
command, but it only returns if log is ON or OFF.
Thanks,
Aleksandar
-
Do you
RRD (http://www.rrdtool.org) is a popular tool which sysadmins use to
collect to network stats (among other things)
One of the best thing about RRD is that it only stores X datapoints at
any one time, and also aggregates simple stats about the data, making it
self-archiving. I was wondering if
Good morning,
I need a MySQL database to be able to query a table in an Oracle database of
a remote host.
Is this possible? Could anybody tell me how to do it or where to find this
information?
Thanks in advance,
--Claudio
..
You may want to look into using a programming language such as C or Java
that communicates between both databases.
-Original Message-
From: Alonso, Claudio Fabian
To: '[EMAIL PROTECTED]'
Sent: 7/7/04 8:14 AM
Subject: How to query an oracle table from a mysql database
Importance: High
8:14 AM
Subject: How to query an oracle table from a mysql database
Importance: High
Good morning,
I need a MySQL database to be able to query a table in an Oracle
database of
a remote host.
Is this possible? Could anybody tell me how to do it or where to find
this
information?
Thanks in advance
PROTECTED]
CC: ''[EMAIL PROTECTED]' ' [EMAIL PROTECTED]
Subject: Re: How to query an oracle table from a mysql database
Date: Wed, 07 Jul 2004 17:02:59 +0100
MIME-Version: 1.0
Received: from lists.mysql.com ([213.136.52.31]) by mc6-f16.hotmail.com
with Microsoft SMTPSVC(5.0.2195.6713); Wed, 7 Jul 2004 09
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could see
PHP has problems with Oracle 9.2.0. I got a conection problem and found in
the PHP's bug database that it isn't currently working.
As I'm familiar with PHP/MySQL, I'm
No, that isn't possible using mySQL.
Try linking PHP with older client libraries (9.0.1,
8.1.5, etc) instead of the newer 9.2 libraries and see
if that fixes your problem with PHP. You can download
them from otn.oracle.com
swany
--- Alonso, Claudio Fabian
[EMAIL PROTECTED] wrote:
Hello
At 13:18 -0300 7/7/04, Alonso, Claudio Fabian wrote:
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could see
PHP has problems with Oracle 9.2.0. I got a conection problem and found in
the PHP's bug database that it isn't
: RE: How to query an oracle table from a mysql database
Importance: High
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could
see
PHP has problems with Oracle 9.2.0. I got a conection problem and found
in
the PHP's bug database
Fabian '; ''Steve Davies' '
CC: '''[EMAIL PROTECTED]' ' '
Asunto: RE: How to query an oracle table from a mysql database
A custom MySQL UDF is one solution if you are comfortable with C.
Off list question:
What sort of `problem` does PHP have with Oracle 9i that is prohibiting you?
-Original
Hi all,
Please, do NOT send messages to a public mailinglist
as high priority by flagging the email itself. You're
sending this message to hundreds/thousands of people.
It might be important to you, but not for each
recipient. If someone has filters/triggers for important
email, he will get
Im confused and obviously missing something really
fundamental here
I would appreciate it if you could glance at my code for the
above. Basically Im trying to write information to the database now I
have managed to resolve the connection issue.
Its the Data Capture section thats
You're missing a closing at the end of your sql on the last line
which may be throwing up an error.
Cheers,
Matt
On 2 Jul 2004, at 15:05, Michael Mason wrote:
Write.txt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
It's the Data Capture section that's causing issues. I keep getting an
error telling me there's an Unexpected $ on a line that's actually
outside
even the HTML tag.
You forgot to end the $sql = .. with a closing quote. The line now ends
with ); while you probably want it to be );
BTW it's
Michael, you're missing a quote just before the last semi-colon. PB
- Original Message -
From:
Michael Mason
To: 'MySQL Mailing List'
Sent: Friday, July 02, 2004 9:05 AM
Subject: Writing to an MySQL
Database
Im confused and obviously missing
something
On Fri, 2004-07-02 at 09:05, Michael Mason wrote:
Its the Data Capture section thats causing issues. I keep getting
an error telling me theres an Unexpected $ on a line thats
actually outside even the HTML tag.
Errors like unexpected $ that are output by a code or statement parser
are
Hi all,
I wish to restore an sql file in a mysql database though VB. One way of
doing it is writing the Create Database command and the mysql restore
command 'mysql -options sql_file' in a batch file and executing it.
Is there any other better way of doing it?
Btw, I try to make an ADO
\. is the MySQL CLI/monitor SOURCE command.
read your file in one statement at a time and execute it (search for
unquoted/unescaped ;'s at the end of the statements)
--On Monday, June 14, 2004 11:32 +0530 Nawal Lodha [EMAIL PROTECTED]
wrote:
Hi all,
I wish to restore an sql file in a mysql
Loftis [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 2:53 PM
To: Nawal Lodha; [EMAIL PROTECTED]
Subject: Re: How to Restore MySQL Database from VB?
\. is the MySQL CLI/monitor SOURCE command.
read your file in one statement at a time and execute it (search for
unquoted/unescaped ;'s
I need some help connecting to my database remotely, I would really
appreciate any input.
Setup:
MySQL Server:
OS: Linux - Debian
MySQL version: 4.0.18
Internal IP: 192.168.1.101
Remote Access PC:
OS: Windows XP
MySQL: 4.0.20
Internal IP: 192.168.1.100
I am trying to connect from 192.168.1.100
Aswad
To: [EMAIL PROTECTED]
Sent: 6/2/04 12:45 PM
Subject: Help With Remotely Connecting to MySQL Database
I need some help connecting to my database remotely, I would really
appreciate any input.
Setup:
MySQL Server:
OS: Linux - Debian
MySQL version: 4.0.18
Internal IP: 192.168.1.101
Remote Access
Fred Aswad wrote:
I need some help connecting to my database remotely, I would really
appreciate any input.
Setup:
MySQL Server:
OS: Linux - Debian
MySQL version: 4.0.18
Internal IP: 192.168.1.101
Remote Access PC:
OS: Windows XP
MySQL: 4.0.20
Internal IP: 192.168.1.100
I am trying to connect
MySQL Listers,
I already asked this question on phpBB's own forums, but no one
seems inclined to answer me. I'm hoping there might be more charitable
souls here on this list.
My question is that I want use phpBB because I am satisfied with
it's overall functionality and usability.
Hi Dave,
I thought one thing I could do is try and find the table that
stores phpBB's usernames and passwords, and extend those to include the
user data that I have already. But I know enough to know that it is
unlikely to be as simple as that. For example, I thought I read
somewhere that
Phpbb uses an md5 hash to store the passwords. You can use the mysql md5
function or php's to encrypt them. To verify md5 the supplied password
and match against the table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jigal,
I know that phpBB has a few converter scripts
I think the converter scripts are for a different issue. I don't have a
previous BBS system that I want to convert from. All I have is user
profile information stored in a simple MySQL database that I built
myself. The users are subscribed
Hi,
I want to store a .txt file in a table in a MySQL database, typically what
is the best type of data type/ column to use for this. The .txt will not
exceed 100K.
Thanks
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
joe collins [EMAIL PROTECTED] wrote:
I want to store a .txt file in a table in a MySQL database, typically what
is the best type of data type/ column to use for this. The .txt will not
exceed 100K.
You need MEDIUMTEXT/MEDIUMBLOB column types:
http://dev.mysql.com/doc/mysql/en/BLOB.html
At 22:39 -0400 4/16/04, Robert A. Rosenberg wrote:
I am talking a PHP+MySQL course at my local community college and
since this is the first time the course is being offered there are
some teething problems with the curriculum. I am posting this query
at the request of the instructor.
We are
I am talking a PHP+MySQL course at my local community college and
since this is the first time the course is being offered there are
some teething problems with the curriculum. I am posting this query
at the request of the instructor.
We are using a Linux Server and each Student has their own
database backup.
Li, Lenny Yong Bo (Lenny) wrote:
Now I am assigned to do the backup of a whole mysql
database (version: 3.23.36). I want to make sure whether the
following procedures are correct for database backup.
1. mysqldump -F --opt database_name database_name.backup
In my
on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED]
wrote:
1. database backup.
This is done on the standby one with the following command.
mysqldump --opt --quote-names --flush-logs database_name database.backup
How does this operations handle binary fields, password
On 02/25/2004 09:13 AM Frederic Wenzel wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name database_name.backup
In my opinion, you
Li, Lenny Yong Bo (Lenny) wrote:
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name database_name.backup
In my opinion, you should
]
Sent: Wednesday, February 25, 2004 4:13 PM
To: Li, Lenny Yong Bo (Lenny)
Cc: [EMAIL PROTECTED]
Subject: Re: A question about mysql database backup.
Li, Lenny Yong Bo (Lenny) wrote:
Now I am assigned to do the backup of a whole mysql
database (version: 3.23.36). I want to make sure
Ms./Sir,
Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I
want to make sure whether the following procedures are correct for database backup.
1. mysqldump -F --opt database_name database_name.backup
2. stop mysqld if is running. Then start it with --log-bin
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly
Thanks for checking this out. However, with InnoDB tables you only get
the .frm files under a database directory and these are only modified
when you change the definition of a table. The data itself is kept in a
big binary file(s) one directory up, whose modification time cannot be
used to deduce
Hi,
I have many smallish, discrete MySQL databases, each of which I would
like to backup individually (mysqldump seems fine for this). However,
there's no point re-backing up a database that has not changed since the
last time it was backed up. So how can I tell if when a MySQL database
was last
. So how can I tell if when a MySQL database
was last modified, so that I can decide whether to run mysqldump on it
again or not? Any help with this would be much appreciated.
Thanks,
Phil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm not 100% sure on this, but what about the .myd file timestamp?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:09 AM
To: Phil
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Add
for this). However,
there's no point re-backing up a database that has not changed since the
last time it was backed up. So how can I tell if when a MySQL database
was last modified, so that I can decide whether to run mysqldump on it
again or not? Any help with this would be much appreciated.
Thanks
timestamp?
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 9:09 AM
To: Phil
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Add a timestamp field to each table.
Phil wrote
PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Thanks. But I would have thought that such information would have been
kept automatically
[EMAIL PROTECTED] wrote: -
To: gerald_clark [EMAIL PROTECTED]
From: Phil [EMAIL PROTECTED]
Date: 02/06/2004 09:27AM
cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
Thanks. But I would have thought that such information would have been
kept
Sorry. Obviously didn't see this...
-Phil [EMAIL PROTECTED] wrote: -
To: Dan Greene [EMAIL PROTECTED]
From: Phil [EMAIL PROTECTED]
Date: 02/06/2004 09:36AM
cc: gerald_clark [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: How to determine when a MySQL database was last modified
do the extra work and risk
not having backups?
Evelyn
-Original Message-
From: Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last
-Original Message-
From: Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL
database was last modified?
Thanks. But I would have thought
the most recent
backup online I don't see the harm. Why do the
extra work and risk not having backups?
Evelyn
-Original Message-
From: Phil [mailto:[EMAIL PROTECTED]
Sent: Fri 2/6/2004 9:27 AM
To: gerald_clark
Cc: [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL
database
; [EMAIL PROTECTED]
Subject: Re: How to determine when a MySQL database was last modified?
mysqlshow gives the same results as SHOW TABLE STATUS, which,
unfortunately, doesn't seem to give created/updated dates for InnoDB
tables.
Michael
Gowtham Jayaram wrote:
If offline tools works for you try
: Re: How to determine when a MySQL database was last modified?
mysqlshow gives the same results as SHOW TABLE STATUS, which,
unfortunately, doesn't seem to give created/updated dates for InnoDB
tables.
Michael
Gowtham Jayaram wrote:
If offline tools works for you try './mysqlshow.exe
On Fri, Feb 06, 2004 at 09:17:32AM -0500, Dan Greene wrote:
I'm not 100% sure on this, but what about the .myd file timestamp?
Well, it depends on which table type, obvously. There are several
files for each database, see what the mtime is on each of them, to
determine what's a live file.
If
On 06-Feb-2004 Phil wrote:
Thanks. But I would have thought that such information would have
been
kept automatically somewhere by the server, and it's just a case of
how
to get at it. I have quite a few tables in each database so I don't
really want to have to maintain a timestamp on each
Doesn't seem to change the mtime on table files. It appears that for
InnoDB tables these files are only updated when the definition of a
table is changed. The content of the all InnoDB tables is kept in one or
two massive files directly under the 'data' directory!
On Fri, 2004-02-06 at 18:13,
Hello,
I am trying to copy the mysql database to a new MySQL server. I have
tried the mysql dump method:
dump data into a file mysql2.sql
move file to the new server
execute:
mysql -u root -p -e source mysql2.sql mysql -on the new server
I
Try using the actual MySQL dump command
mysqldump --Bdatabase --tablesoptional -uusername --opt -ppassword -hhost |
mysql -uusername -ppassword -hhost
Original Message
On 2/5/04, 10:46:21 AM, UpFront Technology [EMAIL PROTECTED]
wrote regarding migrating mysql database:
Hello,
I
Which version of PHP would be good for Red hat 7.3? can someone send URL from where I
can download the php pl?
Jochem van Dieten [EMAIL PROTECTED] wrote:Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
You can find a number of good starting point data
models here:
http://www.databaseanswers.com/data_models
You might also check out some of the applications on
sites like www.hotscripts.com and www.sourceforge.net
to see how they have structured their database for
similar projects. (or maybe you
Hi,
I'm new to this group.I would like to know which frontend tools be good tuned with
Mysql database like php,perl etc?
I want to develop one application on linux on mysql database which eventually would be
webbased.Please suggest what combination would be good.
thx
-Seena
Hi,
I'm new to this group.I would like to know which frontend tools be good tuned with
Mysql database like php,perl etc?
I want to develop one application on linux on mysql database which eventually would be
webbased.Please suggest what combination would be good.
thx
-Seena
or Java crowds. Perhaps I
should sign this with an assumed name?
/Alfred E. Neuman/
Seena Blace wrote:
Hi,
I'm new to this group.I would like to know which frontend tools be good tuned with Mysql database like php,perl etc?
I want to develop one application on linux on mysql database which
roused the VB or Java crowds. Perhaps I
should sign this with an assumed name?
/Alfred E. Neuman/
Seena Blace wrote:
Hi,
I'm new to this group.I would like to know which frontend tools be
good tuned with Mysql database like php,perl etc?
I want to develop one application on linux on mysql
Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/PostgreSQL ;-)
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives:
Lynch 'im!!!
:-)
On Wed, 21 Jan 2004 13:33, Jochem van Dieten wrote;
Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/PostgreSQL ;-)
Jochem
--
I don't get it
immigrants
To those who want to try out a live MySQL on the Net can use the
following from NAVICAT. You can choose client tool of your choice! Get
more information about it on NAVICAT website: www.navicat.com
IP/Server: server1.navicat.com
User: navicat
Password:navicatdemo
Port:
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as the same
Steve Folly wrote:
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as
On 10 Jan 2004, at 17:47, Michael Stassen wrote:
Eg. if you've two host entries; one '192.%' and the other '192.168.%'
- and you connect from 192.168.100.12, which row gets chosen?
As I understand it, 192.168.% is more specific than 192.%, so
192.168.100.12 would match 192.168.%
My thoughts
I am less than 24 hours new to MySql. I have executed the following sql
scripts:
use mysql;
delete from user where User='';
delete from db where User='';
flush privileges;
select host, user, password from user;
The last sql query yields the following:
hostuserpassword
Station 32003
Atlanta GA 30332
Cell: +404.429.5513
http://www.arjunweb.com
-Original Message-
From: Leo Donahue [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 2:47 PM
To: [EMAIL PROTECTED]
Subject: mysql database, user table, two root accounts
I am less than 24 hours new to MySql
Yes, this helps thank you.
-Original Message-
From: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What that means
, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privileges for root connecting from any
I have a folder with all of the files from a database that the server shot craps
(database is used for phpBB). I now have another server up and running with phpBB
setup and a database with the same name.
My question is, is there any way to merge the information into the new database? We
had
10.1.10.12
Dec 3 15:02:00 172.30.1.49 8238:
Dec 3 15:01:59.589 BO: %SNMP-3-AUTHFAIL:Authentication failure for
SNMP req from host 10.1.10.12
I`d like to get some suggestion over
how can I to load these text file to a MySql database automatically.
Thank you for your help.
EDWIN LIMACHI N.
DATACOM
PROTECTED]
Sent: Thursday, December 04, 2003 1:42 AM
Subject: How to pass syslog data to a MySql Database?
Dear list:
I`m running a syslogd into my Linux box for logging all event send from our Cisco
routers, these event are logged in text format, for instance:
Dec 3 15:01:36
[EMAIL PROTECTED] wrote:
Dear list:
I`m running a syslogd into my Linux box for logging all event send
from our Cisco routers, these event are logged in text format, for
instance:
snipped
I`d like to get some suggestion over how can I to load these text file
to a MySql database automatically
I have a table members in the MySQL database. I am
going to supply a String editor and search the
members table. All those who are editor will be
picked up and their name will enter the array I want
to create.
How do I code it and return this array?
Here is a sketch of my code. I do not have
201 - 300 of 726 matches
Mail list logo