WinMySQLAdmin Invocation

Hi, I have installed MySQL 5.0.0-alpha. When I invoke WinMySQLAdmin, on Environment tab, I do not see any information for "Server Info", "Host Info", etc. I am also not able to create any new instance in MySQL control Center. I use Windows 2000 Server with SP4. What could be the reason? Can

Re: select and where clause - help

On Tue, 06 Jul 2004 23:24:13 -0400, [EMAIL PROTECTED] said: > from your output it's not really possible to tell, but i suspect that > there are spaces following (and/or possibly in front of) the > "BT-1034.02" value, which would cause your select to fail to find > anything. > > try: > > SEL

Re: Increasing number of sockets

At 22:09 -0500 7/6/04, Robert Canary wrote: I am getting an error on my radius server asking me to increase the number of sockets on mysql. What kind of socket? TCP/IP socket? Unix domain socket file? Either way, that sounds like an odd message. The server listens to a single TCP/IP port and a si

Re: DBF to MySQL

For some reason, the imported information showed up as garbled nonsense. The file I was importing was an .xls file. Do you know if there is another "TERMINATED BY" I should be using? If not, I wonder how I can find out? The other question I have is: do I have to create a table within the MySQL

Increasing number of sockets

I am getting an error on my radius server asking me to increase the number of sockets on mysql. I'm looking the man pages for safe_mysqld and mysql but I don't see anything that offers to provision this. How does increase the number of sockets on the mysql? thanks in advance -- robert -- MySQ

select and where clause - help

I am trying to get a select statement with "WHERE" to work and I can't seem to do it. Below find some output. I try a select w/WHERE by "book" but it doesn't work. Originally I tried in PHP and didn't work, so now I just want the MYSQL to work first, I could be overlooking something simple since I'

Re: Easy normalization how-to?

I was hoping someone could improve on my suggestion. But, not seeing any further replies, I guess my solution must be optimal (troll, troll :) --John On Saturday 03 July 2004 03:34 am, John Hicks wrote: > On Friday 02 July 2004 11:40 pm, Your Name wrote: > > ... I now realize the importance of

RE: how to write query to return records has the closest date to end of month

Hi Lam, Try and see whether following SQL work for you: create temporary table tmp as select product_id, min(abs(to_days('2004-6-30') - to_days(snapshot_date)) + if(snapshot_date > '2004-6-30',0,0.1)) as date_diff from product_tbl group by product_id; select product_tbl.* from product_tbl, tm

Reset lost password on Server Logistics Mac OS X install

I'm attempting to follow instructions at the MySQL AB site: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html ...in order to reset a lost root password. I am using the Complete MySQL package from Server Logistics (www.serverlogistics.com) for Mac OS X Panther. I've read the install

Re: ER Diagrams with mysql

Hi, Have you tried DBDesigner4? Take a look, it's an OpenSource. http://www.fabforce.net/dbdesigner4/ Andre On Tue, 6 Jul 2004, Daniel Kasak wrote: > Leandro Melo wrote: > > >Hi, > >i created a database with around 20 tables. However i > >created the tables by script writting all create tabl

Re: Range of timestamp(14)

At 16:43 -0700 7/6/04, Scott Haneda wrote: I can not seem to select a range of timestamp(14) data, something like Select * from foo where added is in the range of 01/01/2004 to 01/25/2004 Well, one problem might be that 01/01/2004 and 01/25/2004 are not dates... You should specify your values in ye

Re: slow response time

On Tue, Jul 06, 2004 at 08:05:43PM -0400, Charles Sprickman wrote: > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > > procs memory pagedisks faults cpu > > > r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy > > > > > > 0 13 0 7821

Re: Range of timestamp(14)

Try BETWEEN I hope this helps. Pat... Patrick Sherrill CocoNet Corporation SW Florida's 1st ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Tuesday, July 06, 2004 7:43 PM Subject: Range of

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > procs memory pagedisks faults cpu > > r b w avmfre flt re pi po fr sr da0 md0 in sy cs us sy > > > > 0 13 0 782108 61388 748 0 0 0 863 0 13 0 399 3756 276 23 95 > > 2 13 0 78

Connect to other database format

Hi, I'm completely new to MySQL and some of its concepts, therefore, these questions may be very basic. To connect to another database format I need the ODBC driver for that other format - right? I've built a repair job entry database on my Palm with HanDBase 3.0. I also got the HanDBase ODBC

Range of timestamp(14)

I can not seem to select a range of timestamp(14) data, something like Select * from foo where added is in the range of 01/01/2004 to 01/25/2004 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: slow response time

