re a
table is full based on the number of rows and the Create_time. We have
far too many tables to just alter them all in one sitting so we do them
as needed.
Thanks.
--
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TER STATUS to
get the log file position at the time of your snap shot. When you set
up the slave you can provide the log file position or, if you RESET
MASTER, you can set MASTER_LOG_FILE='the_name_the_log_file' and
MASTER_LOG_POS=4, which is the default start position for a fresh binary
log.
Here is some good reading:
http://dev.mysql.com/doc/mysql/en/replication.html
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
Best of luck to you.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jim Grill <[EMAIL PROTECTED]> wrote on 02/18/2005 03:17:39 PM:
Hi,
I need some SQL guru help on this one.
I'm trying to re factor an existing application where a number of clicks
grouped by keyword for two different time periods are needed. For
example, a user picks a date ra
++---+
I'm using MySQL 4.1 so perhaps some of the new features might help. ???
Thank you for the help!
--
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
consisting of up to a few months worth of data at a time.
Thanks,
Jim Grill
that will shed some
light on the subject.
Jim Grill
> yeah, I seen that have. Have you tried that before? I need to do it
> two-way. But have not seen any special setup for that. Each site
> will be entering data and all sites will need to see the updated
> change.
>
>
> O
).
Do a little research to find out if your locking is working.
>
> Only one idea: sometime 'update' query dont work(or work, but dont
> return good result), and 'insert' query started... But WHY?
Again, I would look at your logic and try to use REPLACE or INSERT ... ON
DUPLICATE KEY UPDATE.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for better performance.
It's really tough to speculate. Every system administrator would probably do
it a different way.
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
> Hola ,
>
> Estoy empezando a notar intentos de ingreso con usuarios ilegales
> no existentes) a mi server.
>
> Mi pregunta es : Como lo rastreo teniendo como unico dato el numero de
> ip desde el cual se esta conectando?
>
> O si alguien tiene una mejor idea o ha pasado por lo mismo,
> le a
#x27;');
and then...
SELECT * FROM sometable;
+--+--+
| name | what |
+--+--+
| Ed's | 'Pizza' |
+--+--+
The slashes never actually get inserted into the table so there is no need
to call strip_slashes() on the results either. :-)
Jim Grill
47 14450 13 2004-09-09
>
>
> Is there a way in which I can make sure I get always the oldest row?
>
Try adding something like ORDER BY d DESC LIMIT 1
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
life (how lucky). I'm not too sure how safe this
idea is and I'm sure that some unnecessary overhead is introduced by testing
for live connections all the time.
My best advice to you is to set up a few servers and start testing.
Replication is not at all hard to accomplish.
Be
started feeling any kind of confidence with MySQL.
Although I have not taken the exam, I am feeling pretty confident that I can
pass after reading the online manual and the study guide from front to
(almost) back. I hope I'm right about that feeling!
Wish me luck :-)
Best of luck to
me,1)),SUBSTRING(name,2)) FROM testing;
:-)
There might be a better way to do this too??? I do agree that you should
probably handle this with simpler functions in your app like php's
ucfirst().
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
native would be to use mysqdump with -T option and use the
options --fields-terminated-by=, --fields-enclosed-by=, --fields-optionally-
enclosed-by=, --fields-escaped-by=, and --lines-terminated-by= to make a csv
file. You can use BCP or MS DTS to load a csv into sql server tables. There
may be another
reates
a tab delimited dump file. That would be a cool option though. :-)
There are a number programs that can assist with converting to and from MySQL if
that's the goal.
Regards,
Jim Grill
- Original Message -
From: [EMAIL PROTECTED]
To: Jim Grill
Cc: Monet ; mysql
S
tes and
not string delimiters. They do not actually get inserted into your table
with the slashes.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ell at me. I've been studying for
the MySQL certification and this is covered in the first chapter of the
study guide. :-)
Regards
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
; b) for a phone number of 99, format the output as 999-999-
> Hints?
Here are some hints. :-)
a) http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
b) http://dev.mysql.com/doc/mysql/en/String_functions.html
Regards,
Jim Grill
--
MySQL General Mailing Li
27;t exist
>
> This shows the table is there though.
>
> mysql> show tables;
> ++
> | Tables_in_spamtool |
> ++
> | spamdata |
> ++
> 1 rows in set (0.00 sec)
>
Try doing 'desc spamd
m/doc/mysql/en/Option_files.html
You can change the location of mysql.sock a few different ways.
1) Add "socket=/path/to/mysql.sock" without the quotes under the [mysqld]
and [client] sections of your my.cnf file.
2) Specify it when starting the server like
mysqld_safe --socket=/path/to/
re option:
--with-unix-socket-path=/path/to/mysql.sock
Make sure that the directory is owned (or at least writable) by the user
that MySQL runs as or you will get the dreaded "MySQL ended" errors when
starting the server.
Regards,
Jim Grill
--
MySQL General Mailing List
For l
arly 2003) I'd say that Gamma is more than safe enough to use in a
production environment.
Regards,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mes but th elast time
> was over a year ago.
>
> Any ideas?
>
> Thanks!
>
> Nestor :-)
> http://www.IneedWork.org
>
How about some more info. Did you install PHP from source or an RPM? Did you
configure PHP --with-mysql or --with-mysqli? Did you install MySQL after you
install
http://www.catb.org/~esr/faqs/smart-questions.html
Stop repeating the same question or you will never get an answer. Try again
please.
> Hi
>
>
> I have installed some software on aix5.2 .
> the list of software:
> apache-1.3.29-1.aix4.3.ppc.rpm
> php-4.0.6-5.aix4.3.ppc.rpm
> MySQL-3.23.47-3.aix
09-14
>
Sounds like a permissions problem. Make sure the data directory is owned by
the user that mysqld runs under. Usually `chown -R mysql /var/lib/mysql`
will do the trick.
The error: "Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)" is due to
ield names.
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
Backtics can also be useful to avoid SQL injections if an application your
working on requires table names or field names to be supplied from user
input (always a bad idea) like a select box.
Jim Grill
--
MySQL General Ma
ysqldump" or see
http://dev.mysql.com/doc/mysql/en/mysqldump.html
The "--add-drop-table" will add a "DROP TABLE IF EXISTS tablename" to your
script before creating and populating the tables. This is useful when
restoring a possibly corrupt table.
Jim Grill
--
MySQL General
e you forgotten the
password?
The default port is 3306
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mcpu=pentiumpro \
-felide-constructors -fno-exceptions -fno-rtti" \
./configure --your options here
change "-mcpu=pentiumpro" to suite your system (i386, i486, i586, i686,
pentium, pentiumpro, k6, or athlon).
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ause or some other
> SQL magic?
>
> Dean
>
This is not meant as an "rtfm", but this helped me in the past.
http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a similar problem.
The only part that I am unsure of is using COUNT inside an IF.
SELECT parent.id, parent.name, IF(child.parent_id IS NULL, 'none',
COUNT(child.parent_id)) AS child_count
FROM PARENT INNER JOIN CHILD ON parent.id=child.parent_id
GROUP BY parent.id;
Jim Grill
--
MySQL
include the possibility that some esoteric
communication problems between Navicat and MySQL caused the problem to begin
with, which brings me back to my first thought.
Best of luck to you,
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
cate value];
This will show you how many dups there are... so let's say there were 7...
DELETE FROM table WHERE id=[your duplicate value] LIMIT 6;
Now you have one left.
I hope that helps.
Jim Grill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
34 matches
Mail list logo
