ANN: Upscene releases Database Workbench 5.6.0

2019-02-26 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.6.0 " This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes. Version 5.5 br

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

2019-01-15 Thread Martijn Tonies (Upscene Productions)
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 sys

ANN: Upscene releases Database Workbench 5.4.6

2018-10-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.6 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.4.6 " This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.

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

2018-09-06 Thread 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

Re: ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread webmaster
Sent from my Samsung Galaxy smartphone. Original message From: "Martijn Tonies (Upscene Productions)" Date: 09/07/2018 13:17 (GMT+00:00) To: firebird-to...@yahoogroups.com, mysql@lists.mysql.com Subject: ANN: Upscene releases Database Workbench 5.4.4 Upscene P

ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases inclu

ANN: Upscene releases Database Workbench 5.4.2

2018-03-06 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.2 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.2 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest ve

ANN: Upscene releases Database Workbench 5.4.0

2018-02-05 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.0 " This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases

ANN: Upscene releases Database Workbench 5.3.4

2017-10-27 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3.4 " This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stor

Upscene releases Database Workbench 5.3.2

2017-06-30 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.3.2 “ This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine

Upscene releases Database Workbench 5.3

2017-04-19 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3 " This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with

Re: filename-safe conversion of database-/tablenames

2016-08-11 Thread Johan De Meersman
- Original Message - > From: "Simon Fromme" > Subject: filename-safe conversion of database-/tablenames > > I need to convert both the names of databases and tables in a > filename-safe way (escaping "/" and other characters as in [1]). The I don

filename-safe conversion of database-/tablenames

2016-08-09 Thread Simon Fromme
Hello, In order to do MySQL-dumps to a file on a Linux system under $BACKUP_DIR/$DB_NAME/$TABLE_NAME.sql I need to convert both the names of databases and tables in a filename-safe way (escaping "/" and other characters as in [1]). The mapping of MySQL database/table n

ANN: Beta of the Database Designer for MySQL 2.1.8 is out!

2016-07-19 Thread Aleksander Andreev
function values as defaults. Full change log: [!] Brand new SSH tunneling introduced [+] Option to quote or not default values for domains and columns added [*] Model file format changed. Notice generated for old models on Open You're welcome to download the Database Designer for MySQL 2.1.8

Re: call the appropriate and correct database

2016-06-20 Thread Johan De Meersman
- Original Message - > From: "HaidarPesebe" > Subject: call the appropriate and correct database > How do I call first database table as follows : > > id | country | province | distric | cost > > 1 | U

call the appropriate and correct database

2016-06-19 Thread Abdullah Bahar
How do I call first database table as follows : id | country | province | distric | cost 1 | USA | Alanama | distrik | 20 2 | USA | Alabama | distrik2 | 22 3 | USA | Alabama | distrik3 | 22 4 | France | Paris | disrik4 | 30 now I use 3 kinds of

ANN: Database Designer for MySQL 2.1.7 released!

2016-05-19 Thread Aleksander Andreev
New maintenance release introduces JSON type support. Full change log: [!] JSON type support added! [-] "Rare EStringListError during Table editor opening" bug fixed You're welcome to download the Database Designer for MySQL 2.1.7 right now at: http://microolap.com/products

ANN: Upscene releases Database Workbench 5.1.12

2016-03-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.12 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.12 “ This release adds a few small features and useful enhancements. The full version 5.1.x change log is available here: http

Oracle Certified Professional, MySQL 5.6 Database Administrator

2016-03-09 Thread Lukas Lehner
Hi when will be the exam "Oracle Certified Professional, MySQL 5.6 Database Administrator" for MySQL 5.7? Lukas

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Steven Siebert
apture failures and record them in another table for analysis or perhaps even to immediate data remediation (update key) and do insert. Now, for me, using triggers or other business-logic-in-database features is a code smell. I loath putting business logic in databases as they tend to be non-portab

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Steven Siebert
Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you use >> mysqldump to dump

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Gary Smith
On 29/02/2016 16:32, Steven Siebert wrote: At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you use the --replace flag you'll convert all INSERT statements to REPLACE, which when you merge will update or insert the record, effect

