Enabling Binary Log In Mysql 5.0.45
I wrote log_bin=[filename] in my.inf and restarted ,eventhough if checked at commandprompt through show variables statement, its showing log_bin =off.I tried through mysql adminstrator stratup variables also. But no change at all.can anyone tell me how to enable binary logs and further process for replication.Awaiting for your valuble replies.
View Complete Forum Thread with Replies
Related Forum Messages:
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?
View Replies !
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)#%'
View Replies !
Enabling InnoDB
Actually am using mysql 5.0 version, default it using MyISAM engine, but i wnat ot use InnoDB engine. I tried to change the my.cnf file with entry "default_server_engnie=InnoDB".but there is no use.
View Replies !
Enabling SSL & Setting Up A Certificate
I have MySQL 5.0.27 on XP Pro. I have not been able to find the correct syntax for starting MySQL so that SSL is enabled.I've searched the forums and the Manual. ALso, can anyone point me to a location which provides clear guidance on setting up an SSL certificate? %.9.7.4 of the Reference Manual wasn't too helpful for me.
View Replies !
Enabling InnoDB Error
I've successfully enabled InnoDB for my database but I'm getting the following error when I try and set on delete cascade for a foreign key. Error SQL query: ALTER TABLE `editors` ADD CONSTRAINT `participants_editors` FOREIGN KEY ( `account_id` ) REFERENCES `participants` ( `id` ) ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table './isimodev_co_uk_main/#sql-7d1_4c69.frm' (errno: 150)
View Replies !
Enabling Multiple Statements
I'm trying to execute the following multiple statements using MySql w/ the ODBC connector. INSERT INTO Sites(Hostname) values('zzz'); INSERT INTO Hosts(SiteID, Hostname) values(last_insert_id(), 'zzz'); I get the following error: [1064] [1] [0] "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO SiteHosts(SiteID, Hostname) VALUES(@@IDENTITY, 'zzz')' at line 2" Is there something I have to do to enable multiple statements?
View Replies !
Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections? Im using mysql 4.1 on Linux Ubuntu 5.10 I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error: Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! What do I have to do to get it to accept local and remote connections? Code:
View Replies !
MySQL RPM / Binary
Thanks for the previous rec regarding 4.xx, Now I want to run a second MySQL server and leave the existing (and working) 3.23...Configuring isn't going to be the issue, but according to the RPM output, the package isn't relocatable from /var/mysql blah blah - which is where my existing installation is.I guess I need to download and make the installation manually to force it to a totally separate directory then right?
View Replies !
MySQL 4.1 Windows Binary
I can't seem to find a binary distribution of mysql 4.1. Can some one tell me if there is one and where to get it? Or is it not as simple as finding a setup.exe?
View Replies !
MySql Binary Log ERROR
I'm getting an "ERROR: File is not a binary log file." error when I execute: >mysqlbinlog ib_logfile0 I'm running 5.0.22 for Win32. I've tried it with the server shutdown, and I've tried it with the -f or --force-read option, too. When I open the ib_logfile0 (or ib_logfile1) in a text editor, it looks like a binary log file --"control characters" interspersed with regular text data from the database. I'm thinking that it may be some problem with the log file headers, but I'm not sure.
View Replies !
Does MySQL Support Binary Strings?
I want to have a sort of switchboard system on my database which tells which features are set and which ones are not... 01010110 That would tell you that some features are enabled and some are not. However when it comes down to storing the value I have two options... 1) Store it as a CHAR(8) value, and then fetch it without decoding it. Simply have a server side code use number.charAt(i) to determine the bit value. 2) Store it as a Decimal (Base10: 0-255) number and then have server side scripts covert it to base2 (binary). Then from there it will take the process that step one takes... Both these solutions work well, But I would really like to have something in the middle. Say storing a base10 number (already decoded into base 2) but stores as a binary string. Is that possible?
View Replies !
Memory Allocation Limit On Mysql 4.0.16 Binary For AIX 5.1
I downloaded the mysql 4.0.16 binary for AIX 5.1 from Mysql.com website. How much memory can this binary's mysqld handle? Is it a 32-bit or 64-bit process? It seems that it can only allocate a maximum of 2GB of memeory (by setting the maxdata as suggested on the AIX note in the documentation). I am using mainly innodb tables. Occasionaly, I have encountered "out of memory error". We have 4GB of memeory on our RS6000 (AIX 5.1). It is used as a dedicated mysql server. Is there a way I could allocate more memory for mysqld?
View Replies !
Binary Data Handling With Mysql Client
I am wondering what I miss to be able to handle binary data from the mysql client. I have ensured that the user has file_priv set to 'Y' and that max_allowed_packet is larger that the binary lumps handled. Here is my version: Ver 4.1.5-gamma-log for pc-linux on i686 (Source distribution) Right now I'm trying this to insert binary data: mysql> update table set col=load_file("/path/file") where id=1; ....and this to fetch the data again: mysql> select col from table into outfile "/path/file"; As for insertion I am actually not quite sure whether or not it goes well, since I get garbled data out from the fetching. Any way to check the data when inside the table (data length, for instance)? I have two problems with the fetching of data: 1) I cannot specify a path. I am only allowed to specify a filename, and the that file is written to the table's directory in the server's data directory. 2) The resulting file is garbled data. I am not sure if this garbling happened at the time of insertion of data or when I fetched the data out again.
View Replies !
Clearing Mysql Binary Logs From A Script
I'd like to know how to clear down mysql binary logs from a script. I have a script which runs this: "C:Program Filesmysqlinmysql" -uroot -prootpasswd < C:ClearBinaryLogs.sql ClearBinaryLogs.sql: use db PURGE MASTER LOGS BEFORE 'NOW()'; doesn't clear anything but seems to complete without any errors and all the paths are correct, anyone have any ideas?
View Replies !
Writing Large Chunks Of Binary Data To MySQL With ODBC
I'm having a lot of trouble writing large chunks of binary data (tests are in the range of 16-512K, but we need support for large longblobs) to MySQL using ODBC. Database is local on a W2K system, but I have to support all modern Windows systems, and a variety of ODBC configurations. (I'll be testing against multiple ODBC databases soon - but development is against MySQL) I've been able to adapt some example code that executes a statement (SQLExecute) and uses SQLBindParameter to mark the longblob field as SQL_DATA_AT_EXEC. That works. However I really need to use a result set (opened for update), and to add new rows using SQLBulkOperation( hStmt, SQL_ADD) This works for the normally bound fields, but fails if I bind a variable using something like: Code:
View Replies !
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 :
View Replies !
Binary Log
I was wondering if it was possible for MySQL to produce a binary log that can be used for Point in Time Recovery without the actual replication process of duplicating everything in another database.
View Replies !
Can We Use Binary?
I had little time so didn't do much research .My apology for that. I want to create column "present" in my table employee.Further I want to use binary datatype(1,0) for field "present" .0 being default.Is it doable?If yes then how? create table employee(present binary default 0)
View Replies !
Binary Log?
I need some advice about how long I must keep those long binary logs created by the RDBMS, I read the doc and I understand that those logs are needed in the case of db recovery, since they have all data involved in updates and deletes, they tend to grow to really huge sizes. I don't use the replication features, so... I think is safe to delete old log files, but how old?, is safe to delete the logs files of the last month or something like that?
View Replies !
MySQLD Binary Log
We've been using MySQLD for a few years now quite happily. It's amazing how well it performs. However, I have a minor issue, and I'm not sure how to deal with it. I've scoured the manual, searched list archives, the web, etc., and am coming up empty. Somehow, the server is recording the Binary log in the data directory. Each of these log files takes up a gigabyte. This would be all well and good if we were using the server in as a master in a replication setup, but we are not. It WAS formerly acting as a master in a replication environment, but we've long since made it the only SQL server on our network. We've removed (commented) all the lines in my.cnf that deal with replication, and the log-bin is one of these lines. To clarify: the log-bin line in the my.cnf file IS commented with a hash-mark (#). The server has been restarted since this change, and "SHOW MASTER STATUS" returns an empty set of data (only showing the field names.) the SQL command RESET MASTER does nothing. It does not delete the hostname-bin.### files. the mysqld commandline parameters follow: /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/inferno.pid --skip-locking We're running version 3.23.41 for pc-linux-gnu on i686, running on SuSE Linux 7.1, kernel 2.4.18 #2 SMP on a Dual-Processor Pentium II 450MHz server.
View Replies !
Ib* Binary Files
I notice in the mysql/data directory the following binary files: ib_arch_log_0000000000 ib_logfile0 ib_logfile1 ibdata1 Some are rather large. I can't seem to find any explanation in the documentation. What are they? What needs to be done with them?
View Replies !
Binary Upload
i like to upload blob-data to MySQl database with this command: insert into files (f_name, f_binary, f_date, t_id) values ('musik2', LOAD_FILE('C:/Dokumente und Einstellungen/wolfgang.RE-MSQDW1NI9MBG/data/Neuer Ordner/a.mp3'), 2004-12-12, 1) MySQl states Error: 1048 Column 'f_binary' can not be null As I wasn't able to figure out my mistake in the commmand I created a txt-file a a.txt and doing the same command with this file - and this works.
View Replies !
Continuous Binary Log
what would work even better for me is if the relay file were continuously updated without actually performing the database changes to the slave. This way my backup server does not need to be bogged down with database operations and can do other things or not require as much hardware to keep up with the master. I tried SLAVE STOP; but noticed that this prevents the relay file from being updated at all. (SLAVE START; resumed the updating of the relay file) So SLAVE STOP; won't work.
View Replies !
TRUE Binary
I have a Status column, stating whether a particular record is active or not. Right now, the way I have it is set that the column is an ENUM('Y','N')... The bad thing is when I try to access the database from some other programming language, like C++, my "binary" column isn't really such... It is not a TRUE binary column. Does MySQL have any kind of TRUE binary? I mean, right now i've got a couple of workarounds, but they're not as effficient, or as pretty as i'd like them to be
View Replies !
Binary Attribute
I have inherited a database that has one of the fields created as varchar(16) binary. It is actually a password field. So I needed to update a password for a particular user to do a test. I just did an update: update database set password='password' where login_name='desireduser' The database updated the password but I could read the word: "password". The other passwords are in binary so I can't read them as English. So I thought of the password() function. I then tried another update: update database set password=password('password') where login_name='desireduser' Again the password was not put in binary form; I could read the actual word. The problem here is that the user can't log in when i do this. Yes that is a web app issue. But it is related to this issue that I am reporting here. So my question is how do you get a string or integer to appear as binary if you can't just use an update statement?
View Replies !
BINARY Fields
I have a field in my table that is BINARY. I do this because I want to be able to store 'Word' and 'word' and 'WoRD' as their own entries.Though, when I display the words on my website, I want them to be in non-binary alphabetical order. Is there a way to do this during a query? Otherwise I will have to sort it with my programming language, which is undesirable.
View Replies !
BINARY And COLLATE
explain how the BINARY and COLLATE operators work? For example, what would the following query do? SELECT user_id, username, ... FROM users WHERE BINARY username = 'user'; Does the query order the results by username?
View Replies !
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?
View Replies !
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?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=...sie.nctu.edu.tw
View Replies !
AIX 5.1 Binary From UCLA Site?
I wonder if anyone would share your experience with the binary download from the UCLA library? I am thinking of an AIX 5.1 box (32 bit) first. If things go well, and if manager allows, I'd like to try another box (AIX 5.1, 64 bit). It'd be nice to hear a success story before taking the jump. Also, is UCLA's binary the same as the one at mysql.com site? If different, in what way? Is one of them 64bit and the other 3 2bit? Or are they both 32 or 64 bit?
View Replies !
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
View Replies !
Loading Binary Data
I have a large data set of binary data files and I'd like to create a database so that I can search on the data contained in these files. I'm new to database development but from what I've seen it is only possible to store & search variables in the database in text format. Is it possible to load the files as binary variables and still use MYSQL commands to search and manipulate the database? For example, assume a file contains a variable X which is a 32-bit floating point number ranging between 0 and 10. Does the variable X have to be converted to text first (possibly using a C program), stored into another text file, which is then loaded into the database/table? Or is it possible to load the 32-bit floating point number directly from the original binary file and perform a MYSQL query looking for instances of variable X with values 1.2 and 4.8?
View Replies !
INSTALL-BINARY File
Open Office has an option to use ODBC to connect to an existing mysql DB on a remote server, and I have successfully done so from a WinXP box where I installed the MySQL Connector/ODBC (I used the standalone installer for Windows) earlier today. Now I want to do the same thing with Open Office on a machine running Ubuntu linux. I downloaded mysql-connector-odbc-3.51.12-linux-i686.tar.gz and got to the place in the instructions found here: http://dev.mysql.com/doc/refman/5.0/en/myodbc-installation-binary.html#myodbc-installation-binary-unix that says "Read the installation instructions in the INSTALL-BINARY file and execute these commands." But I have no "INSTALL-BINARY file." What am I doing wrong?
View Replies !
Starting In Binary Mode
I have installed mysql 5.1 onto one of our Redhat Enterprise 3 test boxes. Theres nothing particularly important on the box as far as I am aware. Anyhow I stopped the server yesterday, with the idea of starting it in Binary Mode. I am looking into how we can do the backups for the system. Since we are due to inherit some mysql databases to look after. Code:
View Replies !
|
TRACKER
