Re: Please Help. selectcol_arrayref problem

Nope. That's just granting replication privileges so it can read updates on all tables on all databases. It cannot select anything. Why are you trying to connect with a replication slave user? On 4/2/13 1:47 PM, "Richard Reina" wrote: >I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19

Re: Please Help. selectcol_arrayref problem

On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote: > use DBI; > my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { > RaiseError => 3 } ); > my $dbs = $dbh->selectcol_arrayref("show databases"); > > #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306"; > #my $dbh =

Re: Please Help. selectcol_arrayref problem

I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED BY 'psswd'; on the master. Doesn't *.* mean everything? Why would it just show me to databases? 2013/4/2 Larry Martell > On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina > wrote: > > use DBI; > > my $dbh = DBI->conn

Please Help. selectcol_arrayref problem

use DBI; my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, { RaiseError => 3 } ); my $dbs = $dbh->selectcol_arrayref("show databases"); #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306"; #my $dbh = DBI->connect($dsn, $usrr, $passw); my $dbs = $dbh->selectcol_arrayr

RE: Fwd: Query take too long time - please help!

lists.mysql.com > Subject: Re: Fwd: Query take too long time - please help! > > On 10.07.2012 13:16, Darek Maciera wrote: > > 2012/7/10 Ananda Kumar : > >> can u show the explain plan for your query > >> > > > > Thanks, for reply! > > > >

Re: Fwd: Query take too long time - please help!

On 10.07.2012 13:16, Darek Maciera wrote: 2012/7/10 Ananda Kumar : can u show the explain plan for your query Thanks, for reply! Sure: mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375'); That's definitely not the query you showed the first time around. The query you'

Re: Query take too long time - please help!

you are using a function-LOWER, which will not make use of the unique key index on ksd. Mysql does not support function based index, hence your query is doing a FULL TABLE scan and taking more time. On Tue, Jul 10, 2012 at 4:46 PM, Darek Maciera wrote: > 2012/7/10 Ananda Kumar : > > can u show th

Fwd: Query take too long time - please help!

2012/7/10 Ananda Kumar : > can u show the explain plan for your query > Thanks, for reply! Sure: mysql> EXPLAIN SELECT * FROM books WHERE LOWER(ksd)=LOWER('4204661375'); ++-+-+--+---+--+-+--++-+ | id | se

Re: Query take too long time - please help!

can u show the explain plan for your query On Tue, Jul 10, 2012 at 2:59 PM, Darek Maciera wrote: > Hello, > > I have table: > > mysql> DESCRIBE books; > > |id |int(255) | NO | PRI | > NULL | auto_increment | > | idu

Query take too long time - please help!

Hello, I have table: mysql> DESCRIBE books; |id |int(255) | NO | PRI | NULL | auto_increment | | idu | int(255) | NO | MUL | NULL | ksd | char(15) | YES |

Re: Slow query - please help

; Date: Wed, Oct 5, 2011 at 9:48 AM > > Subject: Re: Slow query - please help > > To: Johnny Withers > > Cc: "mysql@lists.mysql.com" > > > > > > I just revised my query and now get the following output : > > > > '1', 'PRIMARY&#

Re: Slow query - please help

t help. > > -- Forwarded message -- > From: Tompkins Neil > Date: Wed, Oct 5, 2011 at 9:48 AM > Subject: Re: Slow query - please help > To: Johnny Withers > Cc: "mysql@lists.mysql.com" > > > I just revised my query and now get the followin

Fwd: Slow query - please help

Following my mail below, if anyone can help optimise the query further that would be a great help. -- Forwarded message -- From: Tompkins Neil Date: Wed, Oct 5, 2011 at 9:48 AM Subject: Re: Slow query - please help To: Johnny Withers Cc: "mysql@lists.mysql.com" I ju

Re: Slow query - please help

g where' After doing this the query speed is acceptable. Thanks Neil On Wed, Oct 5, 2011 at 3:12 AM, Johnny Withers wrote: > Can you post the explain extended output of your query? > > Sent from my iPad > > On Oct 4, 2011, at 2:45 PM, Neil Tompkins > wrote: > >

Re: Slow query - please help