Re: dump, drop database then merge/aggregate

2016-02-29 Thread lejeczek
c to ensure integrity is maintained. Attempting to do it within the constructs of the database itself is understandable, but there are risks when not adding that "layer" of logic to ensure state is exactly as you expect it during a merge. At risk of giving you too much rope to hang yourself:

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Steven Siebert
do it within the constructs of the database itself is understandable, but there are risks when not adding that "layer" of logic to ensure state is exactly as you expect it during a merge. At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you us

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Johan De Meersman
- Original Message - > From: "lejeczek" > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again, dump then remove > and

Re: dump, drop database then merge/aggregate

2016-02-29 Thread lejeczek
On 29/02/16 15:42, Gary Smith wrote: On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I&#

Re: dump, drop database then merge/aggregate

2016-02-29 Thread Gary Smith
On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many

Re: dump, drop database then merge/aggregate

2016-02-29 Thread lejeczek
On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's

dump, drop database then merge/aggregate

2016-02-28 Thread lejeczek
fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done best. A box will be dumping

Upscene releases Database Workbench 5.1.10

2015-12-16 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5.1.10 This release adds a few small features and includes Windows Terminal Server support. The full version 5.1.x change log is available here: http://www.upscene.com/go/?go

ANN: 20% discount on Database Workbench Basic or Pro!

2015-11-04 Thread Martijn Tonies (Upscene Productions)
Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering, valid until November the 9th. You can find more information about Database Workb

ANN: 20% discount on Database Workbench Basic or Pro!

2015-10-23 Thread Martijn Tonies
Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering. You can find more information about Database Workbench here: http://

Re: When to create a new database

2015-10-14 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > Subject: Re: When to create a new database > > it makes zero sense since you can use different users for the same > database down to table and even column permissions No, it does make some sense in the case whe

Re: When to create a new database

2015-10-14 Thread Johan De Meersman
- Original Message - > From: "Ron Piggott" > Subject: Re: When to create a new database > > I would lean towards keeping it all together because of the speed > decrease between connecting to different databases. Heh, that consideration is a matter of semantics,

Re: When to create a new database

2015-10-12 Thread shawn l.green
database called "library" since they are used for reference and rarely change? What would be the pros and cons of using two different databases? Thanks The general rule is: are the tables all closely related (as in used for the same business purpose)? If they are, and possibly interdepend

Re: When to create a new database

2015-10-10 Thread Mogens Melander
, teams, games Would it be a good or bad idea to put the first set of tables in a separate database called "library" since they are used for reference and rarely change? What would be the pros and cons of using two different databases? it makes zero sense since you can use different use

Re: When to create a new database

2015-10-10 Thread Ron Piggott
separate database called "library" since they are used for reference and rarely change? What would be the pros and cons of using two different databases? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: When to create a new database

2015-10-10 Thread Reindl Harald
database called "library" since they are used for reference and rarely change? What would be the pros and cons of using two different databases? it makes zero sense since you can use different users for the same database down to table and even column permissions with default (crap) setti

When to create a new database

2015-10-10 Thread Richard Reina
If I were keeping tract of high school sports statistics and thus designed the following tables: sports, rules, statistical definitions and players, teams, games Would it be a good or bad idea to put the first set of tables in a separate database called "library" since they ar

Upscene releases Database Workbench 5.1.6

2015-10-09 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.6 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The full ve

Upscene releases Database Workbench 5.1.2

2015-07-15 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.2 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The change log is available here: http://www.upscene.c

Upscene releases Database Workbench 5.1.0

2015-06-24 Thread Martijn Tonies (Upscene Productions)
For immediate release: http://www.upscene.com/news/item/20150624 Upscene releases Database Workbench 5.1.0 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1 " This version is the next big release after version

ANN: Meet the MicroOLAP Database Designer for MySQL 2.1.5

