I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the
older version. I also exported all the information using phpMyAdmin's export
tool. I have one huge .sql file.
When I upgraded to 4.1.12, I followed instructions to copy the contents of
the old data directory to the new
When mysql had trouble starting up what error messages did it give in
the .err file in the datadir?
-Eric
James Tu wrote:
I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the
older version. I also exported all the information using phpMyAdmin's export
tool. I have one
Dear there,
I have some problems when installing mysql under rpm. Hope some people can
give me help.
I install MySQL-server-4.1.12-0.i386 package and MySQL--client--4.1.12-0.i386
package under root account. Under the root account, I can start the mysql and
it seems working fine. However,
Hi,
I have a question: which way is better for storing data in InnoDB with
MySQL 4.1.x? File per table or one big file? How is the performance with
file per table?
Best Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
You have two way to set two default timestamp columns.
FIRST :
just use a variable :
mysql select @t:=current_timestamp;
+---+
| @t:=current_timestamp |
+---+
| 2005-05-19 08:58:56 |
+---+
1 row in set (0.01
Dear All,
I am using MySQL 4.0.15 on a Linux (RH9) for the past 18 months. All my
tables are InnoDB and tend to be extremely large in nature (running in
couple of millions, actually the ibdata files now stand at 40GB's).
Typically, the database has fewer connections but those who connect use
Hi,
I'm thinking too about switching to MySQL 4.1.x and if it better to user
file per table.
How much tables and data have you in your db? And which performance you have?
Best Regards,
Rafal
At 09:53 19.05.2005, ManojW wrote:
Dear All,
I am using MySQL 4.0.15 on a Linux (RH9) for the past 18
I have a decent number of tables (around 100 ~ 150 ish), some of them are
really chunky. The total db is close to 40 gb.
Cheers
Manoj
- Original Message -
From: Rafal Kedziorski [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 4:57 PM
Hi,
Is it possible to update all the domain names for an email column? I want to
change everyones email address to my domain for a test site, so can I change
the email address column such that everything after @ is changed to
mydomain.com?
Thanks for your advice
--
MySQL General Mailing List
shaun thornburgh wrote:
Is it possible to update all the domain names for an email column? I
want to change everyones email address to my domain for a test site,
so can I change the email address column such that everything after @
is changed to mydomain.com?
- see REPLACE here:
Hi ,
you can. see this :
mysql select * from emails;
+---+
| t |
+---+
| [EMAIL PROTECTED] |
| [EMAIL PROTECTED] |
| [EMAIL PROTECTED] |
+---+
3 rows in set (0.00 sec)
mysql update emails set
with '@' added to the second param :
update emails set t=concat(substring_index(t,'@',1),'@mydomain.com');
:o)
Selon [EMAIL PROTECTED]:
Hi ,
you can. see this :
mysql select * from emails;
+---+
| t |
+---+
| [EMAIL PROTECTED] |
| [EMAIL
On Wednesday 18 May 2005 21:27, Bing Du wrote:
I downloaded MySQL-server-5.0.4-0.i386.rpm. When I did 'rpm -i
MySQL-server-5.0.4-0.i386.rpm', the following message returned:
MySQL-server-5.0.4-0.i386.rpm: not an rpm package (or package manifest):
What's the problem?
Bing
The problem is
Hello.
You may switch to the debug version of libmysqlclient and
research the problem. See:
http://dev.mysql.com/doc/mysql/en/debugging-client.html
Yes, the mysql.exe is the same version - I installed version 4.1.10 of
the server (and binaries) from the Windows
Hello.
It looks like you have a symptom of a downward-incompatible table format
change. Use mysqldump. See:
http://dev.mysql.com/doc/mysql/en/downgrading.html
Bing Du [EMAIL PROTECTED] wrote:
We moved a bunch of *.frm, *.MYD and *.MYI from 5.0 to 3.23. Now after
successfully
Hello.
After checking that MySQL server listens on the interface to which you
are connecting, solve network problems. If you're able to connect
from one host to another it doesn't mean that the opposite is true.
Andy McHargue [EMAIL PROTECTED] wrote:
Here's some more data on this,
Hello.
Your server listens only on a single interface. Options could be given
in different ways, not only from configuration file. If you want
MySQL server to listen on every interface you should find where the
bind option is given and remove it. See:
Hello.
As a footnote to this the 4.1.12 build is significantly smaller, is
this expected?
Check the md5 signature of your packages to be sure in its' origin.
Search in the other rpm's for Linux x86. If you'll be unable to find
mysqld.sym.gz for you distribution - switch to the debug
Dear friend,
Is it possible to substitute, using SQL command, a certain word with another
word in all the field in all the rows (tinytext) within a certain table?
Thanks in advance
--
symbulos - ethical services for your organisation
website www.symbulos.com
--
MySQL General Mailing List
symbulos wrote:
Is it possible to substitute, using SQL command, a certain word with another
word in all the field in all the rows (tinytext) within a certain table?
- see REPLACE here:
http://dev.mysql.com/doc/mysql/en/string-functions.html
- ian
--
Hi,
I am now using the following:
mysql -u root -p dbname backupname.sql
And getting:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'DEFAULT CHARSET=latin1' at line 7
The mySQL
[snip]
mysql -u root -p dbname backupname.sql
And getting:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to
use near 'DEFAULT CHARSET=latin1' at line 7
[/snip]
Can we see the first 10 lines of
Hello,
Yes, here are the first 10 lines:
-- MySQL dump 10.9
--
-- Host: localhostDatabase: account_databasename
-- --
-- Server version 4.1.8-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
[snip]
Yes, here are the first 10 lines:
-- MySQL dump 10.9
--
-- Host: localhostDatabase: account_databasename
-- --
-- Server version 4.1.8-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
On May 19, 2005, at 12:51 AM, Dan Rossi wrote:
Hi there, I am having issues with this funny error message. I am
trying to do a sub query and then a group by clause on a date.
However i keep getting this annoying message for some reason.
Happens via terminal aswell as my sql gui. Here is the
symbulos wrote:
Dear friend,
Is it possible to substitute, using SQL command, a certain word with another
word in all the field in all the rows (tinytext) within a certain table?
Thanks in advance
look for REPLACE :
http://dev.mysql.com/doc/mysql/en/string-functions.html
UPDATE . FROM
The problem is exactly as the problem says, you're trying to install
something
that isn't an RPM package. Try:
file MySQL-server-5.0.4-0.i386.rpm
It'll tell you what the file you've downloaded actually is. Either it's a
corrupted rpm, or you've downloaded a link to the package, instead of
Hello,
None of these lines describe the problem that you are having with
syntax. Can you give us 5 lines either side of the line that includes
'DEFAULT CHARSET=latin1'?
Yes, here it is:
`user_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
On Thursday 19 May 2005 14:36, Bing Du typed:
The problem is exactly as the problem says, you're trying to install
something
that isn't an RPM package. Try:
file MySQL-server-5.0.4-0.i386.rpm
It'll tell you what the file you've downloaded actually is. Either it's a
corrupted rpm,
[snip]
`user_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`quota_type` smallint(2) NOT NULL default '0',
`quota_limit_id` mediumint(8) unsigned NOT NULL default '0',
KEY `quota_type` (`quota_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Hi,
I'd like to insert string values into a table. If I add a new string, I want
to get back the value of the AUTO_INCREMENT column. If the string already
exists in the table, I'd like to get the AUTO_INCREMENT value of the existing
entry.
I thought this might be possible using INSERT ... ON
Hello all,
I'm having a bit of trouble with a full-text query being slow. At first I
thought it was a problem with a join, then I thought it was a problem with a
sort - but I've boiled down the query and it seems like plain-old slowness.
This is the table:
CREATE TABLE `PC1_Text` (
`AssetID`
Hi,
If you add another command,
mysql insert into bla1 values (NULL, Cello3, NULL) on duplicate key update
whentime = NOW();
The right ID will be used.
Since last_insert_id() has a connection scope, it's better for you to use :
select max(id) from bla1;
Mathias
Selon Sven Paulus [EMAIL
On 19.05., [EMAIL PROTECTED] wrote:
If you add another command,
mysql insert into bla1 values (NULL, Cello3, NULL) on duplicate key update
whentime = NOW();
The right ID will be used.
Yes, if I insert an new value then the ID column gets incremented. But if I
try to insert an existing value
This would be even faster if you could concatenate all of the elements
of
@array into a single list then you could say:
#My PERL skills are non existent so you need to write this part.
#I am assuming that @array is holding a list of string values.
foreach my $element (@array) {
@araylist
On 5/18/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
As a footnote to this the 4.1.12 build is significantly smaller, is
this expected?
Check the md5 signature of your packages to be sure in its' origin.
Search in the other rpm's for Linux x86. If you'll be unable
Wow, your going pass the 2 GB barrier on a 32 bit server. I would not do
that. Reduce your key buffer to 1700 or you will eventually crash.
Then type repair table PC1_Text quick, or ALTER TABLE PC1_TEXT
ENGINE=myISAM. This helps with rebuilding full text indexes.
DVP
Dathan Vance
my $sql = sprintf 'EOF', join(',', @array);
SELECT col2, col3, col4
FROM table1
WHERE col1 IN (%s)
EOF
my $sth = $dbh-prepare($sql);
$sth-execute() or die $sth-errstr();
Eamon Daly
- Original Message -
From: Jonathan Mangin
Error:
C:\ARCHIV~1\MySQL\MYSQLS~1.1\binmysql -hlocalhost -uroot -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on
'localhost' (10061)
I`have a Northon Personal Firewall, and when run de config
server wizard
give this error:
The security settings could not be
Dathan,
Thanks for the suggestion - I was under the impression that 4GB is the limit
for 32bit machines. The server is running Redhat Enterprise Linux 3.0 ES for
EM64T and MySQL has also been compiled for EM64T.
I'd already tried running 'table opitmize' and that didn't seem to help,
table
Mark Hughes wrote:
A lot of the RPM's for 4.1.12 seems to have been removed from the
download page so I presume there's a known problem:
http://dev.mysql.com/downloads/mysql/4.1.html
I noticed this when I just went to download 4.1.12. What's going on? Is
4.1.12 unstable or is this strictly a
- Original Message -
From: Eamon Daly [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, May 19, 2005 1:17 PM
Subject: Re: Efficient select/insert
my $sql = sprintf 'EOF', join(',', @array);
SELECT col2, col3, col4
FROM table1
WHERE col1 IN
In article [EMAIL PROTECTED],
Eamon Daly [EMAIL PROTECTED] writes:
my $sql = sprintf 'EOF', join(',', @array);
SELECT col2, col3, col4
FROM table1
WHERE col1 IN (%s)
EOF
my $sth = $dbh-prepare($sql);
$sth-execute() or die $sth-errstr();
This code is susceptible for an SQL injection
Thanks, that works (I'll have to read a bit to learn why)
except for one thing I didn't mention. (Everybody Lies :)
How ugly is this?
$sql = INSERT into $table2; # dynamic name with $user_id as root
$sql .= sprintf 'EOF', join(',', @array);
I see.
I suppose this produced quite a few grins.
Happy
I'm not sure but I know when I installed it yesterday via RPM it kept core
dumping and restarting. Glad I still had 4.1.11 available.
Donny
-Original Message-
From: Douglas K. Fischer [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 1:18 PM
To: mysql@lists.mysql.com
Subject:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Donny Simonton wrote:
I'm not sure but I know when I installed it yesterday via RPM it kept core
dumping and restarting. Glad I still had 4.1.11 available.
Donny
Donny, Douglas,
Something goofy went on with the production of those RPMs for
Hmmm, I downloaded source and compiled, and had an instant segfault.
Rolled back to 4.1.11. I assumed it was something funky w/ my compile,
but after reading all the above posts ... ???
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Donny Simonton wrote:
I'm not sure but I
Is there a good place/book to lookup formulas for tunning mysql ?
What size should the table_cache be ? I have 2,770 tables
What size should the key_buffer be ? I am only using 38 MB out of 265
MB, yet my Index Length reported by mysql-administrator is 2.72 G
Total number of records are 61
Hello all,
I'm having a bit of trouble:.
Welcome to phpMyAdmin 2.5.0-rc1
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
how can I find my password?
Thanks as always!
-Stone.wang
I'm the maintainer for MySQL++ (a C++ wrapper for the MySQL C API) and
while digging through the code I found a reference to mysql_refresh(),
apparently a C API function. I can't find documentation for this
anywhere. What does it do?
If it's obsolete, I'd like to know that, too. I'll remove
At 21:10 -0600 5/19/05, Warren Young wrote:
I'm the maintainer for MySQL++ (a C++ wrapper for the MySQL C API)
and while digging through the code I found a reference to
mysql_refresh(), apparently a C API function. I can't find
documentation for this anywhere. What does it do?
If it's
Paul DuBois wrote:
It's not obsolete, just undocumented.
Okay, thanks. It's documented in MySQL++ now. :)
(It doesn't say more than that bug DB entry, so I doubt you want a
corresponding MySQL doc patch.)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
52 matches
Mail list logo