On Tue, Jul 06, 2004 at 04:26:04PM -0400, Charles Sprickman wrote: > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: > > > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > > > > > Do you have a summary of the poor performance somewh

Re: C API 3.23 to 4.1

On Tue, Jul 06, 2004 at 03:40:02PM -0700, Ron Gilbert wrote: > I am going to upgrade my MySQL server from 3.23 to 4.1, but I have a C > program that needs to continue to connect to the new server, and it > can't be recompiled. Is the old API 100% backwards compatible with a > 4.1 server? I ass

C API 3.23 to 4.1

I am going to upgrade my MySQL server from 3.23 to 4.1, but I have a C program that needs to continue to connect to the new server, and it can't be recompiled. Is the old API 100% backwards compatible with a 4.1 server? I assume the performance is the same? Ron -- MySQL General Mailing List

RE: DBF to MySQL

Try, for example: LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; -Mensaje original- De: John Mistler [mailto:[EMAIL PROTECTED] Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. Para: [EMAIL PROTECTED] Asunto: DBF to M

DBF to MySQL

I am wanting to parse the info in a .dbf file (or .xls file for that matter) and place it in a table in a MySQL database. Is this something that I can do with the server side MySQL application, or do I need to figure out a way to do it on the client side? Any description of the method would be ve

Re: MySQL and Point of Sale

On Wed, Jul 07, 2004 at 12:05:01AM +0200, Schalk wrote: > Hey there! > > Does anyone know where I can find information regarding connecting MySQL and > a Point of Sale device? I suspect it'd depend on the device in question... -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!

Miicroweb

Hi, I have an application that run´s in a CD supported by Microweb, but i have a problem with de db included in the folder data of mysql, in the cd isn´t all the tables of the DB1, when i run microweb and then load the file, that is the backup, run well, but when i see the folder of data, isn t al

RE: MySQL and Point of Sale

Hey there! Does anyone know where I can find information regarding connecting MySQL and a Point of Sale device? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +271254684

Mysql 4.0.20, InnoDB my.cnf problems

Hello all, I would like to create InnoDB databases within MySQL. I have installed MySQL 4.0.20 and I have tried to uncomment the following on my /etc/my.cnf. MySQL is run on top of Fedora Core 2 Linux. # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysq

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: > > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > > > Do you have a summary of the poor performance somewhere? Or at least > > > a sense of where you think the bottleneck is? > > > > T

RE: Concatenar Field's

Ud necesista usar, CONCAT(tabla_manzan.CODUGIGEO, table_manaza.CODCCPP99) AS IDCCPP o si Ud quiere un espacio CONCAT_WS(' ', tabla_manzan.CODUGIGEO, table_manaza.CODCCPP99) AS IDCCPP -Original Message- From: Wilder Castelo To: [EMAIL PROTECTED] Sent: 7/6/04 3:08 PM Subject: Concatenar Fie

Concatenar Field's

Estoy teniendo un problema cuando ejecuto esta sentencia. SELECT Sum(tabla_manzana.TOTPOB) AS POBLACION, Sum(tabla_manzana.TOTVIVIEN) AS VIVIENDA, tabla_manzana.CODUBIGEO & tabla_manzana.CODCCPP99 AS IDCCPP, tabla_manzana.NOMCCPP99 FROM tabla_manzana GROUP BY tabla_manzana.CODUBIGEO, tabla_manzana

Re: slow response time

On Tue, Jul 06, 2004 at 02:29:16PM -0400, Charles Sprickman wrote: > On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > > > Do you have a summary of the poor performance somewhere? Or at least > > a sense of where you think the bottleneck is? > > The best I can tell you is that mysql + moderate qmail l

RE: slow response time

On Tue, 6 Jul 2004, Chip Bell wrote: > Are you running spam assassin? I'm finding that my slow query log is > showing the spam queries to really be dragging. I am, but that's on three other boxes. This one is just qmail/vpopmail (vpopmail hits mysql for user info). If I had to guess at when ex

Re: mysql...transaction question

bruce wrote: hi.. i'm trying to understand if there's a difference/better reason for doing transactions using either of the following psuedo approaches... approach 1 does the commit inside the eval block, whereas approach 2 has the commit outside the eval block... i've seen sample code with transac

RE: slow response time

Are you running spam assassin? I'm finding that my slow query log is showing the spam queries to really be dragging. -Original Message- From: Charles Sprickman [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 2:29 PM To: [EMAIL PROTECTED] Cc: Egor Egorov Subject: Re: slow response

mysql...transaction question

hi.. i'm trying to understand if there's a difference/better reason for doing transactions using either of the following psuedo approaches... approach 1 does the commit inside the eval block, whereas approach 2 has the commit outside the eval block... i've seen sample code with transactions handl

Re: 64 Bit Support

Yah - Jeremy Z. mentioned that a few days ago as well. Guess I have it confused with Posgres (we don't run MySQL on Windows, so I don't pay much attention to it except the performance issues most people seem to mention, which I guess made me assume Cygwin). David Egor Egorov wrote: David Griffi

Re: slow response time

On Tue, 6 Jul 2004, Jeremy Zawodny wrote: > Do you have a summary of the poor performance somewhere? Or at least > a sense of where you think the bottleneck is? The best I can tell you is that mysql + moderate qmail load on the same box causes problems. I don't know if this is a scheduler issue

Re: slow response time

On Tue, Jul 06, 2004 at 12:48:39PM -0400, Charles Sprickman wrote: > On Tue, 6 Jul 2004, Egor Egorov wrote: > > > Charles Sprickman <[EMAIL PROTECTED]> wrote: > > > > > So I haven't really done much to optimize things, as this seems like a > > > fairly light load. I'm running 4.0.20 on FreeBSD 4.

Re: Create Temporary Table, incorrect rows

On Tuesday 06 July 2004 17:20, Paul McNeil wrote: > Yes I am using mysqlcc. Is that why the 1000 row limit? Yes. It's under the server options tag (don't have it in front of me to give exact details). If you right click the server connection, under I think properties, there's a query limit.