2015-06-04 Thread Aleksander Andreev
Preferences [*] "Add object" menu item is available for the Object Tree View [*] Handling of incorrect file paths improved in Generate Database [*] Multiple triggers are permitted for the same Time and Event combination as of MySQL 5.7.2 [*] Trigger name generation simplified in Table Editor

Re: Dumping database names from bash with exclusion

2015-04-01 Thread Tim Johnson
* h...@tbbs.net [150401 15:22]: > On 2015/04/01 16:09, Tim Johnson wrote: > >Using Mysql 5 on darwin (OS x). > >This command > >SELECT schema_name FROM information_schema.schemata WHERE > >schema_name NOT IN > >('mysql','information_schema','performance_schema'); > >as executed from the mysql prom

Re: Dumping database names from bash with exclusion

2015-04-01 Thread hsv
On 2015/04/01 16:09, Tim Johnson wrote: Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those no

Dumping database names from bash with exclusion

2015-04-01 Thread Tim Johnson
Using Mysql 5 on darwin (OS x). This command SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema'); as executed from the mysql prompt gives me a dump of all databases except those not included in the tuple. This command mys

Upscene releases Database Workbench 5.0.10

2015-02-20 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: " Database Workbench 5 " This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.com/go/?go=tracker&v=5.0.10&id=12

ANN: Database Designer for MySQL 2.1.4 is out!

2015-02-05 Thread Aleksander Andreev
27;re welcome to download the Database Designer for MySQL 2.1.4 right now at: http://microolap.com/products/database/mysql-designer/download/ Login to your private area on our site at http://microolap.com/my/keys/ to obtain your key if you have a license. Please don't hesitate to ask any qu

ANN: Upscene releases Database Workbench 5.0.8

2015-01-21 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.8 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: " Database Workbench 5 " This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.

ANN: Database Workbench 5.0.6 released

2014-12-15 Thread Martijn Tonies (Upscene Productions)
ANN: Upscene releases Database Workbench 5.0.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: " Database Workbench 5 " Version 5.0.6 fixes an issue with the MySQL module and includes some changes for Firebird 3. The change log is

ANN: Database Designer for MySQL 2.1.3 released!

2014-10-28 Thread Aleksander Andreev
Reverse Engineering dialog as deprecated You're welcome to download the Database Designer for MySQL 2.1.3 right now at: http://microolap.com/products/database/mysql-designer/download/ Login to your private area on our site at http://microolap.com/my/keys/ to obtain your key if you have a license

ANN: Upscene releases Database Workbench 5.0.4

2014-10-16 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.4 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5 " Version 5.0.4 introduces some small new features and a list of fixes base on user feedback. The change log is available

Re: Importing a database as a data file directory

2014-10-05 Thread Reindl Harald
Am 05.10.2014 um 22:39 schrieb Jan Steinman: I've had good experiences moving MyISAM files that way, but bad experience moving INNODB files. I suspect the latter are more aggressively cached simply no, no and no again independent of "innodb_file_per_table = 1" there is *always* a global tabl

Re: Importing a database as a data file directory

2014-10-05 Thread Tim Johnson
* Reindl Harald [141005 13:12]: > > Am 05.10.2014 um 21:29 schrieb Tim Johnson: > >I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The > >ubuntu system has failed and I am unable to boot it. > > > >I have one database on the ubuntu partition that

Re: Importing a database as a data file directory

2014-10-05 Thread Tim Johnson
* Jan Steinman [141005 13:12]: > > So, this is a "Help me before I hurt myself" sort of question: Are > > there any caveats and gotchas to consider? > Do you know if the database was shut down properly? Or did Ubunto > crash and die and your partition become unboota

Re: Importing a database as a data file directory

2014-10-05 Thread Reindl Harald
Am 05.10.2014 um 21:29 schrieb Tim Johnson: I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The ubuntu system has failed and I am unable to boot it. I have one database on the ubuntu partition that was not backed up. I am able to mount the ubuntu partion with fuse-ext2 from

Re: Importing a database as a data file directory

