How to Backup the Database using Script

Hi Everyone, I am trying to backup a database regularly, without using Administrator tool in mysql, Can anyone help to write a scipt regarding backup database. -Thanks in Advance Ganeswar

Server just hangs when executing a query

We had a bit of a scare yesterday when one of our scripts just hung indefinitely. We nailed it down to a query in the script. When we executed the query manually, it hung as well. We ended up having to restart MySQL which for some reason fixed it. Some background: We're running MySQL 4.0.25.

Re: help with group by

works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, probl

Re: help with group by

try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, problem_type On Wed, Oct 28, 2009 at 12:05 PM, Adam Williams wrote: > I've written a helpdesk ticket problem and am working

help with group by

I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql> select distinct accepted_by

Re: START TRANSACTION COMMIT ROLLBACK

There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out

Re: START TRANSACTION COMMIT ROLLBACK

There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out a

Re: START TRANSACTION COMMIT ROLLBACK

If all the tables are InnoDB, XA isn't needed. It doesn't matter whether all tables are in the same database. On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote: Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Wor

RE: Open Tables

Will Generally this means you need to look at the schema design of your database system If you are running a simple contact Database for Mom and Pop store and you have connections to 100 tables open then you would want to take a more serious look at the schema you are using to merge informati

Open Tables

I saw so many open tables in my server, is it dangerous? And if I execute flush tables what does it impacts to the open tables? Thx. Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: START TRANSACTION COMMIT ROLLBACK

Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforu

ANN: Free Database Workbench 3.4.1 Lite released

Upscene Productions releases a new version of " Database Workbench Lite " There are editions available for MySQL, Firebird and InterBase. What is Database Workbench? Database Workbench Pro is a cross database development environment for database administrators a

Re: START TRANSACTION COMMIT ROLLBACK

Looks to me we should use XA transaction syntax instead. Check this: http://dev.mysql.com/doc/refman/5.0/en/xa.html Thanks, YY 2009/10/28 Martijn Tonies > Michael, > > Does MySQL support multi-db transactions? > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com

Re: START TRANSACTION COMMIT ROLLBACK

Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databa

Re: Req. suitable .cnf file for Server used by 2000 users daily

mysql is successfull in login with same user and password but when the same user and password is given at mysqltuner end it always shows the same error "[!!] Attempted to use login credentials, but they were invalid." Thanks Jeetendra Ranjan SynapseIndia http://www.