update query question

hello, i've had to change some of the tables in my db to accomodate some greater flexibility in the application that uses it and because of this i need to go through and update all the records. i've done one table by hand and it had about 100 records and took about 20 minutes. but this next table

RE: using fulltext search by using match()

i have a sql statement to execute in mysql for fulltext search like this. "select url from search where match(description) against ('oracle application server') limit 20" but the record set is pretty big, so i want to return first 20 rows. but the first 20 rows that are returned don't include t

Re: first record is skipped in select and shows up last

At 10:22 -0400 7/6/04, leegold wrote: What would be the cause of the following situation? I do a select * from a table and sort by the pk. The first line/record is notably empty/not there, and content starts w/2nd record, and what should be the 1st record appears at the end after the what should be

Re: slow response time

On Tue, 6 Jul 2004, Egor Egorov wrote: > Charles Sprickman <[EMAIL PROTECTED]> wrote: > > > So I haven't really done much to optimize things, as this seems like a > > fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux > > Threads). > > Reliability and performance is not what

Re: slow response time

On Tue, Jul 06, 2004 at 05:07:24PM +0300, Egor Egorov wrote: > Charles Sprickman <[EMAIL PROTECTED]> wrote: > > > So I haven't really done much to optimize things, as this seems like a > > fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux > > Threads). > > Reliability and

using fulltext search by using match()

i have a sql statement to execute in mysql for fulltext search like this. "select url from search where match(description) against ('oracle application server') limit 20" but the record set is pretty big, so i want to return first 20 rows. but the first 20 rows that are returned don't include th

User variables & optimization of IF()

Hi everybody. I often try to parametrize out my queries as much as possible with user-variables. So, say you have a general query for all users: --- SELECT ... FROM users --- It's nice to do this: SET @USER_ID:= NULL; SELECT ... FROM users WHERE IF(@USER_ID IS NOT NULL,[EMAIL PROTECTED],1) -

RE: Create Temporary Table, incorrect rows

Yes I am using mysqlcc. Is that why the 1000 row limit? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 11

Re: Query from mulitple tables where data will only be in one table but that table unkown

I don't think I know enough about the tables (is there a primary key) or what the end result should look like (one row per IP address, do you need to know what table matched) to give a very good answer, but a simple UNION will probably get you part of the way there: SELECT DISTINCT 'DIALUP', F

Re: Create Temporary Table, incorrect rows

On Tue, Jul 06, 2004 at 10:30:38AM -0400, Paul McNeil wrote: > Good day to all. > > I have a table and want to find duplicate info in the table. I know > duplicated info exists by running the following... > > Select count(*) from myTable -> 141123 > Select distinct(myData) from myTable -> 141100

Re: InnoDB table data

--- Egor Egorov <[EMAIL PROTECTED]> wrote: > Sagara Wijetunga <[EMAIL PROTECTED]> wrote: > > > I can see his MyISAM *.frm, *.MYD and *.MYI are > kept > > under his database directory. > > > > But I can see only table.frm are in his database > > directory for InnoDB tables. It looks like InnoDB >

sock file

When trying to start mysql on a lx50 I get the following message: Error 2002 Cannot connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111). What can I do to resolve this problem pls? Regards Michael Johnson