2014-10-05 Thread Jan Steinman
> So, this is a "Help me before I hurt myself" sort of question: Are > there any caveats and gotchas to consider? Do you know if the database was shut down properly? Or did Ubunto crash and die and your partition become unbootable while the database was in active use? Either

Importing a database as a data file directory

2014-10-05 Thread Tim Johnson
I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The ubuntu system has failed and I am unable to boot it. I have one database on the ubuntu partition that was not backed up. I am able to mount the ubuntu partion with fuse-ext2 from Mac OS X, thus I can read and copy the mysql

ANN: Upscene releases Database Workbench 5.0.2

2014-09-18 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: " Database Workbench 5 " Version 5.0.2 fixed some issues that came to light after the initial major version 5 release. http://www.upscene.com/news/item/20140918 Version 5 adde

Re: database developer tool "Database Workbench 5" now available

2014-09-05 Thread shawn l.green
tion is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell scripts that will work under Windows cygwin MG>The Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MG>if I have to make changes to my.ini or etc

Re: database developer tool "Database Workbench 5" now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
min and mysql shell scripts that will work under Windows cygwin MG>The Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MG>if I have to make changes to my.ini or etc/init.d the readme should be specific on what those changes should be

RE: database developer tool "Database Workbench 5" now available

2014-09-05 Thread Martin Gainty
> From: m.ton...@upscene.com > To: j...@ecoreality.org; mysql@lists.mysql.com > Subject: Re: database developer tool "Database Workbench 5" now available > Date: Fri, 5 Sep 2014 07:57:37 +0200 > > Hello Jan, list, > > >> From: "Martijn Toni

Re: database developer tool "Database Workbench 5" now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
Hello Jan, list, From: "Martijn Tonies (Upscene Productions)" Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your annou

Re: ANN: database developer tool "Database Workbench 5" now available

2014-09-04 Thread Jan Steinman
> From: "Martijn Tonies (Upscene Productions)" > > Database Workbench now comes in multiple editions with different > pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your annou

ANN: database developer tool "Database Workbench 5" now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5 Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool: " Database Workbench 5 " There have been numerous improvements to existing tools and the new, more consistent user in

ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

2014-06-17 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.4.7 Pro " For more information, see http://www.upscene.

ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

2014-04-29 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.4.6 Pro " For more information, see http://www.upscene.com/g

Re: Calling function, that operates on another database

2014-04-08 Thread Larry Martell
On Tue, Apr 8, 2014 at 4:15 PM, bars0.bars0.bars0 wrote: > Hi all. > > I have standard select statement and on one column I want to run function, > that will connect to another database (same server). > Is this possible? > > High level example: > > SELECT db1.clients

RE: Calling function, that operates on another database

2014-04-08 Thread David Lerer
Chris, take a look at Federated tables https://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html No, it is not as easy as Oracle's dblinks. David. David Lerer | Director, Database Administration | Interactive | 605 Third Avenue, 12th Floor, New York, NY 10158 Direct: (646) 487

Calling function, that operates on another database

2014-04-08 Thread bars0.bars0.bars0
Hi all. I have standard select statement and on one column I want to run function, that will connect to another database (same server). Is this possible? High level example: SELECT db1.clients.client_id, getTurnover(db1.clients.client_id) FROM db1.clients; AND getTurnover($id) body would

Re: Excluding MySQL database tables from mysqldump

2014-04-08 Thread Tim Johnson
* h...@tbbs.net [140407 23:09]: > >>>> 2014/04/07 08:02 -0800, Tim Johnson >>>> > 2)mysqldump forces all database names to lower case in the "CREATE > DATABASE" statement. I know, one shouldn't use upper case in > database names, but :) t

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread hsv
>>>> 2014/04/07 08:02 -0800, Tim Johnson >>>> 2)mysqldump forces all database names to lower case in the "CREATE DATABASE" statement. I know, one shouldn't use upper case in database names, but :) tell that to my clients. <<<<<<&l

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread Tim Johnson
mysql on > >>it. I have already set up a mysql user on the ubuntu OS. > >> > >>In the past I have used mysqldump with just the --all-databases > >>option to transfer data across different linux partitions. > >> > >>I'm wondering if I

