Re: Databases are used to store data,

2007-05-10 Thread Martijn Tonies
> "Databases are used to store data" > > This line spoke the loudest to me. Over the years I had become very > proficient with FileMaker Pro's built in scripting language. I had even > gotten FileMaker to construct the web pages that would be used to > connect to FileMaker (including writing th

Re: Databases in a different location than the default

2005-07-26 Thread Nuno Pereira
Tim Holmes wrote: >> Hello. >> >> You could find the clues in the error log. See: >> >> http://dev.mysql.com/doc/mysql/en/error-log.html >> >> Good Afternoon: >> >> >>> I have rebuilt by web / database server from bare metal this morning. >>> The computer is running Fedora Core 3, and is ful

Re: Databases in a different location than the default

2005-07-13 Thread gerald_clark
Tim Holmes wrote: [Tim Holmes] Gleb, et. al. As you suggested, I have checked out the log files and this is what I have found: 050713 11:00:09 mysqld started 050713 11:00:09 [Warning] Asked for 196608 thread stack, but got 126976 050713 11:00:09 [ERROR] Can't start server: Bind on TCP/IP p

RE: Databases in a different location than the default

2005-07-13 Thread Tim Holmes
> Hello. > > You could find the clues in the error log. See: > > http://dev.mysql.com/doc/mysql/en/error-log.html > > Good Afternoon: > > >I have rebuilt by web / database server from bare metal this morning. > >The computer is running Fedora Core 3, and is fully patched and up to > >dat

Re: Databases in a different location than the default

2005-07-13 Thread Joerg Bruehe
Hi Tim, all! Tim Holmes wrote: [[...]] My databases are located on a different physical machine from the one running the database server - (for backup etc reasons) IMO, this is a "no-no": You add complexity and (potential) bottlenecks to your setup. You should store your data local to the

Re: Databases in a different location than the default

2005-07-13 Thread Gleb Paharenko
Hello. You could find the clues in the error log. See: http://dev.mysql.com/doc/mysql/en/error-log.html Good Afternoon: >I have rebuilt by web / database server from bare metal this morning. >The computer is running Fedora Core 3, and is fully patched and up to

Re: Databases not showing in cmd [SOLVD] and mysqladmin [pending]?

2004-08-19 Thread AceZero2790
Whoa, I ran SHOW DATABASES and everything came up! Now I just have to figure out how to do that with mysqladmin (c:/mysql/bin/mysqadmin - or that is how windows default goes anyway for MySQL 4) Sorry, thanks for the tip. I'm new to mailing lists in general...

Re: Databases not showing in cmd and mysqladmin?

2004-08-19 Thread SGreen
I guess I must be a dinosaur because I don't use either mysqladmin or mysqlgui. So I don't know how else to help. Could it be logging in as something else and THAT account is the one without access to the other tables? What do you get when you do a SHOW DATABASES from each client program? You

Re: Databases not showing in cmd and mysqladmin?