RE: Create Temporary Table, incorrect rows

Thanks. That is a much better way to find dupes. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 200

Re: Create Temporary Table, incorrect rows

A more direct way to find dupes ... SELECT id, COUNT( id ) AS cnt, FROM myTable GROUP BY id HAVING cnt > 1 PB - Original Message - From: Paul McNeil To: MySQL General Sent: Tuesday, July 06, 2004 9:30 AM Subject: Create Temporary Table, incorrect rows Good day to all.

Re: Create Temporary Table, incorrect rows

On Tuesday 06 July 2004 15:30, Paul McNeil might have typed: > > When I run this it says that the temp table has only 1000 rows. Why? Are you using mysqlcc? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL IPv6 enabled ready !!!

Rafael Martinez Torres <[EMAIL PROTECTED]> wrote: > you will find a patch to make the last stable version on MySQL, (4.0.8) You are more than a year past the schedule: the last stable version of MySQL is 4.0.20. :-)) -- For technical support contracts, goto https://order.mysql.com/?ref=en

Temporary Table update

I added a LIMIT clause to my create table command and now all data is present. Is the 1000 row limit a standard that must always be overridden? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -- MySQL Ge

Can't execute the given command because you have active locked tables or an active transaction

Hi all, i have a problem with a db innoDB 4.0.20 server. The error 'Can't execute the given command because you have active locked tables or an active transaction' happens on the second truncate (the fist table trucante correctly) of a db composed by three tables, without any foreign keys. The

Re: INTEL vs. SPARC

mac <[EMAIL PROTECTED]> wrote: >> Are you running Linux or Solaris on these servers? > sparc: solaris 9 > intel: debian-linux (2.4.21-kernel) To achieve best performance, you better get the Official MySQL binaries from http://www.mysql.com rather then compiling by yourself. This is due to glibc p

Re: GUI for mysql

gowthaman ramasamy <[EMAIL PROTECTED]> wrote: > i use MySQL 4.0.20 on RH7.3 on a sun fire workstation. > Can some one of you suggest a good GUI for mysql. > I also use Mysql 4.0.13-pc-linux-i686 on P4. MySQL Administrator and MySQL Control Center are a good choice. See at http://www.mysql.com/pr

Create Temporary Table, incorrect rows

Good day to all. I have a table and want to find duplicate info in the table. I know duplicated info exists by running the following... Select count(*) from myTable -> 141123 Select distinct(myData) from myTable -> 1411000 So I created a temporary table to store distinct records and want to do

Re: INTEL vs. SPARC

mac <[EMAIL PROTECTED]> wrote: > does the speed of mysql depends more on things like the processor than > other resources? Disk speed & memory size are much more important then the CPU. Processor is used to calculate while MySQL is a database. And databases move data back and forth. > if so:

Re: Strange server crashes with large table and myisamchk

Hanno Fietz <[EMAIL PROTECTED]> wrote: > Jul 2 03:10:28 t56 kernel: hda: dma_intr: status=0x51 { DriveReadySeekComplete > Error } > Jul 2 03:10:28 t56 kernel: hda: dma_intr: error=0x40 { UncorrectableError }, > LBAsect=429367, sector=316864 > Jul 2 03:10:28 t56 kernel: end_request: I/O error,

first record is skipped in select and shows up last

What would be the cause of the following situation? I do a select * from a table and sort by the pk. The first line/record is notably empty/not there, and content starts w/2nd record, and what should be the 1st record appears at the end after the what should be the very last record. But doing a li

Re: Concurrency Question

Javier Diaz <[EMAIL PROTECTED]> wrote: > 3- Replication of these tables to another server ?? This is classical solution to the problem and probably the easiest to provide. Just do SELECTs on the slave server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This

DISTINCT issues with 3.23.54

My hosting company is running MySQL 3.23.54-log. I have a problem where I am requesting DISTINCT rows, but am getting repeats. Here is my query: select distinct member.ID as ID from member, address, joinstatuschange, specialtyheld, metroalias where address.memberID = member.ID and specialtyheld.me

Re: 64 Bit Support

David Griffiths <[EMAIL PROTECTED]> wrote: > Sorry - didn't read your email closely enough. The Windows version is > not native - runs under Cygwin. Is there a version of Cygwin for the > Itanium 2? Wrong. It is a native application. :) No, there are no Itanium binaries for Windows. --

Re: Installing innoDB

[EMAIL PROTECTED] wrote: > I have MySQL 3.23 installed, which comes with RedHat ES3. I find that > innoDB is not enabled. Anybody knows can I enable it? The Right Way(tm): download and install the Official MySQL Binary RPM from http://dev.mysql.com/downloads/mysql/4.0.html -- For technical