Re: database not listed

2014-04-07 Thread shawn l.green
Hello Nicu, On 4/6/2014 1:51 AM, Nicolae Marasoiu wrote: Hi, A directory in datadir does not show up as database. Please help! drwx-- 2 mysql root 24576 oct 9 00:34 *opendental* drwx-- 2 mysql mysql 4096 mar 22 19:54 performance_schema drwx-- 2 mysql root 4096 mar 22

Re: Excluding MySQL database tables from mysqldump

2014-04-07 Thread shawn l.green
ldump with just the --all-databases option to transfer data across different linux partitions. I'm wondering if I should explicitly exclude some of the tables from the mysql database. If so, which? perhaps mysql.user? thoughts? Opinions? thanks I should add the following: 1)the only

database not listed

2014-04-05 Thread Nicolae Marasoiu
Hi, A directory in datadir does not show up as database. Please help! drwx-- 2 mysql root 24576 oct 9 00:34 *opendental* drwx-- 2 mysql mysql 4096 mar 22 19:54 performance_schema drwx-- 2 mysql root 4096 mar 22 19:53 test mysql> show databases -&

Re: Excluding MySQL database tables from mysqldump

2014-04-04 Thread Tim Johnson
l-databases > option to transfer data across different linux partitions. > > I'm wondering if I should explicitly exclude some of the tables from > the mysql database. If so, which? perhaps mysql.user? > > thoughts? Opinions? > thanks I should add the following: 1)the

Excluding MySQL database tables from mysqldump

2014-04-04 Thread Tim Johnson
linux partitions. I'm wondering if I should explicitly exclude some of the tables from the mysql database. If so, which? perhaps mysql.user? thoughts? Opinions? thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com, http://www.tj49.com -- MySQL General Ma

Re: Database migration from default configuration to innodb_file_per_table

2014-03-26 Thread Christophe
Hi, Data migration made last night. Use of a new MySQL instance has been quite useful to operate, the outage was about 7 minutes. ibdata1 is now using 58 MiB of disk space ! each table having a proper .ibd file and full data directory from 13GiB to 3.2GiB ... Server load divided by 3 ~ 4 ;). I

Re: Locking a Database (not tables) x

2014-03-23 Thread Peter Brawley
On 2014-03-23 8:02 PM, David Lerer wrote: Thanks Shawn, This may work for us with some script changes. We'll take a look. By the way, too bad we cannot rename a database, or can we? See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal of a "dangerous RENMA

RE: Locking a Database (not tables) x

2014-03-23 Thread David Lerer
Thanks Shawn, This may work for us with some script changes. We'll take a look. By the way, too bad we cannot rename a database, or can we? See http://dev.mysql.com/doc/refman/5.1/en/rename-database.html about removal of a "dangerous RENMAE DATABASE" statement... David. David L

Re: Database migration from default configuration to innodb_file_per_table

2014-03-23 Thread Christophe
Hi Shawn, and thanks for this concise anwser ;) . Le 22/03/2014 05:35, shawn l.green a écrit : > > The system is operating exactly as designed. The ibdata* file(s) contain > more than just your data and indexes. This is the common tablespace and > it contains all the metadata necessary to identify

Re: Locking a Database (not tables) x

