[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub

[QxOrm contact]

Hello,

*QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released
: https://www.qxorm.com/


*QxOrm library 1.4.5 changes log :*
* - Support MongoDB database : QxOrm library becomes a C++/Qt Object
Document Mapper ODM library !- For more details about MongoDB integration,
see QxOrm manual (https://www.qxorm.com/qxorm_en/manual.html#manual_95
) and new sample
project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now
available on GitHub (official repository) : https://github.com/QxOrm/QxOrm
- Fix an issue in qx::IxSqlQueryBuilder
class when QxOrm library is used in a multi-thread environment- Support
latest version of boost (1.66)- Update boost portable binary
serialization classes to version 5.1 (provided by
https://archive.codeplex.com/?p=epa )-
Fix an issue building SQL query for Oracle database (doesn't support AS
keyword for table alias)- Improve qx::QxClassX::registerAllClasses()
function : possibility to initialize all relations (useful to work with
introspection engine)- Improve qx::IxPersistable interface : provide new
methods toJson() / fromJson()- Improve documentation/website :
change http://www.qxorm.com
 by https://www.qxorm.com
 everywhere- Fix fetching relations with soft delete
putting SQL condition in the JOIN part instead of WHERE part- Fix SQL
generator for Oracle database : use new limit/pagination syntax (version
Oracle > 12.1)- Improve SQL generator interface : add
'onBeforeSqlPrepare()' method to modify/log SQL queries in custom classes-
Add an option in qx::QxSqlDatabase class to format SQL query
(pretty-printing) before logging it (can be customized creating a
qx::dao::detail::IxSqlGenerator sub-class)- Fix an issue with
boost/std::optional (to manage NULL database values) and some databases :
if optional is empty, then create a NULL QVariant based on
QVariant::Type- Add an option in qx::QxSqlDatabase class to insert square
brackets (or any other delimiters) in SQL queries for table name and/or
column name (to support specific database keywords)- Improve introspection
engine : add getType() method in qx::IxDataMember interface to get C++ type
of a property dynamically- Improve qx::QxSqlDatabase singleton settings
class to make easier working with several databases : now there are 3
levels of settings : global >> per thread >> per database (see
'bJustForCurrentThread' and 'pJustForThisDatabase' optional parameters in
all set() methods)- Fix QxOrm.pri for MinGW compiler on Windows : an
issue could occurred to export some symbols from shared library (some Qt
signals for example)- Add an option in qx::QxSqlDatabase singleton class to
display only slow SQL queries (see setTraceSqlOnlySlowQueriesDatabase() and
setTraceSqlOnlySlowQueriesTotal() methods)*

*QxEntityEditor application 1.2.3 changes log :*
*- Fix a crash which appears sometimes with complex database schema to draw
relationships (orthogonal way)- Improve QxEntityEditor command line
parameters : possibility to import/export without using GUI (useful to
manage a Jenkins server for example)- For more details about command line
parameters, go to QxEntityEditor documentation
: https://www.qxorm.com/qxorm_en/manual_qxee.html#qxee_command_line
*

You can download latest version of QxOrm library and QxEntityEditor
application on QxOrm website : https://www.qxorm.com/

Regards,


Lionel Marty - QxOrm library

Cannot install mysql 5.6.24 from source

[Jørn Dahl-Stamnes]

Hello,

I'm trying to install mysl 5.6.24 from source on a Fedora Core 21 server, but 
it fails during 'make 
install':

CMake Error at libmysqld/examples/cmake_install.cmake:74 (file):
  file INSTALL cannot copy file
  /var/local/src/mysql-5.6.24/mysql_client_test_embedded.
Call Stack (most recent call first):
  cmake_install.cmake:111 (include)

Makefile:66 recipe for target 'install' failed
make: *** [install] Error 1



Any suggestions?


BTW, I first tried 5.5.36 which I had installed before I had to replace the 
system disk on this 
server. I was able to start it but not to use 'mysql -u root -p' after I 
started it. Got a 
Segmentation fault - core dumped. :(

-- 
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Cannot install mysql 5.6.24 from source

[Jørn Dahl-Stamnes]

On Tuesday, May 12, 2015, Jørn Dahl-Stamnes wrote:
 Hello,
 
 I'm trying to install mysl 5.6.24 from source on a Fedora Core 21 server,
 but it fails during 'make install':
 
 CMake Error at libmysqld/examples/cmake_install.cmake:74 (file):
   file INSTALL cannot copy file
   /var/local/src/mysql-5.6.24/mysql_client_test_embedded.
 Call Stack (most recent call first):
   cmake_install.cmake:111 (include)
 
 Makefile:66 recipe for target 'install' failed
 make: *** [install] Error 1
 
 
 
 Any suggestions?

Never mind - I found out about this. For some reason the disk partition was out 
of free space.


 
 BTW, I first tried 5.5.36 which I had installed before I had to replace the
 system disk on this server. I was able to start it but not to use 'mysql
 -u root -p' after I started it. Got a Segmentation fault - core dumped. :(


-- 
Jørn Dahl-Stamnes
homepage: http://photo.dahl-stamnes.net/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: text field too small to store html page source?

[thufir]

On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote:

 You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large
 text...
 On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
 wrote:
 
 
 Am 18.11.2014 um 10:48 schrieb thufir:
  I'm trying to store a web page to table pages (whether or not
  that's a good idea for a separate thread, please).  What would be a
  suitable type for the field which stores the actual page source?

 text = 64 KB including all spaces and meta chars



Yes, MEDIUMTEXT did the trick.  Seems excessive, but works.

-thufir



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

text field too small to store html page source?

[thufir]

I'm trying to store a web page to table pages (whether or not that's a 
good idea for a separate thread, please).  What would be a suitable type 
for the field which stores the actual page source?

When running my java application, the MySQL errors are as so:

run:
 [java] [EL Info]: 2014-11-18 01:36:57.574--ServerSession(17148489)--
EclipseLink, version: Eclipse Persistence Services - 
2.5.2.v20140319-9ad6abd
 [java] [EL Info]: connection: 2014-11-18 01:36:58.798--ServerSession
(17148489)--file:/home/thufir/NetBeansProjects/AggregatorJpaClient/build/
classes/_SeleniumIteratorPU login successful
 [java] [EL Warning]: 2014-11-18 01:37:46.084--UnitOfWork(29789888)--
Exception [EclipseLink-4002] (Eclipse Persistence Services - 
2.5.2.v20140319-9ad6abd): 
org.eclipse.persistence.exceptions.DatabaseException
 [java] Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data 
truncation: Data too long for column 'page' at row 1Exception in thread 
main javax.persistence.RollbackException: Exception [EclipseLink-4002] 
(Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): 
org.eclipse.persistence.exceptions.DatabaseException
 [java] Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data 
truncation: Data too long for column 'page' at row 1
 [java] Error Code: 1406
 [java] 
 [java] Error Code: 1406
 [java] Call: INSERT INTO rome_aggregator.pages (CREATED, link_id, 
PAGE, STATUS) VALUES (?, ?, ?, ?)
 [java] bind = [4 parameters bound]
 [java] Query: InsertObjectQuery(dur.Page[ id=null ])
 [java] Call: INSERT INTO rome_aggregator.pages (CREATED, link_id, 
PAGE, STATUS) VALUES (?, ?, ?, ?)
 [java] bind = [4 parameters bound]
 [java] Query: InsertObjectQuery(dur.Page[ id=null ])
 [java] at 
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit
(EntityTransactionImpl.java:157)
 [java] at 
net.bounceme.dur.jpa.controllers.PageJpaController.create
(PageJpaController.java:31)
 [java] at net.bounceme.dur.jpa.facades.PageFacade.create
(PageFacade.java:22)


and the table structure as so:

mysql 
mysql describe pages;
+-+---+--+-+---
+-+
| Field   | Type  | Null | Key | Default   | 
Extra   |
+-+---+--+-+---
+-+
| id  | int(11)   | NO   | PRI | NULL  | 
auto_increment  |
| created | timestamp | NO   | | CURRENT_TIMESTAMP | on update 
CURRENT_TIMESTAMP |
| page| text  | NO   | | NULL  
| |
| link_id | int(11)   | NO   | | 0 
| |
| status  | int(11)   | NO   | | 0 
| |
+-+---+--+-+---
+-+
5 rows in set (0.31 sec)

mysql 
mysql select * from pages;
Empty set (0.00 sec)

mysql 

The engine is:

ENGINE=InnoDB DEFAULT CHARSET=latin1


I'll try some different options; thought I'd ask here to see how that 
error is interpreted here.  It seems to me that the String is just too 
large for the field in the database...?


thanks,

Thufir


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: text field too small to store html page source?

[Reindl Harald]

Am 18.11.2014 um 10:48 schrieb thufir:

I'm trying to store a web page to table pages (whether or not that's a
good idea for a separate thread, please).  What would be a suitable type
for the field which stores the actual page source?


text = 64 KB including all spaces and meta chars



signature.asc
Description: OpenPGP digital signature

Re: text field too small to store html page source?

[Daniel Rios Couto]

You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
wrote:


 Am 18.11.2014 um 10:48 schrieb thufir:
  I'm trying to store a web page to table pages (whether or not that's a
  good idea for a separate thread, please).  What would be a suitable type
  for the field which stores the actual page source?

 text = 64 KB including all spaces and meta chars

no binary and source code of MySQL ODBC Connector 5.2.5 for AIX plarform

[Shen, Tingting]

Hi,

I want to install MySQL ODBC Connector 5.2.5 on AIX 7.1 platform. But I cannot 
find any binary for installation on AIX platform. In addition, I also tried to 
build my own installation binary from source code , but found no source code 
for AIX platform.
http://downloads.mysql.com/archives/c-odbc/

Does MySQL ODBC Connector 5.2.5 support AIX platform? Or MySQL only support AIX 
platform with 5.1 version or prior?

Thanks,
Tingting

Unable to connect to foreign data source

[asd asdf]

I had a problem why trying Federated Engine.
Creating tables generate no problems but trying inserting raise an error as
Error 1429 (HY000): Unable to connect to a foreign data source: Can't
connect to MySQL server on '192.168.0.11' (111).

My OS is newly install with no firewall restriction on the system.
And I'm using 'root' user with all privileges.
I can't seem to find a solution at any sites.

Anyone with suggestion for this problems?

The problem could be recreated as the code below.

drop table if exists test001 ;
create table test001 (
   xx bigint(20) unsigned
   )
ENGINE=InnoDB
DEFAULT CHARSET=utf8;

drop table if exists test001FE ;
create table test001FE (
   xx bigint(20) unsigned
   )
ENGINE=FEDERATED
DEFAULT CHARSET=utf8
CONNECTION =  'mysql://root:root@192.168.0.11:3306/Prelude_copy/test001';


insert into test001FE(xx) values (12);

RE: Unable to connect to foreign data source

[Bob Eby]

 CONNECTION =  'mysql://root:root@*stripped*:3306/Prelude_copy/test001';

Should be more like:

CONNECTION = 'mysql://root:stripped_password@localhost/penrepository/test001';

Just seems word if you're showing us your password is root but not host...
I ran your example just fine against localhost on MySQL 5.6 Win7-64bit.

-Bob

RE: MySQL LDAP Authentication Plugin - Full example with source code

[Rick James]

Does that depend on mysql running as root in order to see /etc/shadow (or 
whatever)?

If so, that is too big a security hole to do.

 -Original Message-
 From: Ignacio Ocampo [mailto:naf...@gmail.com]
 Sent: Sunday, August 12, 2012 3:54 PM
 To: mysql
 Subject: MySQL LDAP Authentication Plugin - Full example with source
 code
 
 I have published in my blog, an full example (with source code) of a
 LDAP Authentication plugin for MySQL.
 
 http://nafiux.com/blog/2012/08/11/mysql-ldap-authentication-plugin/
 
 --
 Ignacio Ocampo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL LDAP Authentication Plugin - Full example with source code

[Ignacio Ocampo]

Hi Rick,

The plugin does not need to access to /etc/passwd or /etc/shadow.

It uses an LDAP Server to authenticate the user through
ldap_simple_bind_s function.

Best regards.

On Mon, Aug 20, 2012 at 7:24 PM, Rick James rja...@yahoo-inc.com wrote:

 Does that depend on mysql running as root in order to see /etc/shadow
 (or whatever)?

 If so, that is too big a security hole to do.

  -Original Message-
  From: Ignacio Ocampo [mailto:naf...@gmail.com]
  Sent: Sunday, August 12, 2012 3:54 PM
  To: mysql
  Subject: MySQL LDAP Authentication Plugin - Full example with source
  code
 
  I have published in my blog, an full example (with source code) of a
  LDAP Authentication plugin for MySQL.
 
  http://nafiux.com/blog/2012/08/11/mysql-ldap-authentication-plugin/
 
  --
  Ignacio Ocampo




-- 
Ignacio Ocampo Millán

MySQL LDAP Authentication Plugin - Full example with source code

[Ignacio Ocampo]

I have published in my blog, an full example (with source code) of a LDAP
Authentication plugin for MySQL.

http://nafiux.com/blog/2012/08/11/mysql-ldap-authentication-plugin/

-- 
Ignacio Ocampo

Re: libmysqlclient from source

[Dan Nelson]

In the last episode (Nov 02), Nick Khamis said:
 Hello Everyone,
 
 I am looking to build just the mysql client, and not the entire server
 from source.
 Which cmake flags do I need to install just the mysql client/devel header 
 files.
 The actualy mysql server is on a different machine.

Try -DWITHOUT_SERVER=1 ; it's not documented, but matches the autoconf
--without-server flag, which was documented.

-- 
Dan Nelson
dnel...@allantgroup.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

libmysqlclient from source

[Nick Khamis]

Hello Everyone,

I am looking to build just the mysql client, and not the entire server
from source.
Which cmake flags do I need to install just the mysql client/devel header files.
The actualy mysql server is on a different machine.

Thanks in Advance,

Nick.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: libmysqlclient from source

[Nick Khamis]

I should have mentioned that this is using mysql 5.5.15

Thanks Again,

Nick.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

[Frank Chang]

Good afternoon, We developed a C++ class algorithm and code together with
sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single
Windows DLL/UNIX-LINUX SO

Now we would like to change from SQLite to MySQL to take advantage of
MySQL's ability to do parallel writes on separate threads.

We would still like to combine our c++ algorithm class code, MySQL.c (I am
not sure of the exact name) and the MySQL C/C++ UDFS into a single Windows
DLL/ Unix-Linux SO.

If so, How can this be done? Thank you,

Re: Is it it posiible to combine the C++ algorithm code, the MYSQL source code and the UDF code into a single DLL/SO?

[Frank Chang]

Good evening, Apparently MySQL supports a single client connection to a
local MySQL server
Quoting from the MySQL :: MySQL 5.0 Reference Manual :: 4.2.2
Connecting to the MySQL Server URL by Booz-Allen New York City consultants

The following table shows the permissible --protocol option values on
different operating systems.
 TCP TCP/IP connection to local or remote server All OS
SOCKET Unix socket file connection to local server Unix only
PIPE Named-pipe connection to local or remote server Windows only
MEMORY Shared-memory connection to local server Windows only

