Image in Mysql

Respected Sir i want to know how i store a image in mysql.i sue perl for scripting on linux. please help me thanks allah hafiz

running a second mysql server

Hi List, Though new to mysql server, I was pretty happy with what I was doing till I needed to run another instance of mysql server on the same machine. My first installation is running on port 3307 instead of default which I achieved by adding a port attribute in /etc/my.cnf file. Rest of the /e

Detecting new records

Hello list. Inorder to do some maintainance, I will be shutting down my production server running mysql4.1. I have already prepared a backup server which is running mysql4 and have imported the current database in it. Though one way of doing things can be to shut down the database on the producti

mysql dump

Hello everyone, Few conceptual questions which I can't understand. If any one can please gimme a a quicky! Am I correct when I say that "mysqldump' only works when the database is up and running? and if it is true can any one please tell me that does taking a dump when a database is running is ok

Re: mysql dump

So is it safe to take the dump while database is running. I mean is there any loss of data expected because of taking dump while a database is running. On Nov 13, 2007 2:26 PM, Michael Dykman <[EMAIL PROTECTED]> wrote: > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PR

Re: mysql dump

being a > relative term, depending on the amount of data in your database(s)). > > Craig > > > > On Nov 13, 2007 2:35 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > > > > > > So is it safe to take the dump while database is running. I mean

mysql dump

Hello every one, I have two questions actually. If there is a database server with couple of databases, and we only want to take the dump of few of them, can we specify a list of those on either mysqldump or mysql prompt ( for any other purpose ).or we have to run the mysqldump command seperately

mysql replication

Hello, Just a small question. I had mysql replication configured on my master and slave server. Due to some issues ( when I was on vacations ), logging on master server was switched off and server restarted. Now my question is that in order to resysnc my master and slave correctly, do I need to co

version mimatch

Hi, I had binlogs from the mysql 4 which I was trying to get into mysql3 using the mysqlbinlog utility. Obviously I got the version mismatch error i.e ERROR 1064 at line 8: You have an error in your SQL syntax near 'DEFAULT ROW_FORMAT=DEFAULT' at line 1 My question, is there anywaay to make the

RE: Any MySQL + IBM Power CPU Hardware (pSeries, iSeries, JS20, B lade) Users?

Currently running MySQl on AIX 5.1, F40 -Original Message- From: Zak Greant [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 3:10 PM To: [EMAIL PROTECTED] Subject: Any MySQL + IBM Power CPU Hardware (pSeries, iSeries, JS20, Blade) Users? Greetings All! MySQL AB is interested in t

MySQL SQL Case Stetement

Hi list. Can someone give me a working example of a SQL CASE statement(in SELECT)? I have examples for stored procedures, but none for use within the DML side of SQL. I am trying to in my SELECT (used in PHP) create a variable/col for example: status='high' where value in a other col is withini

New To MySql

Thanks Abdul Sheikh 14 Mahmood Cr. Maple, ON L6A 3A4 H# 905.303.5442 F# 905 417 9495 C# 647.222.4795 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list