Jeremy Proffitt wrote:
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tri
I would like to cron my backups...
I currently have the following items on my list: mysql, ldap, various
files/directories, kerberos, etc.
I'm needing the following questions answered:
1. How to 'cleanly'/securely propagate mysql backup user credentials to
mysqldump. This will be a user with ful
Hello, I'm new to the group and hoping someone can help me figure out a
problem which must be fairly common to new PHP/MySQL users. I have
PHP/MySQL/Apache installed on my Windows XP system. I'm using a supplied PHP
script for making calls from Actionscript to MySQL. The calls work great on
a remot
Hi all,
Is there a rule of thumb how much internal memory you should install,
when pursuing maximum performance? A rule of thumb like: "Internal
memory should be equal or more than the size of the database". Example:
total database size=3 GB; therefor internal memory should be at least 3
Gb.
Is t
is there a trick to saving Excel spreadsheets into a CSV format that will
import into MySQL or phpMyAdmin reliably?
my CSV files get jumbled up, if they load in at all. There is a bug i have
been told concerning columns that contain alphanumeric and just numeric
fields.
I use Excel [office 2k ve
Ok well I reinstalled again and it seems to be working ok now. Thanks anyways ;)
--- "Matt W" <[EMAIL PROTECTED]> wrote:
Hi Charlie,
Don't worry, all questions are OK. :-)
Instead of trying to double-click mysql.exe, open your Command Prompt
and, assuming the mysql\bin directory isn't in your
Dumb Question. I need to move my data from their current access database to my new
MySQL server through an ODBC connection. The tables on both ends are set up
identially. I have added a linked table to the access database called EXPARTAB1. The
data is in EXPARTAB. I tried: INSERT INTO EXPA
Hi,
This is more of a PHP question, but I can't find the answer.
I'm trying to generate a string that contains a , to insert into a MySQL
table. It appears the is being stripped out either just before or
during the update.
** code **
// has both info, update both
$ad_contact = $tr_email;
$ad_co
What follows is a short story, all true and quite stressful. No database
servers were harmed in the making of this server, but a couple were
threatened with loose rack mount rails.
We are trying to move over to InnoDB, but we have a few problems that we
just can't figure out:
First, for some r
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote:
hi, trying out opnecms. so i installed mysql on slak 8.0. added a root
password (something like ... root password opencms) like the doc says, so
i can do a: use mysql and create databases and tables if am root on the
slak box. but only if i am root. tr
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> Is there anything I need to set in MySQL in order to use USER variables?
>
No. What is wrong with user variables for you?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.
I mean look at the --suffix
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
-->Sent: Monday, September 22, 2003 1:26 PM
-->To: 'Gilmore
Your not using mysqlhotcopy correctly.
/usr/bin/mysqlhotcopy db_name[./table_regex/] [new_db_name | directory]
The problem is this
mysqlhotcopy -u root --suffix=091703 staff /backups
look at -u
here is a format from inside mysqlhotcopy
mysqlhotcopy --method='scp -Bq -i /usr/home/foo/.ssh/ide
> At 4:22 PM -0400 9/19/03, Jeff McKeon wrote:
> >We've got mysql 3.23 installed on a redhat system via the rpm's that
> >come with RedHat 8.0. I'd like to change the default data
> directory so
> >something other than /var/lib/mysql. I know this is supposed to be
> >possible with a start swi
as I know, there is no any difference between single and double except the
environment. in ANSI mode, just you should use single quotation. for more :
http://www.mysql.com/doc/en/String_syntax.html
- Original Message -
From: "Stout, Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
"Jon Hancock" <[EMAIL PROTECTED]> writes:
> When you issue this "null" ALTER TABLE, is the entire table locked
> during the build?
The table is read-only during the build.
> i.e. Is the only way to defragment to effectively take the table
> offline during the rebuild?
Well. Not quite offline, b
Gustavo,
- Original Message -
From: ""Gustavo A. Baratto"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, September 22, 2003 7:33 PM
Subject: innodb
> Does anybody know what this error is all about? and how do to get rid of
> it... It started when I upgraded 4.0.1
Hi,
I am trying to install Mantis on Linux but I am totally new for linux as
well as for Mantis.
I have managed to install Linux. I was not sure which components are
required for Mantis So I have selected all the components. Now my Linux is
UP and need you help for the further installation.
P
One of the developers is having a problem optimizing a table in MySQL
4.0.14-standard on Solaris 9. The optimize seems to succeed but when he
tries to access the table with a SQL client, we get an error of
something to the effect that MySQL "cannot fine MESSAGES.MYI". After
running 'myisamchk -o' o
Does anybody know what this error is all about? and how do to get rid of
it... It started when I upgraded 4.0.13 to 4.0.15
---
030922 5:17:30 InnoDB: Error: page 1 log sequence number 0 768348475
InnoDB: is in the future! Current system log sequence number 0 330400180.
InnoDB: Your data
I know this may seem like a trivial question, however I am
new to SQL and it's syntax.
I need to know what the difference between single 'quoting'
and double "quoting" a string. When and why do I use one
or the other,
Any help answering this would be greatly appreciated.
Thanks
Jeff Stout
CSG S
I need help with the proper syntax of my INSERT
Statement.
I have spoken to the support staff of my RADIUS
Vendor they stated that enable to support SHA
The Coolum for password has to have the encrypted
password prefixed with {SHA} not just the hash
I need to include the literal string of {SHA} p
John May wrote:
>On OS X, when issuing the top command in the CLI, my "pageouts" value is:
>
> large number (0)
>
>eg: the number in parentheses is zero, but the other number is large.
>
>Is this a sign of a problem? It's a rather busy server with around
>80 databases totalling 500MB or so. I
well, I am working with mysql for less than 2 months so I may not give you
right answer but I guess we cannot solve this problem without programming.
The point is how to combine the times to have a one POS with continuous
time. this query is an example to combine to records:
SELECT table1.pos, tab
Jeff,
Try creating a new index on Question containing just the question_key field,
and try it again.
Andy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 22 September 2003 13:23
> To: [EMAIL PROTECTED]
> Subject: join not using first primay key, per expla
Hi there,
My problem at this time is following: I have a table of position
bookings, having information of a position code, beginning time of the
booking and end time:
Pos | Begings | Ends
APP | 2003-09-30 11:00:00 | 2003-09-30 12:15:
On OS X, when issuing the top command in the CLI, my "pageouts" value is:
large number (0)
eg: the number in parentheses is zero, but the other number is large.
Is this a sign of a problem? It's a rather busy server with around
80 databases totalling 500MB or so. If this is a problem, how do
Will someone tell me the real difference between FLOAT numbers and DECIMAL numbers?
What are the implications when I use either of those types?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office
Hi group,
Is there anything I need to set in MySQL in order to use USER variables?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTE
"Gilmore, Jason" <[EMAIL PROTECTED]> wrote:
>
> A mysqlhotcopy issue has stumped no less than three of us here today at
> work, ensuring that the solution is glaringly obvious. We're trying to
> use mysqlhotcopy to copy a few databases. We want to make a local copy,
> nothing exotic, just want to
Thank you, Egor,
I *had* the anonymous user, but I deleted it since I couldn't find the use
for it. But I figured out what the problem was. I was
using --safe-show-database, but it didn't seem to work.
My error was that I gave users privileges. I also gave the privileges to the
user on the databa
Dear all,
At the moment I'm working via an R (geoR) & MySQl for the querying,
analysis and displaying of geographical data. The problem is that this
is not a GIS environment.
Does somebody not how I can query results via ARC INFO (or another
GISpackage) out of our mySQL database and create a rast
Thank you for the response Victor!
On 9/22/03 4:02 AM, "Victoria Reznichenko" <[EMAIL PROTECTED]>
wrote:
>> One of our users is trying to execute the LOAD DATA INFILE command (using
>> PHP to talk to MySQL). It is failing for some reason... Everything I believe
>> is set properly, i.e:
>>
>> - t
"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote:
>
> All my MySQL users have access to all databases and all tables, allthough
> I've only given them access to one.
>
> How can I correct this?
Do you have entry for anonymous user in the table 'user'?
>
> Is it possible to have them *onl
S?ren Neigaard <[EMAIL PROTECTED]> wrote:
> I have two MySQL machines, each is both master and slave for each other (to
> en sure high availability).
>
> Then today I rebooted one machine, and when the machine came online again,
> the other machine did not replicate from the rebooted machine any m
I have four tables that i'm trying to join together most are pretty
small(100-200 rows tops) and one, the Response table is 127,000 rows. The
query i'm currently executing is
SELECT Business_Unit.Business_Unit, Question.Text_Long, AVG(Response) from
Question
INNER JOIN Response on Question.Questi
Hello
I often get these errormessages. Why?
* X clients is using or hasnt closed the table properly
(No clients are using the table.)
* found X parts, should be X
* table is marked as crash
(table stopped working, i need to repair it)
Im using mysql-nt 4.0.12
Myodbc 2.x on some
Good morning,
We're still battling with this; haven't heard back from anyone on the
list... Resending one more time in the hopes that it catches somebody's
eye.
Thanks so much,
Jason
-Original Message-
From: Gilmore, Jason
Sent: Wednesday, September 17, 2003 1:36 PM
To: [EMAIL PROTECTED
I have two MySQL machines, each is both master and slave for each other (to
en sure high availability).
Then today I rebooted one machine, and when the machine came online again,
the other machine did not replicate from the rebooted machine any more.
Why can that be, do I have to do something spe
Hi,
I have a serious problem with a site. It's a ASP site running on IIS5 and
MySQL 4.0.15.
I have a DECIMAL(10,2) field in a table. I've now experienced that on some
days, the decimal digit is ignored, meaning that a value of ie. 14.00 is
represented af 1400, 135.00 as 13500.
I have search all t
Hi,
All my MySQL users have access to all databases and all tables, allthough
I've only given them access to one.
How can I correct this?
Is it possible to have them *only* see their database when i.e. typing 'show
databases;', and also refuse them connection to any database but their own?
Tha
Dear Toro Hill,
Thank you for the gentle explanation,
I believe you mean this:
Hence it is not possible to insert, update or modify anything into
TABLE PRODUCT_ORDER
Because :
No is auto Increment, cannot be directly manipulated,
product_category
product_id
customer_id
I know about this limit statement but even if i write the following query,
it *still does not work* because of the nested select statement:
"SELECT Max(id) FROM (select id from systemevents where infoId in ( 3 )
AND id > 100 order by id ASC LIMIT 50) AS t1 "
- Original Message -
F
Use the LIMIT clause in mysql instead of TOP clause for access and mssql.
Luck !
- Original Message -
From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 12:22 PM
Subject: plz help
> I have this statement that works perfectly fine in Acc
Ion-Mihai Tetcu <[EMAIL PROTECTED]> wrote:
>
> I had set up replication between 2 4.0.14 servers and everything seems to work OK.
> Except that SHOW SLAVE HOSTS on muster returns nothing. What am I missing ?
>
Use report-host option on the slave:
http://www.mysql.com/doc/en/Replication_
I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
"SELECT Max(id) FROM (select top 50 id from systemevents where infoId in
( 3 ) AND id > 100 order by id A
After successfully setting up PostgreSQL and better understanding the user and
permission problems I attempted to reinstall mySQL which had been running but
b/c of permission stuff i could only access databases that began with "test".
I installed the OS X bundle with Startup module and then got th
Bill Leonard <[EMAIL PROTECTED]> wrote:
> Let me preface this by saying I am not a MySQL guru myself, but more of a
> general sys admin... !
>
> One of our users is trying to execute the LOAD DATA INFILE command (using
> PHP to talk to MySQL). It is failing for some reason... Everything I believe
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> I have my schema set so that a field in a table has a default value of 16.
>
> I also have a script that "initializes" the database, but I don't want to
> delete the record since I want the other fields' data preserved. Is there a
> way to find out wha
49 matches
Mail list logo