[EMAIL PROTECTED] wrote:
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
Hi -
Please see http://dev.mysql.com/doc/refman/5.0/en/truncate.html
Thanks
-dant
--
MySQL General Mailing List
For list archives: h
Mikhail Berman wrote:
Hi Ravi,
If you are working with one of *NIX, you can try to use
$mysqldump --no-data DB1 tblname | mysql DB2
--no-data switch will dump only data base structure
Regards,
Mikhail Berman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:
Dilipkumar wrote:
Hi everybody
I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to create all the table as ndb but when comming to
the import i am not able to import 20 lakhs of record for a table.please help to solve the problem .
Any suggestions?...
Hi -
D
Dan Buettner wrote:
Dan T -
Well, if all your data files are MyISAM, then I only see one potential
problem, and that is the area of user permissions. I believe that
things in that area have changed around enough that if you simply
re-use those tables as-is (as-are?), you may have some difficult
d them again from inside the mysql client by using the
"source" command.
Dan Trainor wrote:
> Hi -
>
> I know we've rolled this around the list a few times, but I was
> wondering if there's been any real development on the subject
lately. I
> know half of you are
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2 things.
1) if i would like to take mysql incremental backup weekly
cp /var/lib/mysql/ /backup/mysqlbak/
how can i do it by above command as i would like to run cron weekly
for take mysql backup.
i would like to take backup using
Hi -
I was wondering if there was a way to have a less verbose --log. All I
want to see is connects, disconnects, and if they're successful or not.
The reason I ask is because this server runs thousands of queries a
minute, and I'd rather not log *all* data for reasons of performance
degrad
d them again from inside the mysql client by using the
"source" command.
Dan Trainor wrote:
> Hi -
>
> I know we've rolled this around the list a few times, but I was
> wondering if there's been any real development on the subject
lately. I
> know half of you are
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support authent
Hi -
I know we've rolled this around the list a few times, but I was
wondering if there's been any real development on the subject lately. I
know half of you are saying "Forget it... go with a newer version and
get over it", and I'd really really like to, but i have a lot of data
store under
Good morning, all -
I've read for quite a while tonight, but still haven't been able to
figure out - can I upgrade directly from 3.23.58 to 5.0.22?
I've read that I'd have to do something like 3.23.58 > 4.0 > 4.1 >
5.0.22, but then also the 'mysql_upgrade' application which, as
documented, s
Anthony Ettinger wrote:
i actually don't have anything valuable in my database, it's on my
home pc. I upgraded with the standard procedure.
On 6/17/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Anthony Ettinger wrote:
> I just upgraded to mysql 5, and can't restart the da
Anthony Ettinger wrote:
I just upgraded to mysql 5, and can't restart the daemon.
060617 11:57:22 [Warning] No argument was provided to --log-bin, and
--log-bin-index was not used; so replication may break when this MySQL
server acts as a master and has his hostname changed!! Please use
'--log-
Atle Veka wrote:
Replicating a live setup, especially one running on the web is extremely
difficult if not near impossible. Assuming you don't have the freedom to
stop/start your mysqld for tuning/tweaking, here are some things you can
do:
- Enable slow-query-log
- Enable query log
- Query proces
Jake Peavy wrote:
On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [sem
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was
mething similar can match the quality and functionality of MySQL's
Administration and Query Browser software, I can definitely see this
being a great product.
Regards
-Dan Trainor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
AndrewMcHorney wrote:
Hello
I understand that there is a free gui that will allow an administrator
or user to create databases and maybe even add, update and modify rows
in tables. It is something like MySQL Controller. Does this still
exist and what is the link?
Andrew
Hi -
MySQL Quer
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
>
to cluster the database on application level (use
server userID%numServers), which would be a [insert favourite non-swear-word
here] lot of work ;)
Moritz
-Original Message-
From: Dan Trainor [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:41 AM
To: Moritz Möller; mysql@lists.mysql.
Whil Hentzen wrote:
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
r
Moritz Möller wrote:
Hi list,
we're running some large high-traffic mysql servers, and are currently
reaching the limit of our machines.
We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is
quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is
CPU.
The
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able
Bgs wrote:
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able to fine-tune the new
Hi -
It's been a short while since I've seen any discussion on this subject,
and I'm wondering what's happened in this arena since then.
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to
Kishore Jalleda wrote:
On 5/18/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tell
Hi -
I'm trying to import some data into a MySQL database, which was dumped
from mysqldump. Just looking at the .sql file generated, there's only
about 7000 lines, on an 800M dump. I guess this tells me I have some
extremely long lines, which would be happy to take up more than
'max_allowed
Hello, all -
It's been a while since I've posted here, but I read the list daily.
Thanks for all the help.
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I've enabled allocation of more memory per-process,
as described by the FreeBSD notes for 5.0.x
This email has been Scanned for Viruses!
www.newbreak.com
========
--
- Dan Trainor
- id-Confirm, Inc.
- Direct: 720.241.5580
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Walter Johnson wrote:
> This is probably a simple question. I installed MySQL about a month ago
> on Mac OS X and I am new to this. During the installation (as root) I
> created a directory /var/mysql-data. Then, following the installation
> instruc
Ady Wicaksono wrote:
Dear Mr. Heikki and Team,
Currently we hit by this bug
http://bugs.mysql.com/bug.php?id=15868
It got worse on MySQL5 rather than MySQL4, since i failed to downgrade
MySQL. Please give me idea to minimize the impact
My client is very dissapointed with this issue
Thank you
[EMAIL PROTECTED] wrote:
Hello,
Is there anything we can do to help the MySQL project, we are firm believers
and would like to contribute in some way.
We have a several 100 mps connections and server space.
Thank you,
Charles
DWHS Inc. Manager
http://www.dwhs.com
http://www.dwhs.com/hostingf
Rob Gormley wrote:
Short of running two MySQL instances on the same server... What I would
like to do is have a table which exists on disk in InnoDB format, and a
Memory table which clients make requests for.
Lest that sound more convuluted than it really is, the situation is
thus:
Limited (fin
Peter wrote:
--- Dan Trainor <[EMAIL PROTECTED]> wrote:
Peter wrote:
While on MySQL 4.0.24, I connect to my database:
$ mysql -u amavisd -ppassword spamassassin
This user can select and insert (that is confirmed) but cannot delete
a
row:
mysql> delete from users where
Peter wrote:
While on MySQL 4.0.24, I connect to my database:
$ mysql -u amavisd -ppassword spamassassin
This user can select and insert (that is confirmed) but cannot delete a
row:
mysql> delete from users where 'fullname' = 'bongo.net' limit 1;
ERROR 1044: Access denied for user: '[EMAIL PRO
Joerg Bruehe wrote:
Hi Dan, all!
Dan Trainor wrote:
Thanks for the prompt reply, Augusto -
I completely understand what you're saying. To have anything such as
a real-time measurement to the exact number of tables would be an
incredible preformance degration, not to mention overhea
at every transaction commit? The MyISAM storage
engine, with a very tight relationship with the server itself,
probably has a higher 'update rate' than, let's say, InnoDB (with also
may 'suffer' some same consequences as James said related to
transactions).
--
Augusto Bot
e was MyISAM and you get an exact number of rows someone could
still add another 20 rows in the second after you run SHOW TABLE STATUS.
James Harvard
At 5:54 pm -0700 1/2/06, Dan Trainor wrote:
So, now this has made me think here. If 'SHOW TABLE STATUS' only shows an
"estimate&qu
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table&#x
Hi -
Anyone else get the following message with *ever*single*post* to the
list? Anyone have a procmail filter established already? ;)
Thanks
-dant
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]
If you really intend for this to get to me, remove the 'no' in the eMail address
above & I'll send
Dan Trainor wrote:
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table&#x
Hello, all -
Still kidna new to MySQL, so please forgive me if this is somewhat dumb
question...
When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows
column for my table, I see 17333. However, when issuing a 'COUNT (*)
FROM table', I see 17203 - a difference of 130.
We'
[EMAIL PROTECTED] wrote:
Must the RPM be manually downloaded, or can the query browser be
installed from yum? I've tried "search 'mysql-query-browser'" and no
result--perhaps I need to add a repository?
[EMAIL PROTECTED] ~]$ mysql-query-browser
bash: mysql-query-browser: command not found
[
sol beach wrote:
Sounds reasonable, but how do I shutdown down MYSQL so I can restart with
--skip-grant-tables
option?
On 1/30/06, *Dan Trainor* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
sol beach wrote:
> I've been asked to assist the folks who
sol beach wrote:
I've been asked to assist the folks who own the data in the database, but
folks who used to maintain it are no longer with the company.
This installation resides on a Windows 2003 server to which I have local
admin rights.
What is the most painless way to get "root" access to thi
47 matches
Mail list logo
