MYSQL :: Binary Update Logs, Access FE, Distribuite Application

Binary Logs?
My environment:
2 servers, 1 shared storage, redhat cluster keeps mysql running on one node at a time. Not using replication or Mysql Cluster.

My need:
I'd like to move my binary logs to the local device of whatever server is the primary server.

My problem:
If I move my binary logs to the local disk (from the share, where they are now), what happens during a failover? If db01 fails to db02, there will be no binary logs waiting for it. Now, I THINK those binary logs will just start up again, but I can't be sure.

Lets say they do just start populating, brand new: what happens if i fail back? When I fail back the database will suddenly have old binary logs. What's a sys-admin to do?

Delete The Binary Logs
I would like to know if there is any way that I can clear the Binary logs related to one particular database only. I just want an alternative to the Query "Reset master" and "Purge [Master/Binary] logs". I need a query that would just delete the logs that are specific to a particular database.
The reason I need this is whenever I take a full backup/Binary backup using mysqldump/mysqlbinlog I would like to execute the reset master command because I dont need the statements in the Binary log because I already have a backup.. But now the problem is that I have taken the backup of only one database. And now if I use Reset master or Purge Master command , these command delete the entire logs. But what I want is the delete the logs of only one particular database

MySQL Binary Logs
I am taking backups of my databases with mysqlhotcopy. MySQL keeps all binary logs. I only need the most recent binary loigs after the backups to do forward recovery. I would like to copy all logs to a NFS mount point (where they would be copied to TSM) and remove them from the active log directory.

Flush Logs, Binary Log Index File
I'm trying to write a script to weekly remove MySQL logs, the general,
error and binary log files.

Following the MySQL documentation, I've written a script that moves all
current log files, then executes mysqladmin flush-logs.

My question is this on the binary logs (bin.001, bin.002, etc.): once these
are removed and flush logs is executed, the binary log files start over
with bin.001.

HOWEVER, the binary index file does not appear affected by the flush-logs
command; ie, if I'm up to bin.003 in the binary.index file, remove the
files and execute the flush logs command, I'm back to a file names bin.001,
although the binary.index file still has entries for bin.001, bin.002,
bin.003, etc. How does the binary index file stay current when you remove
the logs??

InnoDB Binary Logs - Unique To Each Database Configuration
I would like to back-up our InnoDB databases using a combination of mysqldump and the binary logs. We have multiple databases within our server instance, and each database is unique to a customer so we don't want to mix their data. I know how to create / schedule unique dump files for each database, but was wondering how to configure unique binary logs. Right now all transactions are logged in the same set of files.

Incremental Backups Using Update Logs With Multiple Databases
I've set up my server to keep update logs for incremental backups, as described in Kevin Yank's book (Build Your Own... 3rd Edition), but I've noticed that the update.* files have entries from all the databases on my server. Is there a way to automatically split up the log files so that I can have separate update.* files for each database?

Exporting Binary Data From Access 2000 Into MySQL 4.1.5 Gamma
I'm trying to export a pictures table, my mySQL database table already
exists so I have linked both tables in Access and I tried to run a
simple append query in Access to export the data but I either :

- lose the connection to mySQL
- have packets that exceed max_allow_packet

I have tried different things to set max_allow_packet to a higher
value which seems to be 1M by default. I want it to be 1G like setting
the value at run-time from the prompt but it seems that no matter what
I tried, I either get the syntax wrong or the command is simply
ignored.

I have also added in my.cnf, the following lines :

Application Popup: Mysqld-nt.exe - Application Error
Application popup: mysqld-nt.exe - Application Error : The memory could not be "read".

I have gotten this error twice now. I can't seem to find any rhyme or reason to why though. Our sites are all based on php and mysql. The Server load at the time of the crash was minimal. The only common denominator is the Performance Monitor was running. Any clues?

How To Save Binary Data Into A Binary Field
I want to save some binary data into MYSQL.

dim s as string
s=chr(0)&chr(1) chr(3) & chr(6) & chr(7)
conn.execute "INSERT INTO test values ('" & s & "')"

The field in the table test is binary. The odbc returns an error but using the query browser the query ends good. Any idea?

Key1 Without Binary And Key2 With Binary
I have two search keyes, key1 and key2.

The following is where clause.

where

say like '%#key1#%'
and
say like binary '%#key2#%'
I have to use binary for key2 like the above.

Now I like to make the following where clause.

say like '%#key1#%#key2#%'
The where clause above will retrieve all records which has #key1# and #key2# in that order.

My problem is in the use of binary, i.e I have to use binary for key2.

I can make it like the following for using binary.

say like binary '%#key1#%#key2#%'

But the code above makes not only key2 but also key1 bianry.

