Hi,
In backup directory
cat *.sql | mysql -u root -p database
*
and
*Use import which is given below*
*
Dilipkumar wrote:
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key wa
Hi all,
I am trying to install syslog-ng + phpsyslogng in Linux box. Syslog-ng is
working properly. It pipes all the log messages to a pipe file mysql.pipe in
sql statement format.
But now the problem is mysql can not read from the pipe file. When I give
the command:
$ mysql -u sysloguser -p
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key was found, keep old row)*_
VenuGopal Papasani wrote:
hi all,
I have got a problem.I have data entered in different machines in
Hi,
If you "open" a table using,
HANDLER tablename OPEN;
and then (in another MySQL command windows), execute,
flush tables with read lock;
The flush tables "hangs" until you execute a
HANDLER tablename CLOSE;
command.
Is this a bug? Can anyone explain this?
Many Regards,
Ian Collins.
-
hi all,
I have got a problem.I have data entered in different machines in a
database now i have got all the data in different .sql files.Now i was
importing the same files in order to merge them in a same
database.Herethere was a problem in merging, There were some tables
which does´not change
th
In the last episode (May 18), Jim said:
> Is there any way of getting the max_allowed_packet setting via a SQL
> statement?
mysql> SHOW VARIABLES LIKE 'max_allowed_packet';
++--+
| Variable_name | Value|
++--+
| max_allowed_packet |
Hi All,
Is there any way of getting the max_allowed_packet setting via a SQL
statement?
Eg.
select version(); returns the version and need to do same for
max_packet_size.
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 17, 2006 9:10 AM
Subject: Re: Baffled by query error syntax
Mike,
I ca
Mike,
I can't really help except to ask if you're sure you copied and pasted
the query correctly. I did a similar query against a test system:
select u.uid,u.username,b.buddyUid,SEC_TO_TIME(SUM(TIME_TO_SEC(u.modified)))
as mins from Users u left join BuddyList b on u.uid = b.uid where
u.modifie
The short answer is "in the config file." The long answer is to read:
http://dev.mysql.com/doc/refman/4.1/en/log-files.html
Or whatever manual version is appropriate to your MySQL version.
-Sheeri
On 5/17/06, Peng Yi-fan <[EMAIL PROTECTED]> wrote:
Hi everyone,
How to change the log file pat
BTW, I found a way to get the data restored. If I run the MySQL command
prompt and do Source //risa/backup/data/fccamp.sql; it executes the SQL in
the back up file, and seems to restore all of the data. Why the MySQL
Administrator doesn't work is beyond me. I would rather that it does, but I
do
Hello,
this is a continued problem we are having from a earlier posting to the list
regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to the
manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-type-overvie
Hi everyone,
How to change the log file path of a database. I am using Window XP OS.
Thanks.
Peng
I'm doing a little something for the earth, and I thought I'd invite
you to join me:
http://friends.earthscreen.com/?r=ESF0R3gGdhFSBmcNCyIH&i=gmail&[EMAIL
PROTECTED]&p=2&z=1&tc=11
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
14 matches
Mail list logo
