ANN: PHP Generator for MySQL 16.3 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 16.3, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com

ANN: PHP Generator for MySQL 15.12 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com

ANN: SQL Maestro for MySQL 15.5 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 15.5, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

ANN: Data Sync for MySQL 15.3 released

Hi! SQL Maestro Group announces the release of Data Sync for MySQL 15.3, a powerful and easy-to-use tool for MySQL database contents comparison and synchronization. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/datasync/ Top 5 new features

ANN: PHP Generator for MySQL 14.10 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 14.10, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com

ANN: SQL Maestro for MySQL 14.2 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 14.2, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

ANN: Data Wizard for MySQL 13.12 released

Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 13.12, a powerful Windows GUI solution for MySQL data management. The new version is immediately available at http://www.sqlmaestro.com/products/mysql/datawizard/ Data Wizard for MySQL provides you with a number of easy-to-use

ANN: Code Factory for MySQL 13.9 released

Hi! SQL Maestro Group announces the release of Code Factory for MySQL 13.9, a powerful Windows GUI solution for querying MySQL databases and managing the data. http://www.sqlmaestro.com/products/mysql/codefactory/ Please note that before Oct 13 you can purchase all our products and bundles with

Re: ANN: PHP Generator for MySQL 12.8 released

Hi! It is not correct. System requirements are published on the website: http://www.sqlmaestro.com/products/mysql/phpgenerator/help/00_04_00_system_requirements/ Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - Original Message - From: "Jan Steinman"

ANN: PHP Generator for MySQL 12.8 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 12.8, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP

ANN: Data Wizard for MySQL 12.6 released

Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 12.6, a powerful Windows GUI solution for MySQL data management. The new version is immediately available at http://www.sqlmaestro.com/products/mysql/datawizard/ Data Wizard for MySQL provides you with a number of easy-to-use

ANN: AnySQL Maestro 12.5 released

Hi! SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQLite, PostgreSQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com

ANN: SQL Maestro for MySQL 12.3 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 12.3, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Please note that before April

ANN: Code Factory for MySQL 12.3 released

Hi! SQL Maestro Group announces the release of Code Factory for MySQL 12.3, a powerful Windows GUI solution aimed at the MySQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/codefactory/ Please also note that

Re: Converting Microsoft SQL database to MySQL

I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. The Data Wizard for MySQL software by SQL Maestro Group includes a powerful Data Pump tool that can transfer schema and data from any DBMS to MySQL: http://www.sqlmaestro.com

ANN: PHP Generator for MySQL 11.12 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.12, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP

ANN: Data Sync for MySQL released

Hi! SQL Maestro Group starts a new product family and announces the release of Data Sync for MySQL, a powerful and easy-to-use tool for MySQL database contents comparison and synchronization. http://www.sqlmaestro.com/products/mysql/datasync/ Key product features: 1

ANN: AnySQL Maestro 11.7 released

Hi! SQL Maestro Group announces the release of AnySQL Maestro 11.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQLite, PostgreSQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com

ANN: SQL Maestro for MySQL 11.6 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 11.6, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Please note that before June

Re: PHP Generator for MySQL 11.4 released

Yes, there is a freeware version. http://www.sqlmaestro.com/products/mysql/phpgenerator/feature_matrix/ - Original Message - From: "Sharl.Jimh.Tsin" To: "SQL Maestro Team" Cc: Sent: Wednesday, April 27, 2011 7:33 AM Subject: Re: PHP Generator for MySQL 11.4 re

PHP Generator for MySQL 11.4 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.4, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP

Data Wizard for MySQL 11.1 released

Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 11.1, a powerful Windows GUI solution for MySQL data management. The new version is immediately available at http://www.sqlmaestro.com/products/mysql/datawizard/ Data Wizard for MySQL provides you with a number of easy-to-use

ANN: PHP Generator for MySQL 10.8 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 10.8, a GUI frontend that allows you to generate high-quality PHP scripts for the selected MySQL tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/mysql

Re: from excel to the mySQL

Hi! Data Wizard for MySQL allows you to import data from Excel (as well as from CSV, DBF, XML and text files) in a few mouse clicks. The app also provides a flexible task scheduler. http://www.sqlmaestro.com/products/mysql/datawizard/ - Original Message - From: "HaidarPesebe" To: "MySQL

ANN: AnySQL Maestro 10.7 released

Hi! SQL Maestro Group announces the release of AnySQL Maestro 10.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql

ANN: SQL Maestro for MySQL 10.5 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 10.5, a Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ New features

ANN: PHP Generator for MySQL 10.3 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 10.3, a GUI frontend that allows you to generate high-quality PHP scripts for the selected MySQL tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/mysql

ANN: Code Factory for MySQL 10.2 released

Hi! SQL Maestro Group announces the release of Code Factory for MySQL 10.2, a powerful Windows GUI solution aimed at the SQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/codefactory/download/ Please note that

