Yes, InnoDB is the default storage engine for MySQL as of MySQL 5.5.MyISAM
and InnoDB has its own features.
InnoDB probably the best RDBMS out there. InnoDB is default engine might be
due nowadays most of the application required fully ACID-compliant modes,
self recovery from a crash, and many mo
2011/05/25 10:53 +0200, Reindl Harald
if there is no good reason i will never enable innodb because
MyISAM is enough for most web-apps
And also MyISAM supports auto-increment in a lesser part of a primary key and
InnoDB not--but although it is of interest, I have not tryed it.
Am 25.05.2011 10:35, schrieb Brent Clark:
> Hiya
>
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 / 5.1.
> Have any of you set the mysql def
On 2011-05-25 10:35:45 Brent Clark wrote:
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 /
> 5.1. Have any of you set the mysql default variable to be / u
Hiya
I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
default storage engine.
The question I would like to ask is. For those still running Mysql 5.0 /
5.1. Have any of you set the mysql default variable to be / use Innodb?
Regards
Brent Clark
--
MySQL General Mailing
Options such as these are set in my.cnf/my.ini (depending on your host
operating system).
innodb_file_per_table is a very useful option but not neccessarily the
best choice for a novice trying to set up replication.
- michael dykman
On Tue, Jul 13, 2010 at 5:43 AM, lejeczek wrote:
> I'm a novi
I'm a novice myself and yes I must say on-line documentation is not easy
nor comprehensive,
let's take this page as an example:
http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html
if I don't use InnoDB Hot Backup, doc says..
"..Otherwise, you can obtain a reliable binary snaps
;>> mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
>>> 5.0.xx)
>> MySQL 4.X is EOL. I strongly suggest not using it for new projects, if
>> you have the option. If possible, MySQL 5.1 is recommended,
>
> Thanks, I'm aware of that. The
4.x -
>> 5.0.xx)
>
> MySQL 4.X is EOL. I strongly suggest not using it for new projects, if
> you have the option. If possible, MySQL 5.1 is recommended,
Thanks, I'm aware of that. The 4.x servers are old and should be
migrated to the recent redhat EL released mysql 5.0.x.
&g
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
wrote:
> Hi,
>
> we do have different LAMP systems and recently I started to put some
> mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
> 5.0.xx)
MySQL 4.X is EOL. I strongly suggest not using it for new proj
Hi,
we do have different LAMP systems and recently I started to put some
mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
5.0.xx)
I did this by exporting some databases with mysqldump and importing tham
on the new server.
Now I'd like to add a slave mysqlserver and so I s
Hi Machiel, all!
Machiel Richards wrote:
> [[...]]
>
> We are looking at upgrading a clients' MySQL 5.0 to version
> 5.1.
Good.
>
> They are running the following version: mysql Ver 14.12
> Distrib 5.0.72sp1, for unknown-linux-gnu (
HI All
Maybe you can assist.
We are looking at upgrading a clients' MySQL 5.0 to version
5.1.
They are running the following version: mysql Ver 14.12
Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readlin
Machiel Richards wrote:
Hi All
I hope that someone can assist me with this.
We have a client with a production MySQL database running
MySQL 5.0.
Their slow query counts have skyrocketed over the last week
and I found
We have a client with a production MySQL database running
> MySQL 5.0.
>
>
>
>Their slow query counts have skyrocketed over the last week
> and I found that their slow query logs are not enabled.
>
>
>
>However wh
Hi All
I hope that someone can assist me with this.
We have a client with a production MySQL database running
MySQL 5.0.
Their slow query counts have skyrocketed over the last week
and I found that their slow query logs are
his
thread. :) Therefore permissions should be fine as they go by DB name AFAIK
and not some "pointer".
> -Original Message-
> From: Gavin Towey [mailto:gto...@ffn.com]
> Sent: Friday, December 11, 2009 2:18 PM
> To: Saravanan; MySql; Michael Dykman
> Subject: RE:
t: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
if you have myisam alone tables you can rename the folder of the database. That
can work like rename database. If you have innodb table you have to move one by
one table because details of those tables will be stored in innodb s
--- On Fri, 12/11/09, Michael Dykman wrote:
From: Michael Dykman
Subject: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
To: "MySql"
Date: Friday, December 11, 2009, 10:54 PM
No, not a loophole. Just a plain-old management feature.. there is
nothing particularly hack
On Fri, Dec 11, 2009 at 10:40 PM, Daevid Vincent wrote:
> Will this work in 5.0?
>
Yes.
> If I'm reading this right, it seems like this is some kind of trick or
> loophole then right? If it works and solves my dilemna, I'm fine with that,
> but I'm just curious.
>
Not really, this is by desig
s this? I mean, if I have an 80GB database, is it like a real
> unix 'mv' command where it simply changing pointers or is it a full on
> copy/rm? (Assume same filesystem/directory)
>
>> -Original Message-
>> From: Michael Dykman [mailto:mdyk...@gmail.com]
>>
mv' command where it simply changing pointers or is it a full on
copy/rm? (Assume same filesystem/directory)
> -Original Message-
> From: Michael Dykman [mailto:mdyk...@gmail.com]
> Sent: Friday, December 11, 2009 6:08 AM
> To: MySql
> Subject: Re: Are you serious? mySQ
According to MySQL docs, it should still work atomically. Granted, I
have only used this particular trick when they are on the same
filesystem. Copying across filesystems, I imagine it should still be
atomic, but your system may be locked for awhile.
Obviously, a dedicated RENAME DATABASE comman
Can you use that syntax if the databases are on different file systems? If
you can, and the original table is big, the command would take a while as it
moved data from one file system to another.
On Fri, Dec 11, 2009 at 7:58 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 1:56 PM, Ken D'A
If you want to move the database atomically, a RENAME TABLE statement
may have multiple clauses.
RENAME TABLE
olddb.foo to newdb.foo,
olddb.bar to newdb.bar;
Here, I hot-swap a new lookup table 'active.geo' into a live system
confident that, at any given point, some version of this t
On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio wrote:
> > rename table oldschema.table to newschema.table;
>
> Just to be 100% clear -- I assume you have to first create the destination
> database, and then do this for all the tables in the source database?
>
Yep. Easily scriptable, though :-)
On Fri, December 11, 2009 7:38 am, Johan De Meersman wrote:
> This only works for MyISAM :-)
Good to know -- thanks!
> However, there's another solution where you don't need to shut down, and
> that works for any engine afaik:
>
> rename table oldschema.table to newschema.table;
Just to be 100%
This only works for MyISAM :-)
However, there's another solution where you don't need to shut down, and
that works for any engine afaik:
rename table oldschema.table to newschema.table;
I agree that it's a silly thing to not have, but I can't say that I've
encountered a whole lot of instances wh
Uhhh... wow. Unless I'm very, very, very mistaken, I think you're missing
something pretty obvious: I believe you can simply
a) shut down the database
b) mv the directory to a different directory name.
*DONE* Your database now has a different name. Boy, that 30 seconds of
hard labor was sure fa
How can it possibly be that mySQL doesn't allow you to rename a database? I
can't fathom how this can be a difficult task at all to do. Aren't mySQL
databases stored in a directory of the DB name? And for INNODB, can't you
just find the spot in the ibdata file and alter whatever needs to be
changed
-bit version of MySQL 5.1 server
under Windows Vista x64 and both the installation and configuration
were successful. Then for compatibility reasons with something on
which I am working I realized I needed to install the 32-bit version
of MySQL 5.0 server. Since I did not see anything about
I had previously installed the 64-bit version of MySQL 5.1 server under
Windows Vista x64 and both the installation and configuration were
successful. Then for compatibility reasons with something on which I am
working I realized I needed to install the 32-bit version of MySQL 5.0
server
oki, I found, it's the dll in system32 who was not suppress.
thanks for all
a++
On Wed, Jan 14, 2009 at 4:27 PM, wrote:
>
> Did you re-compile/re-link your C app with the new MySQL header files?...
>
> Sounds like you didn't.
>
>
> --
> MySQL General Mailing List
> For list archives: http
Did you re-compile/re-link your C app with the new MySQL header files?...
Sounds like you didn't.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I m really sorry,I read and re Read but I understang nothing , maybe it's
cause I m noob with mysql or maybe cause the subject is not explicit.
when I say 5.0 to 5.1 it's just the code not the database. like I explain I
TOTALY remove mysql 5.0 AND THE DATA , all data files, all regi
heu... sorry but something I don't understand,
what I did is remove the mysql dierctory (programFile\mysql) remove
the data directory,( C:\Documents and Settings\All Users\Application
Data)
remove all key who are in regedit and contain mysql (more or less).
remove the services, restart my compute
Could it be associated with one of the known issues listed at
http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-5-0.html ?
quote:
"Incompatible change: In MySQL 5.1.25, a change was made to the way
that the server handles prepared statements. This affects prepared
statements processed at the
hi all,
We have a c application who work perfecty with mysql 5.0. We decide to
upgrade and use mysql 5.1.
Since that, nothing work, in owr log, we have always the follonig
error "Using unsupported buffer type: 254 (parameter: 2)" when we
call the mysql_stmt_bind_result function
wha
Moon's
Moon's Father escreveu:
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
I did it, but the problem persists... :-/
+-+---+--++
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I installed MySQL-5.0.67_1.
> When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get
> the message:
>
>
> +
Hi,
I installed MySQL-5.0.67_1.
When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I
get the message:
++---+--++
| Table | Op| M
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL AUTO_INCREMENT,
->PRIMARY KEY(memberId),
->first_name varchar(100),
->last_name varchar(100),
->Email varchar(60),
->phoneNum varchar(25)
-> *);*
Works withou
I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
the mysql command shell,
I got an error 1064 (42000): *You have an error in your SQL syntax*;
Here is my code:
mysql> CREATE TABLE memberDetails
-> *(*
->memberId INT NOT NULL AUTO_INCREMENT,
->
Maybe you should set your old_passwords = on.
On Fri, Oct 17, 2008 at 4:36 PM, Sudhir Menon <[EMAIL PROTECTED]> wrote:
> Hi Ujang
>
> I could reproduce the same error mentioned by you in the actual post even
> after having all of the packages for MySQL. Figuring out the what could be
> the probl
Hi Ujang
I could reproduce the same error mentioned by you in the actual post even
after having all of the packages for MySQL. Figuring out the what could be
the problem .
Thanks & Regards
Sudhir Menon
Kindly check with the below commands, u will get the details of the package.
pkginfo SUNWmysqlu
system SUNWmysqlu mysql - MySQL Database Management System (usr
component)
[EMAIL PROTECTED] # pkginfo -l SUNWmysqlu
PKGINST: SUNWmysqlu
NAME: mysql - MySQL Database Management System (u
on this machine there are libs from solaris package...
bash-3.00# pkginfo | grep mysql
system SUNWmysqlr mysql - MySQL Database
Management System (root component)
system SUNWmysqlt mysql - MySQL Database
Management System (test component)
syste
Hi,
Kindly ignore my first post, as that link was with respect to compiling
super-smack on Solaris, which i found useful.
As far as the problem is concerned can u check the below
1. Check if you have mysql4client package installed.
2. If then install mysql5client
3. Ensure that the binaries and
Hope this link has some workaround.
http://mysqldatabaseadministration.blogspot.com/2006/10/mysql-benchmarking-4-compiling-super.html
Meanwhile i do check out.
Thanks & Regards
Sudhir Menon
all,
does anyone has successful installing super-smack on solaris 10 x86_64
with mysql 5.0.
I have installed, but when will doing stress testing, always
complaining that client should be upgraded
$ super-smack select-key.smack 30 1
super-smack: aborting because of a database error
Shaun Adams schrieb:
> When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
> Does anyone know how I can resolve this?
>
>
>
> QUERY (windows server from the cmd prompt)
>
> mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
> --password=[PASSWORD] --
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD] --host=[HOST] [TARGET DB]
ERROR MESS
First of all, my bad -- I forgot to mention that I use MyISAM.
mysql> show table status from example like 'leads'\G
*** 1. row ***
Name: leads
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
On Fri, Apr 11, 2008 at 6:47 AM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> A COUNT() forces the system to read every row in order to count them...
That is not strictly the case.
A count(field) can use an index scan rather than a sequential scan,
which may or may not be faster. Also some count(field)
Hi,
Can you please post your query? I also need to know your table type as
different settings effect different table types?
You are right that a SELECT COUNT(*) WHERE field = 'value' should hit
the index, but does depend on your query.
You might also try EXPLAIN before your query, which wi
On Fri, April 11, 2008 06:47, Ben Clewett wrote:
> Are you using MyIsam or InnoDB? Or something else?
>
> In either case the speed to get a COUNT() is largely down to the speed
> if your disks and size of disk caching. A COUNT() forces the system to
> read every row in order to count them, and an
Are you using MyIsam or InnoDB? Or something else?
In either case the speed to get a COUNT() is largely down to the speed
if your disks and size of disk caching. A COUNT() forces the system to
read every row in order to count them, and any large table is probably
larger than your caches.
I
Hi,
I am trying to optimize our DB server. We have one table which has 1.3M
entries, and the keys are GUIDs (so the key space is large). However, I
have it all indexed. The performance was iffy, though, so I increased
memory allocation, and the searches on the indexed fields seem to b
from 4.1.22 to 5.0.5 by doing:
> 1) export DB
> 2) stop mySQL daemon
> 3) mv /usr/local/mysql /usr/local/mysq.4
> 4) install mySQL 5.0.5 (./configure --prefix=/usr/local/mysql)
> 5) start mySQL daemon
> 5) import DB
>
> Does PHP 4.4 work with mySQL 5.0 or must I upgrade myS
DB
2) stop mySQL daemon
3) mv /usr/local/mysql /usr/local/mysq.4
4) install mySQL 5.0.5 (./configure --prefix=/usr/local/mysql)
5) start mySQL daemon
5) import DB
Does PHP 4.4 work with mySQL 5.0 or must I upgrade mySQL libraries?
Thank you very much.
--
MySQL General Mailing List
For list arc
Yes, I did try. The issue was the security level setting on the new DB
server, and not the password stuff. I've upgraded apache, mysql, and php
in the last few weeks, and 3-4 issues became painfully apparent when going
from php4 to php5, so I guess I was operating under similar assumptions
and
Have youtried this yet? While 4.0 client can't connect to a v.5
server unless the passwords have explicitly beewen stored as
old_password, I have never run into an issue connecting a 5.x client
to a 4.0 server.
- michael
On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Is it possible t
Is it possible to connect to a 4.0.18 DB from the client of a 5.0.27
system? I know there is an old_passwords function. Can this be used
somehow from a DOS command prompt?
David
eroic.
Geoffroy
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : samedi 2 juin 2007 23:49
À : mysql@lists.mysql.com
Cc : [EMAIL PROTECTED]
Objet : RE: MySQL 5.0 creates 100,000 Window handles
Geoffroy,
Thanks for the reply. Of course by now I figured out what
because of
physical resources, especially RAM, and perhaps by-design in OS kernel.
Regards,
Geoffroy
-Message d'origine-
De : Geoffroy Cogniaux [mailto:[EMAIL PROTECTED]
Envoyé : dimanche 27 mai 2007 23:13
À : 'mos'; mysql@lists.mysql.com
Objet : RE: MySQL 5.0 creates 10
007 23:13
À : 'mos'; mysql@lists.mysql.com
Objet : RE: MySQL 5.0 creates 100,000 Window handles
Hi,
Try [EMAIL PROTECTED] instead.
Bye.
Geof.
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 mai 2007 06:41
À : mysql@lists.mysql.com
Objet : MySQL
Hi,
Try [EMAIL PROTECTED] instead.
Bye.
Geof.
-Message d'origine-
De : mos [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 25 mai 2007 06:41
À : mysql@lists.mysql.com
Objet : MySQL 5.0 creates 100,000 Window handles
I noticed if my program executes a lot of Select statements, Windo
I noticed if my program executes a lot of Select statements, Windows XP
will slow down when the program completes. I did some investigating and
mysqld-nt.exe has close to 100,000 handles created when my program ends
(shown in Task Manager and SysInternals Process Explorer). As each Select
state
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
Hi,
After having compiled (debug and optimized version) of MySQL 5.1.14 on
Itanium-2 using icc, I have run
mysql_install_db --user=...
and started mysqld_safe in both scenarios (debug and optimized). In both
cases mysqld starts without any errors.
Unfortunaly when
help ?
Which are the compilation, linking options used to produce the binary version
of MySQL 5.0.27 for Linux IA64 (using Intel icc and gcc), available at
http://dev.mysql.com/downloads/mysql/5.0.html ?
Which version of the Intel icc has been used ?
Does anybody know whether the issues could be rel
> Yes. MySQL was upgraded.
> What's the name of upgrade script and where is it ?
Check the manual on how to upgrade and what script to run.
I cannot remember the name/place :-)
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
Yes. MySQL was upgraded.
What's the name of upgrade script and where is it ?
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hello Ted,
>
> > I got an error that I don't understand:
> >
> > Enter password:
> > Welcome to the MySQL monitor. Commands end with ;
> or
> > \g.
> > Your MySQL connec
Ted Yu wrote:
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql> create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table 'mys
Hello Ted,
> I got an error that I don't understand:
>
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or
> \g.
> Your MySQL connection id is 3080 to server version:
> 5.0.18-log
>
> mysql> create function do_system returns integer
> soname 'raptor_udf.so'//
> ERROR 1146 (
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql> create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table 'mysql.proc' doesn't
We've added a new appendix to the MySQL Reference Manual:
- Frequently Asked Questions About MySQL 5.1
(http://dev.mysql.com/doc/refman/5.1/en/faqs.html)
- Frequently Asked Questions About MySQL 5.0
(http://dev.mysql.com/doc/refman/5.0/en/faqs.html)
The FAQ answers frequently asked ques
10061 means actively refused. Maybe check your event log around the same
time to see if mysql died?
On 27/10/06, mos <[EMAIL PROTECTED]> wrote:
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get
an error message "Can't connect to MySQL server on 'localhost' (10061)
Socke
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get
an error message "Can't connect to MySQL server on 'localhost' (10061)
Socket error on connect. WSAGetLastError return 10061". Does anyone know
what could be causing it?
This didn't happen when I ways using MySQL 4.1
M
Something like this should work if you want to do it in SQL:
SELECT a, b, c, a+b+c
FROM table
UNION ALL
SELECT SUM(a), SUM(b), SUM(c), SUM(a+b+c)
Dan
On 10/20/06, Brian E Boothe <[EMAIL PROTECTED]> wrote:
How can I keep a running sum of the values in rows as well as columns in a
> mysql
How can I keep a running sum of the values in rows as well as columns in a
> mysql database and display them,,
> Can someone show examples of this thanks
>
>
> Value1 12 14 34 Sum > --
> Value2 14 23 45 Sum> --
>
> Sum > -- -- --
--
No virus
I'm creating a table using a Select statement and several of the columns
are mathematical expressions. Unfortunately MySQL 5.0 creates them as
Decimal and I don't need that much precision. Is there a way to force MySQL
to create these columns as float?
Example:
create table x1 se
I just installed MySQL 5.0 yesterday and ran my application that has a lot
of selects with left joins. I noticed the application is running 4x-7x
slower than with MySQL 4.1. Now it could be because I'm using a new my.ini
file (dedicated server) and I haven't yet copied my old my.in
is [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 22 de septiembre de 2006 2:19
Para: [EMAIL PROTECTED]
CC: MySql Mail List
Asunto: Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
[EMAIL PROTECTED] wrote:
> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
sage -
From: <[EMAIL PROTECTED]>
To: "MySql Mail List"
Sent: Thursday, September 21, 2006 9:27 PM
Subject: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
> Hi.
>
>
>
> What binary relase use for CentOS 4.4:
>
>
>
> * Linux (x86, glibc-2.
[EMAIL PROTECTED] wrote:
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In http://dev.mysql.com/doc/refman/5.0/en/
Hi.
What binary relase use for CentOS 4.4:
* Linux (x86, glibc-2.2, "standard" is static, gcc):
mysql-standard-5.0.24a-linux-i686.tar.gz
* Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz
In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux.html says
at least for one table. All of the data for
the other tables can be regenerated so if I do lose it, it's not the end of
the world.
Have you noticed any speed improvements in MySQL 5.0? The only reason I'd
want to upgrade is to improve the join or sort speeds, or rebuilding the
i
e
you get it back to 4.1 I'd suggest running CHECK TABLE tablename
EXTENDED on each to ensure integrity.
I've always had success going forward with releases, but haven't ever
tried going back that I recall.
Dan
On 8/7/06, mos <[EMAIL PROTECTED]> wrote:
I'm plann
I'm planning on installing MySQL 5.0 today and will try rebuilding some of
the indexes for one of my tables to conduct some benchmarks. I will
probably reboot back to MySQL 4.10 and continue using the database. Have
the table formats changed from 4.10 to 5.0? Or can I create/modify table
Always CC the list. You will get better / faster responses.
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
thats is the syntax it tells me to use so i typed
CREATE USER dimitri [IDENTIFIED BY [PASSWORD] '**'];
were the starts are my password, i hav tried fiddling with the syntax
but
Dimitri Mallis wrote:
hi list
firstly am in the right place to ask this sort of question
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
You've got things confused.
'mysq
hi list
firstly am in the right place to ask this sort of question
i installed mysql 5.0 from the repos on ubuntu dapper drake
i could only go in to mysql when i was root, & then i guess i am
suposed to add users there.
i have tried "man mysql" i might have missed the part
Hi,
RE:
> And finally, you can expect weird messages from mysqladmin.
> E.g. mysqladmin --sort-index on the geometry table works for some
I meant to say myisamchk, and not mysqladmin.
Gaspar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Hello Gilles,
RE:
> I am discovering the Spatial Extensions features of MySQL-5.0
> Is there a way to use a spherical geometry ? (instead of Euclidean)
> like for navigation, or on sky coordinates,...
As far as MySQL-5.0, I have not found any such feature.
I believe it is available in t
Hello,
I am discovering the Spatial Extensions features of MySQL-5.0
Is there a way to use a spherical geometry ? (instead of Euclidean)
like for navigation, or on sky coordinates,...
_-¯-_-¯-_-¯-_-¯-_
Gilles Missonnier
IAP - [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives
erver, as the manual recommends for major
upgrades?
PB
rao
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "prathima rao" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to
er Brawley" <[EMAIL PROTECTED]>
To: "prathima rao" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server
prathima rao wrote:
hello every one,
i have two mysql servers one is the local server 4.1 and
PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server
> prathima rao wrote:
> > hello every one,
> >
> > i have two mysql servers one is the local server 4.1 and one is the
> > centralised serve
prathima rao wrote:
hello every one,
i have two mysql servers one is the local server 4.1 and one is the
centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called
copy database to another server/host - (drop table if exists)
during this process i am not getting the same resu
1 - 100 of 244 matches
Mail list logo