On Thu, Sep 8, 2011 at 12:46 PM, Frank Chang frankchan...@gmail.com wrote:

 Good afternoon, We developed a C++ class algorithm and code together with
 sqlite3.c and the sqlite C/C++ UDFs. Everything is combined into a single
 Windows DLL/UNIX-LINUX SO

 Now we would like to change from SQLite to MySQL to take advantage of
 MySQL's ability to do parallel writes on separate threads.

 We would still like to combine our c++ algorithm class code, MySQL.c (I am
 not sure of the exact name) and the MySQL C/C++ UDFS into a single Windows
 DLL/ Unix-Linux SO.

 If so, How can this be done? Thank you,

Re: Build from bazaar source on Mac 10.7 (Lion) fails

[Jan Steinman]

 From: Derek Downey de...@orange-pants.com
 
 I am trying to setup a development machine to start delving into some of the 
 internal code of the MySQL DB. I'm off to a great start, since I can't even 
 get it to build properly...
 
 My machine is: 
 
 $ uname -a 
 Darwin DDMac 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT 
 2011; root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64

Since you're on a Mac, have you considered using MacPorts? MySQL builds and 
installs flawlessly on 10.6.8 with sudo port -f install mysql5 here. (Haven't 
tried it on 10.7 yet.)

http://www.macports.org/


I can remember when a good politician had to be 75 percent ability and 25 
percent actor, but I can well see the day when the reverse could be true. -- 
Harry S. Truman
 Jan Steinman, EcoReality Co-op 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Build from bazaar source on Mac 10.7 (Lion) fails

[Derek Downey]

MacPorts is nice, but I am wanting to start tinkering with the source code.

I was able to get it to build with the following steps on Lion:

$ mkdir mysql-repo 
$ cd mysql-repo/ 
$ bzr init-repo . 
$ bzr branch lp:mysql-server/5.5 5.5 
$ cd 5.5 
$ ./BUILD/compile-pentium64-debug-max --prefix=/usr/local/mysql5.5 
$ sudo make install 

I think my cmake step was missing a flag to specify x86_64 arch

Derek Downey

