Restoring a backup of a very large database, I've received an error
message by the server (4.13) about an sql syntax error. I've done the
backup with mysql administrator and I've used the same procedure for
months without problems.
I've discovered that problem is into a blob
field that store lo
Warren Young wrote:
That's why it's possible in the Unix/C world,
Typo: should be "That's why it's _popular_..."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Since there was no reply, I will try once more.
I wish to limit table access and data manipulation strictly through
procedures. Can MySQL 5 offer this?
If a user connects to the db and executes "UPDATE" or "DELETE" it should
not allow it, except by calling a procedure e.g.
"CALL DELETE_USER($u
Marco wrote:
So is there any solution on how I can properly use foreign characters
and store them in a MySQL 4.0 database?
You can store UTF-8 in any database in the world. UTF-8 is compatible
with any application capable of dealing with null-terminated strings of
8-bit characters. That's
Fajar Priyanto wrote:
Well, it's not 5.0.x, it's 4.0.25-standard. I'm not sure how the error appears
in the first place. What I notice when I open the database using phpMyadmin
is that that particular troubled table status is "in use".
I'm allowed to ssh into the server, and hopefully I can s
Hi,
I have a silly questionDUH
Im running OS X Server, I installed 4.018 and I want to run 4.1.13,
how do I upgrade the server, without losing anything ?
Do I just install over it ? Of course backing up all the tables and
what not first ?
Any pointers would be helpful.
Thanks.
M
On Wednesday 10 August 2005 06:50 am, Daniel Kasak wrote:
> A hosting provider running 5.0.x? That's whacky.
> When you say "my access to the shell is very limited", what does that
> mean exactly? Can you ssh in and run the 'mysql' command-line client? If
> you can, then do it, and you should be ab
I need a MySql
solution equivalent to sp_fkeys procedure of Sql Server
2000.
As shown in the
attached file I managed to get most of the part working, but steel searching for
DELETE_RULE and UPDATE_RULE equivalents to programmatically check CASCADE update or
delete.
--
MySQL General Ma
Fajar Priyanto wrote:
This is what I think hit me too, Daniel.
Unfortunately, it's not on my own server (a hosting provider), so my access to
the shell is very limited.
My website is still running, but, I can't export the database using phpMyadmin
anymore, because the troubled table is on th
Timothy Smith wrote:
Hi, Daniel,
First, here's a trick that *should* work for dumping out the data.
Change directory to the MySQL data directory, and then use this little
shell command:
for d in mysql test; do (cd $d; tables=`/bin/ls -1 *.frm | sed -e s,\\.frm,,`;
mysqldump $d $tables); done
asdas wrote:
I am trying to create an index with the following command -
create index an_idx on atable
(acol desc, bcol, ccol)
/
select pk, acol, bcol, ccol from atable
doesn't show the result in descending order of acol, instead it's in ascending
order of acol.
Is there a simple t
It could be a known issue, but thought it's a well known & well used feature
so, asking you all.
I am trying to create an index with the following command -
create index an_idx on atable
(acol desc, bcol, ccol)
/
Then when I do a -
show index from atable
It shows for all indexed colum
Kent Roberts wrote:
Has anyone had experience with this yet? My attempts so far render "ODBC--call
failed". My connection is good and I can use select statements successfully, but no
luck with calling an SP yet. I really want to call an SP with parameters, but I'm trying
a simple one first. A
World-wide Stop Order on PERL,Python,Java: Use Ruby instead
Language is the most critical interface to SQL server like MySQL and
Postgresql.
Carefully select the language for interfacing to MySQL!!
Ruby will be storming the IT world an
Kishore Jalleda wrote:
Explain select gives me this
table type possible_keys key key_len refrows extra
template range PRIMARY PRIMARY4 NULL 55 using where
surpisingly it never runs slow when i run the query manually, also
when this query runs f
Hi i have this error on IBM RS6000 with
AIX 4.3.3
# scripts/mysql_install_db --user=mysql
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following errors:
0509-023
Symbol stpcpy in my_print_defaults is not defined.
0509-023
Symbol isinf in my_print_def
Explain select gives me this
table type possible_keys key key_len refrows extra
template range PRIMARY PRIMARY4 NULL 55 using where
surpisingly it never runs slow when i run the query manually, also
when this query runs for long, mytop or show full
Kishore Jalleda wrote:
Try two things. First:
EXPLAIN
SELECT title, template
FROM template
WHERE templateid IN
(608,2072,2073,1888,1898,1895,1897,1894,1896,1901,1903,1889,1900,1890,1891,1902,1904,2104,648,625,2152,617,1985,1996,646,1964,2103,2106,21
Hi All,
We have a query that sometimes takes 10-15 seconds to run,
atleast thats what mytop or the slow log say, usually it runs in less
than 0.04 seconds
SELECT title, template
FROM template
WHERE templateid IN
(608,2072,2073,1888,1898
> Please, send the output of the following statement executed both on
> master and slave:
>
> show variables like '%char%';
mysql> show global variables like 'c%';
+--++
| Variable_name| Value |
+-
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/09/2005 01:52:58 PM:
>
> All,
> Could you tell me how to import data (file.txt)with BLOB column to
mysql?
>
> Thank you
>
> Nguyen
>
>
The "short answer" is: you escape the content of the file and make one big
INSERT statement out of it. The e
All,
Could you tell me how to import data (file.txt)with BLOB column to mysql?
Thank you
Nguyen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multi Table UPDATES are first supported in 4.0.x
-Original Message-
From: Brendan Gogarty [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 12:16 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: JOIN QUERY -> UPDATE ... help?!
"Brendan Gogarty" <[EMAIL PROTECTED]>
Brendan Gogarty wrote:
> We are running mysql 3.23.58 and I want to do a query with joins
> from two tables and then insert the results into the column of a third.
Shawn Green wrote:
Start from here:
http://dev.mysql.com/doc/mysql/en/update.html
Updates *are* allowed to use JOINED tables a
This is what I think hit me too, Daniel.
Unfortunately, it's not on my own server (a hosting provider), so my access to
the shell is very limited.
My website is still running, but, I can't export the database using phpMyadmin
anymore, because the troubled table is on the first list of tables.
D
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
C.F. Scheidecker Antunes wrote:
> Hello,
>
> Can anyone tell me what to do in order to use transactions on a java
> application? Is there any howto regarding this issu?
>
> Thanks,
>
> C.F.
>
C.F.
First, make sure you're using the InnoDB storage
"Brendan Gogarty" <[EMAIL PROTECTED]> wrote on 08/09/2005
05:30:51 AM:
> Hi,
> We are running mysql 3.23.58 and I want to do a query with joins
> from two tables and then insert the
> results into the column of a third. This appears to be harder than I
> realised with this version of mysql a
Thanks Shawn. I'm actually trying using Access's Pass-Through Query
technology
which utilizes ODBC. I'm not sure if it's ADO or DAO. I'll guess ADO
since
that's the default for this version of Access (2002). I haven't tried
connecting in code yet, but that's coming soon. I've had a lot of
experienc
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 12:24:11 PM:
> Has anyone had experience with this yet? My attempts so far render
> "ODBC--call failed". My connection is good and I can use select
> statements successfully, but no luck with calling an SP yet. I
> really want to call an SP
Hi Gleb,
This is what I have using SHOW PROCESSLIST:
Waiting for tableSHOW TABLE STATUS FROM `db_mambo` LIKE 'mos_TFS_visits'
Help me pls, is there any way I can save this database? Looks like the
troubled table is mos_TFS_visits.
Thanks,
Fakar
On Monday 08 August 2005 03:59 pm, Gleb
It might help if I mention my syntax is:
call spTestingStuff();
From: Kent RobertsDate: August 9 2005 6:24pm
Subject: Calling Stored Procedures with MS Access Pass-Through Queries
Has anyone had experience with this yet? My attempts so far render =
"ODBC--call failed". My connection is good an
Has anyone had experience with this yet? My attempts so far render "ODBC--call
failed". My connection is good and I can use select statements successfully,
but no luck with calling an SP yet. I really want to call an SP with
parameters, but I'm trying a simple one first. Also, anyone know of a f
Now that I think about it, if MySql forced declaration of session
variables it
would avoid some nasty bugs in SPs.
>>> Mark Matthews 08/09/05 08:46AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
> I have a simple SP that is selecting rows based on a date range using
param
Sorry, I'll try and proof reed more karefullly in the futchure. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That's it. Thanks Mark. I think I was confusinged by MS SQL Server
syntax
which prefixes both session variables and parameters with @. And you're
right
Scott, I changed the name of the SP for posting simplicity and forgot to
change the colling statement to match. Thanks a lot both of you for
gettin
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:42:24 AM:
> I have a simple SP that is selecting rows based on a date range
> using parameters. I've tried several permutations that all return 0
rows.
>
> The select statement looks like this:
>
> select * from 'mit_log'.'mitlog' where
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
> I have a simple SP that is selecting rows based on a date range using
> parameters. I've tried several permutations that all return 0 rows.
>
> The select statement looks like this:
>
> select * from 'mit_log'.'mitlog' where St
Hello.
Please, send the output of the following statement executed both on
master and slave:
show variables like '%char%';
Send the definition of your table as well:
SHOW CREATE TABLE sum_day_key_requests;
Marco P$hler <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I try to repl
I have a simple SP that is selecting rows based on a date range using
parameters. I've tried several permutations that all return 0 rows.
The select statement looks like this:
select * from 'mit_log'.'mitlog' where StartDateTime between '2005-04-01' and
'2005-04-07'
and returns over 300,000 ro
Hi there,
What is the purpose of this GRANT statement?
GRANT CREATE ON TO [EMAIL PROTECTED];
eg:
GRANT CREATE ON address TO [EMAIL PROTECTED];
It's possible, but what is it supposed to do?
I can understand this grant on a global (server) and database
level, but on a table level?
With regards
Am Dienstag, den 09.08.2005, 17:57 +0400 schrieb Alexey Polyakov:
> If charsets/collations are not set explicitly in my.cnf, server could
> be using ones specified during compilation.
> To check charsets and collations on the running server do:
> show global variables like 'c%';
Thanks.
I execute
> The only idea, which came into my mind, is that the server use different
> default charsets or collations. I checked the configurations and can't
> find a difference. Is there a possibility to check the default charsets
> and collations on the running server ?
If charsets/collations are not set
Hi,
I try to replicate an existing database to a new server and run into
trouble with collations. Maybe somebody can help me.
Existing DB-Server (Master):
MySQL Version 4.1.12
ca. 100 GB Database size.
New DB-Server (Slave):
MySQL Version 4.1.12
Here is what I did to get the replication up and
"Brendan Gogarty" <[EMAIL PROTECTED]> wrote on 08/09/2005
05:30:51 AM:
> Hi,
> We are running mysql 3.23.58 and I want to do a query with joins
> from two tables and then insert the
> results into the column of a third. This appears to be harder than I
> realised with this version of mysql a
suomi <[EMAIL PROTECTED]> wrote on 08/09/2005 03:07:11 AM:
> Hi every
>
> probably silliest question ever posted:
>
> we are running mysql on serveral hosts and sometime it is important to
> know, which host is the mysql server you are connected to.
>
> this is not a session nor a global varia
Enrique Sanchez Vela <[EMAIL PROTECTED]> wrote on 08/09/2005 12:46:44
AM:
>
>
> --- Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > I'm new in database development, and has been
> > wondering if anyone can
> > suggest a good reporting tool that will help me
> > generate graph
I am doing a LEFT OUTER JOIN between 2 MySQL tables in Crystal Report
Designer for a subreport. However, whenever I try to use a field from
othe joined table I get the 'Failed to open rowset' message. How can I
solve this problem?
--
MySQL General Mailing List
For list archives: http://lists.my
Hello.
You can determine the address of the server using 'status' command:
mysql> status
--
mysql Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686)
Connection id: 532284
Current database:
Current user: [EMAIL PROTECTED]
SSL:Not in use
Hello.
> State: Sending data
MySQL server shouldn't spend several days in state of sending one row (your
query should return only one row :) to the client. Server doesn't work
properly and steps like upgrade or switching to the official binaries
might be helpful.
>
> The query h
Hello.
Nothing mentioned at:
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
So, in my opinion, the length of your AGAINST clause is limited by the
max_packet_length. But you should strongly think about the performance
of FULLTEXT searches with long search condition. From m
Hello.
MySQL doesn't support Windows 98, and it's (Windows 98 certainly) design
isn't enough secure. There're no file system which has support for
file permissions. Upgrade to the fresher Windows (2k, XP,
2003) will allow you to solve this issue by protecting 'mysql' database
from replacemen
Hello.
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
http://dev.mysql.com/doc/mysql/en/moving.html
http://dev.mysql.com/doc/mysql/en/backup.html
"Eric Dahlenburg" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am currently a student learning SQL. I have MySQL 5.0 installed at
Hi,
We are running mysql 3.23.58 and I want to do a query with joins
from two tables and then insert the
results into the column of a third. This appears to be harder than I
realised with this version of mysql and I am banging my head against a
wall. Please Help!
ok first query.
--
Hi Mattijs,
Am Montag, den 08.08.2005, 14:56 +0200 schrieb Matthijs van der Klip:
...
> Linux 2.4 and 2.6 kernels have a setting for their overcommitment
> behaviour under /proc/sys/vm/overcommit_memory. The different settings
> are:
...
> For now I've set this to '2' which means the kernel won'
Hello.
> I have noticed that since the update i have multiple instances of mysql
> running which seem to be causing the problem ps uax output below
I usually see a lot of mysqld processes (these are
just different threads of the same process), and I don't see anything
wrong with it:
[
Hello.
If you send your configuration file there might be much more
suggestions. In my opinion SET AUTOCOMMIT=0 before update should
improve performance (don't forget to COMMIT after transaction).
If you're sure in your data you can SET FOREING_KEY_CHECK=0
and SET UNIQUE_CHECKS=0. See:
h
Hello,
If the clients and servers are both Windows systems, then you might want
to try the following script. You need administrator rights for it on the
network and the server must be running as it tries to retrieve a running
process from the server. I am not sure if there is another way and it
on
Hi every
probably silliest question ever posted:
we are running mysql on serveral hosts and sometime it is important to
know, which host is the mysql server you are connected to.
this is not a session nor a global variable, there is no show statement...
what is it else? how to ask a mysql cl
58 matches
Mail list logo
