RE: Problems with clean NET STOP MYSQL on Win2000 server after ad ding INNODB space

2004-04-14 Thread Victor Pendleton
Does this happen with a mysqladmin shutdown command as well? -Original Message- From: TO To: [EMAIL PROTECTED] Sent: 4/14/04 5:23 AM Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding INNODB space Help! We're running MySQl on Win2000 server. The other da

Problems with clean NET STOP MYSQL on Win2000 server after adding INNODB space

2004-04-14 Thread TO
Help! We're running MySQl on Win2000 server. The other day our INNODB database filled up, so we stopped the server, backed up the data, and adjusted the innodb_data_file_path from ibdata1:500M;ibdata2:500M;ibdata3:500M; to ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M;

MySQL on Win2000

2002-11-04 Thread ir000387
Hello, I am running MySQL on my local Windows 2000 box and I am experiencing extreme slowdowns. I have an application that writes query data to MySQL using two, separate threads. After writing 2000-3000 records, all of a sudden, MySQL goes to 98% CPU usage and throughput drops to 1 update every 2

Re: MySQL on Win2000

2001-12-13 Thread ST Ooi
EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 5:58 AM Subject: Re: MySQL on Win2000 > You might want to have a look at a client like urSQL > (http://www.urbanresearch.com/ursql)... > > > > At 14:51 13/12/2001 -0500, Alex Shi wrote: > > &

Re: MySQL on Win2000

2001-12-13 Thread j.urban
You might want to have a look at a client like urSQL (http://www.urbanresearch.com/ursql)... > At 14:51 13/12/2001 -0500, Alex Shi wrote: > > >Hello, > > > >I installed MySQL 3.23.46 on Windows2000. The mysql-nt started > >on Windows startup, and MysqlAdmin is also running well. I tried to > >cr

Re: MySQL on Win2000

2001-12-13 Thread Miguel Angel Solórzano
> >- Original Message - >From: "Miguel Angel Solórzano" <[EMAIL PROTECTED]> >To: "Alex Shi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Thursday, December 13, 2001 3:12 PM >Subject: Re: MySQL on Win2000 > > >At 14:51 13

Re: MySQL on Win2000

2001-12-13 Thread Miguel Angel Solórzano
At 15:50 13/12/2001 -0500, Etienne Marcotte wrote: >I never used any kind of ODBC and can connect to mySQL with the >mysql.exe from c:/mysql/bin/ >also with perl/apache locally installed I can make perl script to play >intop the DB without even thinking about ODBC Good. However is useful for a ne

Re: MySQL on Win2000

2001-12-13 Thread Ryan Fox
- Original Message - From: "Alex Shi" <[EMAIL PROTECTED]> > Okay, I will try MySQL GUI later > BTW, do I have to use ODBC if I use PHP? I'm told PHP has its > own very API for MySQL... You can access MySQL from PHP using PHP's ODBC functions (http://www.php.net/manual/en/ref.odbc.php

Re: MySQL on Win2000

2001-12-13 Thread Etienne Marcotte
I never used any kind of ODBC and can connect to mySQL with the mysql.exe from c:/mysql/bin/ also with perl/apache locally installed I can make perl script to play intop the DB without even thinking about ODBC my 2 cents Etienne Miguel Angel Solórzano wrote: > > At 14:51 13/12/2001 -0500, Alex

Re: MySQL on Win2000

2001-12-13 Thread Joel Wickard
Yes you can use phpmyadmin for windows2000, I always have. Here's a little bonus for you even though you didn't ask for it. Save this to a batch file: @echo off set zdate=%date% set zdate=%zdate: =% set zdate=%zdate:/=-% C:\mysql\bin\mysqldump -A > E:\mysqlDataBackup\%zdate%.txt (replace the

Re: MySQL on Win2000

2001-12-13 Thread Alex Shi
PROTECTED]> Sent: Thursday, December 13, 2001 3:12 PM Subject: Re: MySQL on Win2000 At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete se

Re: MySQL on Win2000

2001-12-13 Thread Miguel Angel Solórzano
At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like

Re: MySQL on Win2000

2001-12-13 Thread Etienne Marcotte
use the mysql.exe file in c:/mysql/bin double click it and it opens a dos shell where youcan do all commands! mysql> use test; Database changed mysql> create table firsttable( -> ID int unsigned auto_increment, -> primary key(ID)); Query OK, # rows affected (0.00 sec) mysql> so on..

MySQL on Win2000

2001-12-13 Thread Alex Shi
Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop

MySQL on Win2000 - fast question

2001-01-29 Thread Gustav Wiberg
Hi Do i have to run MySQL as a service on Windows2000? (or can i just execute mysql.exe?) The purpose of mysql in this situation is just for education... /Gustav Wiberg - Before posting, please check: http://www.mysql.co