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

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

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 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

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 PROTECTED] wrote: Hello

Re: mysql dump

, 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 is there any loss of data expected because of taking dump while a database is running

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

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

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

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

New To MySql

Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks Abdul Sheikh

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