Key1 doesn't need bianry but key2 needs bianry.

How can I make the where clause key1 without binary and key2 with binary?

The following would-be code doesn't work correctly, but it'll show what I want.

woudl-be code

say like '%#key1(non-binary)#%#key2(binary)#%'

MyODBC With Access Update Issue
I am having a problem with using MSAccess (2003) on the front end of a MySQL DB (4.1.10a). When I add a timestamp field, the Access table will allow me to add the record and provides a proper refresh without a #deleted# record. When I attempt to update the table in Access, I get an error of SQL data out of range error. If I delete the timestamp field, I can update the record, but then get the dreaded #deleted# record information. MyODBC version is 3.51. I have upgraded the MDAC to the latest version.

Can't Update Records When Using Linked Tables In Access
I have a linked table to MySQL 5.0 through MS Access 2003 that utilizes a timestamp field in order to prevent the #Deleted signature happening everytime I create a new record. However, when I attempt to update a previous record I receive the error message: "Reserved error (-7776)" and am subsequently prevented from updating any records. Please note, there are no errors when creating new records, only when I attempt to update an existing one. However, if I remove the timestamp field, updates occur without error. Has anyone else encountered this issue? How might I rectify it?

What To Look For In Logs
We are seeting up some alerting mechanisms on a linux server running mysql.

We have a programme that will search for text strings in files and alert us if it detects one.

We could set it to look for ERROR or WARNING in the general or error log.

Does anyone have any suggestions an anything else or anything more specific to search for?

About MySQL Logs
while trying to output mysql logs file from a php file, I've got this message:

You are not using binary logging

So I would like to know what this mean and the reason I got this message!

Mysqld Logs
I have a DATABASE server running MySQLD 3.23.58.Users vist and sign up
their interest in my website.Now the problem is arising that when a
user signs up first , they get emails of confirmation from my
server.In addition to these emails , the customer also gets some
annoyed e-mails from someone residing/depending totllay on @yahoo.com
email-address maintaining the anonymity.

I did try by sending only e-mails to some my own email address,
whether someone is sniffering through my traffic, but I got no e-mail
except the ones I had sent myself.

After this I added some other email addresses in my DB server but I
sent no email to them at all.This time all email addresses got those
*annoying* e-mails also.

Errors And Logs
In the my.cnf file, under [mysqld] I have log-error=/path/to/error log
file directive. The last entries in this file are over an year ago. In
case of MYSQL errors, such as improper roll backs or improper commits,
shouldn't the errors be logged here. And if this is not the right
place, where would the errors be logged? The users claim some data in
the database changed automatically, I want to investigate any errors,
but I don't see a place where that information is.

Error Logs
I'm using mysql 3.23.54 over Red Hat Linux 9. I'm having problems with
the error logs.

I've run mysqld start --l, mysqld start --log, mysqld start
--log-error, and mysqld start --log=MyErrors.log and not once managed
to find a log file.

I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1;
which gives ERROR 1046: No Database Selected. That should surely be
logged in a file somewhere.

I'm using:- find / -amin -5 to select anything altered in the last
five minutes, after many fruitless hours trying to find the correctly
named files (from <http://dev.mysql.com/doc/mysql/en/query-log.html>).
I can't see anything containing that error.

Ultimately, I'm trying to work out whether a J2EE app has connected
with mySQL. I want to see whether the CORBA error I'm getting is
because mySQL rejected the request, or whether it's from CORBA itself.
If mySQL rejected it, there'd be an error message. I just can't see
any error message store at all. Can anyone see the error of my ways?

Security And Logs
There have been some problems with our server and things getting changed in mySQL, either via phpmyadmin or command line.

Is there a logging tool that can keep track of sql commands, what commands were run and give the IP information?

Very Large Bin Logs
We're getting several very large binary logs, reaching overall over 10GB which is a problem:

- When does mysql decide to purge the logs if at all
- Is there a way to control the number of bin logs created
- If the bin log size is set to a small number with max_binlog_size, will we get lots of small files ?

Importing Web Logs
I used to work with MSSQL. I has set up a sheduled task that imported the web log files into the database. Is this possible?

MySQL Logs
I know then when I am using MySQL via the command interface, I can press the up arrow to scroll through previously typed statements. Is this information stored somewhere that can be accessed via log file or via a select statement? Is this available for all accounts?

MySQL Logs
when I am using MySQL via the command interface,I can
press the up arrow to scroll through previously typed statements.Is
this information stored somewhere that can be accessed via log file or
via a select statement?Is this available for all accounts?

MySQL Logs
I know then when I am using MySQL via the command interface, I can
press the up arrow to scroll through previously typed statements. Is
this information stored somewhere that can be accessed via log file or
via a select statement? Is this available for all accounts?

Turn On The Logs
How to turn on the log exactly?? (For all type of logs). And would they all be stored in the ".../mysql/var" directory??

Mysql Logs
I have these logs both on the eclipse's console and the logfile and I want to remove it. I am using log4j to manage the logs:

Mon Jun 19 14:28:15 CEST 2006 TRACE: --> NonRegisteringDriver.java:259 com.mysql.jdbc.NonRegisteringDriver.connect("jdbc:mysql:"})
Mon Jun 19 14:28:15 CEST 2006 TRACE: --> NonRegisteringDriver.java:436 com.mysql.jdbc.NonRegisteringDriver.parseURL(""})
Mon Jun 19 14:28:15 CEST 2006 TRACE: --> StringUtils.java:1110 com.mysql.jdbc.StringUtils.startsWithIgnoreCase("")