On Sep 3, 2011, at 2:38 PM, Jan Steinman wrote:

 From: Derek Downey de...@orange-pants.com
 
 I am trying to setup a development machine to start delving into some of the 
 internal code of the MySQL DB. I'm off to a great start, since I can't even 
 get it to build properly...
 
 My machine is: 
 
 $ uname -a 
 Darwin DDMac 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT 
 2011; root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64
 
 Since you're on a Mac, have you considered using MacPorts? MySQL builds and 
 installs flawlessly on 10.6.8 with sudo port -f install mysql5 here. 
 (Haven't tried it on 10.7 yet.)
 
http://www.macports.org/
 
 
 I can remember when a good politician had to be 75 percent ability and 25 
 percent actor, but I can well see the day when the reverse could be true. -- 
 Harry S. Truman
  Jan Steinman, EcoReality Co-op 
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=de...@orange-pants.com
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Build from bazaar source on Mac 10.7 (Lion) fails

[Derek Downey]

Hello, 

I am trying to setup a development machine to start delving into some of the 
internal code of the MySQL DB. I'm off to a great start, since I can't even get 
it to build properly. I'm sure I'm missing an important step, but am following 
the instructions from 
http://dev.mysql.com/doc/refman/5.5/en/installing-development-tree.html and 
http://dev.mysql.com/doc/refman/5.5/en/installing-source-distribution.html 

Below are my steps, but I do have another instance of mysql running that I use 
for work development. So I was trying to set this one up as on a different 
port. 

$ mkdir mysql-repo 
$ cd mysql-repo/ 
$ bzr init-repo . 
$ bzr branch lp:mysql-server/5.5 5.5 
$ cd 5.5 
$ cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5 -DMYSQL_TCP_PORT=3310 
-DMYSQL_UNIX_ADDR=/tmp/mysql-devel.sock 
$ make VERBOSE=1 

The Make step fails at 95%, here's the last few lines: 

[ 95%] Building C object unittest/mysys/CMakeFiles/lf-t.dir/lf-t.c.o 
cd /Users/derekd/devel/mysql-repo/5.5/unittest/mysys  /usr/bin/gcc 
-DHAVE_CONFIG_H -Wall -O2 -g -DDBUG_OFF 
-I/Users/derekd/devel/mysql-repo/5.5/include 
-I/Users/derekd/devel/mysql-repo/5.5/sql 
-I/Users/derekd/devel/mysql-repo/5.5/regex 
-I/Users/derekd/devel/mysql-repo/5.5/extra/yassl/include 
-I/Users/derekd/devel/mysql-repo/5.5/unittest/mytap -o 
CMakeFiles/lf-t.dir/lf-t.c.o -c 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/lf-t.c 
Linking C executable lf-t 
cd /Users/derekd/devel/mysql-repo/5.5/unittest/mysys  /Applications/CMake 
2.8-5.app/Contents/bin/cmake -E cmake_link_script CMakeFiles/lf-t.dir/link.txt 
--verbose=1 
/usr/bin/gcc -Wall -O2 -g -DDBUG_OFF -Wl,-search_paths_first 
-Wl,-headerpad_max_install_names CMakeFiles/lf-t.dir/lf-t.c.o -o lf-t -lpthread 
../mytap/libmytap.a ../../mysys/libmysys.a ../../strings/libstrings.a 
../../dbug/libdbug.a ../../mysys/libmysys.a ../../dbug/libdbug.a 
../../strings/libstrings.a -lz -lpthread 
/Applications/CMake 2.8-5.app/Contents/bin/cmake -E cmake_progress_report 
/Users/derekd/devel/mysql-repo/5.5/CMakeFiles 
[ 95%] Built target lf-t 
make -f unittest/mysys/CMakeFiles/my_atomic-t.dir/build.make 
unittest/mysys/CMakeFiles/my_atomic-t.dir/depend 
cd /Users/derekd/devel/mysql-repo/5.5  /Applications/CMake 
2.8-5.app/Contents/bin/cmake -E cmake_depends Unix Makefiles 
/Users/derekd/devel/mysql-repo/5.5 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys 
/Users/derekd/devel/mysql-repo/5.5 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/CMakeFiles/my_atomic-t.dir/DependInfo.cmake
 --color= 
Dependee 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/CMakeFiles/my_atomic-t.dir/DependInfo.cmake
 is newer than depender 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/CMakeFiles/my_atomic-t.dir/depend.internal.
 
Dependee 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/CMakeFiles/CMakeDirectoryInformation.cmake
 is newer than depender 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/CMakeFiles/my_atomic-t.dir/depend.internal.
 
Scanning dependencies of target my_atomic-t 
make -f unittest/mysys/CMakeFiles/my_atomic-t.dir/build.make 
unittest/mysys/CMakeFiles/my_atomic-t.dir/build 
/Applications/CMake 2.8-5.app/Contents/bin/cmake -E cmake_progress_report 
/Users/derekd/devel/mysql-repo/5.5/CMakeFiles 
[ 95%] Building C object 
unittest/mysys/CMakeFiles/my_atomic-t.dir/my_atomic-t.c.o 
cd /Users/derekd/devel/mysql-repo/5.5/unittest/mysys  /usr/bin/gcc 
-DHAVE_CONFIG_H -Wall -O2 -g -DDBUG_OFF 
-I/Users/derekd/devel/mysql-repo/5.5/include 
-I/Users/derekd/devel/mysql-repo/5.5/sql 
-I/Users/derekd/devel/mysql-repo/5.5/regex 
-I/Users/derekd/devel/mysql-repo/5.5/extra/yassl/include 
-I/Users/derekd/devel/mysql-repo/5.5/unittest/mytap -o 
CMakeFiles/my_atomic-t.dir/my_atomic-t.c.o -c 
/Users/derekd/devel/mysql-repo/5.5/unittest/mysys/my_atomic-t.c 
/var/folders/1q/0bfhzdp923vf_856z7dzsncmgn/T//ccROezHa.s:596:suffix or 
operands invalid for `add' 
make[2]: *** [unittest/mysys/CMakeFiles/my_atomic-t.dir/my_atomic-t.c.o] Error 
1 
make[1]: *** [unittest/mysys/CMakeFiles/my_atomic-t.dir/all] Error 2 
make: *** [all] Error 2 


My machine is: 

$ uname -a 
Darwin DDMac 11.1.0 Darwin Kernel Version 11.1.0: Tue Jul 26 16:07:11 PDT 2011; 
root:xnu-1699.22.81~1/RELEASE_X86_64 x86_64 


Thanks for any help.

P.S. I have posted this on the Builds/Binary Forums, so I apologize for the 
duplicate content. 

mysql vs source

[Brent Clark]

Hiya

I just found that I can run
 mysql db -e 'source exporteddbdata.sql'

The question I would like to ask is. Is there a speed difference between

mysql db  exporteddbdata.sql
and
mysql db -e 'source exporteddbdata.sql'
(using source)

Reason im asking is, I got a exported 5.4GB database file, and I need to 
import it as quickly as possible.

When I initially testing it, is ran for 170m40.935s

Generally I just scp the files (learnt this from Mylvmbackup), but the 
problem is, is that the source DB is Mysql 5.1 and the target is Mysql 5.0.


Thanks
Brent

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql vs source

[Dan Nelson]

In the last episode (Mar 10), Brent Clark said:
 Hiya
 
 I just found that I can run
   mysql db -e 'source exporteddbdata.sql'
 
 The question I would like to ask is. Is there a speed difference between
 
 mysql db  exporteddbdata.sql
 and
 mysql db -e 'source exporteddbdata.sql'
 (using source)
 
 Reason im asking is, I got a exported 5.4GB database file, and I need to 
 import it as quickly as possible.
 When I initially testing it, is ran for 170m40.935s

I would guess that 95% of that time will be spent within the mysqld server
rather than the mysql client, and if there is a difference between your two
mysql commandlines it won't be noticed.
 
-- 
Dan Nelson
dnel...@allantgroup.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Download, configure, compile, and install MySQL 5.5.8 from source code on Linux

[shahryar ghazi]

Download, configure, compile, and install MySQL 5.5.8 from source code on
Linuxhttp://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_558_on_linux.php

thanks.

Re: How to Install mysql from source

[Krishna Chandra Prajapati]

Hi,

There is a detailed readme (text file) within the file you have downloaded.
It will gives you the complete picture.

Krishna
cgi.com

On Mon, Oct 18, 2010 at 9:24 PM, ml ml mliebher...@googlemail.com wrote:

 Hello List,

 i am trying to install mysql on debian lenny from source. Here is what
 i did (yes, i did read the INSTALL-SOURCE):

 ./configure --prefix=/usr/local/mysql/

  make -j 4  make install

 cp support-files/my-medium.cnf /etc/my.cnf
 cd /usr/local/mysql
 chown -R mysql .
 chgrp -R mysql .
 bin/mysql_install_db --user=mysql

 FATAL ERROR: Could not find mysqld

 The following directories were searched:

/usr/libexec
/usr/sbin
/usr/bin

 If you compiled from source, you need to run 'make install' to
 copy the software into the correct location ready for operation.

 If you are using a binary release, you must either be at the top
 level of the extracted archive, or pass the --basedir option
 pointing to that location.

 == Okay, this my make some sense. Whats the _correct_ way to solve
 this? Which mysql_install_db options do i need here?

 bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
 Installing MySQL system tables...
 101018 11:50:13 [ERROR] /usr/local/mysql//libexec/mysqld: unknown
 option '--skip-bdb'
 101018 11:50:13 [ERROR] Aborting

 101018 11:50:13 [Note] /usr/local/mysql//libexec/mysqld: Shutdown complete


 Installation of system tables failed!  Examine the logs in
 /var/lib/mysql for more information.


 == Why does it also log to /var/lib/mysql ?
 find /var/lib/mysql/
 /var/lib/mysql/
 /var/lib/mysql/mysql
 /var/lib/mysql/test
 /var/lib/mysql/mysql-bin.index


 Cheers,
 Mario

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com

How to Install mysql from source

[ml ml]

Hello List,

i am trying to install mysql on debian lenny from source. Here is what
i did (yes, i did read the INSTALL-SOURCE):

./configure --prefix=/usr/local/mysql/

 make -j 4  make install

cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql

FATAL ERROR: Could not find mysqld

The following directories were searched:

/usr/libexec
/usr/sbin
/usr/bin

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

== Okay, this my make some sense. Whats the _correct_ way to solve
this? Which mysql_install_db options do i need here?

bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
Installing MySQL system tables...
101018 11:50:13 [ERROR] /usr/local/mysql//libexec/mysqld: unknown
option '--skip-bdb'
101018 11:50:13 [ERROR] Aborting

101018 11:50:13 [Note] /usr/local/mysql//libexec/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.


== Why does it also log to /var/lib/mysql ?
find /var/lib/mysql/
/var/lib/mysql/
/var/lib/mysql/mysql
/var/lib/mysql/test
/var/lib/mysql/mysql-bin.index


Cheers,
Mario

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to Install mysql from source

[Sharl.Jimh.Tsin]

you should read the INSTALL file more patient,and know the difference
between prefix  exec-prefix.

Best regards,
Sharl.Jimh.Tsin (From China)



2010/10/18 ml ml mliebher...@googlemail.com:
 Hello List,

 i am trying to install mysql on debian lenny from source. Here is what
 i did (yes, i did read the INSTALL-SOURCE):

 ./configure --prefix=/usr/local/mysql/

  make -j 4  make install

 cp support-files/my-medium.cnf /etc/my.cnf
 cd /usr/local/mysql
 chown -R mysql .
 chgrp -R mysql .
 bin/mysql_install_db --user=mysql

 FATAL ERROR: Could not find mysqld

 The following directories were searched:

    /usr/libexec
    /usr/sbin
    /usr/bin

 If you compiled from source, you need to run 'make install' to
 copy the software into the correct location ready for operation.

 If you are using a binary release, you must either be at the top
 level of the extracted archive, or pass the --basedir option
 pointing to that location.

 == Okay, this my make some sense. Whats the _correct_ way to solve
 this? Which mysql_install_db options do i need here?

 bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
 Installing MySQL system tables...
 101018 11:50:13 [ERROR] /usr/local/mysql//libexec/mysqld: unknown
 option '--skip-bdb'
 101018 11:50:13 [ERROR] Aborting

 101018 11:50:13 [Note] /usr/local/mysql//libexec/mysqld: Shutdown complete


 Installation of system tables failed!  Examine the logs in
 /var/lib/mysql for more information.


 == Why does it also log to /var/lib/mysql ?
 find /var/lib/mysql/
 /var/lib/mysql/
 /var/lib/mysql/mysql
 /var/lib/mysql/test
 /var/lib/mysql/mysql-bin.index


 Cheers,
 Mario

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:    http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

multiple mysql installations - Install mysql from source with a prefix

[ml ml]

Hello List,

how do i install mysql COMPLETLY in a diffrent directory?

Right now i am using:
./configure --prefix=/usr/local/mysql-5.1.42
--sysconfdir=/usr/local/mysql-5.1.42/etc

BUT, mysql still looks for /etc/my.cnf and for
/var/log/mysql/mysql-bin.index ...

So what configure options do i need if i want to install mysql
seperatly in a folder?
Do i also need --datadir? If yes, where sould my data dir be? In
/usr/local/mysql-5.1.42/var?

Thanks a lot,
Mario

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: multiple mysql installations - Install mysql from source with a prefix

[Claudio Nanni]

hi,
do you want to compile or you can use binaries?

Claudio

2010/10/15 ml ml mliebher...@googlemail.com

 Hello List,

 how do i install mysql COMPLETLY in a diffrent directory?

 Right now i am using:
 ./configure --prefix=/usr/local/mysql-5.1.42
 --sysconfdir=/usr/local/mysql-5.1.42/etc

 BUT, mysql still looks for /etc/my.cnf and for
 /var/log/mysql/mysql-bin.index ...

 So what configure options do i need if i want to install mysql
 seperatly in a folder?
 Do i also need --datadir? If yes, where sould my data dir be? In
 /usr/local/mysql-5.1.42/var?

 Thanks a lot,
 Mario

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com




-- 
Claudio

Re: multiple mysql installations - Install mysql from source with a prefix

[ml ml]

Hi Claudio,

i would like to compile it from source.

Mario


On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni claudio.na...@gmail.com wrote:
 hi,
 do you want to compile or you can use binaries?

 Claudio

 2010/10/15 ml ml mliebher...@googlemail.com

 Hello List,

 how do i install mysql COMPLETLY in a diffrent directory?

 Right now i am using:
 ./configure --prefix=/usr/local/mysql-5.1.42
 --sysconfdir=/usr/local/mysql-5.1.42/etc

 BUT, mysql still looks for /etc/my.cnf and for
 /var/log/mysql/mysql-bin.index ...

 So what configure options do i need if i want to install mysql
 seperatly in a folder?
 Do i also need --datadir? If yes, where sould my data dir be? In
 /usr/local/mysql-5.1.42/var?

 Thanks a lot,
 Mario

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
  http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com




 --
 Claudio


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: multiple mysql installations - Install mysql from source with a prefix

[Himanshu Raina]

Hi Mario,

While installing a new instance you don't exactly need to mention
anything except for the --prefix option. While starting the new instance
you can provide all config parameters like config file, datadir etc.


On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
 Hello List,
 
 how do i install mysql COMPLETLY in a diffrent directory?
 
 Right now i am using:
 ./configure --prefix=/usr/local/mysql-5.1.42
 --sysconfdir=/usr/local/mysql-5.1.42/etc
 
 BUT, mysql still looks for /etc/my.cnf and for
 /var/log/mysql/mysql-bin.index ...
 
 So what configure options do i need if i want to install mysql
 seperatly in a folder?
 Do i also need --datadir? If yes, where sould my data dir be? In
 /usr/local/mysql-5.1.42/var?
 
 Thanks a lot,
 Mario
 
-- 
Regards,

Himanshu Raina 
-- 
Guillotine, n.:
A French chopping center.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: multiple mysql installations - Install mysql from source with a prefix

[Claudio Nanni]

Hi Mario,

MySQL search my.cnf in this order(if I remember well):


   1. /etc/my.cnf
   2. /basedir/my.cnf
   3. /datadir/my.cnf
   4. $userhome/my.cnf


you have to make sure that you REMOVE ate least /etc/my.cnf from the system

try and let me know

Claudio





2010/10/15 ml ml mliebher...@googlemail.com

 Hi Claudio,

 i would like to compile it from source.

 Mario


 On Fri, Oct 15, 2010 at 2:08 PM, Claudio Nanni claudio.na...@gmail.com
 wrote:
  hi,
  do you want to compile or you can use binaries?
 
  Claudio
 
  2010/10/15 ml ml mliebher...@googlemail.com
 
  Hello List,
 
  how do i install mysql COMPLETLY in a diffrent directory?
 
  Right now i am using:
  ./configure --prefix=/usr/local/mysql-5.1.42
  --sysconfdir=/usr/local/mysql-5.1.42/etc
 
  BUT, mysql still looks for /etc/my.cnf and for
  /var/log/mysql/mysql-bin.index ...
 
  So what configure options do i need if i want to install mysql
  seperatly in a folder?
  Do i also need --datadir? If yes, where sould my data dir be? In
  /usr/local/mysql-5.1.42/var?
 
  Thanks a lot,
  Mario
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
   http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
 
 
 
 
  --
  Claudio
 




-- 
Claudio

Re: multiple mysql installations - Install mysql from source with a prefix

[ml ml]

Hello,

i installed mysql with:
./configure --prefix=/usr/local/myprefix/mysql/  make  make install

(at the point mysql is not running yet)

Next i would like to initialize the DB but get the follwoing error:
--
#:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql
--basedir=/usr/local/myprefix/mysql/
--datadir=/usr/local/myprefix/mysql/data
Installing MySQL system tables...
101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536
adjusted to 131072
/usr/local/myprefix/mysql//libexec/mysqld: File
'/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
101015 15:13:17 [ERROR] Aborting

101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld:
Shutdown complete


Installation of system tables failed!  Examine the logs in
/usr/local/myprefix/mysql/data for more information.





find /usr/local/myprefix/mysql/data/
/usr/local/myprefix/mysql/data/
/usr/local/myprefix/mysql/data/mysql
/usr/local/myprefix/mysql/data/test

---

And  the folder /var/log/mysql/ does not exist. I dont want it to be
there anyway.


Cheers,
Mario



On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina
himanshu.ra...@naukri.com wrote:
 Hi Mario,

 While installing a new instance you don't exactly need to mention
 anything except for the --prefix option. While starting the new instance
 you can provide all config parameters like config file, datadir etc.


 On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
 Hello List,

 how do i install mysql COMPLETLY in a diffrent directory?

 Right now i am using:
 ./configure --prefix=/usr/local/mysql-5.1.42
 --sysconfdir=/usr/local/mysql-5.1.42/etc

 BUT, mysql still looks for /etc/my.cnf and for
 /var/log/mysql/mysql-bin.index ...

 So what configure options do i need if i want to install mysql
 seperatly in a folder?
 Do i also need --datadir? If yes, where sould my data dir be? In
 /usr/local/mysql-5.1.42/var?

 Thanks a lot,
 Mario

 --
 Regards,

 Himanshu Raina
 --
 Guillotine, n.:
        A French chopping center.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: multiple mysql installations - Install mysql from source with a prefix

[Himanshu Raina]

You can pass the following variables as well

 --defaults-extra-file=path-to-my.cnf
 --socket=path-to-socket-file
--port=port-no

On Fri, 2010-10-15 at 18:50 +0530, ml ml wrote:
 Hello,
 
 i installed mysql with:
 ./configure --prefix=/usr/local/myprefix/mysql/  make  make install
 
 (at the point mysql is not running yet)
 
 Next i would like to initialize the DB but get the follwoing error:
 --
 #:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql
 --basedir=/usr/local/myprefix/mysql/
 --datadir=/usr/local/myprefix/mysql/data
 Installing MySQL system tables...
 101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536
 adjusted to 131072
 /usr/local/myprefix/mysql//libexec/mysqld: File
 '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
 101015 15:13:17 [ERROR] Aborting
 
 101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld:
 Shutdown complete
 
 
 Installation of system tables failed!  Examine the logs in
 /usr/local/myprefix/mysql/data for more information.
 
 
 
 
 
 find /usr/local/myprefix/mysql/data/
 /usr/local/myprefix/mysql/data/
 /usr/local/myprefix/mysql/data/mysql
 /usr/local/myprefix/mysql/data/test
 
 ---
 
 And  the folder /var/log/mysql/ does not exist. I dont want it to be
 there anyway.
 
 
 Cheers,
 Mario
 
 
 
 On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina
 himanshu.ra...@naukri.com wrote:
  Hi Mario,
 
  While installing a new instance you don't exactly need to mention
  anything except for the --prefix option. While starting the new instance
  you can provide all config parameters like config file, datadir etc.
 
 
  On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
  Hello List,
 
  how do i install mysql COMPLETLY in a diffrent directory?
 
  Right now i am using:
  ./configure --prefix=/usr/local/mysql-5.1.42
  --sysconfdir=/usr/local/mysql-5.1.42/etc
 
  BUT, mysql still looks for /etc/my.cnf and for
  /var/log/mysql/mysql-bin.index ...
 
  So what configure options do i need if i want to install mysql
  seperatly in a folder?
  Do i also need --datadir? If yes, where sould my data dir be? In
  /usr/local/mysql-5.1.42/var?
 
  Thanks a lot,
  Mario
 
  --
  Regards,
 
  Himanshu Raina
  --
  Guillotine, n.:
 A French chopping center.
 
 
-- 
Regards,

Himanshu Raina 
-- 
I'm successful because I'm lucky.   The harder I work, the luckier I get.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: multiple mysql installations - Install mysql from source with a prefix

[Claudio Nanni]

did you remove /etc/my.cnf?

2010/10/15 ml ml mliebher...@googlemail.com

 Hello,

 i installed mysql with:
 ./configure --prefix=/usr/local/myprefix/mysql/  make  make install

 (at the point mysql is not running yet)

 Next i would like to initialize the DB but get the follwoing error:
 --
 #:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql
 --basedir=/usr/local/myprefix/mysql/
 --datadir=/usr/local/myprefix/mysql/data
 Installing MySQL system tables...
 101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536
 adjusted to 131072
 /usr/local/myprefix/mysql//libexec/mysqld: File
 '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
 101015 15:13:17 [ERROR] Aborting

 101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld:
 Shutdown complete


 Installation of system tables failed!  Examine the logs in
 /usr/local/myprefix/mysql/data for more information.



 

 find /usr/local/myprefix/mysql/data/
 /usr/local/myprefix/mysql/data/
 /usr/local/myprefix/mysql/data/mysql
 /usr/local/myprefix/mysql/data/test

 ---

 And  the folder /var/log/mysql/ does not exist. I dont want it to be
 there anyway.


 Cheers,
 Mario



 On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina
 himanshu.ra...@naukri.com wrote:
  Hi Mario,
 
  While installing a new instance you don't exactly need to mention
  anything except for the --prefix option. While starting the new instance
  you can provide all config parameters like config file, datadir etc.
 
 
  On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
  Hello List,
 
  how do i install mysql COMPLETLY in a diffrent directory?
 
  Right now i am using:
  ./configure --prefix=/usr/local/mysql-5.1.42
  --sysconfdir=/usr/local/mysql-5.1.42/etc
 
  BUT, mysql still looks for /etc/my.cnf and for
  /var/log/mysql/mysql-bin.index ...
 
  So what configure options do i need if i want to install mysql
  seperatly in a folder?
  Do i also need --datadir? If yes, where sould my data dir be? In
  /usr/local/mysql-5.1.42/var?
 
  Thanks a lot,
  Mario
 
  --
  Regards,
 
  Himanshu Raina
  --
  Guillotine, n.:
 A French chopping center.
 
 

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com




-- 
Claudio

Re: multiple mysql installations - Install mysql from source with a prefix

[Suresh Kuna]

you can use mysqld_multi

On Fri, Oct 15, 2010 at 8:24 PM, Claudio Nanni claudio.na...@gmail.comwrote:

 did you remove /etc/my.cnf?

 2010/10/15 ml ml mliebher...@googlemail.com

  Hello,
 
  i installed mysql with:
  ./configure --prefix=/usr/local/myprefix/mysql/  make  make install
 
  (at the point mysql is not running yet)
 
  Next i would like to initialize the DB but get the follwoing error:
  --
  #:/usr/local/myprefix/mysql# bin/mysql_install_db --user=mysql
  --basedir=/usr/local/myprefix/mysql/
  --datadir=/usr/local/myprefix/mysql/data
  Installing MySQL system tables...
  101015 15:13:17 [Warning] option 'thread_stack': unsigned value 65536
  adjusted to 131072
  /usr/local/myprefix/mysql//libexec/mysqld: File
  '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
  101015 15:13:17 [ERROR] Aborting
 
  101015 15:13:17 [Note] /usr/local/myprefix/mysql//libexec/mysqld:
  Shutdown complete
 
 
  Installation of system tables failed!  Examine the logs in
  /usr/local/myprefix/mysql/data for more information.
 
 
 
  
 
  find /usr/local/myprefix/mysql/data/
  /usr/local/myprefix/mysql/data/
  /usr/local/myprefix/mysql/data/mysql
  /usr/local/myprefix/mysql/data/test
 
  ---
 
  And  the folder /var/log/mysql/ does not exist. I dont want it to be
  there anyway.
 
 
  Cheers,
  Mario
 
 
 
  On Fri, Oct 15, 2010 at 2:12 PM, Himanshu Raina
  himanshu.ra...@naukri.com wrote:
   Hi Mario,
  
   While installing a new instance you don't exactly need to mention
   anything except for the --prefix option. While starting the new
 instance
   you can provide all config parameters like config file, datadir etc.
  
  
   On Fri, 2010-10-15 at 16:47 +0530, ml ml wrote:
   Hello List,
  
   how do i install mysql COMPLETLY in a diffrent directory?
  
   Right now i am using:
   ./configure --prefix=/usr/local/mysql-5.1.42
   --sysconfdir=/usr/local/mysql-5.1.42/etc
  
   BUT, mysql still looks for /etc/my.cnf and for
   /var/log/mysql/mysql-bin.index ...
  
   So what configure options do i need if i want to install mysql
   seperatly in a folder?
   Do i also need --datadir? If yes, where sould my data dir be? In
   /usr/local/mysql-5.1.42/var?
  
   Thanks a lot,
   Mario
  
   --
   Regards,
  
   Himanshu Raina
   --
   Guillotine, n.:
  A French chopping center.
  
  
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
  http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
 
 


 --
 Claudio




-- 
Thanks
Suresh Kuna
MySQL DBA

Re: mysql 5.5.3 and innodb from source. (SOLVED)

[Andrés Tello]

Thanks to everybody, and to Rob Wultsch, his link helped me to understand
what I was doing...

./configure select an automake configure or a perl one...

I ended building mysql with innodb,heap,myisam and partitions, statically
built with:

./configure --with-plugins=heap,partition,innobase,myisam
--prefix=/usr/local/mysql5/ --with-plugin-heap --with-plugin-partition
--with-plugin-innobase --with-plugin-myisam

The first line says that the flags are recognzed:
configure.pl : calling cmake /usr/src/mysql-5.5.4-m3  -DWITH_HEAP=1
-DWITH_PARTITION=1 -DWITH_INNOBASE=1 -DWITH_MYISAM=1
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5/ -DWITH_PLUGIN_HEAP=1
-DWITH_PLUGIN_PARTITION=1 -DWITH_PLUGIN_INNOBASE=1 -DWITH_PLUGIN_MYISAM=1

and after install:
show engines;
mysql show engines;
++-++--+--++
| Engine | Support |
Comment| Transactions |
XA   | Savepoints |
++-++--+--++
| MRG_MYISAM | YES | Collection of identical MyISAM
tables  | NO   | NO   | NO |
| PERFORMANCE_SCHEMA | YES | Performance
Schema | NO   | NO   |
NO |
| CSV| YES | CSV storage
engine | NO   | NO   |
NO |
| InnoDB | YES | Supports transactions, row-level locking,
and foreign keys | YES  | YES  | YES|
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
performance | NO   | NO   | NO |
| MEMORY | YES | Hash based, stored in memory, useful for
temporary tables  | NO   | NO   | NO |
++-++--+--++

If I'm unable to get a report from the application, I will test partitions
tomorrow, well, in a while xD

Thanks everybody...

Re: mysql 5.5.3 and innodb from source.

[Rob Wultsch]

On Sat, Jul 17, 2010 at 7:34 AM, Andrés Tello mr.crip...@gmail.com wrote:
 Who you build mysql 5.5.3 with innodb suport?

 I made
 sh configure.am --with-plugins=all
 I see the makefile at innodb subdir being created.
 I build the system correctly but when I log in to the mysql 5 instance and
 do a

 show engines;


 I only have this:

 ++-+---+--+--++
 | Engine             | Support |
 Comment                                                   | Transactions |
 XA   | Savepoints |
 ++-+---+--+--++
 | MRG_MYISAM         | YES     | Collection of identical MyISAM
 tables                     | NO           | NO   | NO         |
 | PERFORMANCE_SCHEMA | YES     | Performance
 Schema                                        | NO           | NO   |
 NO         |
 | CSV                | YES     | CSV storage
 engine                                        | NO           | NO   |
 NO         |
 | MEMORY             | YES     | Hash based, stored in memory, useful for
 temporary tables | NO           | NO   | NO         |
 | MyISAM             | DEFAULT | Default engine as of MySQL 3.23 with great
 performance    | NO           | NO   | NO         |
 ++-+---+--+--++


 my my.cnf...

 skip-name-resolve
 log_error    =/mysql5/mysql5.err
 socket     = /mysql5/mysql.sock
 port       = 3308
 pid-file   = /mysql5/mysql5.pid
 datadir    = /mysql5/data

 tmpdir=/tmpfs

 binlog_cache_size=64M #tamaño de la transaccion a cachear
 bulk_insert_buffer_size=256M #cache de insert por thread
 delay_key_write=OFF #detiene la creacion de llaves? No, no nos conviene por
 integridad.

 max_allowed_packet=256M
 table_cache=4096
 join_buffer_size=256M
 tmp_table_size=1024M
 sort_buffer_size=1024M
 thread_cache_size=64
 #default_storage_engine=INNODB
 query_cache_size=1024M
 query_cache_limit=256M
 innodb_file_per_table


 innodb_data_home_dir = /mysql5/innodb
 innodb_data_file_path = ibdata/innodb:2000M:autoextend
 innodb_buffer_pool_size=512M
 innodb_flush_method=fdatasync #ls opciones son fdatasync (default), O_DSYNC,
 (lento?) O_DIRECT
 innodb_locks_unsafe_for_binlog=1 #solo usa indices
 innodb_additional_mem_pool_size=512M
 innodb_log_file_size=2000M
 innodb_log_buffer_size=32M
 innodb_max_dirty_pages_pct=95
 innodb_max_purge_lag=0
 innodb_flush_log_at_trx_commit=1
 innodb_lock_wait_timeout=50
 innodb_thread_concurrency=200

 max_heap_table_size=4G


 what I'm doing wrong? Please advice.
 Thanks.


Assuming that you actually built the innodb plugin (I have no
experience building 5.5) the you should probably look at what you need
to add to the cnf in order to use the plugin.

http://www.innodb.com/doc/innodb_plugin-1.0/innodb-plugin-installation.html

This is only a guess.

-- 
Rob Wultsch
wult...@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysql 5.5.3 and innodb from source.

[Andrés Tello]

Who you build mysql 5.5.3 with innodb suport?

I made
sh configure.am --with-plugins=all
I see the makefile at innodb subdir being created.
I build the system correctly but when I log in to the mysql 5 instance and
do a

show engines;


I only have this:

++-+---+--+--++
| Engine | Support |
Comment   | Transactions |
XA   | Savepoints |
++-+---+--+--++
| MRG_MYISAM | YES | Collection of identical MyISAM
tables | NO   | NO   | NO |
| PERFORMANCE_SCHEMA | YES | Performance
Schema| NO   | NO   |
NO |
| CSV| YES | CSV storage
engine| NO   | NO   |
NO |
| MEMORY | YES | Hash based, stored in memory, useful for
temporary tables | NO   | NO   | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
performance| NO   | NO   | NO |
++-+---+--+--++


my my.cnf...

skip-name-resolve
log_error=/mysql5/mysql5.err
socket = /mysql5/mysql.sock
port   = 3308
pid-file   = /mysql5/mysql5.pid
datadir= /mysql5/data

tmpdir=/tmpfs

binlog_cache_size=64M #tamaño de la transaccion a cachear
bulk_insert_buffer_size=256M #cache de insert por thread
delay_key_write=OFF #detiene la creacion de llaves? No, no nos conviene por
integridad.

max_allowed_packet=256M
table_cache=4096
join_buffer_size=256M
tmp_table_size=1024M
sort_buffer_size=1024M
thread_cache_size=64
#default_storage_engine=INNODB
query_cache_size=1024M
query_cache_limit=256M
innodb_file_per_table


innodb_data_home_dir = /mysql5/innodb
innodb_data_file_path = ibdata/innodb:2000M:autoextend
innodb_buffer_pool_size=512M
innodb_flush_method=fdatasync #ls opciones son fdatasync (default), O_DSYNC,
(lento?) O_DIRECT
innodb_locks_unsafe_for_binlog=1 #solo usa indices
innodb_additional_mem_pool_size=512M
innodb_log_file_size=2000M
innodb_log_buffer_size=32M
innodb_max_dirty_pages_pct=95
innodb_max_purge_lag=0
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
innodb_thread_concurrency=200

max_heap_table_size=4G


what I'm doing wrong? Please advice.
Thanks.

Re: source backup.sql - troubleshoot

[a . smith]

Quoting Sydney Puente sydneypue...@yahoo.com:


Hello,

I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql  source backup.sql


If you are trying to restore from backup.sql to a database called  
soure then your syntax is wrong. You should be running:


mysql source  backup.sql

Assuming you don´t need a password to connect to mysql...




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: source backup.sql - troubleshoot

[Johan De Meersman]

On Wed, May 26, 2010 at 10:20 AM, a.sm...@ukgrid.net wrote:

 If you are trying to restore from backup.sql to a database called soure
 then your syntax is wrong. You should be running:

 mysql source  backup.sql


You are assuming that the file named backup.sql contains a backup of the
database named backup. There is no grounds in the mail that support that
assumption; I would even say that 'backup.sql' is a rather generic name for
a file containing a backup. Such naming is not uncommon for a one-shot
backup; or it might be used as a placeholder in an explanation.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Re: source backup.sql - troubleshoot

[a . smith]

Quoting Johan De Meersman vegiv...@tuxera.be:


On Wed, May 26, 2010 at 10:20 AM, a.sm...@ukgrid.net wrote:


If you are trying to restore from backup.sql to a database called soure
then your syntax is wrong. You should be running:

mysql source  backup.sql



You are assuming that the file named backup.sql contains a backup of the
database named backup. There is no grounds in the mail that support that
assumption; I would even say that 'backup.sql' is a rather generic name for
a file containing a backup. Such naming is not uncommon for a one-shot
backup; or it might be used as a placeholder in an explanation.



Actually Im assuming a DB name of source, which I mentioned in my  
first post. Thats actually an bad assumption as, as Ive just read,  
source is an alternative way to read in data from a file that Id never  
seen before. However the syntax would still seem to be bad, assuming  
the command is being run from the command prompt as opposed to the  
mysql command prompt. According to the man page the two options from  
the command prompt are:


   shell mysql db_name  backup-file.sql
OR
   shell mysql -e source /path-to-backup/backup-file.sql db_name

thanks Andy.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: source backup.sql - troubleshoot

[Johan De Meersman]

On Wed, May 26, 2010 at 10:54 AM, a.sm...@ukgrid.net wrote:


 Actually Im assuming a DB name of source, which I mentioned in my first
 post. Thats actually an bad assumption as, as Ive just read, source is an
 alternative way to read in data from a file that Id never seen before.
 However the syntax would still seem to be bad, assuming the command is being
 run from the command prompt as opposed to the mysql command prompt.
 According to the man page the two options from the command prompt are:

   shell mysql db_name  backup-file.sql
 OR
   shell mysql -e source /path-to-backup/backup-file.sql db_name


Ahh :-)

It is quite possible for the backup file to contain a use mydatabase
statement - I usually do this, makes my restores easier. The clause is added
automatically by mysqldump if you use the --databases parameter.

It could be argued, however, that this allows accidental restores of a
production database, whereas the omittance of the use clause means that the
client will barf as soon as you start the restore without target db
specification, because you're trying to create objects outside of a
database.

Both approaches are valid.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Re: source backup.sql - troubleshoot

[Sydney Puente]

Hello,
The invocation syntax is OK  I think.
yes backup.sql was just a generic name.  I think the sql file could be called 
anything.
And there is a use event
The result of sourcing the sql file is to create only the 1st (of the expected 
4 ) tables - and it hangs - I never get the mysql prompt back.


-- MySQL dump 10.11
--
-- Database: event
-- --
-- Server version   5.0.54a-enterprise

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `event`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET 
latin1 */;

USE `event`;


Can I have the commands being issued echo to the screen somehow, so I can 
identify which command is causing the problem?
Or investigate the problem in some other way?

TIA

-Syd
 
mysql source /home/sydney/event/event_2010-05-25_02h07m.Tuesday.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.20 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)






From: Johan De Meersman vegiv...@tuxera.be
To: a.sm...@ukgrid.net
Cc: Sydney Puente sydneypue...@yahoo.com; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 10:15:47
Subject: Re: source backup.sql - troubleshoot




On Wed, May 26, 2010 at 10:54 AM, a.sm...@ukgrid.net wrote:



Actually Im assuming a DB name of source, which I mentioned in my first 
post. Thats actually an bad assumption as, as Ive just read, source is an 
alternative way to read in data from a file that Id never seen before. However 
the syntax would still seem to be bad, assuming the command is being run from 
the command prompt as opposed to the mysql command prompt. According to the 
man page the two options from the command prompt are:

   shell mysql db_name  backup-file.sql
OR
   shell mysql -e source /path-to-backup/backup-file.sql db_name


Ahh :-)

It is quite possible for the backup file to contain a use mydatabase 
statement - I usually do this, makes my restores easier. The clause is added 
automatically by mysqldump if you use the --databases parameter.

It could be argued, however, that this allows accidental restores of a 
production database, whereas the omittance of the use clause means that the 
client will barf as soon as you start the restore without target db 
specification, because you're trying to create objects outside of a database.

Both approaches are valid.


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel



  

Re: source backup.sql - troubleshoot

[Johan De Meersman]

The use event statement is the one that results in the database changed
message. You can easily count the result messages after that to find out
which statement is hanging.

It seems very strange to me that the import would just hang, and not exit
with an error. Is there any disk activity ongoing ? Aren't your disks (or
your innodb tablespace) full ? Is there anything in the systemlogs that
might be relevant ?


On Wed, May 26, 2010 at 12:18 PM, Sydney Puente sydneypue...@yahoo.comwrote:

 Hello,
 The invocation syntax is OK  I think.
 yes backup.sql was just a generic name.  I think the sql file could be
 called anything.
 And there is a use event
 The result of sourcing the sql file is to create only the 1st (of the
 expected 4 ) tables - and it hangs - I never get the mysql prompt back.


 -- MySQL dump 10.11
 --
 -- Database: event
 -- --
 -- Server version   5.0.54a-enterprise

 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
 FOREIGN_KEY_CHECKS=0 */;
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

 --
 -- Current Database: `event`
 --

 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER
 SET latin1 */;

 USE `event`;
 

 Can I have the commands being issued echo to the screen somehow, so I can
 identify which command is causing the problem?
 Or investigate the problem in some other way?

 TIA

 -Syd

 mysql source /home/sydney/event/event_2010-05-25_02h07m.Tuesday.sql;
 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)

 Database changed
 Query OK, 0 rows affected (0.20 sec)

 Query OK, 0 rows affected (0.12 sec)

 Query OK, 0 rows affected (0.00 sec)

 Query OK, 0 rows affected (0.00 sec)





 
 From: Johan De Meersman vegiv...@tuxera.be
 To: a.sm...@ukgrid.net
 Cc: Sydney Puente sydneypue...@yahoo.com; mysql@lists.mysql.com
 Sent: Wed, 26 May, 2010 10:15:47
 Subject: Re: source backup.sql - troubleshoot




 On Wed, May 26, 2010 at 10:54 AM, a.sm...@ukgrid.net wrote:


 
 Actually Im assuming a DB name of source, which I mentioned in my first
 post. Thats actually an bad assumption as, as Ive just read, source is an
 alternative way to read in data from a file that Id never seen before.
 However the syntax would still seem to be bad, assuming the command is being
 run from the command prompt as opposed to the mysql command prompt.
 According to the man page the two options from the command prompt are:
 
shell mysql db_name  backup-file.sql
 OR
shell mysql -e source /path-to-backup/backup-file.sql db_name
 

 Ahh :-)

 It is quite possible for the backup file to contain a use mydatabase
 statement - I usually do this, makes my restores easier. The clause is added
 automatically by mysqldump if you use the --databases parameter.

 It could be argued, however, that this allows accidental restores of a
 production database, whereas the omittance of the use clause means that the
 client will barf as soon as you start the restore without target db
 specification, because you're trying to create objects outside of a
 database.

 Both approaches are valid.


 --
 Bier met grenadyn
 Is als mosterd by den wyn
 Sy die't drinkt, is eene kwezel
 Hy die't drinkt, is ras een ezel








-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Re: source backup.sql - troubleshoot

[Radoulov, Dimitre]

On 26/05/2010 12.18, Sydney Puente wrote:

[...]

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET 
latin1 */;

USE `event`;


Can I have the commands being issued echo to the screen somehow, so I can 
identify which command is causing the problem?
Or investigate the problem in some other way?


[...]


Not sure if this was already mentioned:


mysql --show-warnings -v -u user -ppass db_name  dump_file



You can use -vv  or -vvv for more verbose output.



Regards
Dimitre

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: source backup.sql - troubleshoot

[Sydney Puente]

Thanks Johan,
Ah I see.
So this line for example:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
generates the first
Query OK, 0 rows affected (0.00 sec)

I did not realise, it looks like a comment.
Not sure about disk activity - top says 100% on 1 of the 4 CPUS

Seems to be this causing problems
DROP TABLE IF EXISTS `ping`;
CREATE TABLE `ping` (
  `TestName` varchar(50) default '',
  `TimeStamp` int(11) default '0',
  `Elapsedtime` int(11) default '0',
  `Fail` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ping`
--

LOCK TABLES `ping` WRITE;
/*!4 ALTER TABLE `ping` DISABLE KEYS */;
I think it is this causing problems
INSERT INTO `ping` VALUES 
('Test1',1258368123,1,0),('Test1',1258368134,1,0),('Test1',1258368144,0,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
...

TIA

Syd



From: Johan De Meersman vegiv...@tuxera.be
To: Sydney Puente sydneypue...@yahoo.com
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 11:35:22
Subject: Re: source backup.sql - troubleshoot

The use event statement is the one that results in the database changed 
message. You can easily count the result messages after that to find out which 
statement is hanging.

It seems very strange to me that the import would just hang, and not exit with 
an error. Is there any disk activity ongoing ? Aren't your disks (or your 
innodb tablespace) full ? Is there anything in the systemlogs that might be 
relevant ?



On Wed, May 26, 2010 at 12:18 PM, Sydney Puente sydneypue...@yahoo.com wrote:

Hello,
The invocation syntax is OK  I think.
yes backup.sql was just a generic name.  I think the sql file could be called 
anything.
And there is a use event
The result of sourcing the sql file is to create only the 1st (of the 
expected 4 ) tables - and it hangs - I never get the mysql prompt back.


-- MySQL dump 10.11
--
-- Database: event
-- --
-- Server version   5.0.54a-enterprise

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `event`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER 
SET latin1 */;

USE `event`;


Can I have the commands being issued echo to the screen somehow, so I can 
identify which command is causing the problem?
Or investigate the problem in some other way?

TIA

-Syd

mysql source /home/sydney/event/event_2010-05-25_02h07m.Tuesday.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.20 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)