2004-08-19 Thread SGreen
Sounds like a permissions problem. Make sure the login you are using has the rights to see the databases in question. (http://dev.mysql.com/doc/mysql/en/SHOW_GRANTS.html) You may need to GRANT yourself additional privileges. (http://dev.mysql.com/doc/mysql/en/GRANT.html) Respecfully, Shawn Gre

RE: Databases not showing in cmd and mysqladmin?

2004-08-19 Thread Victor Pendleton
Has the ODBC user been removed? Have you logged into mysql, mysql -uuser -p and done show databases? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/19/04 9:44 AM Subject: Databases not showing in cmd and mysqladmin? Just so you know I am pretty new to all this.

Re: Databases not seen in MySQLCC

2004-06-17 Thread Hans-Peter Grimm
Marvin Cummings wrote: Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before? If you right-click the server entry in MySQLCC and select "Edit", there is a "Databases" ta

Re: Databases go away... But why?

2003-03-29 Thread Jeremy Zawodny
On Sat, Mar 29, 2003 at 07:53:32AM -0500, Bill Leonard wrote: > On 3/29/03 12:53 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote: > > >> Every so often, once every couple days or so, the databases just disappear. > >> Doing a show databases command yields an empty set. Actually sometimes, it > >> s

Re: Databases go away... But why?

2003-03-29 Thread Bill Leonard
On 3/29/03 12:53 AM, "Jeremy Zawodny" <[EMAIL PROTECTED]> wrote: >> Every so often, once every couple days or so, the databases just disappear. >> Doing a show databases command yields an empty set. Actually sometimes, it >> shows 1 or 2 in there. >> >> Any ideas as to what could be causing this,

Re: Databases go away... But why?

2003-03-28 Thread Jeremy Zawodny
On Fri, Mar 28, 2003 at 11:15:42PM -0500, Bill Leonard wrote: > One of our servers has been acting up recently... There is about 400 > databases on the machine, about 1000 requests per hour. > > Every so often, once every couple days or so, the databases just disappear. > Doing a show databases co

Re: Databases with Tables approaching several million

2002-05-15 Thread Arjen Lentz
Hi Erik, On Thu, 2002-05-16 at 07:50, Erik Fears wrote: > I'm looking for a solution to a database problem I'm having. The > current implementation is a file based database of roughly 57 > million entries. I'm wondering if anyone has had any experience running > a mysql based database with 50-10

Re: databases projecting

2002-04-04 Thread BD
At 04:23 PM 4/3/2002, you wrote: >hello, > >i have plans to create a complex SQL database. >before that i'd like to draw a scheme of it. >could you please advice which >program(freeware/shareware) >would fit for that purpose? >any links to pages, tutorials about graphical >databases projecting wou

Re: databases projecting

2002-04-03 Thread Christopher Thompson
On Wednesday 03 April 2002 3:23 pm, ktt wrote: > hello, > > i have plans to create a complex SQL database. > before that i'd like to draw a scheme of it. > could you please advice which > program(freeware/shareware) > would fit for that purpose? > any links to pages, tutorials about graphical > da

Re: databases projecting

2002-04-03 Thread Gabriel
mechanical pencil + graph paper? That's what I use. ktt wrote: > hello, > > i have plans to create a complex SQL database. > before that i'd like to draw a scheme of it. > could you please advice which > program(freeware/shareware) > would fit for that purpose? > any links to pages, tutorials ab

Re: databases under users dir

2002-03-09 Thread prafulyahoo
- From: "Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 10, 2002 04:40 Subject: Re: databases under users dir > Hi > > Thanks for the tip! it works fine. > > Now all i need to do is modify my create database code to use $HOME/my

Re: databases under users dir

2002-03-09 Thread Support
AIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 09, 2002 10:07 PM Subject: RE: databases under users dir > Hi, > > > Anyone know if its possible to have mysql databases under > > $HOME for users. > > I am running RH7.2 and have virtualhosts under

Re: databases under users dir

2002-03-09 Thread Intrex
physical disk space, but it would simplify my management dramatically. Thank you for that question. Mark - Original Message - From: "Andreas Frøsting" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 09, 2002 5:07 PM Subject: RE: databases

RE: databases under users dir

2002-03-09 Thread Andreas Frøsting
Hi, > Anyone know if its possible to have mysql databases under > $HOME for users. > I am running RH7.2 and have virtualhosts under apache 1.3.22 > so i am hoping > i can put databases under each user account in order to > control (quota's) > etc. You can put them under each users homedir and

Re: databases

2001-10-03 Thread Arjen G. Lentz
Hi Benjamin, Andre, > > i have a mysql server on a dual xenon with 2GB ram > > with 300 Databases (for each customer one) > > but in the meantime a simple query takes ages to complete >10s Generally, slow queries are caused by inadequate configuration of the server and/or badly formed queries (s

Re: databases

2001-10-03 Thread Benjamin Pflugmann
Hi. On Tue, Oct 02, 2001 at 05:23:51PM +0200, [EMAIL PROTECTED] wrote: > Hi, > > i have a simple question: > how many databases is mysql able to handle. There is no hard limit by MySQL. There are limits brought in by your operating system, though. > i have a mysql server on a dual xenon with 2

Re: Databases and ADODB

2001-08-18 Thread Peter M. Perchansky
Greetings: We have been using it with great success for our enterprise level network monitoring system. We use mySQL as the back end database server, PHP for the user interface, and a combination of Perl / C++ for the actual monitoring. At 04:32 PM 8/18/2001 +0200, you wrote: >Anyone made goo

Re: Databases on Removable Media?

2001-08-03 Thread Werner Stuerenburg
Gerald R. Jensen schrieb am Freitag, 3. August 2001, 02:51:36: > Is it possible to create mulitple database directories ... with one of them > on a CD-ROM? As far as I know, you can spread your data physically to different locations and different media. You will find information on this quest

Re: databases disappear...

2001-06-26 Thread David Robley
On Wed, 27 Jun 2001 12:34, Marco Bleeker wrote: > For the first time developing a PHP-MySQL system, I am experiencing > strange things. Perhaps it is the off-line mode (Localhost) I am > running Apache in, or my Wintel 98SE Pentium3. So I create and populate > 3 small tables in a database with a s

Re: databases and operating systems

2001-04-20 Thread Heikki Tuuri
#x27;re used or not.- Original Message - >From: "Ben Garvey" <[EMAIL PROTECTED]> >To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Friday, April 20, 2001 13:43Subject: Re: databases and operating systems >> Sorry for the topic

Re: databases and operating systems

2001-04-19 Thread Rolf Hopkins
racle & MSSQL server, aren't used very often and usually tend slow down queries, whether they're used or not. - Original Message - From: "Ben Garvey" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday,

Re: databases and operating systems

2001-04-19 Thread Ben Garvey
lf Hopkins" <[EMAIL PROTECTED]> To: "Ben Garvey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 19, 2001 11:43 PM Subject: Re: databases and operating systems > This is rather off topic but for what it's worth, to me, it doesn't make > mu

Re: databases and operating systems

2001-04-19 Thread Rolf Hopkins
This is rather off topic but for what it's worth, to me, it doesn't make much sense in gearing OSs more towards databases. PCs do far more than just databases. - Original Message - From: "Ben Garvey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 20, 2001 1:52 Subject: d

Re: databases size limitation #2

2001-01-13 Thread marko milovanovic
David Hodgkinson wrote: > > marko milovanovic <[EMAIL PROTECTED]> writes: > > how would it be possible to set a limitation in the size of the > > databases at the creation time so that a user couldn-t build any > > databases greater than, say, 20 MB? > Smells like using quotas at the OS level t

Re: databases size limitation #2

2001-01-13 Thread marko milovanovic
Tõnu Samuel wrote: > > marko milovanovic wrote: > > > > uh! i already posted this message a while ago! > > could anyone please help me? > > > > i could find some informations about increasing the size of the > > databases, but not about limitations to their size. > > > > how would it be possible

Re: databases size limitation #2

2001-01-13 Thread Tõnu Samuel
marko milovanovic wrote: > > uh! i already posted this message a while ago! > could anyone please help me? > > i could find some informations about increasing the size of the > databases, but not about limitations to their size. > > how would it be possible to set a limitation in the size of th

Re: databases size limitation #2

2001-01-13 Thread David Hodgkinson
marko milovanovic <[EMAIL PROTECTED]> writes: > uh! i already posted this message a while ago! > could anyone please help me? > > i could find some informations about increasing the size of the > databases, but not about limitations to their size. > > how would it be possible to set a limitatio