InnoDB: Error: tablespace

Hi list, I have the following error in a MySQL server: 050617 09:16:35 mysqld started InnoDB: Error: tablespace size stored in header is 8660992 pages, but InnoDB: the sum of data file sizes is only 6432768 pages 050617 9:16:40 InnoDB: Started /usr/sbin/mysqld-max: ready for connections And

recovering a 17G dump

Hi list, I have a 17G dump from my DB, any suggestions to recover that dump faster, any variables to tune up?... I don't have an accurate binary backup, so I have to restore it from my 17G text file. I remove the indexes, foreign keys, I will create them after I've recovered all the data. I ha

RE: MYSQL to XML

Mathias Thanks for your help, I really appreciated it. And I was just wondering if MySQL has another statment (besides show create table) that only displays the foreign key, but I see that only with the "show create table MyTable" could get this. Greetings From: [EMAIL PROTECTED]

RE: MYSQL to XML

mysql.com X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 24 Apr 2005 19:42:26.0285 (UTC) FILETIME=[BE1839D0:01C54905] Hi Mikel, There are a l

MySQL to XML

Hi list, does it possible for MySQL to generate XML in the followin format: This XML is the structure of the ServiceType table, I'll hope that you can help me Thnx in advanced Greetings P.S. Any suggestions (tools) will be appreciated -- MySQL General Mail

Master-Slave bin-logs problem

87 | | sauron-bin.388 | | sauron-bin.389 | +-+ Thanks in advanced for your help, an I hope you can help me guys. Mikel _ Platica con tus amigos en linea con T1msn Messenger http://messenger.t1msn.com.mx/ -- MySQL Gene

RE: Handling threads

Yes it is, it shows the threads_created, threads_cached, threads_active, Do I need to check out another variable, Greetings and thanx in advanced From: Victor Pendleton <[EMAIL PROTECTED]> To: 'Mikel - ' <[EMAIL PROTECTED]>,Victor Pendleton <[EMAIL PROTECTED]>,&q

Re: Handling threads

Yes I can ping my server, the server still alive, I have a monitor that displays all the active connections, the hostname.err file doesn't log new lines, do I have to check out something else?... Thanks in advance Mikel From: Victor Pendleton <[EMAIL PROTECTED]> Reply-To: [EMAI

Handling threads

rked pretty fine but it lasted 20 hours to displayed me the same error "Can't create thread errno (11)" the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. Thank

Re: Too slow recovering mysqldump files

Thanks for your fast response, I'll adjust the autocommit parametr, too, and I'll will let you know if this improves the restore of my data base. Greetings Mikel From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Mikel -" <[EMAIL PROTECTED]> CC: <[EMAIL

Re: Too slow recovering mysqldump files

I'll set up those parameters in my.cnf and try again the recovery from the dump file. I'll hope these changes make faster the recovery. Thanks again Heikki, Mikel P.S. Do you recommend the innodb hot backup tool, does it do faster than the other options, or is a combination of b

Re: Too slow recovering mysqldump files

Here we are my options: set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M I follow the example that came here: "http://www.mysql.com/doc/en/InnoDB_start.html"; Greetings and best regards Mikel From: "Heikki Tuuri" <[EMAIL PROTECTED]

Re: Too slow recovering mysqldump files

I will review the log files, I guess that I set the correct size of my innodb log files, but I'll check it out again. Best Regards Mikel P.S. How about of InnoDB Hot Backup? does it do much faster? From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED

Too slow recovering mysqldump files

Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ dum

table creation

Hello list: Is it possible to create a table with a date column with current date as is default value?, like curdate() or now() values?, any ideas. - MySQL 3.23.58-Max-log - RH. 7.3 Greetings and thanks in advanced Mikel _ Charla

threading limit

at 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http:/

threading support

at 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL Gene

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://pho

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. does This information is ok?, or I'm missing something. Greetings From: Jeremy Zawodny <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Mikel - <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: R

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect "Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent" G

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect "Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent" G

Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie

whole channel issue? cheers, Mikel Rich Fortnum wrote: >Hi there. I have a need to reach into a remote database and write to their >tables from my tables. Or have them reach into my tables and read from >mine. Either way, data will travel over the net. I need that data secure >and

Re: [PHP-DB] any good web hosting with php and mysql support? (OT)