onst', '267', '100.00', 'Using index condition; Using where' Thanks Neil On Wed, Oct 5, 2011 at 3:12 AM, Johnny Withers wrote: > Can you post the explain extended output of your query? > > Sent from my iPad > > On Oct 4, 2011, at 2:45 PM

Re: Slow query - please help

; To: mark carson >> Cc: "[MySQL]" >> Subject: Re: Slow query - please help >> > >> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are >> below, let me know if you need any more information. >> >> CREATE TABLE `districts` (

Fwd: Slow query - please help

Can anyone help me ? Begin forwarded message: > From: Tompkins Neil > Date: 30 September 2011 20:23:47 GMT+01:00 > To: mark carson > Cc: "[MySQL]" > Subject: Re: Slow query - please help > > I downloaded version mysql-5.6.2-m5-win32.msi and he table definitio

Re: Slow query - please help

I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are below, let me know if you need any more information. CREATE TABLE `districts` ( `district_id` int(11) NOT NULL, `language_code` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en', `city_id` int(11) DEFAULT NULL,

Slow query - please help

Hi I've the following query : SELECT city_id, name, meta_title, meta_description, meta_keywords, country_code, link_text, folder_url, enabled, last_changed, nr_hotels, (SELECT COUNT(hotels.hotel_id) FROM hotels WHERE hotels.city_id = cities.city_id AND hotels.country_code = 'gb' AND hotels.enable

RE: Please help me.

; mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: RE: Please help me. Velentin, http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Note the section for the droping of foreign keys used the contraint name, not the key name. Try this

RE: Please help me.

column after that. From: Valentin Ionescu [colibry...@yahoo.com] Sent: Wednesday, March 18, 2009 11:27 AM To: mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: Please help me. Hi! My name is Valentin and I am writing to

Please help me.

ried to do like:   alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key  Journal_ex_ID or alter table documents_ex drop  key  Journal_ex_ID    I receive the same error 150 and I don't know what to do.   Please help me.  Best regards. -- MySQL

Re: can some please help me -- REPLICATION

bmisq01.bmi.com', master_user > = 'repl', master_password = 'repl'; > ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found > (Errcode: 2) > mysql> > > > > -Original Message----- > From: David Giragosian [mailto:[EMAIL PRO

RE: can some please help me -- REPLICATION

t; -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your s

RE: can some please help me -- REPLICATION

Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On

Re: can some please help me -- REPLICATION

On 8/10/08, Jim Lyons <[EMAIL PROTECTED]> wrote: > > you should probably just resync your slave. If it hasn't run for over a > month then there's not a lot of point in trying to start it up. Even if > you > did start the slave (which seems doubtful) you'd have over a month's worth > of commands t

Re: can some please help me -- REPLICATION

you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that ha

can some please help me -- REPLICATION

The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not

Re: ODBC 3.51.22 problem - please help

On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote: > I've found a glaring problem with the latest ODBC connector. Data > types have been changed and data is no longer being read correctly. That's not quite correct -- data types are now actually being read correctly. They were wrong before, e

ODBC 3.51.22 problem - please help

I've found a glaring problem with the latest ODBC connector. Data types have been changed and data is no longer being read correctly. I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The following query produces different data types depending on the version of the ODBC d

Re: Please help to solve a serios problem

- Original Message - From: "Russell E Glaue" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Tuesday, November 06, 2007 8:55 PM Subject: Re: Please help to solve a serios problem > > The mysql.sock location '/var/lib/mysql/mysql.sock' att

Re: Please help to solve a serios problem

>>> From: Ali Nebi <[EMAIL PROTECTED]> >>> Sent: Nov 6, 2007 9:24 AM >>> To: mysql@lists.mysql.com >>> Subject: Please help to solve a serios problem >>> >>> Hi, i need of help for a serios problem. >>> >>> We have ins

Re: Please help to solve a serios problem

t runs mysql. > > > > > -Original Message- > >From: Ali Nebi <[EMAIL PROTECTED]> > >Sent: Nov 6, 2007 9:24 AM > >To: mysql@lists.mysql.com > >Subject: Please help to solve a serios problem > > > >Hi, i need of help for a serios problem. > > > >

Re: Please help to solve a serios problem

6, 2007 9:24 AM >To: mysql@lists.mysql.com >Subject: Please help to solve a serios problem > >Hi, i need of help for a serios problem. > >We have installed mysql 5 and we are using InnoDB engine. OS is CentOS >5, x86. > >Our problem is this. >We get this message

Please help to solve a serios problem

Hi, i need of help for a serios problem. We have installed mysql 5 and we are using InnoDB engine. OS is CentOS 5, x86. Our problem is this. We get this message in the log: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ERROR 2002 (HY0

RE: Slow query examining 10 Million Rows, please help !!!

- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 10:23 AM To: Brent Baisley Cc: mysql@lists.mysql.com Subject: Re: Slow query examining 10 Million Rows, please help !!! Yes I already did try adding an index on tag, but as you said it didn't work as its using the pr

Re: Slow query examining 10 Million Rows, please help !!!

Yes I already did try adding an index on tag, but as you said it didn't work as its using the primary key from the freetags table for the join , anyway I will try adding an index on "object_type", and see if that helps ... Thanks Kishore Jalleda http://kjalleda.googlepages.com On 6/20/07, Brent

Re: Slow query examining 10 Million Rows, please help !!!

As Dan mentioned, you're searching on the 'tag' field which has no index. But since that field is in the table you're joining on, adding an index on it might not help. You actually searching on the tag_id in the join field, not the 'tag'. Add an index on 'object_type' in the freetagged_object

Re: Slow query examining 10 Million Rows, please help !!!

I would try adding an index on the freetags.tag column as you are querying against that column with WHERE tag = 'shot' HTH, Dan On 6/19/07, Kishore Jalleda <[EMAIL PROTECTED]> wrote: Hi everybody, we have this super slow query which is going through more than 10 million ro

Slow query examining 10 Million Rows, please help !!!

Hi everybody, we have this super slow query which is going through more than 10 million rows to retrieve results, here is the query and other information, I tried a few things to make this faster , but failed , so any help from you guys in making this faster is greatly appreciate

Re: please help reading DB deadlock notice

"Nikita Tovstoles" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Do both of your SELECT statements use the same index (`token`) when setting locks on the rows? My guess is that the situation is as follows. TX2: SELECT ... WHERE id = ... FOR UPDATE TX2 sets an exclusive lock for a ro

please help reading DB deadlock notice

Hi, I'd really appreciate help with reading this db deadlock notice. Essentially, I'd like to understand: -what holds the lock that TX2 is waiting on index `token` of table `eviltwin/user_sessions`? I thought it'd be TX1 (hence deadlock ?), yet it appears that TX1 holds no locks -if the an

Re: Please help*

VeeJay wrote: How and at What place, can I configure the Makefile under /usr/ports/databases/mysql50-server/ to have MySQL server working with above mentioned configurations? Why not just use MySQL that comes from ports? If you really want to build from source, read: http://dev.mysql.

Re: FreeBSD chroot problem...Please help!!!

On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote: > I trying to run MySQL and Apache under a chroot envoirnment. But I am > getting these errors. [ ... ] > # /usr/local/mysql/libexec/mysqld: Can't create/write to file > '/var/tmp/ibPM3e0d' (Errcode: 13) [ ... ] > fopen: Operation not supp

FreeBSD chroot problem...Please help!!!

Hello there I was wondering if someone having great knowledge of FreeBSD chroot system could give me some help. I trying to run MySQL and Apache under a chroot envoirnment. But I am getting these errors. Could you please help me to solve these problems. I have googled a lot but did't fin

Please help*

I am a novice with Unix and user of MySQL on windows….. I have a problem, i.e. I want to install MySQL5.0 at my FreeBSD 6.1 box with following configurations: --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-ldflags=-all-static H

Re: help please, help please

I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] I need the full error, but have some questions: 1. Are you sure that you set a root password? 2. Are you using the command line client or some other administrative tool?

help please, help please

I am not able to install Mysql on my 2003 server at home. error 1045!! I get an accesd denied for user [EMAIL PROTECTED] my firewall is off and I know it is not the port becuase when I configure it as 'anonymous" it works like a charm. Plea

Re: Please Help - Stored Procedure Issue

" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 27, 2006 5:15 PM Subject: Re: Please Help - Stored Procedure Issue On Tuesday 27 June 2006 01:52 pm, Jesse wrote: @cInvNo replace all instances of this with just cInvNo. cInvNo is already declared as an OUT variable, and @cInvNo wi

Re: Please Help - Stored Procedure Issue

On Tuesday 27 June 2006 01:52 pm, Jesse wrote: > @cInvNo replace all instances of this with just cInvNo. cInvNo is already declared as an OUT variable, and @cInvNo will be set to that value when you run: CALL sp_GetNextInv(-1,@cInvNo); -- Chris White PHP Programmer/DBBD Interfuel -- MySQL Gen

Please Help - Stored Procedure Issue

I have the following stored procedure that I'm using: DELIMITER $$ DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$ CREATE PROCEDURE `sp_GetNextInv`( IN nChapterID Int, OUT cInvNo VarChar(7)) BEGIN Declare cPrefix VarChar(1); Declare cNextInv VarChar(7); Set cInvNo = ''; IF nChapterID > 0 THEN

TABLE and VIEW have same IDENTIFIER: PLEASE HELP

views have the same identifier as the tables. I don't know if it is possible to have views and tables the same identifier. I didn't create these views. Can someone please help me figure this out? Thanks Murthy __ Do You Yahoo!? Tired

Re: please help me.

On 6/2/06, yuan edit <[EMAIL PROTECTED]> wrote: my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? You notices most of those files are .asc and .md5 used to verify the integrity of the archive after

please help me.

my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz

Re: please help optimize this query

May 31, 2006 12:25:50 PM CDT To: "Joseph Alotta" <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Subject: Re: please help optimize this query I'd start by looking at your schema.. Quite a lot of use of varchars... I'd suggest using chars (takes more space but processes fas

Re: please help optimize this query

I'd start by looking at your schema.. Quite a lot of use of varchars... I'd suggest using chars (takes more space but processes faster).. Or even better, normalize the data so that you have a table for symbols that is linked to this table via an integer based foreign key. Also it seems wierd fo

please help optimize this query

Greetings, I generate this report of all the holdings by symbol, summing up over accounts. It is taking much too long. I was wondering if I can add an index on something to make it more efficient. The first query gets the most recent date, the next query sums it up by symbol. Thank you

RE: totalizing of Rows please help!!

i have three Values in each row of my MySQL database, im needing to sum them in the table as they are displayed per Row ?? how do i do this ? Projectname Elecremain Controlremainotherremain Project1 2300 1600 250

Re: totalizing of Rows please help!!

Brian E Boothe wrote: i have three Values in each row of my MySQL database, im needing to sum them in the table as they are displayed per Row ?? how do i do this ? As Eugene said, VARCHAR values don't sum, since they are not numeric. Either cast the column values you wish sums of to a numeri

Re: totalizing of Rows please help!!SQL Dump

Please answer to list next time. Good. Now, what is your "Elecremain", "Controlremain", "otherremain"? How should they be calculated... P.S.: Why don't you give a try to some numerical data types? ;) To use varchar everythere isn't a right way I think. Brian E Boothe wrote: my database st

Re: totalizing of Rows please help!!

Brian, i have three Values in each row of my MySQL database, im needing to sum them in the table as they are displayed per Row ?? how do i do this ? Projectname Elecremain Controlremain otherremain Project1 2300 1600 25

Re: totalizing of Rows please help!!

Hi, Brian! First of all I think next time you should better attach your database structure. It'll be much easier to understand your problem if you will... Maybe you're asking for something like this: SELECT project_name, elecremain, controlremain, otherremain, elecremain + controlremain + ot

totalizing of Rows please help!!

i have three Values in each row of my MySQL database, im needing to sum them in the table as they are displayed per Row ?? how do i do this ? Projectname Elecremain Controlremainotherremain Project1 2300 1600 250

Re: please help, can not delete database

database will be destroyed. Do you really want to drop the 'billmax' database [y/N] y Database "billmax" dropped But it does not do anything. I have tried restarting the DB and restarting the box as well Please help Randy Remember that MySQL uses directories to implement datab

Fw: please help, can not delete database

riginal Message - From: "Randy Paries" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Saturday, April 22, 2006 11:04 AM Subject: Re: please help, can not delete database when i go back and try to create it , it says it already exisit? Randy On 4/22/06, R

Re: please help, can not delete database

9:22 AM Subject: please help, can not delete database Hello, Not sure what is going on i have mysql Ver 12.22 Distrib 4.0.17, I have a database that i can not delete. i do this #mysqladmin drop billmax -u admin --password Enter password: Dropping the database is potentially a very bad thing

please help, can not delete database

. Do you really want to drop the 'billmax' database [y/N] y Database "billmax" dropped But it does not do anything. I have tried restarting the DB and restarting the box as well Please help Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: Summing tables and fields Please help,,,

Brian, >can someone post a snippit on Summing tables together of a feild of the >entire Database ? Do you mean summing all row values of a column in a table, grouped by the value of another column? If so, for example to retrieve all electprojcost, electprojbilling values and their difference

Summing tables and fields Please help,,,

can someone post a snippit on Summing tables together of a feild of the entire Database ? why does everyone Have such a problem with this question? everyone i ask says the same thing,, let me show what i'm needing by Visual representation MySQL database >> workorders

Re: Please help: recovering db from crash

Thanks for coming to the rescue, Mark and Bruce. Mark Leith wrote: This is actually for Linux/Unix, not Windows. What error do you get from MySQL when trying to log in? Does the mysqld(-nt) process show within Task Manager? What does the new error log say? You may need to reset permissions:

Re: Please help: recovering db from crash

not sure, but it may be worth trying the following run the script: mysql_install_db --user=root In the installation dir this should change ownership and make mysql recognise the data dir. good luck Ade Foo Ji-Haw wrote: Hi all, My Windows-based database server crashed (no fault of MySQL. pr

Re: Please help: recovering db from crash

This is actually for Linux/Unix, not Windows. What error do you get from MySQL when trying to log in? Does the mysqld(-nt) process show within Task Manager? What does the new error log say? You may need to reset permissions: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Please help: recovering db from crash

Hi all, My Windows-based database server crashed (no fault of MySQL. probably OS or hardware), and I managed to copy out the data files. I am using version 5.0 of the Essentials package. I tried to install a similar setup on another server, then copy the data\ folder over. The MySQL service

RE: urgent : PLEASE HELP - problems with back up and restore

o: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypa

RE: urgent : PLEASE HELP - problems with back up and restore

t;myback1.sql > > it now restore the tables but not the views or sp’s > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.m

RE: urgent : PLEASE HELP - problems with back up and restore

Thanks Marko :) -Original Message- From: Marko Knezevic [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 12:29 AM To: MySQL list Subject: Re: urgent : PLEASE HELP - problems with back up and restore Dear Barak, Save yourself year or two of your life and try using MySQL Front

RE: urgent : PLEASE HELP - problems with back up and restore

Thanks again, I will try this and read the manual again. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:30 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore There

RE: urgent : PLEASE HELP - problems with back up and restore

MAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/

RE: urgent : PLEASE HELP - problems with back up and restore

EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:07 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: Re: urgent : PLEASE HELP - problems with back up and restore "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > >

Re: urgent : PLEASE HELP - problems with back up and restore

"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > >

urgent : PLEASE HELP - problems with back up and restore

Hi, I'm really desperate on this on. After struggling with some really weird bugs I finally finished my project. Buut I can't perform a good backup and restore. I'm using : MySql 5.0.16-nt (essentials version) Windows xp The DB contains tables, vw's and sp's. It is a v

Re: upload images / mp3 more Than 1 MB capacity ---- please help

For an PHP example of how to import data getting around max_packet_size, performance, etc. issues.. Be sure to read this article. Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6 -- MySQL General Mailing List For list

Re: upload images / mp3 more Than 1 MB capacity ---- please help

Dan Buettner wrote: I tend to disagree - at my place of employment, a newspaper, we have hundreds of gigabytes of BLOB data (ad and page layouts & digital artwork) stored in SQL databases. Granted we are using Sybase for that and not MySQL but there are a lot of advantages to it - access contr

Re: upload images / mp3 more Than 1 MB capacity ---- please help

I tend to disagree - at my place of employment, a newspaper, we have hundreds of gigabytes of BLOB data (ad and page layouts & digital artwork) stored in SQL databases. Granted we are using Sybase for that and not MySQL but there are a lot of advantages to it - access control, change control a

Re: upload images / mp3 more Than 1 MB capacity ---- please help

machine. so then i'm not worry about perforamnce. > > please , let me know how could be the way to store such files in a > mysql databse ??? > > please help > > > Jigal van Hemert <[EMAIL PROTECTED]> wrote: > Kane Wilson wrote: > > But when i try to s

Re: upload images / mp3 more Than 1 MB capacity ---- please help

troubles. contents wont stored. my requrement is any how keep the contents , in the mysql database, i have high performance machine. so then i'm not worry about perforamnce. please , let me know how could be the way to store such files in a mysql databse ??? please help Jigal van Hemert &l

Re: upload images / mp3 more Than 1 MB capacity ---- please help

Kane Wilson wrote: But when i try to store little but huge gif files it wont store . First of all, use the method described at http://www.php.net/manual/en/features.file-upload.php for a safe way to handle file uploads. It could be that you run into a server limit which will show up if you u

upload images / mp3 more Than 1 MB capacity ---- please help

wont give any error messages . But that particular data wont displayed. so , this is a big problem for me . i couldnt sorted out yet . I used mysqlcc and sqlYOG as well to upload images ( contents ). in like this situations how can we work with mp3 and such huge files ???? please . help me ..

RE: please help .........very urgent

Kane Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 07, 2005 1:40 AM To: mysql Subject: please help .very urgent hi , I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = resu

Re: please help .........very urgent

Hello. > $dbQuery = results; Have you forgotten to put '$' before the 'results'? Do you have display_errors = On in your php.ini? Kane Wilson <[EMAIL PROTECTED]> wrote: > > > hi , > > I wanted to check the following condition and if it is > success i wanted to display a massag

Re: please help .........very urgent

Kane Wilson wrote: I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = results; $result = mysql_query($dbQuery) or die("Couldn't get file list"); if (!isset($result)) {echo "NULL";}

please help .........very urgent

hi , I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = results; $result = mysql_query($dbQuery) or die("Couldn't get file list"); if (!isset($result)) {echo "NULL";} //if (mysql_

Re: Please help me: Boolean fulltext searches, AND instead of OR

John thegimper wrote: This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search, G

Re: Please help me: Boolean fulltext searches, AND instead of OR

efaults to AND instead of OR. > > Almost every search engine i have tried, google etc. works like this. > > "black horse cat dog" only show results with all words present. > > > > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' &

Re: Please help me: Boolean fulltext searches, AND instead of OR

7; > > I really appreciate your help!! > > >From: Sergei Golubchik <[EMAIL PROTECTED]> > >To: Jessica Svensson <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Please help me: Boolean fulltext searches, AND instead of > OR > >Date: Wed,

Re: Total Sum of Monthly Counts for Older MySQL 4.0.22 (Please Help)

Without knowing more of your requirements, I find seeing the grand total and overall average repeated in every row strange from a usability perspective. Do you really need that, or were you just hoping to get that information out of your query? I'd suggest something like: SET @sum=0, @m=0;

Re: Total Sum of Monthly Counts for Older MySQL 4.0.22 (Please Help)

Hello. It is possible to obtain your results without temporary tables, but with user variables. For a pity you should execute three queries. With first query you're getting the Sum: select @all_sum:= count( employee_id) from table_employee where employee_hire_date between "2005

Total Sum of Monthly Counts for Older MySQL 4.0.22 (Please Help)

Hello MySQL users, Currently, I use MySQL 4.0.22 and I can do a straightforward count of employees hired for each month. select employee_hire_date, count(employee_id) from table_employee where employee_hire_date between "2005-01-01" and "2005-4-30" group by month(employee_hire_date) Date

Re: SLOW SLOW query - please help!

Hi, with a table with 33 rows, i have the row in 0s using index on term. mysql> select * from tx where term like 'Britney Spears' ; +++ | id | term | +++ | 327681 | Britney Spears | +++ 1 row in set (0.00 sec

Re: SLOW SLOW query - please help!

What is the output of the following: EXPLAIN select * from terms where term like 'Britney Spears' limit 1; select_type = SIMPLE table = terms type = range possible_keys = term, term_2 (I just created term_2, fulltext) key = term (this means it's not using the one I just created?) key_len = 255 ref

  1   2   3   4   5   6   7   >