Manager That Logs Activity
Im running a site that several users need access to the databse, and we are currently using phpmyadmin.

But we really need to log activity each user does in the database. As from time to time some dishonest users change things they are not suppose to change.

Any software like phpmyadmin that logs activity, and purhaps even limit access to the database,

View Query Logs
I have a db set up and it looks like nothing went to the db because of some errors. How do I open the query log to see if anything was registered.

Replication Bin Logs Issue
We are in the process of setting my mysql replication on mysql ver
4.1.18. However we have noticed an odd bug that occurs every so often.

Every hour we issue flush logs to mysql so that we can move the bin
logs to our backup server. In our mysql logs we notice the following;

060526 12:00:02 [ERROR] Failed to open log (file
'/srv/backup/mysql/mysql-bin.000068', errno 2)

This doesn't happen on each flush. This is resulting in us losing an
hours bin logs at a time which then causes replication to break (rows
are inserted during this time and as they are not logged to the bin
logs they never make it to the slaves).

errno 2 is "No such file or directory" however the structure is correct
and this is confirmed by the fact that the bin log rotation/flushing
does work correctly most of the time.

Does any one have any ideas why this may be taking place?

A Way To Implement Change Logs?
I've recently started using MYSQL and its got to a stage where i want to add a few features into it.

One of these things is that i want to have a log of all the changes that i make. Logging each cell that i change, and who it was changed by and when. Basically logging all the details of all the changes i make.

I know how to do this manually, like through making a new table and adding in the details by hand, which can be extremely time-consuming and boring to say the least.

I was wondering if anyone knew of any way that all the changes i make will be logged automatically after they are saved.

MySQL Administrator Logs
I have been using mysql database on two servers for about three years now. I recently downloaded the new MySQL Administrator and I love it. My only problem is I cannot see logs.

I am connected on the local machine and cannot find the option to turn on the logs or anything. I have looked through my.ini and everywhere.

Relay Logs Being Generated
I was looking through the mysql data directory and have noticed that relay logs are being generated on a regulay basis.These log names are in the format hostname-relay-bin.nnnnnn.
I was under the impression that relay logs were only generated if replicaition was set up/being used, and whilst I plan to set up replication in the near future,it is not being used at present.

Show Master Logs
When would SHOW MASTER LOGS be used?
I've had mysql hang 4 times this week and we've done all we can to fix it - but it seems that what we have done has only reduced the backlog of queries that occur when it hangs - now it hung again this morning and the only thing of note in the mysqladmin process list was SHOW MASTER LOGS - I googled it and there seemed to be a few cases of crash related bugs with this particular command - now I know I didnt issue the command so what would have done

PROBLEM WITH PURGE MASTER LOGS
I have a Server Linux with mysql 4.0.13 version with qmail server.

I run the command purge master logs but he return a message of error i/o.
The table "relay" on db vpopmail is corrupt and the command repair or restore not function.

Mysql Logs Files - How To Flush
I see some log files that are taking up 20 megs. How do I get rid of these, view them or work with them.

Using mysql 4.0.24

I have attempted the following:

E:mysql2in>mysqladmin.exe -u root -p -v flush-logs
Enter password: *******

E:mysql2in>mysqladmin.exe flush-logs -u root -p
Enter password: *******

However I still see the following files:

01/05/2006  11:49 PM        10,485,760 ibdata1
05/11/2005  03:44 PM            25,088 ib_arch_log_0000000000
01/05/2006  11:50 PM         5,242,880 ib_logfile0
05/11/2005  03:44 PM         5,242,880 ib_logfile1

Where To Find Error Logs For MySQL
Can any one tell me where to find the error logs for MySQL server 4.0.

GUI Application
I would like to know which is the most convenient and functionable GUI package for MySQL design and administration under Windows OR Mac OS X.

