 | | | MySQL on Win32 | | Hi I work for a mobile technology company in London.
We are looking to recruit a MySQL DBA.
The world of the enterprise DBA is changing be part of it. Like it or
not open source technology is maIs it possible to use the migration tool to convert a MySql v4.1.17
database to a v5 database?
I 've tried but I run the program with the source and destination db
info as the same.
The problem seOk here ya go. This is just 1 of the databases I 'm fighting with.... )
SET @@(protected) 'ANSI_QUOTES '
SET @(protected) @@(protected)
SET @(protected) @@(protected)Steve Grosz wrote
> I get the same result just with the error being on line 14 instead of
> 13 since I added the line at the top
Can you post the CREATE TABLE command that starts at line 13/14 of I get the same result just with the error being on line 14 instead of 13
since I added the line at the top
"Todd Farmer " <todd@(protected) > wrote in message
news 46CCBF7F.9010307@(protected)
> SteSteve Grosz wrote
>
> Ok when I try it from the command line I get
>
> C \Program Files\MySQL\MySQL Server 5.0\bin >mysql.exe -uroot -ppass Sereni
> ty < Serenity.sql
> ERROR 1064 (42000) at line
Ok when I try it from the command line I get
C \Program Files\MySQL\MySQL Server 5.0\bin >mysql.exe -uroot -ppass Sereni
ty < Serenity.sql
ERROR 1064 (42000) at line 13 You have an error in your Hi Steve
Steve Grosz wrote
> Ok I had several databases on v4.1.17 that were working fine. I wanted
> to upgrade to v5 to work with stored procedures and triggers a little.
>
> I removed the Ok I had several databases on v4.1.17 that were working fine. I wanted
to upgrade to v5 to work with stored procedures and triggers a little.
I removed the instance of 4.1.17 and installed v5.
II downloaded MySQL release 5.1 beta source code <mysql-5.1.20-beta >. I
found that 5.1 source code package is a complete package with "win "
subdirectory included.
Either MySQL 5.0 online documenCheck section 2.10 in the MySQL manual.
John Bonnett
-----Original Message-----
From Steve Grosz [mailto boise_bound@(protected)]
Sent Tuesday 14 August 2007 10 01 AM
To win32@(protected)
SuIs there a easy way to upgrade from v4.1.7 to 5.x without the risk of
loosing data?
Where would I find the best process for doing this?
Thanks! )
--
MySQL Windows Mailing List
For list archiveI followed the instructions in 5.0 Reference Manual
http //dev.mysql.com/doc/refman/5.0/en/windows-source-build.html
and downloaded the latest MySQL 5.0 Windows source distribution
mysql-5.0.48-20I am running a MySql server ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year nice and quick. Now it seems
like its running slowly. Is there a tool to test theI am running a MySql server ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year nice and quick. Now it seems
like its running slowly. Is there a tool to test thI am running a MySql server ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year nice and quick. Now it seems
like its running slowly. Is there a tool to test theHi all
I have version 4.0.15 installed on my PC but I want to connect to a
v5.0 server. Obviously this is a problem as the authentication
protocols are different. I don 't particularly want to havHellow there
Is there an alternative for ampersand? Because in my MYSQL the ampersand function as a bitwise operator.
P.S.
I 'm still a newbie in MYSQL so kindly speak english.
THANK Hi
I am having a problem with installing MySQL 5.0 Community Edition on a
Windows XP Professional laptop.
The install program itself works but the configuration wizard that comes up
afterwards doesnHi All
I have a table which contains phone numbers. I want to extract these
phone numbers in a common format but they have not been entered the
same way. Is there any easy way of removing whitespacHi
I set up the muSQL server in a workgroup with a static IP address and
connected through mySQL Administrator using this address for the server
host. Now we have switched over onto a domain and ???????? ???????? ?? ??????????? ????? ???????? ????? ??????????? ????????
??????? ????? ??????? ? ????? ? ?????????.
???? ???? ??????????? ? ??????????? ??????????.
??????????? ???????? - ??? ??I have PHP&MySQL installed on my system well working.
I get error Access denied for user 'ODBC '@ 'localhost ' when I connect MySQL
using command line with a command like this
mysql -hlocalhost -urootHi
I have a question on LOAD DATA INFILE command.
I have a table with 10 columns. Is it possible to update only few
columns of this table using LOAD DATA INFILE?
When I tried it updates theWe 're purchasing a new database server to run MySQL 5.0.x. Will MySQL
utilize more than one processor on a multiprocessor Windows system?
With the 64bit version of the operating system will it uti >
> #define _WIN32_IE 0x0601
>
#define _WIN32_WINNT 0x0501
> #include <cstdlib >
> #include <iostream >
> #include <windows.h >
> #include "mysql\mysql.h "
> using namespace std
>
> int WinMainHello all
I am completely new to mysql. I would like to work with mysql and C++.
Could someone please point me to tutorials or simmilar stuff to show me
how to setup mysql and how to connect to it. Hum check the errors from apache 's logs only there you can see the true
reason
----- Original Message -----
From "Andreas F?rber " <andreas.faerber@(protected) >
To "Miguel de Icaza " <miguel@(protected)I have MySQL (latest version) and PHP 5 installed on my system.
When I start PHPMyAdmin from my local host I get an error like this
phpMyAdmin - Error
> Cannot load mysql extension. Please check yoI need a libmysql.a file for using with mysql.h header file.
I really need this library for my graduation project.
Please someone send this file to me by mail KamilKarayel@(protected)
Looking for yo |
|
|
