Hi
It's my first time using mysqldump.
[EMAIL PROTECTED] mysql]$ mysqldump -uroot --all-databases >
backup_test.sql
mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode:
2)
mysqldump: Character set '#33' is not a compiled character set and is
not specified in the '/usr/share/
Johan Höök <[EMAIL PROTECTED]> writes:
> Hi Scott,
> I think you've been lucky so far...
> As you're only ordering on listdate, which is the same
> for both homes in your example you might definitely get different
> results once you put in the limit.
> A basic thing about rdb's is that you must ne
Dear Gleb:
The problem has occured again, and I grab some output.
This box run mysql 4.1.11 on FreeBSD 5.4 AMD64, with 8GB RAM
In this case,
The original query is "INSERT INTO LOW_PRIORTY INTO `statistics`.`search`
(`userid`, `id`, `func`) VALUES('lty0105', '8', 2)"
The strange query is "'INSER
Is there a way to tell NOW() in mysql to be based on a time in the future?
Bascially, I am in PST, and they are in EST, I have a ton of reports that
show the time and date, and they want them in EST time, not the time the
server is in.
it is trivial to modify the display output of the time, but th
> I took a dump of (pretty chunk) database, the output is close to 45G.
I
> am trying to reload this dump file onto a development server but it's
> taking long time to load the database. Is their a faster way to load
the
> data in? I am using plain and simple mysql < dump.sql syntax on a
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a "binary" if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
libr
Greetings,
I took a dump of (pretty chunk) database, the output is close to 45G. I
am trying to reload this dump file onto a development server but it's
taking long time to load the database. Is their a faster way to load the
data in? I am using plain and simple mysql < dump.sql syntax on
At 04:58 PM 6/1/2005, you wrote:
I'm having a brain freeze and can't seem to figure out why I can't insert
a constant into a table using a column list.
Here is a simple query that inserts blanks instead of the constant.
insert into tmp (cust_id, custname) select cust_id, 'bob smith' from cust
I'm having a brain freeze and can't seem to figure out why I can't insert a
constant into a table using a column list.
Here is a simple query that inserts blanks instead of the constant.
insert into tmp (cust_id, custname) select cust_id, 'bob smith' from cust table
It inserts the cust_id but
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Burton wrote:
> [EMAIL PROTECTED] wrote:
>
>
>>Wouldn't it make better sense to build on the NDB protocol and keep
>>the native messaging infrastructure than it would be to build a
>>similar wrapper from scratch? I mean to use the NDB commun
We have a client-side load balancer, as well as a central load balancer
for mySQL traffic. I've done many different models at a variety of
companies, all which still use the solutions. Building on top of the NDB
protocol would take a very long time to produce-a HA solution native to
mySQL, when oth
You guys have been so helpful with this, I'm hoping that I can ask for
one more favor...
The reason I needed the greatest(max()) functionality, was to run the
following query...I can make it work from the command line, but
everytime I run it from PHP, the MySQL service shuts down, and needs
to be
[EMAIL PROTECTED] wrote:
Wouldn't it make better sense to build on the NDB protocol and keep
the native messaging infrastructure than it would be to build a
similar wrapper from scratch? I mean to use the NDB communications on
top of regular MySQL
Biting off an NDB migration would be a L
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/01/2005 02:31:54 PM:
> I'd love to get some feedback here:
>
> > MySQL currently falls down by not providing a solution to transparent
> > MySQL load
> > balancing. There are some hardware solutions but these are expensive
and
> > difficult to config
Frank Schröder wrote:
The thing that's really a headscratcher for me is why its possible for
me to set a name for a constraint if it isn't displayed in an error and
I can't get to it. It's useless.
Same as setting a name for an index -- it allows you to alter or delete it
later.
--
Keith Iv
I'd love to get some feedback here:
MySQL currently falls down by not providing a solution to transparent
MySQL load
balancing. There are some hardware solutions but these are expensive and
difficult to configure. Also none of them provide any information
about the
current state of your MySQL
[EMAIL PROTECTED] wrote:
Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constr
Thanks.
On 6/1/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Scott Klarenbach <[EMAIL PROTECTED]> wrote on 05/27/2005 06:57:19
> PM:
>
>
> > -- How is 'xFxIxExLxDx1x' easier to search than 'FIELD1'?
> >
> > It's not easier. It is; however, accurate for the purpose at hand.
> > FIEL
Hi!
InnoDB is the MySQL table type that supports foreign key constraints,
transactions, two-phase commit in XA, row-level locking, non-locking
consistent read (MVCC), all four SQL-1992 isolation levels of transactions,
multiple tablespaces, asynchronous unbuffered disk I/O on Windows, and a
n
Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 01/06/2005
17:13:25:
> Hello all,
> My question is if unix Epoch time started on January 1st 1970 ,and
> mysql uses
> the same implementation of time , what is the logic mysql developers
have
> used to offset it by 30 odd years that is the max
Hi,
try this :
mysql> select * from users;
++--+-+
| userID | username | realname|
++--+-+
| 1 | toto1| toto1 toto1 |
| 2 | toto2| toto2 toto2 |
| 3 | toto3| toto3 toto3 |
| 4 | toto4| toto4 toto4 |
+---
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and mysql uses
the same implementation of time , what is the logic mysql developers have
used to offset it by 30 odd years that is the max date for mysql is 2068 and
not 2038 18th January, i work in a Financial services f
<[EMAIL PROTECTED]> wrote on 06/01/2005 11:49:35 AM:
>
> I have two tables, cutting out the extra stuff they boil down to:
>
> users:
> userID int,
> username varchar(11),
> realname varchar(40)
>
> logins:
> ID int,
> lastLogin timestamp
>
> So, what I am doing is:
> select user.id, username
I have two tables, cutting out the extra stuff they boil down to:
users:
userID int,
username varchar(11),
realname varchar(40)
logins:
ID int,
lastLogin timestamp
So, what I am doing is:
select user.id, username, realname, lastLogin
from users left join logins on users.id = logins.id
group
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
> Just curious - was there a 5.0.5-beta release? The last beta I had
> was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
Well I sent this message to both the mysql mailing list and this perl
list, because I am using perl to accomplish this, and mysql to talk to.
But anyway, thank you very much your number 3 EXACTLY fixed my issues, so
the person with the right answer contacted me.
Again, thank you very much for yo
On Wed, 1 Jun 2005 10:40:10 -0500
Josh Trutwin <[EMAIL PROTECTED]> wrote:
> On Tue, 31 May 2005 18:01:48 -0500
> Matt Wagner <[EMAIL PROTECTED]> wrote:
>
>
>
> > This is the third published Beta release in the 5.0 series. All
> > attention will now be focused on fixing bugs and stabilizing 5.0
On Tue, 31 May 2005 18:01:48 -0500
Matt Wagner <[EMAIL PROTECTED]> wrote:
> This is the third published Beta release in the 5.0 series. All
> attention will now be focused on fixing bugs and stabilizing 5.0 for
> later production release.
Just curious - was there a 5.0.5-beta release? The last
look at automatic character set conversion
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
mathias
Selon [EMAIL PROTECTED]:
> Salut,
> i don't see what doesn't work ! Where characters are replaced by ?, since you
> say that insert,select and import work fine ? is it in the expo
Salut,
i don't see what doesn't work ! Where characters are replaced by ?, since you
say that insert,select and import work fine ? is it in the export ?
see http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html for migration.
Mathias
Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
> Voilà,
Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM:
> Hello,
>
> I have an InnoDB table running on MySQL 4.1.11 with multiple FK
> constraints. I'm accessing it via JDBC from Java.
>
> When an FK constraint fails with error 1216 I need to know which of the
> constraints failed.
>
Great!! Thx
I looked into the manual and the refer to the create syntax concerning
auto_increment.
The one thing I did not get was the fact I have to 'recreate' the column
definition and can not just add something to it.
It works great now!
The for the effort of replying :)
Greetings,
Reinhart Vi
Reinhart Viane wrote:
Hey list,
I need a query that checks if a certain table column has type auto-increment
If not set it to auto increment, else do nothing.
Let's say I have the table objects (object_id, object_name) in which
object_id is the primary field.
Now check to see if object_id is
You can use joins instead of subqueries if you cannot upgrade to 4.1.x of
mysql.
Actually in my opinion joins are more efficient than subqueries. Subqueries
(more often than not) tend to become bottlenecks in the long run..
http://dev.mysql.com has a some reference material about converting
su
Hi!
I've need to find the largest blobs in a table but I seem not to be able
to figure out what it is. Could anyone please help me with this?
Regards
Roland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
We have the following problem.
Cluster means "table 'TABLENAME' is full"
We have 11076890 rows in this table.
Where is the limit defined ?
Disk are Not full. RAM not full too.
Table engine is "NDBCLUSTER".
Can anybody help ?
---
Powered by: T-Systems Multimedia Soluti
Wrong forum for MySQL but you're getting the error because unless you created a
view/table for "all_tables" then it doesn't exist. I suspect you're trying to
use the view "USER_TABLES" or "DBA_TABLES" (if you have the GRANT to view that
DBA view.
[EMAIL PROTECTED] wrote:
>ALL,
>
>
>
>Can so
> Is it possible to update all my encoded data with another password?
Yes. Example for the encoded/decode functions:
UPDATE table
SET pass_colum = encode(decode(pass_column, old_password), new_password);
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I think I have found the solution for my problem. I made the following
changes:
-> I added a new field RecordID in GroupMemberInfo to make the records
unique
-> Instead of MemberID and GroupID, I'm now using MemberName and GroupName.
I made this change since in Active Directory every name is uniqu
Scott Klarenbach <[EMAIL PROTECTED]> wrote on 05/27/2005 06:57:19
PM:
> -- How is 'xFxIxExLxDx1x' easier to search than 'FIELD1'?
>
> It's not easier. It is; however, accurate for the purpose at hand.
> FIELD1 isn't completely inclusive...it would miss FIELD-1...
>
> -- However, It seems to m
Voilà,
Everything works fine: insert, select and importing. I have always the same
text:
'Ceci est un test en Français'
So what could be the problem ? and how to recover foreign characters ?
Thanks
Roberto Jobet
> i mean :
> if you launch :
> into into table (toto) values ('Ceci est un test
Hi,
I'll try even if this is not a neither oracle nor perl-dbd list.
1. verify that NLS_LANG is correct in your client env (and all the other ORA
vars)
2. verify the query is simply quoted (" needs \_ for _)
3. Put all oracle variables in BEGIN {ORACLe_HOME=""}; in the perl script
4. verify that s
Hi,
I downloaded and tried to install from the sources.
./configure, make seem ok, however the make install exit very quickly with
an error code 127 (perror gives "record-file is crashed", no idea of what
that means!).
My "old" 5.0.4 istall is working fine, so I don't think the system is in
Hey list,
I need a query that checks if a certain table column has type auto-increment
If not set it to auto increment, else do nothing.
Let's say I have the table objects (object_id, object_name) in which
object_id is the primary field.
Now check to see if object_id is auto_increment a
ALL,
Can someone help out with this error:
DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication
protocol error (DBD ERROR: error possibly near <*> indicator at char 23 in
'select table_name from <*>all_tables') [for Statement "select table_name
from all_tables"] at ./orac
i mean :
if you launch :
into into table (toto) values ('Ceci est un test en Français');
then :
select toto from table;
can you read it correctly ? And if the same row is imported, is there any
difference ?
A bientôt
Mathias
Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
> Salut,
>
> je vois q
Hi,
Here is the table in question.
drop table `portfolio1`;
CREATE TABLE `portfolio1` (
`ccode` varchar(99) default NULL,
`symbol` varchar(99) default NULL,
`transaction_date` date default NULL,
`rate` decimal(11,2) default NULL,
`quantity` int(11) default NULL,
`transaction` enum('buy','sell') d
Salut,
je vois que tu es français, j'aimerai bien continuer en français mais il vaut
mieux en anglais si jamais il y avait quelqu'un avec le même problème ;-)
So what I'm trying to achieve is to have UTF-8 databases in order to support
multilingual content.
But first I have to understand how to
Hi,
Can you send some more output from the MySQL error log (normally located
at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the
tables that are giving the errors? Also you might want to take a look at
http://dev.mysql.com/doc/mysql/en/gone-away.html
On Wednesday 01 June 20
hi,
have you installed php4-mysql ?
look at http://www.coagul.org/article.php3?id_article=169 for example.
Mathias
Selon bruce <[EMAIL PROTECTED]>:
> hi...
>
> trying to build php4 with mysql4.1-12, for use in apache2. i have the
> following "./compile" that works for php5. however, when i try
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following "./compile" that works for php5. however, when i try to use it for
php4, i get a msg, stating that it can't find the MySQL Headers...
can anybody provide any pointers as far as what the Headers are for mysql,
an
hi,
your config supports european charcters :
mysql> select * from tst;
+--+---+
| a| txt |
+--+---+
|1 | Ceci est un test en Français
Hi,
I recently upgraded from 4.0 to 4.1 because of the multilingual support.
But importing the DB dump into the new 4.1 version all foreign characters
(french, spanish, portoguese) have been replaced by ? character...
I've been trying to understand the new "collation" feature but i seems quite
d
Hi,
Is it possible to update all my encoded data with another password?
Thanks for your advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi
as per the online manual, i have configured mysql and able to run the server as
mysqld_safe. but if i want to run mysqld_multi with the following configuration
it doesnt work... the config file is like
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/
In article <[EMAIL PROTECTED]>,
Scott Gifford <[EMAIL PROTECTED]> writes:
> The problem we're seeing is that when additional tables are pulled in
> for the detailed view, the order is different from the summary view,
> so the wrong homes are displayed. Here's a simplified example. A
> summary qu
On 31/05/2005, Lucio Crusca wrote:
> I use mysql 4.0.24 as found in debian gnu/linux sarge.
> mysql> select * from SAMPLES S1 where exists (select * from SAMPLES
> S2 where S1.ID = S2.ID);
>
> ERROR 1064: You have an error in your SQL syntax. Check the manual
> that corresponds to your MySQL ser
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.5.0)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, man
Hello everybody.
I use mysql 4.0.24 as found in debian gnu/linux sarge.
$ mysql -u root
[...]
mysql> use mydb
[...]
Database changed
mysql> select * from SAMPLES S1 where exists (select * from SAMPLES S2 where
S1.ID = S2.ID);
ERROR 1064: You have an error in your SQL syntax. Check the manual t
Mark Ahlstrom wrote:
Here's an odd question for you, how do you become a MySQL DBA?
I've got enough Solaris/Linux Experience under my belt and I was a Jr.
Oracle DBA for a year, which got me really interested in RDBMS. I try
to work with MySQL as much as possible, but I work with one of those
l
Hello,
Each time we run long queries (over around 5 seconds) the mySQL server
fails and restarts (you can see it in the error log that starts with
"Database page corruption on disk or a fail.." and then there is a
dump...) and the query return with "Lost connection to MySQL server
during que
61 matches
Mail list logo