ANN: PHP Generator for MySQL 9.12 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 9.12, a GUI frontend that allows you to generate high-quality PHP scripts for the selected MySQL tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/mysql

ANN: Data Wizard for MySQL 9.12 released

Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 9.12, a powerful Windows GUI solution for MySQL data management. Data Wizard for MySQL provides you with a number of easy-to-use wizards to convert any ADO-compatible database to the MySQL database, import data into MySQL

Re: MySQL GUI Tools

> What are the best MySQL GUI tools available at the moment, for example > SQLyog. You could start with our AnySQL Maestro (free version available). http://www.sqlmaestro.com/products/anysql/maestro/ Sincerely yours, SQL Maestro Group Team http://www.sqlmaestro.com -- MySQL General M

ANN: SQL Maestro for MySQL 9.9 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 9.9, a Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ New features: --- 1

INSERT ... SELECT ON DUPLICATE

Does anyone know if I can add a hint SQL_BUFFER_RESULT to INSERT .. SELECT ON DUPLICATE ex.. INSERT INTO foo SELECT SQL_BUFFER_RESULT* FROM bar ON DUPLICATE KEY UPDATE foo.X=.. Both my tables foo and bar are InnoDB; but the idea is to release the lock on bar as soon as possible by moving the r

ANN: AnySQL Maestro 9.8 released

Hi! SQL Maestro Group announces the release of AnySQL Maestro 9.8, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql

iostats per mysql process

Does anyone has any suggestions on how to get IO stats used by per process (mysqld) on Linux 2.6.18-53 kernel ... I just need to see  how much reads and writes mysql is actually doing and what else is causing the IO load..

percona builds

Does anybody know how percona builds the server .. what configure options.. I never able to match the mysqld binary size ... so, wondering whats wrong..

RAID-10 perf numbers

Does anybody have any RAID-10 sysbench fileio numbers for random writes with any number of disks(4/6/8/12...) to compare with write cache(512,256,...) backed by BBU.. I really appreciate your nos.. or whats the decent requests/sec for pure rndwrs ?

Re: MySQL Log and Data directories

Thanks Baron... Also, curious question.. as you might have used what is called GOOD hw configurarion with RAID 5/10 .. so whats the typical IO (rnd rw) that you archive/expect on high trafficked sites ? --- On Wed, 3/4/09, Baron Schwartz wrote: From: Baron Schwartz Subject: Re: MySQL Log and

Re: MySQL Log and Data directories

Lets say HP Modular Storage/Smart Array.. http://h18006.www1.hp.com/storage/disk_storage/msa_diskarrays/san_arrays/index.html From: Chaim Rieger Subject: Re: MySQL Log and Data directories To: "Michael Dykman" Cc: dbrb2002-...@yahoo.com, mysql@lists.mysql.com Date: Wednesday, March 4, 2009, 10:

MySQL Log and Data directories

On a high read/write load.. is it good to split log (binlogs, innodb txn logs) and data (all tables, innodb tablespace) in different partitions ? Anybody had any experience ? For example; out of 25 disks array with 142GB 1rpm... I would like to keep few disks to logs and rest to data .. is

Re: MySQL Closing/Opening tables

Thanks Dan.. thats a valuable point.. and this actually happening with MyISAM tables only.. But the question is; when I set the table_cache to higher than total tables.. then it should stop closing the table in first place..so that only un-opened tables will be opened and kept in cache.. it wil

Re: MySQL Closing/Opening tables

Thanks for the quick followup Baron.. vmstat procs ---memory-- ---swap-- -io --system-- -cpu-- r b swpd free buff cache si sobibo in cs us sy id wa st 3 0100 499380 139256 560400000 190 693 11 11 20 2 70 8 0 iosta

MySQL Closing/Opening tables

Hi Recently I noticed the server takes lot of time on and off when opening and closing tables. And I tried to increase the table_cache more the the total tables (file_limit is properly set); and the problem still continues and lowering it also continues.. and tried to set in middle.. same Any

ANN: SQL Maestro for MySQL 9.2 released

Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 9.2, a Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ New features: 1. Starting with this

WHY do I see this error when restoring my backup db : InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files.

WHY do I see this error when restoring my backup db : " InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. " GOAL: Trying to restore mysql backup on different host using InnoDB backup that copes the backed up files to a files sever where

ANN: SQL Maestro for MySQL 8.10 released

Hi! SQL Maestro Group announce the release of SQL Maestro for MySQL 8.10, a complete Windows GUI solution for MySQL server administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/ New features: = 1. An ability of using the LOAD DATA INFILE command

ANN: Data Wizard for MySQL 8.4 released

Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 8.4, a powerful Windows GUI solution for MySQL data management. Data Wizard for MySQL provides you with a number of easy-to-use wizards to generate PHP and ASP.NET scripts for the selected tables, views and queries

ANN: AnySQL Maestro released (freeware cross-database tool)