From: Johan De Meersman vegiv...@tuxera.be
To: a.sm...@ukgrid.net
Cc: Sydney Puente sydneypue...@yahoo.com; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 10:15:47
Subject: Re: source backup.sql - troubleshoot





On Wed, May 26, 2010 at 10:54 AM, a.sm...@ukgrid.net wrote:



Actually Im assuming a DB name of source, which I mentioned in my first 
post. Thats actually an bad assumption as, as Ive just read, source is an 
alternative way to read in data from a file that Id never seen before. 
However the syntax would still seem to be bad, assuming the command is being 
run from the command prompt as opposed to the mysql command prompt. 
According to the man page the two options from the command prompt are:


   shell mysql db_name  backup-file.sql
OR
   shell mysql -e source /path-to-backup/backup-file.sql db_name


Ahh :-)

It is quite possible for the backup file to contain a use mydatabase 
statement - I usually do this, makes my restores easier. The clause is added 
automatically by mysqldump if you use the --databases parameter.

It could be argued, however, that this allows accidental restores of a 
production database, whereas the omittance of the use clause means that the 
client will barf as soon as you start the restore without target db 
specification, because you're trying

Re: source backup.sql - troubleshoot

[Johan De Meersman]

A-ha ! :-)

That's an InnoDB table, allright. Can you check if your InnoDB file is set
to autoextend ? It smells like it's full and waiting for more space or
something.

