DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Mroonga 9.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 9.00 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

mysql V 8.0.12 and mysqdump

Hello list,
i run into an unexpected problem with mysqldump:

mysqldump --version
mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)

when i try it results in:
mysqldump: Error: 'Lost connection to MySQL server during query' when trying to
dump tablespaces
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL
server has gone away (2006)

I seems it get stuck in this query:

explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE,
ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE
_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL A

Reported lengths of char fields - psqlODBC

Linux Mint 18.3 x64 (base on Ubuntu 16.04 package base)
Postgresql v 9.5.14
unixODBC v2.3.1-4.1
psqlODBC v1:09.03.0300-1

I created a simple table containing one column of type character (n).
When I ask for the width of the column via (ODBC)SQLColAttribute function,
it answers (n*6) , so if defined as character(1) the call reports length 6,
character(2) reports 12, character(4) reports 24, etc.

I see the same kind of results when using a varchar(n) field (character
varying (2), etc ) as well .

Is this expected, or am I doing something wrong?

Thanks,
Bob

PG12 patch

Hello, I use the PostgreSQL-devel server with which the psqlodbc-git
version does not work because the field 'relhasoids' was dropped in
PG12. After applying the patch that I send you, my huge c++ ODBC
application now works again with PostgreSQL-devel server. Vladimir
Koković DP senior(69), Belgrade, Serbia

MySQL Enterprise Backup 8.0.15 has been released

Dear MySQL users,

MySQL Enterprise Backup 8.0.15, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.15 supports only the MySQL Server 8.0.15.
For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup
version with the same version number as the server.

MySQL Router 8.0.15 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Router 8.0.15 is a new release for MySQL Router 8.0 series.

MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Router 8.0.15.

The MySQL Router is a new building block for high availability solutions
based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

MySQL Connector/Node.js 8.0.15 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Connector/J 8.0.15 has been released

Dear MySQL users,

MySQL Connector/J Version 8.0.15 is the GA release of the 8.0
branch of MySQL Connector/J. It is suitable for use with MySQL Server
versions 8.0, 5.7, 5.6, and 5.5.

MySQL Workbench 8.0.15 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.15 as our general available
(GA) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number of
platforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.15 (2019-02-01, General
Availability)

   This release contains no fun

MySQL Connector/NET 8.0.15 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.15 is the third version to support
Entity Framework Core 2.1 and the fifth general availability release
of MySQL Connector/NET to add support for the new X DevAPI, which
enables application developers to write code that combines the
strengths of the relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Shell 8.0.15 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Shell 8.0.15 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0
and 5.7. Please upgrade to MySQL Shell 8.0.15.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Community Server 8.0.15 has been released

Dear MySQL users,

MySQL Server 8.0.15, a new version of the popular Open Source
Database Management System, has been released.

Erreur when testing connection

Hi,

I have a problem on W7 (inside  a qemu/kvm vm) with last ANSI odbc
driver (psqlodbc_11_00_0000-x86.zip) when trying  to connect to
postgresql 11 (from buster debian package).

The db has been created but is empty.

I use the test button of psqlodbc_x86 with  odbcad32 (32bits version).

Sometimes the test successes, but most of the time, I get :

(...) could not send startup packet Connection reset by peer.

Thnks for any help

PC

Log here :

