Re: Disable DB without deleting data

Would this keep permissions intact? I need something that would make it easy to automatically restore the database including any custom permissions? Thanks again for the input, Kirk On 07/20/2012 12:16 PM, Rick James wrote: No. RENAME DATABASE does not exist. It may have something to do

Disable DB without deleting data

I need to find an easy way to make a database unavailable without deleting the data, so that it could be easily and quickly restored if necessary, without impacting the availability of the other databases. Something like moving the databases subdirectory to a different directory, or the "detac

Re: BUG: DATE_ADD 99999 fails, but 9999 works.

of software is going to have problems around that time. Wikipedia has a good write-up of it: http://en.wikipedia.org/wiki/Year_2038_problem And yes, it will be Y2K all over again - hype, hassle, and probably not much real trouble (famous last words!) -- _____ Kirk Friggstad, Daft Vi

microsoft sequel server

Is anyone familiar with how to dump a database from Microsoft sequel server to mysql? I know nothing about Microsoft products and am looking for a utility or similar to do the conversion. Maybe Microsoft has something built in? Although I doubt it. TIA Kirk -- MySQL General Mailing

newbie desperately seeking clues

Folks, I am EW to the list, and MYsql. I am totally adrift, and looking for some good reading for a raw beginner. PLEASE post some linke for my use. I remain, Kirk Bailey think - | THE BOX | - kniht Defend

Re: Using Access as client all fields are marked "#Deleted"

Patrick Sherrill wrote: Ensure you have a timestamp(14) field. This will provide the required Thanks all but I reposted and the problem was my primary key being a BIGINT which Access can't display. I should have closed off both threads. -- MySQL General Mailing List For list archives: http://list

Re: MySQL and Ms Access - a better description of the problem

Daniel Kasak wrote: Patrick Kirk wrote: [...] CREATE TABLE `tblContacts` ( `p_ID` bigint(11) NOT NULL auto_increment, That's your problem there. You can't have a bigint() column as a primary key when Access is being used. In fact you probably shouldn't have any bigints a

MySQL and Ms Access - a better description of the problem

Hi all, I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51. Using the ODBC Administrator I've set up a connection and made sure to check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG Results", "Use Compressed

Using Access as client all fields are marked "#Deleted"

Hi all, My setup is windoes 2000, Access 2000 and Mysql built from source on Debian. Some tables can be seen but all new entries are marked "#Deleted". If I close the table in Access and re-open it, its looks fine. Others have every field marked "#Deleted" and nothing I do makes those tables

Re: RE: SHOW PROCESSLIST

.vbmysql.com > -Original Message- > From: Shane Kirk [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 12:25 PM > To: [EMAIL PROTECTED] > Subject: SHOW PROCESSLIST > > > Hi, we've got a linux server (version 4.0.12) and we seem to > be having a > strange

Re: RE: SHOW PROCESSLIST

.vbmysql.com > -Original Message- > From: Shane Kirk [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 12:25 PM > To: [EMAIL PROTECTED] > Subject: SHOW PROCESSLIST > > > Hi, we've got a linux server (version 4.0.12) and we seem to > be having a > strange

RE: Re: Alternative for NOT EXISTS

>> SELECT u.uname FROM users u >> WHERE NOT EXISTS (SELECT * FROM team_members=20 >> WHERE team_id =3D 7 AND user_id=3Du.user_id); >It sounds to me like you are trying to ask the database: > "Tell me all the users that aren't in team 7." Yes. > If so, this should work

RE: Alternative for NOT EXISTS

>> I have two tables, one for user details and another to indicate >> membership of some team. The later has user_id and team_id. I >> want to select all users that are NOT in a particular team. >> >> After a lot of effort (my sql skills are almost no existent) I >> have the following that work

Alternative for NOT EXISTS

Hi, I have two tables, one for user details and another to indicate membership of some team. The later has user_id and team_id. I want to select all users that are NOT in a particular team. After a lot of effort (my sql skills are almost no existent) I have the following that works with Oracle

Re: Japanese Charset

stions to use a BLOB instead of a text field. But MySQL supports double-byte languages. Why not use an encoding it supports (SJIS or UJIS for Japanese) instead of this kludge? If I compile MySQL to support UJIS with --with-charset=sjis won't text fields then store ujis encoded text

Can't Connect From Script

sort of permissions might be wrong there. Any ideas? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: help with MySQL SELECT statement

. I intend to then parse the adresses leaving only a list of "whatever.com"s which I will stick into an array for my validation function to use. Or am I making a mountain out of a molehill here? TIA -Kirk - Befo

help with MySQL SELECT statement

his? It would lighten the server load and the download times for the form page if possible. thanks! Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Thanks

hanks for walking me through it. It was a new install on a new machine, and I appreciate all the help from everybody. cheers, Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: answer to MySQL service problems

nce in the manual for a manual installation of MySQL as a service if problems occur, but have no idea if that is the course of action to take since I don't really know why there is a problem. Putting MySQL in the startup items makes no difference. HELP! [/snip] Kirk, Are you starting MySQL on individual

I KNOW one of you LISTers has experienced this

ce in the manual for a manual installation of MySQL as a service if problems occur, but have no idea if that is the course of action to take since I don't really know why there is a problem. Putting MySQL in the startup items

Problems starting MySQL as a Service for all users

; I'd really like to have MySQL running for all users (that would enable the Apache-based site I'm running on the same box to access the database at all times). Thanks! Kirk - Before posting, please check: htt

Date Field + Time Field = Datetime Field?

ng? I'd really appreciate any hints you could give. FYI, I'm running MySQL 3.23.37. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Time Weirdness

I was using float...but even when I changed it to time, MySQL still gave me odd values on those rows. What type should I use? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual

Time Weirdness

start & finish. Is this a bug in MySQL 3.23.37? Could it have something to do with my OS (OpenBSD 2.9)? Or am I doing something wrong with the statement "update time_worked set total = start - finish;"? Thanks, Alex Kirk --

Re: Time Difference Function

urs worked on a particular project, where I'm entering in start and end times; if there's a function like period_diff for time, that'd be perfect. Thanks in advance for your help. Alex Kirk - Before

Search & Replace

What is the best way to do a search & replace on a MySQL database? I just want to wipe a particular character from each field it occurs in; the REPLACE command, at least in the documentation on www.mysql.com, doesn't appear to be the best bet for doing this. Thanks,

Selecting unknown columns

them. How would I go about selecting out these fields? Even if I can only get those with one answer, I'd be immensley appreciative. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php

Re: users@localhost problems

how up with equivalent resutls. Hmmm...that seems OK to me...but then again, I can't really say much, since I don't really know. Any further tests I should run? Thanks, Alex Kirk - Before posting, please check:

users@localhost problems

w | root | +---++ 7 rows in set (0.00 sec) Also, if I try to connect to any databases as a non-root user, MySQL sees me solely as '@localhost' -- i.e., it doesn't see my UNIX user name. What's up with that? Thanks in advance. Alex Kirk -

Addendum: DBI Handle Has No Magic

about the wrong version when I first tried this). Is there any way I can just delete everything associated with DBI and start fresh? I really need to get Perl to interface with MySQL. Alex Kirk - Before posting, please check

DBI Handle Has No Magic

d DBI 1.15; ran 'make uninstall', and then installed DBI 1.20 * OpenBSD 2.9 Any ideas what I might to do correct this? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the

Selling MySQL to Government

). Since I'm sure this sort of thing has come up before, I'm wondering if you can point me to any good resources, particularly as they might relate to the US Gov't, banks, or direct mailing agencies. Thanks in advance for any help you can provide. Alex Kirk -

