MYSQL :: MySQL 4.1 Windows Binary

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)#%'

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?

MySQL MAx Binary For SLES 9 ?
There is no MySQL MAX binary for SLES 9 here http://dev.mysql.com/downloads/mysql/5.0.html

Which MAX binary should we use for SLES 9 ?

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.

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?

MySQL 5.0 Copy Of DB Binary Files
I'm using MyDQL 5.0 with Administrator 1.2.11 on an XP OS. I'm attempting to copy a database by simply copying the data directory and binary files, and then renaming it. MySQL Admin can see the new database and I can connect to it via ODBC. While the MySQL Admin catalog for this DB lists all the tables, it displays an error that all the tables do not exist.

MySQL Binary Or Source Distribution
I'm interested in which one is better for performance issues? The
binary distribution or a self compiled one?

Displaying Binary Images On Pages From Mysql?
On my site, my friend has made a news managment system, so that through mysql you can easily post news. Go to http://www.allsortshop.com/news to see.

In the /news folder i have index.php which is the main file, and article.php whcih is to display articles.

In the index.php, this is the php code that gets all the news from the database...

<?php
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
$result = mysql_query("SELECT * FROM news WHERE type=0 LIMIT 0 , 10");
if ($row2 = mysql_fetch_array($result)) {
echo "<table>
";
do {
Printf("<tr><td><b>%s</b></td></tr><tr><td>%s <a href=article.php?read=$row2[id]>more...</a></td></tr><tr><td> </td></tr>", $row2[title], $row2[mini], $row2[id]);
}while ($row2 = mysql_fetch_array($result));
}else{
echo "No News... Shocking!!!";
}
echo "</table>
";
?>

That displays news files, but it only displays an intro, then when you click more it goes to the full news article at /news/article.php?read=1

(in the article.php ive converted the id to read)

Then once on the page article.php?read=1 or read=2 depending on what id number the news article is in mysql, it then shows you the full story.

In the article.php this is the code at the very top of that page before the <html> tag...

<?php
$read = $_GET['read'];
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
$result = mysql_query("SELECT * FROM news WHERE id=$read");
$text = mysql_fetch_array($result);
?>

Then in the <body</body> tags of the article.php page i have...

<?php
echo ("<b>".$text['title']."</b>");
echo "<p>";
echo $text['full'];
?>

Now in the mysql this is my news table...

The thing is, i want to display all the images like image.php?id=1 or whatever and then on the news page, when you click more on an article and it takes you to article.php?read=1 then on the mysql table, on the row with id = 1 in it, it has an image at the end. I want to display that image in the article.php?read=1. And then on article.php?read=2, i want it to display the image on that one too which will be located at image.php?id=2.

Check Compiled In Options To Mysql Binary
How do I find out what options were compiled into the binary versions of mysql? Also, is there a way to see what options were compiled when a binary was manually created with configure/make/make install. Is there a query you can do on the daemon?

How To Convert MySQL Tables To Binary .dat Files
I have some mysql tables that I need to convert to binary files with .dat extension for some testing. Could anyone tell me how I can do that using the console, or any mysql tools like Navicat?

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.

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?

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 :

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:

MySQL On Windows
I downloaded and installed MySQL for Windows this morning, V4.1. =
Unzipped, installed and started the server as a service, no problems. =
Installed the ODBC driver. A-OK

But, the DOC tells me I have to run "mysql_install_db.sh". So, the =
question is, how am I supposed to run shell scripts on Windows?

Mysql 4.0.20a For Windows
i installed just a few days ago the new my sql 4.0.20a server on a Windows Machine

and heart about that the feature "auto_increment = default value" will work now

now i created a new table added some fields and one field shoud be auto_increment and shoud have a default value (which means, mysql shoud then auto_increment up from the given value), but this doesn't work

i can only choose between default value or auto_increment but not both any ideas ?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run. Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL 5.0 On Windows 98 SE
I just downloaded MySQL 5.0 and installed it on a machine that I just did a fresh install of Windows 98 Second Edition on.

The install seemed to go smoothly, and when it was done I try to start mysqld from the command line and get this:

C:Program FilesMySQLMySQL Server 5.0in>mysqld --console
051125 21:04:07 [ERROR] Can't find messagefile 'C:Program FilesMySQLMySQL Ser
ver 5.0shareenglisherrmsg.sys'
051125 21:04:07 [ERROR] Aborting

Also, when I look in the above referenced directory, the file errmsg.sys is there: Code:

Mysql On IIS Windows
I very new to mysql. I would like to get some advise on which release i should install in my windows 2000 server using IIS.