Re: slow response time

Charles Sprickman <[EMAIL PROTECTED]> wrote: > So I haven't really done much to optimize things, as this seems like a > fairly light load. I'm running 4.0.20 on FreeBSD 4.8 (port build w/Linux > Threads). Reliability and performance is not what you should expect to find in FreeBSD 4.x. MySQL do

Re: Bug in fulltext index creation on very huge sets of data?

Hi, I got the following values: key_buffer_size = 256M myisam max extra sort file size = 8000M myisam max sort file size = 8000M myisam sort buffer size = 128M But that big table (MYD = 2397 MB), rows = 5 355 866 still won't index in full text. Disk space is enough (25GB of free space), no error

Re: InnoDB table data

Sagara Wijetunga <[EMAIL PROTECTED]> wrote: > I can see his MyISAM *.frm, *.MYD and *.MYI are kept > under his database directory. > > But I can see only table.frm are in his database > directory for InnoDB tables. It looks like InnoDB > table data belongs to his database are not kept under > his

Re: bugzilla not working now after MySQL re-installed

"Nguyen, Long P (Mission Systems)" <[EMAIL PROTECTED]> wrote: > Your thoughts on this would be appreciated. > MySQL was re-installed and now Bugzilla is not working now I am getting this error > when I bring up - http://localhost/bugzilla/ > The scripts were lookin

Re: select query that uses a temporary table

"Lorderon" <[EMAIL PROTECTED]> wrote: > Mabye, is there a way to tell MySQL to limit the temporary table up to 500 > rows? so, when a row is matching into the top 500 rows, the last row will be > dropped out (in case the table is on limit), and the new matched row will be > inserted into the right

Re: authentication error

"Chip Bell" <[EMAIL PROTECTED]> wrote: > The email users authenticate against a MySQL table... Then it's not about MySQL, it's about the imap/pop3 server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.ne

RE: InnoDB table data

InnoDB data is kept in the ib* files. Did you explicitly create a directory for your innoDB files? -Original Message- From: Sagara Wijetunga To: [EMAIL PROTECTED] Sent: 7/6/04 8:16 AM Subject: InnoDB table data Hi all We allocate a limited amount of disk space for user's home directory a

MySQL 4.1.3 and time zone tables

Is there supposed to be data loaded into the mysql.time_zone* tables? There is none in the Solaris binaries nor the Win32 binaries. Is this a bug? Does anyone know? Thanks, Rick

InnoDB table data

Hi all We allocate a limited amount of disk space for user's home directory and the user is required to keep everything under his home directory including his databases. I moved the database created for the user under his home directory and made a link to it from /var/lib/mysql. We use InnoDB as

Unexpected insert/update behaviour makes backup import impossible.

>Description: On a table with a auto_increment/primary constraint is it not possible to insert an id with value 0 but it is possible to insert it with another id and use update to set it to 0, thereby making the backup import later fail due to the use of "insert" statements. >How-To-Repeat: mys

More semaphore mystery

Hi gang, Back in the throes of semaphores that refuse to play nice with all the other kids on the playground ;-) I'm getting the following in my error file: -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 79461482, signal count 75199550 --Thread 23744585 has waited at btr0c

Query from mulitple tables where data will only be in one table but that table unkown

Ok, So here is what I am trying to do, I have 2 tables one with DSL IP addresses and one with Dialup addresses. I need to be able to query both tables and extract the information by IP address but I will not know which table the data is in before I do the search. Basically I want to have a que

Re: Spatial not in current 4.1.3 build?

Hi! On Jul 06, Barend K?bben wrote: > It seems the Spatial Extension is not in the 4.1.3 binary (for Win)...? You're right :( Sorry for this. We recently made GIS features optional, but ON by default. Unfortunately, this "default" is the value of ./configure switch and does not apply to Windows.

SV: ER Diagrams with mysql

I have been using dbdesigner from fabforce. An excellent tool for visual design. It also has a reverse engineer feature. http://www.fabforce.net/dbdesigner4/ regards /Jonas Hi, i created a database with around 20 tables. However i created the tables by script writting all create table statement

Spatial not in current 4.1.3 build?

It seems the Spatial Extension is not in the 4.1.3 binary (for Win)...? This is frustating, as I am a GIS/Spatial database developer using until now succesfully the earlier alpha in my projects. I am not a programmer and certainly do not want to go into building my own binaries. Why this exclusi

I change my password,now I can't go to my site.

 Does anyone know how I can return to my site. I changed the mysql password and it says cant log in because my password isn't "yes" I change it but now what do I do any help would be great.   L.