David Griffiths >> Look at the documentation regarding the users table in
the mysql database.
Thx David, but I wasn't asking about limiting access to a database, but
rather how to set things up so that users at a branch office can have
read/write access to a database located at the main office.
Chip Wiegand wrote:
John,
Yep, looking at phpinfo.php shows no support for mysql. This is very
strange. I know these things don't just happen by themselves. I also know
there are only two people with the password to the server, myself and my
boss (and he knows nothing about the server to begin
Victor Pendleton wrote:
The `INTO OUTFILE` clause is expecting a table reference. An alternatvie is
mysql -uuser -N -e"select now()" > sample2.txt
-Original Message-
From: Yingyos
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 5/4/04 2:20 AM
Subject: Export query to text file
Hi,
I have M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
Can I create a user that can create and drop his database while at the same
time can not drop databases that are not belong to him?
How do I set this priviledge?
TIA,
- --
Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org
09
At 19:08 -0600 5/4/04, Andrew Loughe wrote:
Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip
the files, and presto! I have exac
Are you dropping then recreating the tables and data, or just doing a
diff between what's on the backup and what's in the zip file and
updating the difference?
I've been doing a drop on the tables and recreating them and it seems to
work ok.
> -Original Message-
> From:
> [EMAIL PROTECTE
Hello,
MySQL version: 3.23.58
Each week I make a hotcopy of numerous database files.
I tar them and gzip them, and move them to an archive machine.
I then use a second machine to read from the archive, untar and ungzip
the files, and presto! I have exact copies of my databases running on
a backup
Is there a way to create a GRANT for a DB so that only one user can
access to the database? The only way I can see to do it involves taking
every user and GRANT them access to every other database, but not this
one.
The problem I face is that I share a server with three friends, and we
all create
Ah!!
I was tripped up by the fact that things were fine when I was doing an
ADO "recordset.addnew, recordset!Fieldname = variable",
recordset.Update" kind of approach. Switching to an INSERT query, and
sure enough the backslashes need a little escape.
Don't we all need a little escape every n
Hum. I've never tried inserting without the field names.
> Serves me right to type this stuff instead of copying/pasting - my
> previous post was indeed wrong but also wasn't the exact code I used
> (yours was, with the single quote embedded in the doubles).
>
> It's been a very dyslexic week for
In the last episode (May 04), Steve Pugh said:
> Hello all, once again! Can anyone tell me why the following takes
> place? In my VB app I am adding records to the table "Jobs" with
> this code (trimmed way down - my actual INSERT statement populates
> about 20 fields):
>
> sqlstr = "INSERT INTO
Serves me right to type this stuff instead of copying/pasting - my
previous post was indeed wrong but also wasn't the exact code I used
(yours was, with the single quote embedded in the doubles).
It's been a very dyslexic week for me.
On your previous response regarding field names and case sen
How about: (I reversed on set of quotes)
sqlstr = "INSERT INTO Jobs VALUES('" & txtSceneFile & "')"
> Err...what I meant to say here was "ascii code equivalent (chr(39)" (I
> tried single *and* double quotes). Sorry about that.
>
> Steve Pugh wrote:
>
>> Hi Daniel,
>>
>> I tried that to no avai
Check the table sturcture for required fields and EXACT field names.
mysql is case sensitive.
> I tried that to no avail (I had actually had the code set initially to
> use single quotes thusly:
>
> sqlstr = "INSERT INTO Jobs VALUES("' & _
> txtSceneFile & "')"
>
> but it generated the
Err...what I meant to say here was "ascii code equivalent (chr(39)" (I
tried single *and* double quotes). Sorry about that.
Steve Pugh wrote:
Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT INTO Jobs VALUES("' & _
Hi Daniel,
I tried that to no avail (I had actually had the code set initially to
use single quotes thusly:
sqlstr = "INSERT INTO Jobs VALUES("' & _
txtSceneFile & "')"
but it generated the same erroneous string. Using the ascii-code
equivalent (Chr(34) does the same.
It's just so
I think you want chr(39) (single quote).
> Every time I think I've got it, I am reminded thatI don't got it.
>
> Hello all, once again! Can anyone tell me why the following takes
> place? In my VB app I am adding records to the table "Jobs" with this
> code (trimmed way down - my actual INS
Every time I think I've got it, I am reminded thatI don't got it.
Hello all, once again! Can anyone tell me why the following takes
place? In my VB app I am adding records to the table "Jobs" with this
code (trimmed way down - my actual INSERT statement populates about 20
fields):
sqlstr
>From the docs: "If there are random insertions into or deletions from the indexes of
>a table, the indexes may become fragmented."
How can I go about determining if my indexes are, in fact, fragmented?
Thanks,
Lou
>From the docs, it says:
"You can use innodb_tablespace_monitor to check the integrity of the file space
management inside the tablespace files. "
Does this mean that it is part of the SHOW INNODB STATUS command or is this something
separate?
Thanks,
Lou
I am wondering what the best backup strategy is for my database.
The database is used to store a very large number of binary files,
ranging from a few K to 20MB's. The database stores thousands of these
files. I can not put this data on the file server, it needs to be in
the database.
Curren
Hello.
I have installed MySql on RH Linux, however since I have installed in the
wrong location I would like to uninstall.
Basically I have installed the binary version from the
"mysql-standard-4.0.18-pc-linux-i686.tar.gz" and
I have followed the instructions in the INSTALL-BINARY, in partic
On Tue, May 04, 2004 at 12:36:19PM -0700, Max Clark wrote:
>
> Can't create a new thread (errno 35). If you are not out of
> available memory, you can consult the manual for a possible
> OS-dependent bug
>
> I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux
> Threads. I am running la
Can't create a new thread (errno 35). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
I am running FreeBSD 4.9 with Mysql 4.0.18 compiled with Linux Threads.
I am running large inbound concurrency on Postfix which is forking
several processes.
Mike Johnson wrote:
From: Eve Atley [mailto:[EMAIL PROTECTED]
Hi. I had a MySQL DB set up and recently added a field
'order' to allow for exceptions in a web site menu
heirarchy. Fields should be ordered by 'order' field
first where it does not contain 'NULL', and then by
field 'title'. I had
I think the problem was that the binary was indeed probably incompatible
with my libraries/kernel. I installed an IBM supplied version and it seems to
work OK now, albeit with some strange warning messages from time to time.
I would have prefered using an x86 platform myself, but we had all these
[EMAIL PROTECTED] wrote:
Hi folks!
I have diffrent linux-machines running with the great mysqld.
But on some machines I have 20 running threads on some other only 2
threads.
If only 2 threads are running is that not bad for fast sql-results?
I have about 500 v-hosts and many sql-queries on my mac
Paul Sue wrote:
Hi,
I downloaded mysql-3.23.35.0 for AIX 4.3 from bullfreeware.com and as I soon
as I start mysqld, it starts consuming almost all the CPU (hovers around 97%).
Any idea what might be the cause of this??
Paul:
I assume this happens with no or minimal server activity. If yes, the
That did the trick! SO many thanks
Niels Riis Kristensen
([EMAIL PROTECTED])
NRK Group
- Electronic Music Engraving
- Dynamic Web design
- E-Lists hosting
---
Send money safely over the Internet!
Click this link for more information:
https://www.paypal.com/refer/pal=EAJLSE5TQELFC
On 4/5-200
At 10:39 -0400 5/4/04, Lou Olsten wrote:
This is not a question, rather just some information I wanted to
post in case someone else hits it and searches the lists.
I do a lot of straight command line connecting using the mysql.exe
client for windows. Aside from my other challenges with getting
You can also use the `old-passwords` option in the my.cnf file.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 5/4/04 1:09 PM
Subject: Re: 4.0 mysql client vs 4.1 installation
This is not a question, rather just some information I wanted to post in
case someone e
This is not a question, rather just some information I wanted to post in
case someone else hits it and searches the lists.
I do a lot of straight command line connecting using the mysql.exe client
for windows. Aside from my other challenges with getting users set up
properly, I ran into another
Nils,
At 05:30 PM 5/4/04 +0100, you wrote:
Basically the best guess would be the documentation that comes with your
download. Note that online documents at www.mysql.com are always a mixture of
several documentation versions really.
Thats the problem. Yesterday, I downloaded 4.0.1x yet the docu
Niels Riis Kristensen wrote:
I backed up my data with CC-cloner without the boot feature - - - -yeah
I know!
So I have the directory with the data in them, in the form of .frm, .MYD
and -MYI files, but when I try to acces the data I get the error message:
Can't find file: './vault/data.frm' (e
Thanks Paul. But that my query doesn't violate any of
these conditions. Here is more detail:
mysql> show status like "%qcache%";
+-+---+
| Variable_name | Value |
+-+---+
| Qcache_queries_in_cache | 0 |
| Qcache
You need to change permissions on the files
-Original Message-
From: Niels Riis Kristensen
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 5/4/04 12:11 PM
Subject: Stupid Mistake - update [Was: Stupid mistake]
I backed up my data with CC-cloner without the boot feature - - - -yeah
I kno
I backed up my data with CC-cloner without the boot feature - - - -yeah I know!
So I have the directory with the data in them, in the form of .frm, .MYD and -MYI files, but when I try to acces the data I get the error messege:
Can't find file: './vault/data.frm' (errno: 13)
Error
SQL-query :
Hi folks!
I have diffrent linux-machines running with the great mysqld.
But on some machines I have 20 running threads on some other only 2
threads.
If only 2 threads are running is that not bad for fast sql-results?
I have about 500 v-hosts and many sql-queries on my machine.
Does somebody kno
>$result_insert = @mysql_query ($query_insert) or die("you suck! $mysql_error");
Try mysql_error() instead of $mysql_error.
- seb
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi David,
(B
(BYou may find my UC-2004 presentation useful as well as some UC-2003
(Bpresentations from Mr. Gulutzan and Mr. Barkov:
(B
(Bwww.be-known-online.com/mysql
(Bmysql.planetmirror.com/Downloads/Presentations/MySQL-User-Conference-2003/National-Character-Sets-and-Unicode.pdf
(B
(BB
Gabriel,
First of all, sorry for my poor english (I´m just a brazilian guy - eu
quase não sei falar o portugues, imaginem o ingles então.)
Tucker, Gabriel wrote:
Luciano
I am confused... As far as I can tell, the set foreign_key_checks=0; is used with the
load data infile command. I am not us
In the last episode (May 04), Jim said:
> Do changes in database structure replicate to the slaves from the
> master? Is there a document somewhere in the manual (I have not
> found one) that explains what gets replicated and what does not?
> Specifically, does an ALTER TABLE get replicated? The
Hooray!
The last problem was b/c I did not have the same InnoDB settings in my cnf file.
Again, thank you all for your time in this matter!
Gabe
-Original Message-
From: [EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 11:29 AM
To: Victoria Reznichenko; [EMAIL PROTECTED]
Subject: RE: Inno
Victoria
That seemed to work well, thank you.
However, I received another error that I am not sure how to troubleshoot during the
restore:
ERROR 1114 at line 83 in file: '/bb/bin/mysql/backups/archive_4320.sql': The
table 'cur_reject_tk_sum' is full
What can I do here?
Thanks -
On Tue, 4 May 2004 11:01:59 -0400
"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Luciano
>
> I am confused... As far as I can tell, the set
> foreign_key_checks=0; is used with the load data infile command.
Actually, I think that it is used for all operations on the DBMS, not just load data
Hi List,
Do changes in database structure replicate to the slaves from the master? Is
there a document somewhere in the manual (I have not found one) that explains
what gets replicated and what does not? Specifically, does an ALTER TABLE
get replicated? There is some mention that replication
Victoria ,
Thank-you.
At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote:
David Jourard <[EMAIL PROTECTED]> wrote:
>
> I got the 4.0.17 documentation but when it discusses character sets it
> discusses this topic wrt 4.1
>
> Where can I find documentation specifically in regards to the product
Oooops - I sent that last email before I read this one, please disregard.
This appears that it will solve my problem. I will give it a try.
Thanks for all that replied!
Gabe
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:35 AM
To:
Your first problem is the order not having backticks you have to do
ORDER BY `order`, title or you'll get a sql error.
But the other thing you'll run into is that null evaluates to les than any
int, meaning the null rows will come before your numbered rows, however you
can't just switch to
ORD
Luciano
I am confused... As far as I can tell, the set foreign_key_checks=0; is used with the
load data infile command. I am not using this command to restore the database. The
mysqldump command creates a file with the data and schema. I restore it to a new
instance that just has the mysql
"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Marvin
>
> I believe that is the problem with the restore. When I create the =
> archive file using the mysqldump command and options previously listed, =
> I get the create table in the order listed below and thus, the foreign =
> key constraint is
From: Eve Atley [mailto:[EMAIL PROTECTED]
> Hi. I had a MySQL DB set up and recently added a field
> 'order' to allow for exceptions in a web site menu
> heirarchy. Fields should be ordered by 'order' field
> first where it does not contain 'NULL', and then by
> field 'title'. I had this previ
Hi Guy's,
first: Your are correct it is contraints:
bash-2.05a$ perror 150
Error code 150: Unknown error: 150
150 = Foreign key constraint is incorrectly formed
Second you could also try:
set foreign_key_check=0;
at the beginning of the restore file.
set foreign_key_check=1;
at the end!
Best
This is not a question, rather just some information I wanted to post in case someone
else hits it and searches the lists.
I do a lot of straight command line connecting using the mysql.exe client for windows.
Aside from my other challenges with getting users set up properly, I ran into another
On Tue, 4 May 2004 09:46:27 -0400
"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Hello All:
>
> I am having a problem with both V4.0.16 and 4.0.18. Let me explain:
>
> I have a database with two InnoDB tables in v4.0.16. I backup up
> this database every night using the following command:
>
>
Hi,
I don't think mysqldump takes foreign key constraints into account when
dumping them.
You could specify the tables that you want when you dump so you get the
correct order.
e.g.
mysqldump --allow-keywords --host=$HOST --flush-logs --disable-keys --opt
--port=$1 --socket=/bb/bin/mysql/sock
Marvin
I believe that is the problem with the restore. When I create the archive file using
the mysqldump command and options previously listed, I get the create table in the
order listed below and thus, the foreign key constraint is created on table
cur_reject_tk_sum before the object_type ta
Hi,
Are you creating them in the correct order ?
object_type must exist before you can create cur_reject_tk_sum otherwise the
foreign key will give errors.
Marvin
-Original Message-
From: Tucker, Gabriel [mailto:[EMAIL PROTECTED]
Sent: 04 May 2004 14:46
To: Mysql General (E-mail)
Subje
Hello All:
I am having a problem with both V4.0.16 and 4.0.18. Let me explain:
I have a database with two InnoDB tables in v4.0.16. I backup up this database every
night using the following command:
mysqldump --allow-keywords --host=$HOST --flush-logs --disable-keys --opt
--port=$1 -
The `INTO OUTFILE` clause is expecting a table reference. An alternatvie is
mysql -uuser -N -e"select now()" > sample2.txt
-Original Message-
From: Yingyos
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 5/4/04 2:20 AM
Subject: Export query to text file
Hi,
I have MySQL 4.0.17 on Windows
Which query log are you referring to? The user and the host are both logged
in the slow query and general logs.
-Original Message-
From: Lou Olsten
To: [EMAIL PROTECTED]
Sent: 5/3/04 4:59 PM
Subject: Query Log
I'm pretty sure that the answer to this is "No, you cannot" but I
figured I'd c
Are you looking for an interface to read MS Access other than the default
application and MS Query?
-Original Message-
From: Nik Belajcic
To: [EMAIL PROTECTED]
Sent: 5/3/04 9:52 PM
Subject: Reading MS Access tables from MySQL or Perl
Hello,
This is partially off-topic as I am looking at
David Jourard <[EMAIL PROTECTED]> wrote:
>
> I got the 4.0.17 documentation but when it discusses character sets it
> discusses this topic wrt 4.1
>
> Where can I find documentation specifically in regards to the production
> version on how to work with, store, and search asian character sets
Hi there,
Does someone have a MySQL 5.0.x current source build
available for the Win32 platform?
I'm not able to build it myself, but I would like to give the
stored procedures (db specific, not the current MySQL
5.0 Alpha stuff) a try and make Database Workbench
MySQL 5.0 ready...
With regards,
Look at the documentation regarding the users table in the mysql database.
You can specify an ip address (or subset of an ip address) on which users
are allowed to connect; others are rejected, via the hosts column.
IE if you specify 192.168.1.%, any user on the 192.168.1 portion of the
network (
Niels Riis Kristensen <[EMAIL PROTECTED]> wrote:
>
> I have made an horrendous stupid mistake. In migrating from OSX 10.3 to
> OSX Server 10.3 I backed up all the data, but forgot to dump my sql
> databases. I have the data, but simply copy paste into the relevant
> directories doesn't work.
>
"Lou Olsten" <[EMAIL PROTECTED]> wrote:
> I'm pretty sure that the answer to this is "No, you cannot" but I figured I'd check
> anyway...
> As I go back through my query log, I'd like to know the user that issued the
> statement.
> If the user is still connected, I can cross reference it with th
Great! Thanks for the quick pointer!
ken
Quoting Diana Soares <[EMAIL PROTECTED]>:
> You may use MERGE TABLES:
>
> http://dev.mysql.com/doc/mysql/en/MERGE.html
>
> --
> Diana Soares
>
> On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote:
> > Heya folks --
> >
> > Trying to come up with a way
You may use MERGE TABLES:
http://dev.mysql.com/doc/mysql/en/MERGE.html
--
Diana Soares
On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote:
> Heya folks --
>
> Trying to come up with a way to count across multiple tables, and failing
> miserably. I need a simple way, preferably better than loope
Heya folks --
Trying to come up with a way to count across multiple tables, and failing
miserably. I need a simple way, preferably better than looped queries, of
summing the number of rows in multiple tables.
Example:
I have multiple tables with the same column layout, due to the amount of dat
bonjour,
voici mon problème:
Systeme: windows NT4 server
Sql server 6.5
Application: Deux bases SQL utilisé: une pour les bases
une pour les données
Diag:
Apres un sp_spaceused sur la base des données,
il apparait que 160
I pruned it all down ti this:
The Board Lady - Work Order Database 0.1a
\n";
echo "";
echo "Work Order #: \n";
echo "Customer Name: Phone: \n";
echo "Email Addy: Date In: \n";
echo "Board Type and SN: Last 3 of
SN: \n";
echo "Weight In: Weight Out: \n";
echo "\n";
echo " \n";
}
if ($page_req
Hi
I have made an horrendous stupid mistake. In migrating from OSX 10.3 to
OSX Server 10.3 I backed up all the data, but forgot to dump my sql
databases. I have the data, but simply copy paste into the relevant
directories doesn't work.
Please help!
Niels Riis Kristensen
([EMAIL PROTECTED])
N
Hi,
I have MySQL 4.0.17 on Windows XP.
I use SELECT ... INTO OUTFILE print out query to text file.
If i write this command.
mysql>SELECT * from tbl1 INTO OUTFILE "C:\\Query\\sample1.txt";
MySQL reponse OK.But i change command.
mysql>SELECT now() INTO OUTFILE "C:\\Query\\sample2.txt";
MySQL res
I've got it currently as method=get; I thought it had to be get in order to
manipulate variables in the URL, as I've got them...have I thought wrong?
- Original Message -
From: "Ross Honniball" <[EMAIL PROTECTED]>
To: "Dan Bowkley" <[EMAIL PROTECTED]>
Sent: Monday, May 03, 2004 11:53 PM
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
76 matches
Mail list logo
