06-19-2011
Hi Scott,
which storage engine are you using (show create table <table_name>;)?
Bear in mind that MySQL 5.0.x default's storage engine is MyISAM and that storage engine doesn't support transactions (you cannot rollback a statement).
You should take a look at InnoDB if you need transactions (start transaction; do your work; commit or rollback).
InnoDB is the default storage engine in 5.5 (I'm not sure when exactly it became the default storage engine).
This User Gave Thanks to radoulov For This Post:
7 More Discussions You Might Find Interesting
1. AIX
Hi,
Can anybody tell,how to set the auto commit option in AIX,i have tried with environmental variables option like 'export db2option=-c +a'.
But its not working in my environment.
is there any other option? (1 Reply)
Discussion started by: DB2AIX
1 Replies
2. Shell Programming and Scripting
Hi All,
I have bash script, so what is sintax script in bash for Enable and Disable Tab Key. Thanks for your help.:(
Thanks,
Rico (1 Reply)
Discussion started by: carnegiex
1 Replies
3. UNIX for Dummies Questions & Answers
mysql.sock file is missing in /opt/lampp/etc/ is there any backup file available in unix...
since without that file .. project is not opening..
reply me as soon as possible ... (19 Replies)
Discussion started by: senkerth
19 Replies
4. UNIX and Linux Applications
Hi,
Pls let me know command to get following:
1. how to check current value of autocommit
2. how to check current value of isolation level
I am using mysql-5.0.26 on unix
-Thanks (2 Replies)
Discussion started by: newbielgn
2 Replies
5. Red Hat
Hi all Expertise,
I have following issue to solve,
SSL / TLS Renegotiation DoS (low) 222.225.12.13
Ease of Exploitation Moderate
Port 443/tcp
Family Miscellaneous
Following is the problem description:------------------
Description The remote service encrypts traffic using TLS / SSL and... (2 Replies)
Discussion started by: manalisharmabe
2 Replies
6. Emergency UNIX and Linux Support
I know, its stupid..
MYSQL on CENTOS 5 using WHM
Imported a lot of users/posts from old forum to new forum, but my backup was lost.
Can I somehow simply remove all mysql table changes for the last 3 hours, returning to pre-import status.
---------- Post updated at 03:44 AM ----------... (6 Replies)
Discussion started by: lawstudent
6 Replies
7. Emergency UNIX and Linux Support
Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :(
Dear community,
I have a table with two rows like:
Row1 Row2
======= =======
7,3 text 1
1,3 text 2
1,2,3 blabla
What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
ULOGD(8) System Manager's Manual ULOGD(8)
NAME
ulogd - netfilter/iptables ULOG daemon
SYNOPSIS
ulogd [options]
DESCRIPTION
ulogd connects to the netlink device of the Linux kernel and reads messages from the netfilter that get queued with the iptables ULOG tar-
get. For this to work you have to compile the ULOG target into your kernel or load the respective module.
The received messages can be logged into files or into a mySQL or PostgreSQL database.
OPTIONS
-d, --daemon
fork ulogd into background (start as daemon)
-c <filename>, --configfile <filename>
use <filename> as configuration file instead of /etc/ulogd.conf
-h, --help
show usage information
-V, --version
show version information and copyright
FILES
/etc/ulogd.conf
/var/log/ulog/ulogd.log
SEE ALSO
There is more documentation about the daemon and the database plugins (including examples) in the directories
/usr/share/doc/ulogd
/usr/share/doc/ulogd-mysql and
/usr/share/doc/ulogd-pgsql
AUTHOR
This manual page was written by Joerg Wendland <joergland@debian.org>, for the Debian GNU/Linux system (but may be used by others).
Linux Netfilter November 05, 2002 ULOGD(8)