2014-03-22 Thread Karr Abgarian
into one of our QA instances that contains many more databases. >> (i.e. "database" being a "schema" or a "catalogue). >> At the beginning of the import script, we first drop all objects in the QA >> database so that it will be a perfect match (object wise)

Re: Locking a Database (not tables) x

2014-03-22 Thread Manuel Arostegui
2014-03-21 18:42 GMT+01:00 David Lerer : > Frequently, we import a production dump that contains only 1 or 2 > databases into one of our QA instances that contains many more databases. > (i.e. "database" being a "schema" or a "catalogue). > At the beginning of

Re: Database migration from default configuration to innodb_file_per_table

2014-03-21 Thread shawn l.green
Hello Christophe, On 3/21/2014 4:47 PM, Christophe wrote: Hi list, I'd like your advice, (one more time ;) ) about this case : The context is : A huge database using InnoDB engine from filling about several years (without possible shrinking, as I've seen, except dropping all da

Database migration from default configuration to innodb_file_per_table

2014-03-21 Thread Christophe
Hi list, I'd like your advice, (one more time ;) ) about this case : The context is : A huge database using InnoDB engine from filling about several years (without possible shrinking, as I've seen, except dropping all databases to recreate them ... ) the ibdata file , which is taking

Re: Locking a Database (not tables) x

2014-03-21 Thread shawn l.green
Hi David. On 3/21/2014 1:42 PM, David Lerer wrote: Frequently, we import a production dump that contains only 1 or 2 databases into one of our QA instances that contains many more databases. (i.e. "database" being a "schema" or a "catalogue). At the beginning of th

RE: Locking a Database (not tables) x

2014-03-21 Thread David Lerer
Thanks Wayne. This a great idea to prevent user activity on the server. I’ll use it in the future. But I’m looking for a way to prevent user activity on a database ((i.e. "database" being a "schema" or a "catalogue). David. David Lerer | Director, Database Admin

Locking a Database (not tables)

2014-03-21 Thread David Lerer
Frequently, we import a production dump that contains only 1 or 2 databases into one of our QA instances that contains many more databases. (i.e. "database" being a "schema" or a "catalogue). At the beginning of the import script, we first drop all objects in the QA da

Locking a Database (not tables) x

2014-03-21 Thread David Lerer
Frequently, we import a production dump that contains only 1 or 2 databases into one of our QA instances that contains many more databases. (i.e. "database" being a "schema" or a "catalogue). At the beginning of the import script, we first drop all objects in the QA da

ANN: Database Workbench 4.4.5, special MySQL discount!

2014-03-19 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.5, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.4.5 Pro " March only: 25% discount on "Database Wo

Database/kernel community topic at Collaboration Summit 2014

2014-03-10 Thread Mel Gorman
Hi, Arrangements have been made to hold a meeting between database and kernel developers at Collaboration Summit 2014 http://sched.co/1hEBRuq on March 27th 2014. This was organised after discussions on pain points encountered by the PostgreSQL community. Originally the plan had been to just have

ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

2014-01-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.4.4 Pro " For more information, see http://www.upscene.

Re: ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Aleksander Andreev
Hi Jan! We are very sorry that we misled you. However, our Database Designer for MySQL works well under WineHQ. Best regards, On Thu, Jan 23, 2014 at 11:35 PM, Jan Steinman wrote: > Can you please add to your announcements that this product is Windows-only? > > It took some searchin

Re: ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Jan Steinman
Can you please add to your announcements that this product is Windows-only? It took some searching on your website to come up with that info, and I dare say the majority of MySQL users here are non-Windows-based. Thank you! (Now I have to go find and delete that download...) A low-energy

ANN: MicroOLAP Database Designer for MySQL 2.1.2 is available!

2014-01-23 Thread Aleksander Andreev
bug fixed [-] "Cannot merge model with views or stored routines" bug fixed [-] "Unable to find a Table of Contents when invoking help system" bug fixed You're welcome to download the Database Designer for MySQL 2.1.2 right now at: http://microolap.com/products/database/mysql-design

ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

2013-11-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: " Database Workbench 4.4.3 Pro " This release fixes a blocking problem after a rece

Re: How do I mysqldump different database tables to the same .sql file?

2013-11-22 Thread Johan De Meersman
--databases, methinks. - Original Message - > From: "Daevid Vincent" > To: mysql@lists.mysql.com > Sent: Thursday, 21 November, 2013 10:44:39 PM > Subject: How do I mysqldump different database tables to the same .sql file? > > I'm working on some co

RE: How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Daevid Vincent
Except that it outputs the "USE" statement if you have more than one database, so your theory doesn't hold a lot of water IMHO. Not to mention it's near the very top of the output so it's pretty easy to trim it off if you REALLY needed to move the DB (which I presume is no

  1   2   3   4   5   6   7   8   9   10   >