MYSQL In Windows XP Pro Sp2
i get a ERROR 0 when loading the program into my computer. and the servise could not be started, if i go into cmd and type "Net start MYSQL" it says sucsessfull

but when i go into Contrl panel > Administrtor tools > Servise's and click MYSQL it says "error 1067 could be be started"

Can I Use MySQL With A Mac And Windows
I need to share a MySQL database with a guy that uses a Mac, but I don't know anything about the Mac environment. I use WinXP. He has a server that has MySQL loaded on it. I want to create the database, then both of us want to be able to access it or make changes to it via the web.

What type of products do I need? I figure a good MySQL reference book is a necessity. Is there some type of front end application that he can run. I think I can run Access as a front end once it is set up properly. Am I making sense?

MySQL 4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine.
However version 4 won't run.

Even if I start the server with the admin panel
it shuts down again after a couple of seconds. This has only been a problem
since I wiped my hard drive and did a clean install of everything.

MySQL On Windows
when i try to install mysql on my pc it works just fine until i'm near the end of the installation, the installer writes:

the security settings could not be applied
error number 2003
can't connect to mysql server on 'localhost' (10061)

i have disable my firewall... so whats the problem then..? please make an easy explanation... i'm not that good at english so i hope that you understand me...

Mysql On A Windows Box
there are two options for mysql when it comes to windows...there is a 'windows essentials' and then there is the normal download.
the documentation says the essentials package, (it's almost half the size) is the recommended one because it has all that is needed.
i don't really care if i download the biggest file size, but if i don't need to, i'll take the smaller package.

Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6).

Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me.

As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.

Mysql, Linux Or Windows?
Does mysql work on windows or it has to be on linux only?

MySQL / Windows XP SP2 Incompatibility
I've been posting the problem earlier on Microsoft newsgroups (cannot use support, because of using OEM Windows):

Windows XP SP2 Security Center stops recognizing antivirus and firewall software when I install MySQL server and GUI tools (MySQL Administrator and MySQL Query Browser).

The only way to make the Security Center recognize the software again is to restart it using Services snap-in.

Is it a bug on Microsoft side or on MySQL team side? Are there any solutions for the problem?

Configuration:
Intel Celeron 1200 MHz / 512 MB RAM
Windows XP Home Edition with Service Pack 2
MySQL 4.1 with the latest versions of GUI tools

Cannot Get MYSQL To Start In Windows
Here are some of the errors I receive when trying to start mysql under windows xp home edition:

When I goto mysql command line client the client start but If I hit a button it shuts down.

When I type this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysql" test
ERROR 2013 (HY000): Lost connection to MySQL server during query

Or I try this:
C:>"C:Program FilesMySQLMySQL Server 5.0inmysqld" --console
060323 12:18:24 InnoDB: Operating system error number 32 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
C:>

Also while trying to install I cannot get the security setting to go thru, it give me the error 2013, lost server during query, I've tried to shut off my firewall and still the same, given access to port 3306 and still nothing.

Mysql And Windows 2003
does the latest versions of Mysql work with windows 2003.

Used Mysql On Windows Now Im On Linux Need Help!
Ok iv changed over to linux running ubuntu 6.06 after installing mysql i tried create a database i did "CREATE DATABASE forums" and got this:

./mysqladmin: CREATE DATABASE failed; error: 'Access denied for user ''@'localhost' to database 'DATABASE''

so how do i logging as root? on windows i just used the terminal thing but now i dont have that (well to the point where it asks you to login)

Does MySQL Work On Windows?
I've been trying to get 3.23 to behave on '98. MATCH seems very erratic, and FULLTEXT never works. RELOAD silently fails. Is it worth it to pursue MySQL on Windows?

Install MySQL 4.1 On Windows
I'm trying to install the 4.1 alpha binary version on Windows.

After unzipping the download I don't find a setup.exe file.

MySQL 5.0.45 Windows Install
I am having an issue installing MySQL 5.0.45 on Windows 2003 (VMware). Basically, I extracted the contents of "mysql-5.0.45-win32.zip" to c: emp and double-clicked the setup.exe. However, the install wizard doesn't launch. I get a window with the install options via CLI.

Mysql Dump And Windows
I have installed mysql on windows.

However, due to database corruption issues I would like to perform a backup every hour or so. As a result I plan to schedule a mysql dump at regular intervals(for example using the AT command). The problem is that the user that runs mysql dump has to supply the password. ie: myslqdump -u user -p databasename > backup.sql

My question is: how do I specify (in a .cmd file) the password to enter after the mysql command above? I do not think "echo password" is enough for mysql to pick up the password.

MySQL Server For Windows
I have Windows-2000 Server with IIS-5.0, PHP (4.3.0) and MySQL (3.23.55).
There are about 4000 users with their MySQL databases. Users can access databases using their PHP scripts. Only local users are allowed.