Starting @ $20.00/month http://www.ocsny.com > >-- Original Message -- >From: Gurhan Ozen <[EMAIL PROTECTED]> >Date: Mon, 14 Jan 2002 13:17:59 -0500 > > Hi All, > I am currently looking for a reliable web host to host my personal website. >I know there

Re: mysqldump - basic question

Rory, Take a look at the shell scripts for mysqlbackup here http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain things quite nicely. Cheers, m! ROry O'Connor wrote: >this is an absolute newbie question - but when i try to run mysqldump with a cron >(like with a shell scr

Re: Need help with SELECT and JOIN pls

mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | ++-+-+---+--++-+--+ 3 rows in set (0.00 sec) I hope this helps... cheers, Mikel Jaim

Re: ALTER TABLE error

are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: >Can anyone tell me why I am receiving the following error? I am connecting >to a remote server via ssh, and accessed the mysql prompt by typing: mysql > The following is the screen contents after try

Re: Image's

tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: >Either the coffee is flat or someone switched to decafe on me. > >What is the proper way to retrive an image that is stored as a path in a >field name with SQL? > >My path would be so

Re: conceptual question.

Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: >hello all! >i have a question regarding the storage of data. The >doubt is... >Should the data (mostly binary files) be stored in the >database as a field or a link(a path)

Re: question

Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... "Wells, Kenneth L" wrote: > How can I fix this? > > Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect > to This mysql server F

Re: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box

well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver m

Re: FreeBSD server help

Kyle, Need a bit more info, what version of mysql? Have you granted the other host(s) permission to use mysql? are you using mysqladmin to stop and start the daemon? cheers, m! Kyle B wrote: > Hi all, > > I am going to try and describe my problem as best as possible. here it goes. > > Am

Re: Unix Shell Auth from MySQL

checkout pam_mysql under the ports collection in fBSD...;) cheers, Mikel Chris Aitken wrote: > Hi, > > Something ive been thinking about for a while but havent been able to come > up with a definitive answer is this... > > Is there a system out there which can

Re: Expect Script accessing MySQL

I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD="/usr/local/bin./mysql" USER="me' HOST="some.host.com" PASSWD="whatever" QUERY="SELECT userId FROM thisTable WHERE id=

Re: ACT2 Conversion

Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: > I've never heard of ACT2 but if you can export the data to a delimited text > file, you could import it into mysql. You may have to edit the file a bit > though. > &g

Re: Migration Oracle => MySQL

I'm not sure how this happend but Mikel didn't write that. Could some one kindly forward me the original for the snippet below, including the headers...? Thanks, Mikel Ray Cote wrote: > At 4:44 PM -0400 4/26/01, Mikel wrote: > > > I'm trying to create a perl script

Re: Migration Oracle => MySQL

just curious but can't you do a SQL dump of oracle...and if so (since I'm not up on it) whats' the correct syntax, especially from the command line... Cheers, Mikel Johan Andersson wrote: > Anybody tried this? and hopefully got some good ideas of how to do it > proper

Re: Mysql commands from Linux shell