Hi! SQL Maestro Group announces the release of AnySQL Maestro - a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, SQLite, etc). http://www.sqlmaestro.com/products/anysql/maestro

ANN: Freeware PHP Generator for MySQL 7.10 released

Hi! SQL Maestro Group announce the release of PHP Generator for MySQL 7.10, freeware MySQL GUI frontend that allows you to generate high-quality MySQL PHP scripts for the selected tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com

ANN: SQL Maestro for MySQL 7.8 released

Hi! SQL Maestro Group announce the release of SQL Maestro for MySQL 7.8, a complete Windows GUI solution for MySQL administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/ New features: 1. SQL Maestro for MySQL is optimized to work with MySQL servers with

ANN: SQL Maestro 6.12 released

Hi! SQL Maestro Group is happy to announce a new version of our powerful GUI solution for MySQL server administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/download/ Also we're happy to grant you a time-limited 25% discount on all our products and bu

ANN: SQL Maestro 6.10 released

Hi! SQL Maestro Group is happy to announce a new version of our powerful GUI solution for MySQL server administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/download/ New version features: 1. Support of events and table partitions (MySQL 5.1). 2. The new

How to write SQL statement to do such query?

Hi! dear all, (BI encountered a problem with designing SQL statement. For example, I (Bwant to query population information from a "city" table, and the (Brecords returned must be ordered according to the population of the (Bcity. Like

Resetting the password error

While trying to login to the server I got the following errors: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>c:\mysql\bin\mysql -root -p Enter password: * ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) C:\>c:\mysql\bin\m

Clean Reinstall

I am extremely frustrated with the root passwordproblem. I read the manual and followed the instructions but it just won't work. I tried setting a newpassword but then when I insert the new passoword it says the password it wrong. In any case...I want to uninstall MySQL and try a new clean inst

problems setting up the anonymous and root passwords

Hi, I have just finished installing MySQL, Apache and PHP on a Windows platform and have tested my Apache and PHP installations without problems. My issue now is that when I log in using just -u root I can get through but I just can't seem to be able to set a password. It keeps giving me an error

[ANN] SQL Service Center 1.2 released

Hello, SQL Maestro Group is happy to announce the release of SQL Service Center 1.2, a Windows GUI tool for MySQL server maintenance and data reservation. The trial version of the software is available at http://www.sqlmaestro.com/products/myservice/download.html. In this version we have

[ANN] SQL Data Wizard 1.3 released

Hello, SQL Maestro Group is happy to announce the release of SQL Data Wizard 1.3 - a powerful Windows GUI utility for MySQL data export, import, database conversion and PHP script generation. The trial version of the software is available at http://www.sqlmaestro.com/products/mywizard

[ANN] SQL Maestro 1.5 released

Hello, We are happy to announce the release of SQL Maestro 1.5. The trial version of the software is always available at http://www.sqlmaestro.com/products/download.html. In this version we have implemented a possibility to connect to a remote MySQL server using a secure protocol. The secure

[ANN] SQL Maestro 1.4 released

Hello, SQL Maestro Group is happy to introduce a new release of SQL Maestro - a powerful Win32 GUI solution for MySQL server administration and database development. A fully functional trial version of SQL Maestro is available at http://www.sqlmaestro.com/products/download.html. SQL Maestro

Html and mysql..

Hi all, I have got one serious doubt. Can we access mysql database from the front end html. If it all it is possible, we have to right in javascript. ofcourse we can write it using JDBC(provided we have a servlet engine integrated with a webserver). My question is can we access mysql database f

www.SQL-Scripts.com web site

Hello, Teh other day I posted an annoncement about my new web site www.SQL-Scripts.Com . It is a place were you can find SQL scripts for database system. You can even lodge your own scripts and help someone out there. I have started a monthly contest on the site now. The first people to lodge

SQL Scripts web site

database scripts on the internet, we hope that you will all visit this site. We are also on the look out for any and all scripts for MySQL. Having a quick search on the Internet I could find many scripts at all, compared to Oracle or MS SQL Server. If you have any general use script (things like list

Re: Load data infile

"Works" "Record 3","some 'data'","Works" "Record 4",""some" "data","Works" "Record 5",""some"data"","Fails" "Record 6","some"data",&q

Load data infile

Hi I'm working on importing csv datafile returns Warnings, after carefully checking data I noticed that there are double quotes (") inside the records. mysql> LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata FIELDS TERMINATED BY ',' ENCLOSED BY '

PHP Warning

On a new install of Suse 7.2 I get this message when attempting to acces MySQL through a php scrpipt in apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6): Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/apache_1.3.20/htdocs/dbtest.php on line 1

could not insert BLOB data types in table

Hi all, I could not insert BLOB data types in a table. I want that the INSERT statement should insert a picture in a field of a table. Like, INSERT INTO testtable (id, picture) values (1,picref) Here I want to know what should be the picref I know picref is a variable in a programming la