Hello.
I've been able to insert Russian characters (utf8) through the
QueryBrowser under Linux (FC4). Please, could you provide CREATE
statement for you table and output of:
show variables like '%char%';
As far as I know, QueryBrowser invokes SET NAMES 'utf8' by default.
And the only
Hello.
Please, I don't need comments telling me that I'm missing the semicolon
or that comments such as doesn't work are worthless. I know there's
something inherently wrong with this query (obviously . . . since it
doesn't give me the results that I am looking for). Does anyone havea
Hello.
For such an old version of MySQL use --set-variable syntax.
See:
http://dev.mysql.com/doc/refman/4.1/en/program-variables.html
I'm not sure if it supports dynamic system variables through the SET
syntax, according to the manual they have appeared in 4.0.3. In the future,
instead
hello,
i have a database in mysql i want to restore the backup server every 15
minutes if i take a backup in sql its huge and my transfer cost of the data
will be very high can anyone suggest how to restore the data in small size
regards
prao
--
MySQL General Mailing List
For list archives:
prathima rao wrote:
hello,
i have a database in mysql i want to restore the backup server every 15
minutes if i take a backup in sql its huge and my transfer cost of the data
will be very high can anyone suggest how to restore the data in small size
regards
prao
time to think about
Thanks! I will try the -set again to see if it works.
I seem to remember that was the first one I tried and
had no luck. I might have had the wrong syntax. I will
try again tomorrow morning and see how this works. I
am pushing the users to upgrade to 4.1 for now and
then 5.x when the dust
Alex Gemmell wrote:
Thanks Micheal - yeah, I managed to figure out the CREATE_TMP_TABLE
privilage problem myself.
I should have used those die on errors too - will do next time!
To recap here's the working final solution (after MySQL User has
CREATE_TMP_TABLES and DROP privilages):
[PHP]
Gleb,
What I need to have is a total of 16 columns: issue ID, priority,
assigned (to), project name, category, status, last update date,
summary, product name, project name (not the same as before), change
requester, change type, requested completion date, lead, developer,
impacted dept.
I have
I see it!
Tito, you have to pivot those fields out of your custom fields/custom
field values table(s). One of the best places to do that is into a
temporary table so that you can join your pivoted rows into the rest of
the report. I am assuming that the `eventum_custom_field` table has a
Hi,
I'm having a problem with subqueries in MySQL 4.1.14 running on Fedore
core 3.
mysql create table day_6_12_2005 (f1 int(1), f2 char(4));
Query OK, 0 rows affected (0.04 sec)
mysql insert into day_6_12_2005 values(1,'test');
Query OK, 1 row affected (0.00 sec)
mysql select * from (select
Hello.
will be very high can anyone suggest how to restore the data in small
size
Have you thought about using binary logs or compressing the sql file?
prathima rao wrote:
hello,
i have a database in mysql i want to restore the backup server every 15
minutes if i take a
Hello.
So it is clear now, that you should have 16 columns and to build
dynamically the column headings. The usual way to do such things
in SQL is prepared statements. See:
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
And good example of how to use them (though it is an article
Andrew Braithwaite [EMAIL PROTECTED] wrote on 12/06/2005 11:34:50
AM:
Hi,
I'm having a problem with subqueries in MySQL 4.1.14 running on Fedore
core 3.
mysql create table day_6_12_2005 (f1 int(1), f2 char(4));
Query OK, 0 rows affected (0.04 sec)
mysql insert into day_6_12_2005
*shrug* Livejournal uses MySQL just fine:
http://www.danga.com/words/2004_mysqlcon/mysql-slides.pdf
I dare say livejournal has more writes and is more real-time than friendster.
MySQL Cluster isn't a bad solution, just remember that you need
machines with LOTS of memory -- 'cause that's where
Shawn, Glen, and everyone else,
Thank you very much! I do believe that I have enough material to work
on it now!
I appreciate your help very much!
Joseph Tito Kraer
Business Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL
[EMAIL PROTECTED] wrote:
Responses intermixed. See below...
untz [EMAIL PROTECTED] wrote on 12/02/2005 10:43:41 PM:
snip
3. After logging into mysql, I created the following database:
mysql create database music_development to 'untz'@'localhost'
identified by 'paintball';
MySQL
Octavian Rasnita wrote:
From: Daniel Kasak [EMAIL PROTECTED]
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
Yes you can insert those
hi there.
1st time posting to this list (and although i know linux, libraries linking is
above my level slightly as yet) so apologies if this is a case of rtfm but i
can't find a clear definition on this subject.
I want to run Postfix with Mysql support for aliasing etc. I installed postfix
with
Gleb Paharenko wrote:
Hello.
I've been able to insert Russian characters (utf8) through the
QueryBrowser under Linux (FC4). Please, could you provide CREATE
statement for you table
CREATE TABLE `WebNewsPostings` (
`PRID` mediumint(8) unsigned NOT NULL auto_increment,
`MyStamp` timestamp
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tool:
Database Workbench 2.8.0 has been released today!
Download a trial at: http://www.upscene.com
What's new?: http://www.upscene.com/products/dbw/whatsnew.htm
Full list of
At 11:23 PM 12/5/2005, you wrote:
Hi ALL,
We are planning to create a social software similar to friendster
and Im
working on the requirements... I saw a site:
http://philip.greenspun.com/teaching/6171/2003-fall/friendster
and for some reasons its telling me not to use
I'm sorry, I' just gotta interject.
800 hits/second is not that big of a deal.
I've got a client running an affiliate tracking system across several
high traffic domains. To properly scale this we had to do some testing.
Using a Dell 2800 w/2GB of RAM and a single HD (not the greatest
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt but
doesn't matter
23 matches
Mail list logo