To create a user I use this command:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `User_database` . * TO 'User'@'localhost' IDENTIFIED BY 'Pass';

The problem: after 3-4 hours of work, all users getting the error message: "Can't connect to MySQL database at localhost (10061)".

I can't connect to MySQL using mysql.exe with admin username and password too!
But MySQL service is still running! Restarting of MySQL service gives no result. Restarting of IIS gives no result. Code:

MySQL 3.23 Windows Access
I am trying to set up an Invision Board forum on my windows 2003 RC2 server. I have already set up and configured PHP4. I am now in the process of setting up mySQL. I have never used it, so you can imagine how confused I feel right now.

I installed the 3.23 windows version on C:mySQL
I do not know how to access it, nor really how to use it.

The invision board is asking me to input

SQL Database Name
SQL Username
SQL Password

How do I createaccess this information.
Thank you for your help.

BTW: I recive this error while attempting to connect to my sql via cmd.exe

"ERROR 2003: Cant connect to my SQL server on Local Host (10061)"

I have two firewalls, XP's built in one and Norton Internet Security. Could this be the reason.

Windows App To MySql Table
I have a C++ Builder APP that uses the Advantage database. I want to export
data from the Advantage tables to a MySQL database on my website.

What is the best way to get my data into the MySQL table ? I am only
looking at 10-15 records, but I would be updating every 10 seconds or so.

I could create a text file and upload it via FTP, and then a PHP script
could load the text file into MySQL, but I am sure you guys know a better
way to do it.

MySQL Slow In Windows NT4
I am running the Apache web server, MySQL v4, and PHP on an NT4 server.
Apache runs great, but the auction software I am using (Web2035 Auction
software written in PHP) is very, very slow.

Sometimes it takes 20-30 seconds to bring up an auction page from the items
table which has less than 200 records in it.

Can anyone can give me some pointers on where to start looking? (I don't
know if the bottleneck is with MySQL or PHP or what I might need to look at
to enhance the performance of either package.)

Is Mysql For Windows Free?
I saw in a site that says "mysql for windows is free for one month to continue using it you must get a license". I was planning to use mysql on windows for company database I thought mysql windows version is free. Am I have to use on the linux for free solution?

Windows MySQL Questions
After installing on Windows XP, is WinMySQLAdmin.exe (WMA) the only way to start MySQL?

WMA is supposed to add a user and password to the "grant" tables. Altho it does appear in the My.ini file, if I do this:

Mysql -u root
Use mysql;
Select user,host from user;
it prints:

USER--------HOST
(blank)     build
root        build
(blank)     localhost
root        localhost

Why does the user name that shows in My.ini not show here?
(I cannot connect with that user name.)

What is the "build" host?

If MySQL is on a pc for development, and it has access to the internet, does the internet have access to the server? Do I need to be concerned about security in the same way as a web hosting server? I'm the only person who operates this pc.

Does the statement "The MySQL server should not run as the root user." refer to Windows? If yes, how is it run as a non-root user?

Loading Mysql On A Windows - IIS
I have a personal web server (IIS) that i am trying to install mysql with...or install mysql so that it is available through my IIS server.

I d/l it...now what? is there a GUI for mysql that i can use? a gui like access or something. if i create databases in mysql at home, how do i get them on a ISP server...

Installation Of Mysql 4.0.14 On Windows Xp
I am new to mysql server and trying to install the mysql server on my
windows xp home edition. I have downloaded 4.0.14 zip file on my computer.
I can unzip the file and it generates 10-15 files. When I do double click on
the setup.exe it loads for 5 seconds and then stops. No window is displayed.
No error message is generated.

I thought may be I should try some other version. I downloaded older version
4.0.13 and same thing here. I downloaded 3.23.57 and same thing here.
I am logged in as administrator. I can install other softwares without any
problem. Can you please suggest any thing I should try to install the mysql
server.

Mysql On Windows Servers
Will mysql work with microsoft server products? Does it lose any funtionality? Would it be better to use mssql?

Mysql, Linux Or Windows
Does mysql work on windows or it has to be on linux only?

Doubt In MySQL Windows
I tried to insert some large amount of text in mysql and used "Long Text" data type.

But I am not able to insert a text that is having about 1.2 million characters in it.

It is showing an error: "DBD::mysql::st execute failed: Got a packet bigger than
'max_allowed_packet' bytes".

I used PERL script for database population and using Windows 2000 OS with pentium 2.4 Ghz Processor and 512 MR RAM.

Anyone kindly tell me how to change the value for the max_allowed_packets variable in windows environment.

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?

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?