yes absolutely...look into mysqlbackup (http://www.ocsny.com/main/index.ocs?url=osl ) for an example. Cheers, Miekl Fabio Galarraga wrote: > Hi to all: > I have a linux script and I need it can execute some mysql commands. > Is it possible? If possible, how? > > Best regards, > Fabio Galarraga

Re: Run time version of MySQL

g for free and you've spent a whaping $0. Cheers, Mikel johnd wrote: > Hi, > > We are planning to move on to MySQL. > Could you send us your opinions about MtSQL. It will greatly help us to make >decision and to

Re: MySQL performances?

Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: > Hi, > does any one used MySQL in real environment with big databases and > a big number of connections? If yes, what's the hardware config? > > Thanks > -- > >

Re: Saving pictures in MySql

..but generally most of us are creating web based apps that end up creating url's to said data anyway. Ok well that's my take on it. cheers, mikel Barry Radloff wrote: > A blob is a nice field to use I guess > > see these attachements from when I asked the same Q... > &

Re: Once again... quotas...

h for the burstable circuits. Cheers, Mikel Tristan 'Minty' Colgate wrote: > Hi There, > > I have recently been asked to implement per database quotas > for mysql for a large scale shared webhosting environmnet, > from the lists it seems pretty obvious that mysql can

Re: taxes

core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: > Mikel King wrote: > > > > guys I think

Re: taxes

they are in my state. cheers, mikel Mike Wexler wrote: > Actually its even more complicated than this. There are city taxes and > other taxes on other boundaries. In addition the rules as far as what > things are taxable vary by locality. For example, some localities charge > taxe

Re: taxes

Wound't you just set a table with an id, state_abrev, & tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: > does anyone know how to calculateg taxes for a shop cart that would set the > tax depending on the state that they select when filling

Re: Shell Shocking

Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: > Hello > > The hostin

Re: Shell Shocking

Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: > On Tue, 13 Feb 2001, Donald Korth wrote: > > > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in the server

Re: PHP - working with two MySQL serwers

ct for that one. cheers, mikel Anna wrote: > Original Message - > From: "MB" <[EMAIL PROTECTED]> > > > Hi all, > > I use replication on MySQL. One of my ideas is to generate HTML pages > > using PHP. > > Will I have any troubles using PHP

Re: Port 3306

fwcmd=/sbin/ipfw<... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: > What OS? If Linux or *BSD, they have firewall software (ipchains on linux, > don'

Re: GUI for Linux mySQL

Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: > Is there a GUI for mySQL that will run on eit

Re: Problem for localhost connection.....

did you edit /etc/resolv.conf? dyu wrote: > Dear all, > > i m running mysql on freebsd webserver and using our own DNS server. > Everything run fine with database and web serving. However, i m trying to > change the DNS ip addresses to our isp's DNS server instead of ours on this > webserver.

Re: MySQL connecting to MSSQL7

=mysqlbackup Cheers, Mikel UN Services wrote: > Hi, > > It may sound strange, but the fact is that I'm needing to share data between > one M$SQL7 and the MySQL. It's one business envoirnment that is migrating > from one to the other, and in the meantime (until the new system doe

Re: How to use a database from Sun solaris to Linux

Legeard, You can try this utility; I have never run it on Solaris but since it is based on sh it should run and of course I'd be curious to see how well it does. That asside it uses mysqldump and some shell scripting to auto discover all of the databases in a running mysql system and dump e

Re: Changing a Table name

Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: > Hi, > > Is there a quick and simple way to change

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: > Hi, > > I`ve been searching for hours now so I thought I`d ask some lists I belong > to, does anyone know of a decent CRON tutorial??? &

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: > Hi, > > I`ve been searching for hours now so I thought I`d ask some lists I belong > to, does anyone know of a decent CRON tutorial??? &

Re: Drop Database

Hi David, Have you tried DROP DATABASE "\#Muffin" ; ? Cheers, Mikel David Lidström wrote: > Hi! > > I was testing some queries and now I've created a database > named "#Muffin", and I cannot drop it! > > I've tried the following: &g

Re: Corrupted tables

routine to auto discover the databases in your db and print them into straight sql...I have another cron job that runns shortly after that tars the data to tape and then they can be erased from disk... cheers, mikel "Kissandrakis S. George" wrote: > Hello > > I have mysql 3.

Re: Starting MySQL

e; again you can use localhost or the webserver's domain name. > > > Sorry but I just don't quite understand this stuff yet. Cheers, Mikel - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Starting MySQL

ed on the same server you can get away with localhost, however; if not then you must make an entry for each domain... Cheers, Mikel Carlos Corzo wrote: > Hello, > > I bought MySQL by O'reilly. This thing is just as tough to read as the > manual but I am trying and utilizing bo

Re: date_format

Hi Cindy, This might help... http://www.upan.org/rtfm/strftime.html Cheers, Mikel Cindy wrote: > OK. I went to the documentation at www.mysql.com and typed in > DATE_FORMAT in the search box, hopefully find a list of the %M's, etc > rules that may be used (I'd like Dec

Re: ISAM to MYISAM

Aaron, I sugest that you use this app, http://www.ocsny.com/main/index.ocs?url=mysqlbackup and then use the dumped files on the new server to rebuild you db you could quite conceivably br up within 2 hours... Cheers, Mikel Aaron Schlesinger wrote: > I've noticed that mos

Re: Please read the manual

it is important for all of us to help by giving back to our community...;D Cheers, Mikel Neff Patrick K wrote: > Maybe it is the lack of coffee this morning talking or maybe it is the fact > that I have spent 4 days trying to get mysql up and running on linux(a > platform I am unfamiliar with)