[2360-0.000]   mylog.c[logs_on_off]274: mylog_on=1 qlog_on=0
[2360-0.000]    start_logging:Global.debug&commlog=1&0
[2360-0.000]psqlodbc.c[DllMa

MySQL Connector/ODBC 5.3.12 has been released

Dear MySQL users,

MySQL Connector/ODBC 5.3.12, a new version of the ODBC driver for the
MySQL database management system, has been released.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select the driver
type you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL version from 5.5.

This is the sixth release of the MySQL ODBC driver conforming to the
ODBC 3.8 specification.

MySQL Cluster 7.6.9 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.6.9 has been released and can be downloaded from

  <a href="http://www.mysql.com/downl" title="http://www.mysql.com/downl">http://www.mysql.com/downl</a>

MySQL Cluster 7.5.13 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.13 has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Cluster 7.5.13 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

  - In-Memory storage - Real-time performance (with optional
    checkpointing to disk)
  - Transparent Auto-Sharding - Read & write scalability
  - Active-Active/Multi-Master geographic replication

  - 99.999% High Availability with no single point of failure
    and on-line maintenance
  - NoSQL and SQL APIs (including C++, Java, http, Memcached
    and JavaScript/Node.js)

MySQL Cluster 7.5.13 has been released and can be downloaded from

  <a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

MySQL Connector/C++ 8.0.14 has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.14 is a new release version of the MySQL
Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

MySQL Shell 8.0.14 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Shell 8.0.14 is a maintenance release of MySQL Shell 8.0 Series
(a component of the MySQL Server). The MySQL Shell is provided under
Oracle's dual-license.

MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0
and 5.7. Please upgrade to MySQL Shell 8.0.14.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Community Server 5.7.25 has been released

Dear MySQL users,

MySQL Server 5.7.25, a new version of the popular Open Source Database
Management System, has been released.

MySQL Workbench 8.0.14 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.14 as our general available (GA) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/changes-8-0.html</a>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number
ofplatforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.14 (2019-01-21, General
Availability)

* Functionality Added or

MySQL Connector/NET 8.0.14 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.14 is the second version to support
Entity Framework Core 2.1 and the fourth general availability release
of MySQL Connector/NET to add support for the new XDevAPI, which
enables application developers to write code that combines the
strengths of the relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the XDevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Connector/J 8.0.14 has been released

Dear MySQL users,

MySQL Connector/J Version 8.0.14 is the GA release of the 8.0
branch of MySQL Connector/J. It is suitable for use with MySQL Server
versions 8.0, 5.7, 5.6, and 5.5.

MySQL Connector/ODBC 8.0.14 has been released

Dear MySQL users,

MySQL Connector/ODBC 8.0.14 is a new version in the MySQL Connector/ODBC
8.0 series,
the ODBC driver for the MySQL Server.

The available downloads include both a Unicode driver and an ANSI driver
based on the
same modern codebase. Please select the driver type you need based on
the type of your
application - Unicode or ANSI.

MySQL Enterprise Backup 8.0.14 has been released

MySQL Enterprise Backup 8.0.14, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.14 supports only the MySQL Server 8.0.14.
For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup
version with the same version number as the server.

MySQL Router 8.0.14 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Router 8.0.14 is a new release for MySQL Router 8.0 series.

MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Router 8.0.14.

The MySQL Router is a new building block for high availability solutions
based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology, and
combined with the MySQL Shell, InnoDB clusters provide an integrated
solution for high availability and scalability for InnoDB based MySQL
databases, that does not require advanced MySQL expertise.

The deployment of applicat

MySQL Connector/Node.js 8.0.14 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Community Server 8.0.14 has been released (part 2/2)

[This is part 2 of the announcement]

Bugs Fixed

* Important Change: Importing a dump from a MySQL 5.7
server to a server running MySQL 8.0 often failed with
ER_WRONG_VALUE_FOR_VAR when an SQL mode not supported by
the 8.0 server was used. This could happen frequently due
to the fact that NO_AUTO_CREATE_USER is enabled by
default in MySQL 5.7 but not supported in MySQL 8.0.
The behavior of the server in such circumstances now
depends on the setting of the pseudo_slave_mode system
variable.

MySQL Community Server 8.0.14 has been released (part 1/2)

[Due to size limitation, this announcement is split in two. This is part 1]

Dear MySQL users,

MySQL Server 8.0.14, a new version of the popular Open Source
Database Management System, has been released.

Re: Help in Exporting PostgreSQL DB to SQL Server

Hi

I am trying to Export PostgreSQL into SQL Server

But For some reason I do have an issue and I couldn't find a right way also Online help is not helping me much

Can you please let me know how can this be made easier ?

Also reason for me to export PostgreSQL to SQL server:

All our data are right now stored in PostgreSQL and we are migrating to Mysql server (PHP).

So we have to give a CSV file of our current data dump to the new provider to import in Mysql

When I export from PostgreSQL any special char in the database is exported as some special char and this is causing us problem

So

MySQL Community Server 5.6.43 has been released

Dear MySQL users,

MySQL Server 5.6.43, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.43 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

Character with byte sequence has no equivalent in encoding.

Hello Dear Postgresql- Team,

first of all thank you for that great odbc driver!

I discovered an error while using an old version (9.00.02.00) (ANSI) (x64)
Version and wanted to ask for some more information on that one.

I get following error when Selecting some data from an PostgreSQL UTF 8
Database:
{"ERROR [22P05] ERROR: character with byte sequence 0xef 0xbc 0x8c in
encoding \"UTF8\" has no equivalent in encoding \"WIN1252\";\nError while
executing the query"}

When I change the driver to UNICODE I don't get the error at all.

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

Upscene releases Database Workbench 5.5.0

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.5.0 "

This new release brings you support for the latest versions of supported database systems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8.

There's also a new release of the free Lite Edition for MySQL: version 5.4.6 has been made available today.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

Here's the full list of c

Is psqlodbc_11_00_0000-x64 supported against PostgreSQL 10.06

Hello,

I was unable to find the support matrix for odbc to database. So I woull like to know if psqlodbc_11_00_0000-x64 is supported against PostgreSQL 10.06.

Thank you

[ASG Technologies]<http://www.asg.com/>

Kaleb Akalework, Sr Software Engineer

kaleb. ... at asg dot com<mailto:kaleb. ... at asg dot com> | 914-921-7357
www.asg.com<http://www.asg.com/> |

Facebook<https://www.facebook.com/ASGTechnologiesGroup/> | LinkedIn<https://www.linkedin.com/company/asg> | Twitter<https://twitter.com/ASGTec> | YouTube<https://www.youtube.com/asgtech>

connecting to postgres database

Sir,ma'am,

I am writing an application in vb2010 Visual basic express and am having issue with the data base connection for Postgres. I have installed the driver but haven't been able to get the connection to work. Please advise.

Imports System.Data.Odbc

Dim MyCon As New Odbc.OdbcConnection
MyCon.ConnectionString = "Driver={PostgreSQL ANSI};database=fgsms_performance;server=127.0.0.1;port=5432;"
MyCon.Open()

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Respectfully,
William Hoffmann
2604336018

Full text search not matching 2 letter word

Im trying to run a full text query on a two letter keyword 'K7'. I have
set ft_min_word_len=2 and restarted the server and if I view the system
vars in Mysql Workbench it shows it is set correctly.

I have then dropped and re-created the index on the descrip column. It
is an InnoDB table so I cannot do repair table.

Im running the following query which I expect to match the following
record but it doesnt.

Performance Issue with bulk Insert of Rows to Temp Table

Hello,

I am trying to insert multiple rows to temp tables on postgreSQL database
using psqlodbc lib (version 10.4). I am using bind variables to insert the
rows to the table.

NOTIFY/LISTEN with ODBC interface

Hi,
Is there a way to write a code found at
<a href="https://www.postgresql.org/docs/9.1/libpq-example.html" title="https://www.postgresql.org/docs/9.1/libpq-example.html">https://www.postgresql.org/docs/9.1/libpq-example.html</a>
Example 2 with the ODBC interface?

Thank you.

MySQL Cluster Manager 1.4.7 has been released

Dear MySQL Users,

MySQL Cluster Manager 1.4.7 can be downloaded from
the My Oracle Support (MOS) website.

Incomplete log for node group

1. I have received some error logs in data node.
"""
*** 278 BYTES LOST ***
file 64(364) FileChangeState: 0 logFileStatus: 1 currentMbyte: 255 currentFilepage 8191
file 35(335) FileChangeState: 0 logFileStatus: 1 currentMbyte: 0 currentFilepage 0
file 75(375) FileChangeState: 0 logFileStatus: 1 currentMbyte: 255 currentFilepage 8191
file 113(413) FileChangeState: 0 logFileStatus: 1 currentMbyte: 255 currentFilepage 8191
file 76(376) FileChangeState: 0 logFileStatus: 1 currentMbyte: 255 currentFilepage 8191
"""

2.

undiscribe

|
undiscribe

SQLTables does not retrieve everything

Hi,
I am trying to write an application where I need to know the list of
"ALL" tables and views.

However, it looks like the code:

[code]
ret = SQLTables( m_hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0 );
if( ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO )
{
GetErrorMessage( errorMsg, 1 );
result = 1;
}
[/code]

only retrieves the tables from the current database/catalog and "public" schema.

There is no tables/view on the INFORMATION_SCHEMA and all the system tables.

Do I have to drop it and use the actual que

Repository odbc driver AIX 7.1

Hi,

I'm trying to find out a repository of odbc driver package for AIX 7.1, but
I only found postgresql server packages, is there any repository ?
If there isn't any repository, could I use cross-compile odbc driver from
linux x64 to aix 7.1 power ? could you share me any documentation that
explain the compilation process ( I supposed that it's in a different way
of <a href="https://odbc.postgresql.org/docs/unix-compilation.html" title="https://odbc.postgresql.org/docs/unix-compilation.html">https://odbc.postgresql.org/docs/unix-compilation.html</a> explains ) ?

Thanks

Mroonga 8.09 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 8.09 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Estimate mysqldump size

Hello,

Is there a way that gives an estimate of the size of a mysqldump such a
way that it would always be larger than the real size?

So far, I have found:

mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM
information_schema.tables WHERE table_schema NOT IN
('information_schema','performance_schema','mysql');

but the result may be smaller than the real size.

I am writting a program that takes the result of mysqldump and pipe it
in a tar file.

Segmentation fault in case Debian9+odbc+pgsql10.6

Hi guys,

FYI - I noted that i have not problems with Deb9+pgsql9 and with
Deb8+pgsql10
But!

Segmentation fault in case Debian9+odbc+pgsql10.6

Hi guys,

FYI - I noted that i have not problems with Deb9+pgsql9 and with
Deb8+pgsql10
But!

bugfix: bit/varbit type support

hi, all

patch attached,please review.

support the type BIT/BIT VARYING
1. calculate column length correctly.
2. reverse type name correctly

it cause SQLColAttribute can not get
SQL_DESC_BASE_COLUMN_NAME/SQL_DESC_TYPE_NAME.

ODBC driver on OSX

Hi,
I downloaded the source code and then did:

./configure
make
sudo make install

on the sources

Then I opened iODBC DM 64-bit but couldn't find any references to the driver.

What did I do wrong?

This is on OSX 10.13.6 High Sierra.

Thank you.

psqlODBC 11.00.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 11.00.0000.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Mysql-proxy Load balancer for replication servers.

Hello Folks,

I have installed mysql-proxy in multiple Freeswitch PBX servers
and they are Live and I have master ans salve mechanism configured for
MySQL, Eventually, I want a mechanism which can balance a load of query on
mysql servers like round robbin fashion, but the lua script in mysql-proxy
is not balancing it properly.

Is there anyone who can help to achieve this scenario.

*Thanks & Regards,*
*Dhaval Chaudhary*
Jr. Software Engineer
[image: Ecosmob Technologies Pvt. Ltd.]
<https://htmlsig.com/t/000001C50ZHN>
Ecosmob Technologies Pvt.

FAQ update

Hi

Can someone please replace my name on the FAQ (
<a href="https://odbc.postgresql.org/faq.html" title="https://odbc.postgresql.org/faq.html">https://odbc.postgresql.org/faq.html</a>) with whatever is appropriate now
please?

Thanks!

MySQL Encryption-at-rest capability

Hi MySQL Community,

Greetings !

I have a query regarding encryption-at-rest feature in MySQL Community Edition -

What i understand is that Encryption-at-rest is supported from MySQL-5.7.11 community edition and only on file-per-table basis which means encryption at table-level can be implemented - is that correct ?

Also, if you can help us understand the security compliance requirements (like PCI-DSS etc.) this encryption can satisfy, that would be great. Thanks in advance !

Please confirm !
Regards,
Ven

enhanced SQLSpecialColumns

hi, all

patch attched,please review.

If a table has not WITH OIDS option.
Try to find primary-key(prefered)/unique index.
If it has not either of them, returns "ctid" as text type.

ODBC SQLSpecialColumns bugfix

hi, all

odbc patch attached.

if a table does not exist,
SQLSpecialColumns returns oid/xmin incorrectly.

Does the psqlodbc driver support asynchronous queries?

Hello everyone,

I'm trying to run asynchronous queries with unixODBC + psqlodbcw.so in
linux (RHEL5), but I can not do it.

The next code:

//-------
// Get the Async state
SQLINTEGER attrState;
SQLGetConnectAttr(hstmt, SQL_ATTR_ASYNC_ENABLE, &attrState, 0, NULL);
std::cout << "Async is set to: " << attrState << std::endl;
// Enable Async Operation - if ASYNC is not allowed, SQLSetStmtAttr
// will return an error
retcode = SQLSetStmtAttr (hstmt, SQL_ATTR_ASYNC_ENABLE,
(SQLPOINTER) SQL_ASYNC_ENABLE_ON,
SQL_IS_INTEGER);
CHECK_ERROR(retc

Syndicate content