Mysql Logs Show Query With T_tablename
select col1 from table1;

shows

select t_table1.col1 from table1;

in the logs.

Printing Application
I would like to thank everyone with their sincere efforts in keeping a
well orgranized mailing list. I have a question and require guidance.
I have been thinking of making a printer management application, which
uses mySQL and PHP and the Linux log files to check activities of the
printer, log information about printouts, and make final reports. If
anyone can point me in the direction I can start? I have looked at
internet but was unable to really find something in this subject.
Ofcourse if there are who think this message should go to other
mailing list please kindly let me know.

Web Based Application
Im pretty new to MySQL and been asked to develop a web-based application using MySQL for data repository. The site im developing has three different kind of access level i.e. Guest, Registered User, and Administrator. The last two users/group have similar privileges (Add/Update/Delete operations) except Administrator being the Super User.

My Questions:

(1)Say there are more than 100 registered users, do I have to add these users manually one after another using the Insert SQL command or is it better to use one Group ID since MySQL support concurrency connection?

(2)By default, table "user" of "mysql" database stores users who can access and manipulate the database. is it possible to create new database or table to store these users?

(3)What is the best way to store images, videos and audios in MySQL (for better performance)? is it storing file paths (its location) or storing it as Binary Objects)?

Application Security
I would like to add client application security at the server end so it doesn't have to be embeded into each of the clients, just at/in the server.
I have done a search of the Forum/NGs but can see no reference.

Is it possible to access an external .dll from the server? The .dll would hold some security routines that could validate use, registration,etc. Obviously the .dll would have to be called by the server so the server would need to be 'called' to pass on the request. Is this possible?

Alternativley, is it possible to embed routines in the server that can be locked and not got at by the normal tools?

PHP-MYS SQL APPLICATION SERVER
I want to set up an application server using PHP and MySQL 5.0.x as the database server. I want the application to be installed in one server unit and the database in another to improve security.In this set up,i will be using the PHP APIs and the stored procedure capability of MySQL.

How To Deploy An Application
I would like to know ho to deploy a standalone MySQL-based application (written in Java). Let's suppose I want to deploy it to another pc.

What should I do ?

1) Install MySQL on the target pc
2) Run a program to create the required tables
3) Install the application

Is the right path?

Using Mysql In An C++ Application
i am using mysql in my c++ application and when compileing i get the following linker errors (mysql.h, winsock2.h includen AND linked):

mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegCloseKey@4 referenced in function _my_win_init
mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegEnumValueA@32 referenced in function _my_win_init
mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __imp__RegOpenKeyExA@20 referenced in function _my_win_init
mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptReleaseContext@8 referenced in function "public: __thiscall TaoCrypt::OS_Seed::~OS_Seed(void)" (??1OS_Seed@TaoCrypt@@QAE@XZ)
mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptAcquireContextA@20 referenced in function "public: __thiscall TaoCrypt::OS_Seed::OS_Seed(void)" (??0OS_Seed@TaoCrypt@@QAE@XZ)
mysqlclient.lib(random.obj) : error LNK2019: unresolved external symbol __imp__CryptGenRandom@12 referenced in function "public: void __thiscall TaoCrypt::OS_Seed::GenerateSeed(unsigned char *,unsigned int)" (?GenerateSeed@OS_Seed@TaoCrypt@@QAEXPAEI@Z).

Specification Vs Application
I need to display a large rate sheet that has a specific set range

EG:

1-15, 20, 25, 30, etc (up to 150).

I have three options in my head:

1. Specify these values in an "IN" statement in the query OR
2. Specify a subquery to see grab only things in the range OR
2. Use PHP to check each row before displaying.

IE: Use Mysql Engine vs using PHP engine.

Any thoughts?

If you want more details, let me know.

Web Based Application
i have a body that im doing a web based form for his small business.now he needs to have access to that form in all time s when he is at his clients even if they have no internet.
now i was thinking of installing wamp on his laptop and making a web based application.since wamp will act like a server he wont need internet.i think?
so my question is can i make a script that when he connects his pc to internet it will send the info store in the wamp db to his web server db?is that possible?

Embedded Application
I would like to make a win ce(or pocket PC) application connect to a mysql server which is installed at pc. any one did this before?

CORBA Application
i have a situation to build a large scale app,there are many of client
to call insert and select method from a corba object,then the corba
object operation on the mysql db,but i am a much newbie for carba

Embedded Application Query A Sql DB
I have an embeded application that needs to get data from a SQL database running on a server. The embedded application must use a GPRS enabled GSM modem to get to the database. I have managed to establish a TCP connection to the database server. Now how do I log onto the server and how do I post a query?