Re: questions about merging

2009-01-28 Thread Robert D. Crawford
Hello, Olaf, "Stein, Olaf" writes: > the import of the dump will not remove your other tables unless there > is a naming conflict, then the table will be overwritten. As far as > the prefix goes you can edit the dump file, find the create table > statement for each table and add the prefix. If y

RE: questions about merging

2009-01-28 Thread Stein, Olaf
Robert, the import of the dump will not remove your other tables unless there is a naming conflict, then the table will be overwritten. As far as the prefix goes you can edit the dump file, find the create table statement for each table and add the prefix. If you have lots of tables or a huge d

questions about merging

2009-01-28 Thread Robert D. Crawford
Hello all, I hope I get the terminology right. I am not sure merge is what I want, so let me describe what I need. I have a sql dump from a db that is a mediawiki. I cannot upgrade the software on the old server and need to move it to a new server. I have only one db available to me on the new

Re: Are dates stored as String? Or Integer?

2009-01-28 Thread Paul DuBois
On Jan 27, 2009, at 11:31 PM, mos wrote: Are date columns stored as String or Integer in a MyISAM table? I am trying to squeeze more speed from my application and a date column is used in most of the indexes for my tables. I'm wondering if changing the Date data type to an Integer is going

Re: Setting the value for the EDITOR variable

2009-01-28 Thread Johan De Meersman
Bah, annoying person :-p TBH, when I think on it, it'd probably not even work, because the env variable you need to set is that of the client, not the server. I suppose the simplest way of doing this would be to write a wrapper script around the mysql client that sets the editor. On a per-user ba

RE: Setting the value for the EDITOR variable

2009-01-28 Thread Xristos Karvouneas
That would apply across all users then, wouldn't it? What if I wanted to set it on a per user basis, but only for the MySQL sessions? Thanks, George> Date: Wed, 28 Jan 2009 00:47:07 -0800> Subject: Re: Setting the value for the EDITOR variable> From: vegiv...@tuxera.be> CC: mysql@lists.mysql.c

Re: Setting the value for the EDITOR variable

2009-01-28 Thread Johan De Meersman
You need to set that in the script that starts your mysql daemon, probably /etc/init.d/mysql or something similar. On Tue, Jan 27, 2009 at 3:44 PM, Xristos Karvouneas wrote: > > Dear All, > > I would like to be able to do that from the cnf file, as I want to have a > different editor for MySQL co