Re: msql client , C++ , compiler ,mysql header files , and mysql client library

At 2001-10-01T17:31:46Z, "Lou DAmbrosio" <[EMAIL PROTECTED]> writes: > What is required to be installed on webserver (redhat linux i686) as far > as msql client , C++ , compiler ,mysql header files , and mysql client > library To do what? -- Kirk Strauser Internet

RE: group by error in query

2001 10:54 To: Daniel Kirk; [EMAIL PROTECTED] Subject: Re: group by error in query On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote: > Hi, > > I've just ported from SQLServer where this query ran fine, however MySQL > gives an "invalid use of group function" er

RE: group by error in query (RESEND, don't think it came through)

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match

group by error in query

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match

importing data into a table with auto_increment

hi there, is there a problem with importing data into a table with an auto_increment field with a primary key, if the data contains values for the auto_increment field? I keep getting an error that it can't insert the value "1" more than once. However, all the values for the auto_increment fiel

from SQLServer7 to MySQL

Does anyone know of any good resources on converting an SQLServer7 database to MySQL? In particular, what's the best method of copying the data (about 150MB over 10 000 kilometres), and do any changes need to be made to datatypes? thx for any info or pointers to resources Dan ---

RE: INDEX() / UNIQUE()

on a related but slightly different example, what would happen if you had a Primary Key consisting of 2 columns a & b (so the pkey enforces a unique combination of a & b) and then created an index on one of the columns eg b. Would the index on b have any effect, or does a primary key on 2 columns

RE: MySQL Memory Requirements...

vek Khera [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 08:39 To: [EMAIL PROTECTED] Subject: RE: MySQL Memory Requirements... >>>>> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes: DK> 30gb eide hdd DK> Will the machine fall over because it doesn&

RE: MySQL Memory Requirements...

/CPU power (for about 20k users per week as below)? any ball park comments eg no worries, close call, not a chance? thx dan -Original Message- From: Daniel Kirk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 09:38 To: [EMAIL PROTECTED] Subject: MySQL Memory Requirements... Can

RE: amazingly slow

i've heard it said that every so often (eg every month) you need to rebuild indexes on tables, as over time they lose their performance enhancement. could that be true? dan -Original Message- From: Tim Samshuijzen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 04:50 To: [EMAI

MySQL Memory Requirements...

Can someone please give me a rough estimate of how much RAM MySQL would require to run something like : A connection pool of around 50 connections 20,000 users every week re-using these 50 connections around 50 inserts per user (each row around 30 bytes) around 20 queries per user Installation on

any recommendations

any recommendations for jdbc drivers running red hat? which version of red hat should i install - 6.2 or 7? thx for advice dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

date/time functions

Does MySQL have any date/time functions -> can anyone give me a URL where I can find some documentation on it. I'm looking for SQLServer equivalents of DateAdd(), DateDiff(), Month(), Year() etc thx dan - Before posting, pleas

when does inserting become too much of an overhead?

Hi there, I am considering porting a MS-SQLServer database to MySQL. After reading some of the documentation, I am concerned about inserts. I run a sports prediction website, where players submit their predictions for a competition. When a player submits their predictions, this is generally 10