Either look in your my.cnf file, or do a show variables like '%inno%';.
Check the filesize of your InnoDB datafiles, too.


On Wed, May 26, 2010 at 1:27 PM, Sydney Puente sydneypue...@yahoo.comwrote:

 Thanks Johan,
 Ah I see.
 So this line for example:

 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 generates the first
 Query OK, 0 rows affected (0.00 sec)

 I did not realise, it looks like a comment.
 Not sure about disk activity - top says 100% on 1 of the 4 CPUS

 Seems to be this causing problems
 DROP TABLE IF EXISTS `ping`;
 CREATE TABLE `ping` (
  `TestName` varchar(50) default '',
  `TimeStamp` int(11) default '0',
  `Elapsedtime` int(11) default '0',
  `Fail` int(11) default '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 --
 -- Dumping data for table `ping`
 --

 LOCK TABLES `ping` WRITE;
 /*!4 ALTER TABLE `ping` DISABLE KEYS */;
 I think it is this causing problems
 INSERT INTO `ping` VALUES
 ('Test1',1258368123,1,0),('Test1',1258368134,1,0),('Test1',1258368144,0,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
 ...

 TIA

 Syd


 
 From: Johan De Meersman vegiv...@tuxera.be
 To: Sydney Puente sydneypue...@yahoo.com
 Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
 Sent: Wed, 26 May, 2010 11:35:22
 Subject: Re: source backup.sql - troubleshoot

 The use event statement is the one that results in the database changed
 message. You can easily count the result messages after that to find out
 which statement is hanging.

 It seems very strange to me that the import would just hang, and not exit
 with an error. Is there any disk activity ongoing ? Aren't your disks (or
 your innodb tablespace) full ? Is there anything in the systemlogs that
 might be relevant ?



 On Wed, May 26, 2010 at 12:18 PM, Sydney Puente sydneypue...@yahoo.com
 wrote:

 Hello,
 The invocation syntax is OK  I think.
 yes backup.sql was just a generic name.  I think the sql file could be
 called anything.
 And there is a use event
 The result of sourcing the sql file is to create only the 1st (of the
 expected 4 ) tables - and it hangs - I never get the mysql prompt back.
 
 
 -- MySQL dump 10.11
 --
 -- Database: event
 -- --
 -- Server version   5.0.54a-enterprise
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
 FOREIGN_KEY_CHECKS=0 */;
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
 */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
 -- Current Database: `event`
 --
 
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT
 CHARACTER SET latin1 */;
 
 USE `event`;
 
 
 Can I have the commands being issued echo to the screen somehow, so I can
 identify which command is causing the problem?
 Or investigate the problem in some other way?
 
 TIA
 
 -Syd
 
 mysql source /home/sydney/event/event_2010-05-25_02h07m.Tuesday.sql;
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Database changed
 Query OK, 0 rows affected (0.20 sec)
 
 Query OK, 0 rows affected (0.12 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 Query OK, 0 rows affected (0.00 sec)
 
 
 
 
 
 
 
 From: Johan De Meersman vegiv...@tuxera.be
 To: a.sm...@ukgrid.net
 Cc: Sydney Puente sydneypue...@yahoo.com; mysql@lists.mysql.com
 Sent: Wed, 26 May, 2010 10:15:47
 Subject: Re: source backup.sql - troubleshoot
 
 
 
 
 
 On Wed, May 26, 2010 at 10:54 AM, a.sm...@ukgrid.net wrote:
 
 
 
 Actually Im assuming a DB name of source, which I mentioned in my
 first post. Thats actually an bad assumption as, as Ive just read, source is
 an alternative way to read in data from a file that Id never seen before.
 However the syntax would still seem to be bad, assuming the command is being
 run from the command prompt as opposed to the mysql command prompt.
 According to the man page the two options from the command prompt are:
 
 
shell mysql db_name  backup-file.sql
 OR
shell mysql -e source /path-to-backup/backup

Re: source backup.sql - troubleshoot

[Sydney Puente]

Thanks.
Getting better informed by the minute!
plenty of disk space (GBs) - datafiles small MB


mysql show variables like '%inno%';

+-++
| Variable_name   | Value  |
+-++
| have_innodb | YES|
| innodb_additional_mem_pool_size | 20971520   |
| innodb_autoextend_increment | 8  |
| innodb_buffer_pool_awe_mem_mb   | 0  |
| innodb_buffer_pool_size | 268435456  |
| innodb_checksums| ON |
| innodb_commit_concurrency   | 0  |
| innodb_concurrency_tickets  | 500|
| innodb_data_file_path   | ibdata1:10M:autoextend |
| innodb_data_home_dir||
| innodb_adaptive_hash_index  | ON |
| innodb_doublewrite  | ON |
| innodb_fast_shutdown| 1  |
| innodb_file_io_threads  | 4  |
| innodb_file_per_table   | ON |
| innodb_flush_log_at_trx_commit  | 1  |
| innodb_flush_method ||
| innodb_force_recovery   | 0  |
| innodb_lock_wait_timeout| 50 |
| innodb_locks_unsafe_for_binlog  | OFF|
| innodb_log_arch_dir ||
| innodb_log_archive  | OFF|
| innodb_log_buffer_size  | 1048576|
| innodb_log_file_size| 5242880|
| innodb_log_files_in_group   | 2  |
| innodb_log_group_home_dir   | ./ |
| innodb_max_dirty_pages_pct  | 90 |
| innodb_max_purge_lag| 0  |
| innodb_mirrored_log_groups  | 1  |
| innodb_open_files   | 300|
| innodb_rollback_on_timeout  | OFF|
| innodb_support_xa   | ON |
| innodb_sync_spin_loops  | 20 |
| innodb_table_locks  | ON |
| innodb_thread_concurrency   | 8  |
| innodb_thread_sleep_delay   | 1  |
+-++
36 rows in set (0.00 sec)




From: Johan De Meersman vegiv...@tuxera.be
To: Sydney Puente sydneypue...@yahoo.com
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 12:58:07
Subject: Re: source backup.sql - troubleshoot

A-ha ! :-)

That's an InnoDB table, allright. Can you check if your InnoDB file is set to 
autoextend ? It smells like it's full and waiting for more space or something.

Either look in your my.cnf file, or do a show variables like '%inno%';. Check 
the filesize of your InnoDB datafiles, too.



On Wed, May 26, 2010 at 1:27 PM, Sydney Puente sydneypue...@yahoo.com wrote:

Thanks Johan,
Ah I see.
So this line for example:


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
generates the first

Query OK, 0 rows affected (0.00 sec)

I did not realise, it looks like a comment.
Not sure about disk activity - top says 100% on 1 of the 4 CPUS

Seems to be this causing problems
DROP TABLE IF EXISTS `ping`;
CREATE TABLE `ping` (
  `TestName` varchar(50) default '',
  `TimeStamp` int(11) default '0',
  `Elapsedtime` int(11) default '0',
  `Fail` int(11) default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ping`
--

LOCK TABLES `ping` WRITE;
/*!4 ALTER TABLE `ping` DISABLE KEYS */;
I think it is this causing problems
INSERT INTO `ping` VALUES 
('Test1',1258368123,1,0),('Test1',1258368134,1,0),('Test1',1258368144,0,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
...

TIA

Syd




From: Johan De Meersman vegiv...@tuxera.be
To: Sydney Puente sydneypue...@yahoo.com
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 11:35:22

Subject: Re: source backup.sql - troubleshoot

The use event statement is the one that results in the database changed 
message. You can easily count the result messages after that to find out 
which statement is hanging.

It seems very strange to me that the import would just hang, and not exit 
with an error. Is there any disk activity ongoing ? Aren't your disks (or 
your innodb tablespace) full ? Is there anything in the systemlogs that might 
be relevant ?



On Wed, May 26, 2010 at 12:18 PM, Sydney Puente sydneypue...@yahoo.com 
wrote:

Hello,
The invocation syntax is OK  I think.
yes backup.sql was just a generic name.  I think the sql file could be 
called anything.
And there is a use event

Re: source backup.sql - troubleshoot

[Johan De Meersman]

Hmm, probably not that, then. Strange.

You already said there's 100% cpu on one core while that executes. Can you
see if there's disk activity going on ?

After you kill the script, can you check the contents of that table, to see
if any data from the hanging statement is in there ? Can you try to run the
statement by hand, to see if it executes ?

I have to admit I'm a bit lost, here. Whenever I see a MySQL server hanging,
it tends to be because it's waiting for me to free up space so it can
continue writing logs or whatever.


On Wed, May 26, 2010 at 3:11 PM, Sydney Puente sydneypue...@yahoo.comwrote:

 Thanks.
 Getting better informed by the minute!
 plenty of disk space (GBs) - datafiles small MB


 mysql show variables like '%inno%';

 +-++
 | Variable_name   | Value  |
 +-++
 | have_innodb | YES|
 | innodb_additional_mem_pool_size | 20971520   |
 | innodb_autoextend_increment | 8  |
 | innodb_buffer_pool_awe_mem_mb   | 0  |
 | innodb_buffer_pool_size | 268435456  |
 | innodb_checksums| ON |
 | innodb_commit_concurrency   | 0  |
 | innodb_concurrency_tickets  | 500|
 | innodb_data_file_path   | ibdata1:10M:autoextend |
 | innodb_data_home_dir||
 | innodb_adaptive_hash_index  | ON |
 | innodb_doublewrite  | ON |
 | innodb_fast_shutdown| 1  |
 | innodb_file_io_threads  | 4  |
 | innodb_file_per_table   | ON |
 | innodb_flush_log_at_trx_commit  | 1  |
 | innodb_flush_method ||
 | innodb_force_recovery   | 0  |
 | innodb_lock_wait_timeout| 50 |
 | innodb_locks_unsafe_for_binlog  | OFF|
 | innodb_log_arch_dir ||
 | innodb_log_archive  | OFF|
 | innodb_log_buffer_size  | 1048576|
 | innodb_log_file_size| 5242880|
 | innodb_log_files_in_group   | 2  |
 | innodb_log_group_home_dir   | ./ |
 | innodb_max_dirty_pages_pct  | 90 |
 | innodb_max_purge_lag| 0  |
 | innodb_mirrored_log_groups  | 1  |
 | innodb_open_files   | 300|
 | innodb_rollback_on_timeout  | OFF|
 | innodb_support_xa   | ON |
 | innodb_sync_spin_loops  | 20 |
 | innodb_table_locks  | ON |
 | innodb_thread_concurrency   | 8  |
 | innodb_thread_sleep_delay   | 1  |
 +-++
 36 rows in set (0.00 sec)



 
 From: Johan De Meersman vegiv...@tuxera.be
 To: Sydney Puente sydneypue...@yahoo.com
 Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
 Sent: Wed, 26 May, 2010 12:58:07
 Subject: Re: source backup.sql - troubleshoot

 A-ha ! :-)

 That's an InnoDB table, allright. Can you check if your InnoDB file is set
 to autoextend ? It smells like it's full and waiting for more space or
 something.

 Either look in your my.cnf file, or do a show variables like '%inno%';.
 Check the filesize of your InnoDB datafiles, too.



 On Wed, May 26, 2010 at 1:27 PM, Sydney Puente sydneypue...@yahoo.com
 wrote:

 Thanks Johan,
 Ah I see.
 So this line for example:
 
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 generates the first
 
 Query OK, 0 rows affected (0.00 sec)
 
 I did not realise, it looks like a comment.
 Not sure about disk activity - top says 100% on 1 of the 4 CPUS
 
 Seems to be this causing problems
 DROP TABLE IF EXISTS `ping`;
 CREATE TABLE `ping` (
   `TestName` varchar(50) default '',
   `TimeStamp` int(11) default '0',
   `Elapsedtime` int(11) default '0',
   `Fail` int(11) default '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --
 -- Dumping data for table `ping`
 --
 
 LOCK TABLES `ping` WRITE;
 /*!4 ALTER TABLE `ping` DISABLE KEYS */;
 I think it is this causing problems
 INSERT INTO `ping` VALUES
 ('Test1',1258368123,1,0),('Test1',1258368134,1,0),('Test1',1258368144,0,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
 ...
 
 TIA
 
 Syd
 
 
 
 
 From: Johan De Meersman vegiv...@tuxera.be
 To: Sydney Puente sydneypue...@yahoo.com
 Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
 Sent: Wed, 26 May, 2010 11:35:22

source backup.sql - troubleshoot

[Sydney Puente]

Hello,

I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a 
mysql  source backup.sql
It is 32 MB - it creates 4 tables and after creation of each table it populates 
it.
Actually it only creates the 1st table before hanging.

My first thought is it would be nice to echo each of the commands it is 
executing so I can tell whoch command it is that is the problem.
My second thought is that there must be a quite a few troubleshooting 
techniques i could/should use - except I dont know hwtat they are.

All advice gratefully received!

BTW Platform redhat 5.2,   Server version   5.0.54a-enterprise

-Syd





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: source backup.sql - troubleshoot

[Daevid Vincent]

Use something like SQLYog, load your .sql file into the editor, run all the
commands one at a time, or in bulk.  Look at the info window for what
line failed.

 -Original Message-
 From: Sydney Puente [mailto:sydneypue...@yahoo.com] 
 Sent: Tuesday, May 25, 2010 2:39 PM
 To: mysql@lists.mysql.com
 Subject: source backup.sql - troubleshoot
 
 Hello,
 
 I have a mysqldump file created by AutoMySQLBackup.
 And it hangs when I do a 
 mysql  source backup.sql
 It is 32 MB - it creates 4 tables and after creation of each 
 table it populates it.
 Actually it only creates the 1st table before hanging.
 
 My first thought is it would be nice to echo each of the 
 commands it is executing so I can tell whoch command it is 
 that is the problem.
 My second thought is that there must be a quite a few 
 troubleshooting techniques i could/should use - except I dont 
 know hwtat they are.
 
 All advice gratefully received!
 
 BTW Platform redhat 5.2,   Server version   5.0.54a-enterprise
 
 -Syd
 
 
   
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=dae...@daevid.com
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: source backup.sql - troubleshoot

[Rob Wultsch]

On Tue, May 25, 2010 at 2:39 PM, Sydney Puente sydneypue...@yahoo.com wrote:
 Hello,

 I have a mysqldump file created by AutoMySQLBackup.
 And it hangs when I do a
 mysql  source backup.sql
 It is 32 MB - it creates 4 tables and after creation of each table it 
 populates it.
 Actually it only creates the 1st table before hanging.

 My first thought is it would be nice to echo each of the commands it is 
 executing so I can tell whoch command it is that is the problem.
 My second thought is that there must be a quite a few troubleshooting 
 techniques i could/should use - except I dont know hwtat they are.

 All advice gratefully received!

 BTW Platform redhat 5.2,   Server version       5.0.54a-enterprise

 -Syd

The easiest way to see what MySQL is working on is to start up another
connections and run SHOW PROCESSLIST.  Note that the command output
will be truncated if it is long at all. If you need to see the entire
query run SHOW FULL PROCESSLIST.

Alternatively start up the mysql client with the --verbose flag. I
don't recall in what version that became available. You will probably
flood your term if you use this option.

-- 
Rob Wultsch
wult...@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Windows installer source code...

[Andrés Tello]

I followed the instructions from Mysql site to donwload the code using
bazaar...

I need to make a modification to the installer, but I wasn't able to find
the source code where the is the reference to a screen at the wizard...  so
I wonder, does the windows installer code is distributed with the mysql
code? If not where can I find it, if yes, where is it in the source tree?

rant
I'm more a linux dev, more than windows, I have no idea how a msi source
file should look... :/ but you know, management requirements...
/rant

Please Advice...

I NEED HELP ON 'SOURCE(\.) MYSQL

[kebede teferi]

Hi, I'm very new to this and I need help.

What I want to do is to execute a source command statement from cmd to create 
tables and populate them on a data base that I created in Mysql.  Here is what 
I did at CMD:
*I changed the directory from c:\ to mysql
*At mysql prompt i used -u root -p that prompted me to give my password.
*I put in my password and I was allowed to access the mysql server.
*I used the 'the use --database' command and I can see the database I created 
is active and waiting to be worked on.
*then to run the script which is on a note pad with the name create and file 
type: sql I typed the following at the mysql prompt:
*source create.sql;
  I get the error message '2' and '22' whichever way I tried the source 
command.  I appreciate your help

Kebede Teferi




  

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

[Jesper Wisborg Krogh]

How did you type the source command? Did you remember not to quote the file 
name? E.g.

mysql SOURCE schema.sql

is the correct way.

Jesper

On Tue, 2 Feb 2010 10:38:08 kebede teferi wrote:
 Hi, I'm very new to this and I need help.

 What I want to do is to execute a source command statement from cmd to
 create tables and populate them on a data base that I created in Mysql. 
 Here is what I did at CMD: *I changed the directory from c:\ to mysql
 *At mysql prompt i used -u root -p that prompted me to give my password.
 *I put in my password and I was allowed to access the mysql server.
 *I used the 'the use --database' command and I can see the database I
 created is active and waiting to be worked on. *then to run the script
 which is on a note pad with the name create and file type: sql I typed the
 following at the mysql prompt: *source create.sql;
   I get the error message '2' and '22' whichever way I tried the source
 command.  I appreciate your help

 Kebede Teferi


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

[John List]

On 02/01/2010 06:38 PM, kebede teferi wrote:

Hi, I'm very new to this and I need help.

What I want to do is to execute a source command statement from cmd to create 
tables and populate them on a data base that I created in Mysql.  Here is what 
I did at CMD:
*I changed the directory from c:\ to mysql
*At mysql prompt i used -u root -p that prompted me to give my password.
*I put in my password and I was allowed to access the mysql server.
*I used the 'the use --database' command and I can see the database I created 
is active and waiting to be worked on.
*then to run the script which is on a note pad with the name create and file 
type: sql I typed the following at the mysql prompt:
*source create.sql;
  I get the error message '2' and '22' whichever way I tried the source 
command.  I appreciate your help

Kebede Teferi
  


mysql looks in the current directory for the source file. That the 
directory where you ran the mysql client from. The quickest fix is to 
give the complete path to the file, e.g. source /home/me/mysourcefile.sql


(You say yoiu changed your current directory to mysql but didn't give us 
the complete path. There are multiple mysql directories in most 
configurations.)


--John






  
  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

[Carlos Proal]

Error 2 is  No such file or directory

So, probably the file is not in the right path or you need to explicitly 
provide the path to the file.


Carlos


On 2/1/2010 5:38 PM, kebede teferi wrote:

Hi, I'm very new to this and I need help.

What I want to do is to execute a source command statement from cmd to create 
tables and populate them on a data base that I created in Mysql.  Here is what 
I did at CMD:
*I changed the directory from c:\  to mysql
*At mysql prompt i used -u root -p that prompted me to give my password.
*I put in my password and I was allowed to access the mysql server.
*I used the 'the use --database' command and I can see the database I created 
is active and waiting to be worked on.
*then to run the script which is on a note pad with the name create and file 
type: sql I typed the following at the mysql prompt:
*source create.sql;
   I get the error message '2' and '22' whichever way I tried the source 
command.  I appreciate your help

Kebede Teferi





   



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

[Colin Streicher]

what everyone else said... also, is there a longer version of the error? or is 
it literally error 2 
or error 22?

Colin

On February 1, 2010 06:38:08 pm kebede teferi wrote:
 Hi, I'm very new to this and I need help.
 
 What I want to do is to execute a source command statement from cmd to
  create tables and populate them on a data base that I created in Mysql. 
  Here is what I did at CMD: *I changed the directory from c:\ to mysql
 *At mysql prompt i used -u root -p that prompted me to give my password.
 *I put in my password and I was allowed to access the mysql server.
 *I used the 'the use --database' command and I can see the database I
  created is active and waiting to be worked on. *then to run the script
  which is on a note pad with the name create and file type: sql I typed the
  following at the mysql prompt: *source create.sql;
   I get the error message '2' and '22' whichever way I tried the source
  command.  I appreciate your help
 
 Kebede Teferi
 

-- 
Your love life will be happy and harmonious.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

[sureshkumarilu]

Give the ful path of file name with in '' and try it out 

Thanks
Suresh Kuna
MySQL DBA
--Original Message--
From: Colin Streicher
To: mysql@lists.mysql.com
Cc: kebede teferi
ReplyTo: co...@obviouslymalicious.com
Subject: Re: I NEED HELP ON 'SOURCE(\.) MYSQL
Sent: Feb 2, 2010 7:33 AM

what everyone else said... also, is there a longer version of the error? or is 
it literally error 2 
or error 22?

Colin

On February 1, 2010 06:38:08 pm kebede teferi wrote:
 Hi, I'm very new to this and I need help.
 
 What I want to do is to execute a source command statement from cmd to
  create tables and populate them on a data base that I created in Mysql. 
  Here is what I did at CMD: *I changed the directory from c:\ to mysql
 *At mysql prompt i used -u root -p that prompted me to give my password.
 *I put in my password and I was allowed to access the mysql server.
 *I used the 'the use --database' command and I can see the database I
  created is active and waiting to be worked on. *then to run the script
  which is on a note pad with the name create and file type: sql I typed the
  following at the mysql prompt: *source create.sql;
   I get the error message '2' and '22' whichever way I tried the source
  command.  I appreciate your help
 
 Kebede Teferi
 

-- 
Your love life will be happy and harmonious.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com



Sent from BlackBerry® on Airtel

MY PROBLEM WITH THE SOURCE(\.) IS SOLVED

[kebede teferi]

I thank you all who responded to solve my problem in using the source command 
to execute a mysql script saved on a notepad.  Thank you, for your tips, I've 
solved the problem.  When I was using the \.create.sql at the prompt I wasn't 
giving the full path where 'create.sql' is residing.  Once I did, that thanks 
to you all, I saw my command line streaming with data and finally the result 
was in my database. Thanks.

Kebede




  

Re: [PHP] Good source for sample data?

[tedd]

At 3:08 PM -0800 1/29/10, Brian Dunning wrote:
Thanks for the suggestions but I couldn't find any that suited my 
needs, so I made my own. Feel free to download if you can use them, 
I made files with up to a million unique records.


Name, Company, Address, Phone, Email, etc., all are fake but are 
real addresses with correct area codes, zips, exchange, so will work 
for mapping, phone or address validation, whatever your needs are. 
Hope someone find it useful.


http://www.briandunning.com/sample-data/


Brian:

Thanks -- that was very nice of you.

Cheers,

tedd

--
---
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Mark Goodge]

On 29/01/2010 03:18, John Meyer wrote:

If I may recommend:
http://www.generatedata.com/#download


That's brilliant. The only minor issue is that, at least for UK data, it 
won't validate for mapping purposes - the postcodes are syntactically 
correct, but non-existent. I don't know if it would have the same 
problem for US or Canadian data.


Mark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Good source for sample data?

[Jerry Schwartz]

If you need verifiable mailing addresses (actual street/city/state/zip 
combinations), you should look at some of the databases the USPS (usps.com) 
has available. They are mostly for tracking delivery statistics, and the like, 
but as a side effect they list streets all over the USA. The only thing you 
won't have are street numbers and names, but you can easily generate random 
combinations there.

By the way, if you need real-sounding names you can get a pile of first names 
from http://www.socialsecurity.gov/OACT/babynames/decades/names2000s.html; I 
used that information as part of security screening for a registration system.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com

-Original Message-
From: Shawn McKenzie [mailto:nos...@mckenzies.net]
Sent: Thursday, January 28, 2010 7:20 PM
To: Brian Dunning
Cc: php-gene...@lists.php.net; mysql@lists.mysql.com
Subject: Re: Good source for sample data?

Brian Dunning wrote:
 Hey all -

 I need a few million sample contact records - name, company, address, 
 email,
web, phone, fax. ZIP codes and area codes and street addresses should be
correct and properly formatted, but preferably not real people or companies 
or
email addresses. But they'd work if you did address validation or mapping.
Anyone have a suggestion?

 - Brian

It should be easy to code a routine to generate random data.  Maybe 20 -
30 lines of code.  Obviously you may have a name like Dgidfgq Xcvbop and
company Wsdkn, but it shouldn't matter if testing is your purpose.

--
Thanks!
-Shawn
http://www.spidean.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the-
infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Martijn Tonies]

Hello Brian,

We have a tool that can generate these kind of data, if you want
real data (like the ZIP-codes), you can supply it yourself and
use non-existent company names and al.

Have a look at www.upscene.com and go to Advanced Data
Generator.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com



I need a few million sample contact records - name, company, address, email, 
web, phone, fax. ZIP codes and area codes and street addresses should be 
correct and properly formatted, but preferably not real people or companies 
or email addresses. But they'd work if you did address validation or 
mapping. Anyone have a suggestion?


- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Good source for sample data?

[Jerry Schwartz]

That's brilliant. The only minor issue is that, at least for UK data, it
won't validate for mapping purposes - the postcodes are syntactically
correct, but non-existent. I don't know if it would have the same
problem for US or Canadian data.

[JS] Sorry, my suggestion won't work either: I didn't notice that you are from 
the UK.

Well, the name part will work; and perhaps the UK has databases similar to 
what the USPS (US Postal Service) makes available. I'd think they would, since 
they are accountable to the public.
Mark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the-
infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Mark Goodge]

On 29/01/2010 15:20, Jerry Schwartz wrote:


That's brilliant. The only minor issue is that, at least for UK data, it
won't validate for mapping purposes - the postcodes are syntactically
correct, but non-existent. I don't know if it would have the same
problem for US or Canadian data.


[JS] Sorry, my suggestion won't work either: I didn't notice that you are from
the UK.

Well, the name part will work; and perhaps the UK has databases similar to
what the USPS (US Postal Service) makes available. I'd think they would, since
they are accountable to the public.


You might think so; you'd be wrong! In the UK, postcode data - even a 
comprehensive list of allocated postcodes - is the copyright of Royal 
Mail and only available under license.


(Off-topic, but relevant to UK-based developers: please take a look at 
my blog at http://mark.goodge.co.uk/musings/422/locate-that-postcode/ 
for a topical twist on this)


Mark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Martijn Tonies]

I need a few million sample contact records - name, company, address, 
email, web, phone, fax. ZIP codes and area codes and street addresses 
should be correct and properly formatted, but preferably not real people 
or companies or email addresses. But they'd work if you did address 
validation or mapping. Anyone have a suggestion?


- Brian


It should be easy to code a routine to generate random data.  Maybe 20 -
30 lines of code.  Obviously you may have a name like Dgidfgq Xcvbop and
company Wsdkn, but it shouldn't matter if testing is your purpose.


Actually, this DOES matter...

Test data can be required for all sorts of purposes, for example:

- running a demo of the application
- testing real life-like data entry
- trial versions that include data
- course-ware for your application when it gets implemented by a company
- decent value distribution in indices

This is why our tool, Advanced Data Generator, allows you to
generate life-like company names, has libraries for first/last names
and much more.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Good source for sample data?

[Jerry Schwartz]

-Original Message-
From: Mark Goodge [mailto:m...@good-stuff.co.uk]
Sent: Friday, January 29, 2010 10:32 AM
To: mysql@lists.mysql.com
Subject: Re: Good source for sample data?

On 29/01/2010 15:20, Jerry Schwartz wrote:

snip

 [JS] Sorry, my suggestion won't work either: I didn't notice that you are
from
 the UK.

 Well, the name part will work; and perhaps the UK has databases similar to
 what the USPS (US Postal Service) makes available. I'd think they would,
since
 they are accountable to the public.

You might think so; you'd be wrong! In the UK, postcode data - even a
comprehensive list of allocated postcodes - is the copyright of Royal
Mail and only available under license.

[JS] Well, then we just need to get Her Highness to subscribe to this list. 
:)


Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com








-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: [PHP] Good source for sample data?

[Brian Dunning]

Thanks for the suggestions but I couldn't find any that suited my needs, so I 
made my own. Feel free to download if you can use them, I made files with up to 
a million unique records.

Name, Company, Address, Phone, Email, etc., all are fake but are real addresses 
with correct area codes, zips, exchange, so will work for mapping, phone or 
address validation, whatever your needs are. Hope someone find it useful.

http://www.briandunning.com/sample-data/

On Jan 28, 2010, at 3:52 PM, Brian Dunning wrote:

 I need a few million sample contact records - name, company, address, email, 
 web, phone, fax. ZIP codes and area codes and street addresses should be 
 correct and properly formatted, but preferably not real people or companies 
 or email addresses. But they'd work if you did address validation or mapping. 
 Anyone have a suggestion?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Good source for sample data?

[Brian Dunning]

Hey all -

I need a few million sample contact records - name, company, address, email, 
web, phone, fax. ZIP codes and area codes and street addresses should be 
correct and properly formatted, but preferably not real people or companies or 
email addresses. But they'd work if you did address validation or mapping. 
Anyone have a suggestion?

- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Shawn McKenzie]

Brian Dunning wrote:
 Hey all -
 
 I need a few million sample contact records - name, company, address, email, 
 web, phone, fax. ZIP codes and area codes and street addresses should be 
 correct and properly formatted, but preferably not real people or companies 
 or email addresses. But they'd work if you did address validation or mapping. 
 Anyone have a suggestion?
 
 - Brian

It should be easy to code a routine to generate random data.  Maybe 20 -
30 lines of code.  Obviously you may have a name like Dgidfgq Xcvbop and
company Wsdkn, but it shouldn't matter if testing is your purpose.

-- 
Thanks!
-Shawn
http://www.spidean.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[John Meyer]

On 1/28/2010 4:52 PM, Brian Dunning wrote:

Hey all -

I need a few million sample contact records - name, company, address, email, 
web, phone, fax. ZIP codes and area codes and street addresses should be 
correct and properly formatted, but preferably not real people or companies or 
email addresses. But they'd work if you did address validation or mapping. 
Anyone have a suggestion?

- Brian


You can typically rip off a list of baby names online and can randomize 
them on the name address and company. e-mail, web, phone, fax and zip 
codes can be randomized, depending upon how accurate you need it to be. 
 Given a few hours you could write up a script in your language of 
choice to get these records.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Nathan Rixham]

Brian Dunning wrote:
 Hey all -
 
 I need a few million sample contact records - name, company, address, email, 
 web, phone, fax. ZIP codes and area codes and street addresses should be 
 correct and properly formatted, but preferably not real people or companies 
 or email addresses. But they'd work if you did address validation or mapping. 
 Anyone have a suggestion?
 
 - Brian

get the data from a whats near X API and obscure the personally
identifiable data with dummy values.
?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[Carlos Proal]

Google for data generator, there are free and commercial solutions 
available.


Carlos

On 1/28/2010 5:52 PM, Brian Dunning wrote:

Hey all -

I need a few million sample contact records - name, company, address, email, 
web, phone, fax. ZIP codes and area codes and street addresses should be 
correct and properly formatted, but preferably not real people or companies or 
email addresses. But they'd work if you did address validation or mapping. 
Anyone have a suggestion?

- Brian
   



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Good source for sample data?

[John Meyer]

If I may recommend:
http://www.generatedata.com/#download


On 1/28/2010 8:11 PM, Carlos Proal wrote:


Google for data generator, there are free and commercial solutions
available.

Carlos

On 1/28/2010 5:52 PM, Brian Dunning wrote:

Hey all -

I need a few million sample contact records - name, company, address,
email, web, phone, fax. ZIP codes and area codes and street addresses
should be correct and properly formatted, but preferably not real
people or companies or email addresses. But they'd work if you did
address validation or mapping. Anyone have a suggestion?

- Brian






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: [PHP] Good source for sample data?

[TG]

I remembered a coworker found an online resource that generated sample data 
for you.  I hit google and I think I found it:

http://www.generatedata.com/

I I found it on a list of resources for data generation:

http://www.webresourcesdepot.com/test-sample-data-generators/


I've never used any of these, but once again.. Google is your friend.

-TG

- Original Message -
From: Brian Dunning br...@briandunning.com
To: php-gene...@lists.php.net, mysql@lists.mysql.com
Date: Thu, 28 Jan 2010 15:52:41 -0800
Subject: [PHP] Good source for sample data?

 Hey all -
 
 I need a few million sample contact records - name, company, address, 
email, web, phone, fax. ZIP codes and area codes and street addresses 
should be correct and properly formatted, but preferably not real people 
or companies or email addresses. But they'd work if you did address 
validation or mapping. Anyone have a suggestion?
 
 - Brian
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Nov/Dec 2009 Issue of Open Source Database Magazine released!!

[Keith Murphy]

Exciting news!

The next issue of Open Source Database Magazine (http://www.osdbzine.net) is
now available. This information-packed issue has over 60 pages of
information including:

* Firebird’s Road Trip and What’s New with 2.5
* Coding Corner: Trees – Where’s the Performance?
* PostgreSQL’s tsvector: Secret Sauce for Search Engines
* The Lab: The XtraBackup Program for MySQL – Part Two
* Drizzle – A Lightweight Database for the Web
* Kontrollbase: Enterprise grade MySQL monitoring and analytics
* Creating a Twitter Mashup with MongoDB
* Introducing LucidDB

Plus the usual news and views. All of this for $4.95.  It is simply the
biggest and the best issue we have ever released. Ready to sign up? Head
over http://www.osdbzine.net/signup.html to register and then you can
download the new issue. Curious as to what this is all about? I just
posted an online addendum to the Drizzle article here:
http://www.osdbzine.net/index.php?option=com_contentview=articleid=91:drizzle-table-formatcatid=39:generalthat
will give you a taste of what you can expect.

Thanks to the contributors. You all did a great job and I appreciate it!

thanks,

keith

-- 
Editor
Open Source Database Magazine
http://www.osdbzine.net

Source build failed with 5.1.23

[Peiran Song]

Hi All,

I tried to build RPM with version 5.1.23 source package, 
mysql-5.1.23a-maria-alpha.tar.gz and mysql-5.1.23-rc.tar.gz. Both failed 
on missing a few executable files. I couldn't find those files in the 
tarball. And for mysql_explain_log, it seems deprecated in 5.1? Any one 
could shed some light on what might be wrong?


RPM build errors:
File not found: .../mysql-5.1.23/bin/mysql_create_system_tables
File not found: .../mysql-5.1.23/bin/mysql_explain_log
File not found: .../mysql-5.1.23/bin/mysql_tableinfo
File not found: .../mysql-5.1.23/bin/mysqltestmanager
File not found: .../mysql-5.1.23/bin/mysqltestmanager-pwgen
File not found: .../mysql-5.1.23/bin/mysqltestmanagerc
File not found: .../mysql-5.1.23/bin/comp_err

Thanks!

Joy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Source build failed with 5.1.23

[Peiran Song]

Never mind, my bad.


Hi All,

I tried to build RPM with version 5.1.23 source package, 
mysql-5.1.23a-maria-alpha.tar.gz and mysql-5.1.23-rc.tar.gz. Both 
failed on missing a few executable files. I couldn't find those files 
in the tarball. And for mysql_explain_log, it seems deprecated in 5.1? 
Any one could shed some light on what might be wrong?


RPM build errors:
File not found: .../mysql-5.1.23/bin/mysql_create_system_tables
File not found: .../mysql-5.1.23/bin/mysql_explain_log
File not found: .../mysql-5.1.23/bin/mysql_tableinfo
File not found: .../mysql-5.1.23/bin/mysqltestmanager
File not found: .../mysql-5.1.23/bin/mysqltestmanager-pwgen
File not found: .../mysql-5.1.23/bin/mysqltestmanagerc
File not found: .../mysql-5.1.23/bin/comp_err

Thanks!

Joy




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Call for articles for Fall Issue of Open Source Database Magazine

[Keith Murphy]

Hello everyone,

I wanted to take a minute and extend an invitation to anyone who has
interest in writing about MySQL or other open source database servers.

July brought the first issue of Open Source Database Magazine and it was a
resounding success. Our download count has skyrocketed. I was blown away
when I checked my stats after the first two days of release and there were
almost three times as many downloads as I had ever had of any of the
previous issues of MySQL Magazine. Thanks to those who participated by
contributing articles; I couldn't have done it without you. The feedback I
have received is that the change in direction has been embraced by the
open source database community.

I am making multiple changes in the magazine but the one that will
directly affect authors is that I am increasing the payment for articles.
All the details about the coming changes are on an OSDB Magazine blog post
here: http://www.osdbzine.net/wordpress/?p=3

I need to hear from you by October the 5th with any proposals and the
article needs to be completed and turned in by October the 30th.

Looking forward to hearing from you.

Keith Murphy

-- 
Editor
Open Source Database Magazine
http://www.osdbzine.net
edi...@osdbzine.net


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

MySQL University session on October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure

[Stefan Hinz]

InnoDB Internals: InnoDB File Formats and Source Code Structure
http://forge.mysql.com/wiki/InnoDB_Internals:_InnoDB_File_Formats_and_Source_Code_Structure

This Thursday (October 1st, 14:00 UTC - one hour later than usually),
Calvin Sun will give a session on InnoDB Internals: InnoDB File Formats
and Source Code Structure. The InnoDB storage engine provides
transactions, row-level locking, and automatic crash recovery. Its
on-disk files play a pivotal role for those key features. This
presentation describes how on-disk files are structured, how compressed
tables are organized, and how long variable-length columns are stored.
As we develop new features, it is inevitable for file format changes. We
will explain how the new file format management works in the InnoDB
Plugin. This talk also covers InnoDB source code structure.

For MySQL University sessions, point your browser to this page:

http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity

You need a browser with a working Flash plugin. You may register for a
Dimdim account, but you don't have to. (Dimdim is the conferencing
system we're using for MySQL University sessions. It provides integrated
voice streaming, chat, whiteboard, session recording, and more.)

MySQL University is a free educational online program for
engineers/developers. MySQL University sessions are open to anyone, not
just Sun employees. Sessions are recorded (slides and audio), so if you
can't attend the live session you can look at the recording anytime
after the session.

Here's the schedule for the upcoming weeks:

* October 8: Building MySQL Releases on Unix (Jörg Brühe)
* October 15: The Spider Storage Engine (Giuseppe Maxia)
* October 22: Dual Master Setups With MMM (Arjen Lentz)
* October 29: MySQL scalability on SPARC  INTEL X5500 (Nehalem) (Benoit
  Chaffanjon)
* November 12: Gearman for MySQL (Giuseppe Maxia)
* November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith)
* December 3: Practical Full-Text Search in MySQL (Bill Karwin)

The schedule is not engraved in stone at this point. Please visit
http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the
up-to-date list. On that page, you can also find the starting time for
many time zones.

Cheers,

Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.de/mysql  mailto: stefan.h...@sun.com

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Source-Install 5.0.85 on Debian Lenny: MySQL-Client segfaults

[Werner]

Hi everybody,

I'm currently installing MySQL 5.0.85 from source on Debian Lenny, but do 
expirience
Problems with the MySQL-Client.

# uname -a
Linux corleone 2.6.26-2-amd64 #1 SMP Wed Aug 19 22:33:18 UTC 2009 x86_64 
GNU/Linux


# The following configure-options are used:
./configure --prefix=/usr/local/mysql --with-charset=latin1 
--with-mysqld-user=mysql --with-comment=x86_64-SMP --without-debug
--enable-thread-safe-client --with-client-ldflags=-all-static 
--with-mysqld-ldflags=-all-static --disable-shared

I'm able to start the database successfully *but* I've I try to connect with the
MySQL-Client - the MySQL-Client dies with a segfault as follows:


server:#/usr/local/mysql/bin/mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.84 GOFRESH-x86_64-SMP
Segmentation fault

Any help greatly appreciated.

Thank you,
Werner

PS: Here is the strace of the mysql-Call

corleone:/usr/local/mysql/bin# strace /usr/local/mysql/bin/mysql -u root
execve(/usr/local/mysql/bin/mysql, [/usr/local/mysql/bin/mysql, -u, 
root], [/* 15 vars */]) = 0
uname({sys=Linux, node=corleone, ...}) = 0
brk(0)  = 0x2647000
brk(0x2647f70)  = 0x2647f70
arch_prctl(ARCH_SET_FS, 0x26478b0)  = 0
brk(0x2668f70)  = 0x2668f70
brk(0x2669000)  = 0x2669000
ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, {B9600 opost isig icanon echo ...}) = 0
ioctl(1, SNDCTL_TMR_TIMEBASE or TCGETS, {B9600 opost isig icanon echo ...}) = 0
dup(1)  = 3
close(3)= 0
stat(/etc/my.cnf, {st_mode=S_IFREG|0644, st_size=2212, ...}) = 0
open(/etc/my.cnf, O_RDONLY)   = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=2212, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x7f611564a000
read(3, # The following options will be p..., 4096) = 2212
read(3, ..., 4096)= 0
close(3)= 0
munmap(0x7f611564a000, 4096)= 0
stat(/usr/local/mysql/etc/my.cnf, 0x7fff1d649b30) = -1 ENOENT (No such file 
or directory)
stat(/root/.my.cnf, 0x7fff1d649b30)   = -1 ENOENT (No such file or directory)
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)= 0
connect(3, {sa_family=AF_FILE, path=/var/run/nscd/socket...}, 110) = -1 
ENOENT (No such file or directory)
close(3)= 0
socket(PF_FILE, SOCK_STREAM, 0) = 3
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)= 0
connect(3, {sa_family=AF_FILE, path=/var/run/nscd/socket...}, 110) = -1 
ENOENT (No such file or directory)
close(3)= 0
open(/etc/nsswitch.conf, O_RDONLY)= 3
fstat(3, {st_mode=S_IFREG|0644, st_size=475, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x7f611564a000
read(3, # /etc/nsswitch.conf\n#\n# Example ..., 4096) = 475
read(3, ..., 4096)= 0
close(3)= 0
munmap(0x7f611564a000, 4096)= 0
open(/etc/ld.so.cache, O_RDONLY)  = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=14229, ...}) = 0
mmap(NULL, 14229, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f6115647000
close(3)= 0
access(/etc/ld.so.nohwcap, F_OK)  = -1 ENOENT (No such file or directory)
open(/lib/libnss_db.so.2, O_RDONLY)   = -1 ENOENT (No such file or directory)
stat(/lib, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open(/usr/lib/libnss_db.so.2, O_RDONLY) = -1 ENOENT (No such file or 
directory)
stat(/usr/lib, {st_mode=S_IFDIR|0755, st_size=12288, ...}) = 0
open(/lib/x86_64-linux-gnu/libnss_db.so.2, O_RDONLY) = -1 ENOENT (No such 
file or directory)
stat(/lib/x86_64-linux-gnu, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open(/usr/lib/x86_64-linux-gnu/libnss_db.so.2, O_RDONLY) = -1 ENOENT (No such 
file or directory)
stat(/usr/lib/x86_64-linux-gnu, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
munmap(0x7f6115647000, 14229)   = 0
open(/etc/ld.so.cache, O_RDONLY)  = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=14229, ...}) = 0
mmap(NULL, 14229, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f6115647000
close(3)= 0
access(/etc/ld.so.nohwcap, F_OK)  = -1 ENOENT (No such file or directory)
open(/lib/libnss_files.so.2, O_RDONLY) = 3
read(3, 
\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0\0\1\0\0\0\340\37\0\0\0\0\0\0@..., 832) = 
832
fstat(3, {st_mode=S_IFREG|0644, st_size=47520, ...}) = 0
mmap(NULL, 2143528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0x7f611543b000
mprotect(0x7f6115445000, 2097152, PROT_NONE) = 0
mmap(0x7f6115645000, 8192, PROT_READ|PROT_WRITE, 
MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa000) = 0x7f6115645000
close(3)= 0
access(/etc/ld.so.nohwcap, F_OK)  = -1 ENOENT (No such file or directory)
open(/lib/libc.so.6, O_RDONLY)= 3
read(3

Using Open Source Database

[Sameh Attia]

Hi,
   Part of our road map is to use an open source database besides commercial
databases (oracle and sql server), we need to select an open source database
to build the necessary skills for administration and operation.

Then we would put guidelines on which applications should use open source
database and which to use Oracle.
Then migrate these applications to the new open source database.

 Part of this exercise is a financial exercise on the savings resulting from
this transformation (CAPEX  OPEX). So do you have any pointers, case
studies, and so on?
Regards
Sameh Attia
--
- Failure is not an option; it is a built-in feature in Windows.
- The two basic principles of system administration:

 * For minor problems, reboot
 * For major problems, reinstall

dc -e
'603178305900664311156641389051003470569569613466992253686426210705237258P'

Re: Using Open Source Database

[Colin Streicher]

On Thursday 27 August 2009 03:35:19 am Sameh Attia wrote:
 Hi,
Part of our road map is to use an open source database besides
 commercial databases (oracle and sql server), we need to select an open
 source database to build the necessary skills fo

I know this is a mysql mailing list, but I strongly encourage having a good 
look at Postgresql. In my opinion, it is better suited for a commercial 
database environment than mysql. 
If you are curious, join the Postgresql general mailing list and watch the 
traffic for a couple days, see what others are using it for. 

Colin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Open Source Database Magazine - Issue One Released

[bmurphy]

I just uploaded the pdf of the summer issue of Open Source Database
Magazine. Included in this issue:

* A great article on the new features of Postgresql 8.4 by Robert Treat
* Part one of a two part article on Percona’s new XtraBackup backup
program

Also the news, the book shelf and Peter Brawley’s Coding Corner. Downloads
are available at http://www.osdbzine.net.

thanks,

Keith Murphy

Editor

Open Source Database Magazine
http://www.osdbzine.net


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Open Source Database Magazine

[bmurphy]

hello everyone,

Many of you know I have been the editor of MySQL Magazine for the last two
years. Beginning with the summer issue I will be making some pretty major
changes. The magazine is being renamed Open Source Database Magazine and I
am going to be attempting to steer the subject matter to include any open
source db.

The details are here:

http://www.paragon-cs.com/wordpress/2009/06/16/mysql-magazine-is-dead-long-live-open-source-database-magazine/

This does not mean that MySQL will be forgotten. Quite the opposite, I
expect that there will be more articles about MySQL Server than any other
database if for no other reason than there are more installations of MySQL
than any other OS db. So step up to the plate! Send me a proposal for an
article for the next issue which will come out in mid-July.

Looking forward to hearing from you.

thanks,

Keith





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

6.0.11 source

[Alex Katebi]

Anyone knows where I can download the 6.0.11 gziped source from?

Open source Data warehouse

[Lin Chun]

Hi
   Anybody know some open source data warehouse product like Bizgres?

New version of open source MySQL appliance

[Liraz Siri]

Hello everyone,

We just released a new version of our MySQL appliance:

http://www.turnkeylinux.org/appliances/mysql

In a nutshell, this is an extremely easy way to get a MySQL instance up
and running on your server or VM (VMware, VirtualBox, Xen, KVM) of
choice in just a couple of minutes.

Changes include:

* Security: SSL support, crypto key regeneration during installation,
  database password setting during installation.

* Usability: confconsole support for systems with multiple NICs,
  password-free login in demo mode, added many generically useful Webmin
  modules, and improved embedded documentation.

* A bugfix in the daily auto-updates mechanism.

* rebuilt on top of TurnKey Core, the new common base for all software
  appliances, which is assembled from Ubuntu 8.04.2 LTS packages.

Cheers,
Liraz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Installing MySQL from source

[michel]

From the different documentation I was reading that after going to the root 
directory I should execute /.configure; but there is no configure file in the 
root source directory, just configure.in

Re: Installing MySQL from source

[Joerg Bruehe]

Michel,


michel wrote:
 From the different documentation I was reading that after going to the root 
 directory I should execute /.configure; but there is no configure file in the 
 root source directory, just configure.in

there is a difference between
  Installing MySQL from the current development source tree
and
  Installing MySQL from the source tarball of some released version.

In the development source tree, we have files which need to be processed
by the GNU autotools (autoconf, automake, aclocal),
whereas a source tarball is created from the result of these tools.

The manual should cover that, but I don't have a specific URL handy.

The development tree contains a file BUILD/autorun.sh which runs these
tools.


HTH,
Jörg

-- 
Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com
Sun Microsystems GmbH,   Sonnenallee 1,   D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Installing MySQL from source

[Paul DuBois]

On Feb 13, 2009, at 8:52 AM, Joerg Bruehe wrote:


Michel,


michel wrote:
From the different documentation I was reading that after going to  
the root directory I should execute /.configure; but there is no  
configure file in the root source directory, just configure.in


there is a difference between
 Installing MySQL from the current development source tree
and
 Installing MySQL from the source tarball of some released version.

In the development source tree, we have files which need to be  
processed

by the GNU autotools (autoconf, automake, aclocal),
whereas a source tarball is created from the result of these tools.

The manual should cover that, but I don't have a specific URL handy.


It's http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html


The development tree contains a file BUILD/autorun.sh which runs  
these

tools.


HTH,
Jörg


--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

MySQL Community Server 5.0.75 has been released in source

[Joerg Bruehe]

Dear MySQL users,

MySQL Community Server 5.0.75, a new version of the popular Open Source
Database Management System, has been released.  The release is now
available in source (only) form from our download pages at

  http://dev.mysql.com/downloads/

and mirror sites.  Note that not all mirror sites may be up to date at
this point in time, so if you can't find this version on some mirror,
please try again later or choose another download site.

We expect to publish the next community version in both source and
binary form early next year (2009).

We welcome and appreciate your feedback, bug reports, bug fixes,
patches etc.:

  http://forge.mysql.com/wiki/Contributing

The following section lists important, incompatible and security
changes since the previous MySQL Community Server 5.0.67 release.  The
full changelog including many more fixes can be viewed online at

  http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-75.html


This is a bugfix release for the current production release
family. It replaces MySQL 5.0.67.

Functionality added or changed:

  * Security Enhancement: To enable stricter control over the
location from which user-defined functions can be loaded, the
plugin_dir system variable has been backported from MySQL 5.1.
If the value is non-empty, user-defined function object files
can be loaded only from the directory named by this variable.
If the value is empty, the behavior that is used prior to the
inclusion of plugin_dir applies: The UDF object files must be
located in a directory that is searched by your system's
dynamic linker. (Bug#37428: http://bugs.mysql.com/37428)

  * Previously, index hints did not work for FULLTEXT searches.
Now they work as follows:
For natural language mode searches, index hints are silently
ignored. For example, IGNORE INDEX(i) is ignored with no
warning and the index is still used.
For boolean mode searches, index hints are honored.
(Bug#38842: http://bugs.mysql.com/38842)

Bugs fixed:

  * Important Change: Security Fix: Additional corrections were
made for the symlink-related privilege problem originally
addressed in MySQL 5.0.60. The original fix did not correctly
handle the data directory pathname if it contained symlinked
directories in its path, and the check was made only at
table-creation time, not at table-opening time later.
(Bug#32167: http://bugs.mysql.com/32167, CVE-2008-2079
(http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-2079))
See also Bug#39277: http://bugs.mysql.com/39277.

  * Security Enhancement: The server consumed excess memory while
parsing statements with hundreds or thousands of nested
boolean conditions (such as OR (OR ... (OR ... ))). This could
lead to a server crash or incorrect statement execution, or
cause other client statements to fail due to lack of memory.
The latter result constitutes a denial of service.
(Bug#38296: http://bugs.mysql.com/38296)

  * Incompatible Change: There were some problems using DllMain()
hook functions on Windows that automatically do global and
per-thread initialization for libmysqld.dll:

   + Per-thread initialization: MySQL internally counts the
 number of active threads, which causes a delay in
 my_end() if not all threads have exited. But there are
 threads that can be started either by Windows internally
 (often in TCP/IP scenarios) or by users. Those threads do
 not necessarily use libmysql.dll functionality but still
 contribute to the open-thread count. (One symptom is a
 five-second delay in times for PHP scripts to finish.)

   + Process-initialization: my_init() calls WSAStartup that
 itself loads DLLs and can lead to a deadlock in the
 Windows loader.
To correct these problems, DLL initialization code now is not
invoked from libmysql.dll by default. To obtain the previous
behavior (DLL initialization code will be called), set the
LIBMYSQL_DLLINIT environment variable to any value. This
variable exists only to prevent breakage of existing
Windows-only applications that do not call mysql_thread_init()
and work okay today. Use of LIBMYSQL_DLLINIT is discouraged
and is removed in MySQL 6.0.
(Bug#37226: http://bugs.mysql.com/37226,
Bug#33031: http://bugs.mysql.com/33031)

  * Incompatible Change: SHOW STATUS took a lot of CPU time for
calculating the value of the Innodb_buffer_pool_pages_latched
status variable. Now this variable is calculated and included
in the output of SHOW STATUS only when the UNIV_DEBUG symbol
is defined at server build time.
(Bug#36600: http://bugs.mysql.com/36600)

  * Incompatible Change: In connection with view creation, the
server created arc directories inside database directories and
maintained useless copies of .frm files there. Creation and
renaming procedures of those

Windows source distribution

[Edward Diener]

The MySql manual in section 2.4.15.6.2 mentions building MySql from the 
Windows source distribution. I need to do this in order to add SSL 
support to my MySql server on Windows.


From where do I download the Windows source distribution ?

The source distributions listed at 
http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any 
as the Windows source distribution. I downloaded the .zip file, thinking 
that might be the one, but it is not.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Windows source distribution

[Warren Young]

Edward Diener wrote:


The source distributions listed at 
http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any 
as the Windows source distribution. I downloaded the .zip file, thinking 
that might be the one, but it is not.


I just downloaded it, and it looks like the source code to me.  I think 
you're just not finding the build instructions, or not understanding them.


The zip file contains just one top-level directory, mysql-5.0.67. 
Inside that is a file called INSTALL-WIN-SOURCE.  Read it, ignoring the 
claims that you should find .sln files within the package; it's clearly 
outdated information.  You will probably need to get cmake from 
somewhere to generate the .sln and .vcproj files.  At that point, 
building MySQL should be straightforward.


Getting it to find the openssl libraries, as discussed on the other 
list, is another question...


I've not done this myself, just reporting on what I've figured out in a 
few minutes' poking around.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Windows source distribution

[Edward Diener]

Warren Young wrote:
 Edward Diener wrote:

 The source distributions listed at
 http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify
 any as the Windows source distribution. I downloaded the .zip file,
 thinking that might be the one, but it is not.

 I just downloaded it, and it looks like the source code to me. I think
 you're just not finding the build instructions, or not understanding 
them.


No, I am not finding the VC++ .sln files as explained in the MySql 
reference
manual section 2.4.15.6.2. Building MySQL from a Windows Source 
Distribution.



 The zip file contains just one top-level directory, mysql-5.0.67. Inside
 that is a file called INSTALL-WIN-SOURCE. Read it, ignoring the claims
 that you should find .sln files within the package; it's clearly
 outdated information. You will probably need to get cmake from
 somewhere to generate the .sln and .vcproj files. At that point,
 building MySQL should be straightforward.

Essentially then the entire 2.4.15.6.2* *section in the MySql reference 
is just obsolete and the
reference manual never was updated to reflect that. In fact what you are 
saying is that in

2.4.15.6, where it says:

There are three solutions available for building from the source code on 
Windows:


   *

 Build from the standard MySQL source distribution. For this you
 will need CMake and Visual C++ Express Edition or Visual Studio.
 Using this method you can select the storage engines that are
 included in your build. To use this method, see Section
 2.4.15.6.1, “Building MySQL from the Standard Source Distribution”
 ch02s04.html#windows-source-build-cmake.

   *

 Build from the MySQL Windows source distribution. The Windows
 source distribution includes ready-made Visual Studio solution
 files that enable support for all storage engines (except |NDB|).
 To build using using method you only need Visual C++ Express
 Edition or Visual Studio. To use this method, see Section
 2.4.15.6.2, “Building MySQL from a Windows Source Distribution”
 ch02s04.html#windows-vc-plus-plus-build.

   *

 Build directly from the BitKeeper source repository. For this you
 will need CMake, Visual C++ Express Edition or Visual Studio, and
 |bison|. For this method you need to create the distribution on a
 Unix system and then copy the generated files to your Windows
 build environment. To use this method, see Section 2.4.15.6.5,
 “Creating a Windows Source Package from the BitKeeper Repository”
 ch02s04.html#windows-bitkeeper-build.

that the middle way does not really exist.


 Getting it to find the openssl libraries, as discussed on the other
 list, is another question...

 I've not done this myself, just reporting on what I've figured out in a
 few minutes' poking around.

I guess I actually believed the docs. Thanks for telling me that they 
are just plain wrong. I will follow the
INSTALL-WIN-SOURCE file and just ignore the reference manual in this 
situation. But really the docs
should be corrected so that others do not attempt to follow the 
incorrect path it outlines in

2.4.15.6.2 ch02s04.html#windows-vc-plus-plus-build.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

OpenSQL Camp -- a conference for open-source databases

[Baron Schwartz]

OpenSQL Camp is a hybrid conference and hackfest on November 14-16,
2008 in Charlottesville, Virginia USA. It's of, by and for open-source
databases.  A lot of celebrities will be here, including the creator
of SQLite, and of course Brian Aker and Monty Widenius and Peter
Zaitsev etc.  It's free, and even the meals are provided.

See http://www.opensqlcamp.org/

Spread the word -- tell your friends, blog about it, and most of all,
attend and participate!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to install MYSQL from source on windows?

[nick xu]

I want to install MYSQL from source on Windows. 
Now, i have compiler success with Microsoft Visual Studio 2005 and Cmake on
Windows XP. 
But nothing happened!! 
I have read the INSTALL-WIN-SOURCE that is in source, but no use. 
So, who can help me what should I do the next step to install MYSQL from
source on Windows.

-- 
View this message in context: 
http://www.nabble.com/how-to-install-MYSQL-from-source-on-windows--tp15530583p15530583.html
Sent from the MySQL - General mailing list archive at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Pass Reference to source table in Stored Procedure - How??

[roger.maynard]

Hi

 

Is there any way I can pass the reference to a source table to be used
in a SELECT command within a Stored Procedure

 

Something like this

 

CREATE PROCEDURE `myDB`.`sp_test` (myTable varchar(20))

BEGIN

SELECT * FROM myTable;

END $$

 

This gives error cannot find Table myDB.myTable

 

I cant find how to pass reference in this context.  If its not possible,
are there any suggestions as to how to create a flexible SP whereby I
can pass the source?

 

I can do it by repeating the main select within a switch case structure
but it doesn't seem a very elegant solution

 

Thanks for looking 

 

Roger Maynard

Somerset UK