MySQL Open Source And Enterprise
what is the main difference of the two... enterprise and open source
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL Open Source Application Components/plug-ins/add-ons
Perhaps someone might be able to tell me if there is a place to find MySQL opensource community application components/add-ons/plug-ins/contributions (whatever one might call them) which developers can reuse and modify to deliver MySQL applications faster? eg. something like a community download repository, or something to that effect. Would likely contain database definitions, queries, performance analysis tools, etc. Many open source products have this, I'm sure MySQL must, just feel silly that I can't find it.
View Replies !
Open Source Question
We are in the process of designing and building an application to collect a relatively small amount of discrete data (less than 100 data elements) from a potentially large group of industrial facilities. This system needs to be Open Source so other organizations can use the application by simply "plugging" in the app to do authentication/authorization (Open LDAP?) with a home-grown security design, access a web app (J2EE & probably Linux O/S), and MySQL as the backend. Certainly it's more complicated than what I describe, but I have my doubts of the capabilities of MySQL to be "robust" (yuk, I hate that word) enough to handle the potentially large number of simultaneous connections, among other issue including remote connection to Oracle DBs. I'm new to the organization and my boss's boss is the driving force behind the development. He's gung ho to get it built, but (beyond the political nightmare) I would like to "caution" him that the chosen platform is suspiscious at best.
View Replies !
Open Source English Dictionary Database
I'm looking for an open source database of English words. I don't even care if it has the definitions or not. I'm working on a password security project, and the client wants to prevent users from creating passwords containing real English words.
View Replies !
Open-source/free DB Modeling Tool
I'm looking for a decent DB modeling/designing tool that is free and supports the following features: 1. Visual design of tables/relationships 2. Syncronization to database 3. Query mode 4. Ability to sync with different database types I've been using DBDesigner, but it has a few bugs that are really annoying.
View Replies !
Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local. 1. I have installed MYSQL Server to my localhost [Windows]. MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt. 2. I have installed the MYSQL Network Monitor to my local system [Windows] With all options like admin login, agent and other details. But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor. I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor. We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
View Replies !
MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like. The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead. I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims. By no means do I want to get into 'down with Microsoft' thread here. Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us. What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job. Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days. So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery. How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to install the binaries recommended on MySQL. However, when I run the mysql client, I get simply: Segmentation fault. So I tried to do a basic source compile, which went fine, but when I run mysql client, I get this: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 4.1.12 Segmentation fault When I try the flags recommended by MySQL (--with-extra-charsets=complex among others), the make test fails on ucs_binlog - something to do with charsets I believe? The mysql user, group etc. are all set up. Strangely, the mysql client works in batch mode so if you make a file that reads: SHOW DATABASES; Then type: mysql < commandfile It'll display Database mysql test Without any faults.... Anyone any ideas or suggestions?
View Replies !
MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant". Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service. Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?
View Replies !
Compile MySql Source
What do I need to compile MySql source? I want to create MySql with SSL, and AFAIK i need to compile it. Do I need MS Visual C++ or something like that ( I work in Delphi )?
View Replies !
Compiled Mysql From Source
I'm trying to install the DBD::mysql perl module, which, apparently, needs the mysql-devel stuff. If I compiled mysql from source, can I install the devel RPM without it messing up my settings? I have mysql in a non-standard directory.
View Replies !
Mysql SOURCE Command
i am new to mysql.i have a file full of sql statements like insert into mysql1.table1 values(4343); . . . now i want to run these statements and create my mysql table with data in it. i was told to use a SOURCE command but iam having problems from the mysql prompt i tried mysql> source test.sql ( this is the file that has all the sql statements) and i got "file could not be located" error: 2 my questions: how can i syntactically specify the location of my file ? will the SOURCE command serve my purporse?
View Replies !
Pipe An Sql Source File In MySQL
Question: How can the command "source:data.sql" work. It says file cannot be found? This is after I saved the files in E:Mysqldata Background -------------- I have just set up MySQL,PHP and Apache. Since I can now manipulate data, both from command and using HTML.
View Replies !
Can't Decide On MySQL Source Compile Or RPM
In about a week I need to install my new website which I have been working on for about 3 months. The website will run on a multiple of servers, but one of the primary servers will run as a MySQL database only server. In the past I have installed the MySQL server from yum (an update manager). I have been looking at ways to improve performance on my database server and one option was to install the server from source. By using the correct compile flags and only compiling the extensions into MySQL that you need the result can be rewarding. But is it really? The problems that I see with a source install is that updating it will take longer (since the database has to be compiled each time). This may get to be annoying each time a bug is found. Also I am kinda paranoid of some compile related errors. What should I do? Just stick to installing from an update manager? Or should I install from source and take full control of my server.
View Replies !
Linking HTML To A Mysql Data Source
I have a question and perhaps one of the bright sparks here can guide our thoughts. 1. We have a mysql based application that we use in our daily business operations. Capture information and then it drags it through to the web (php pages) we have started a linking programme with other sites, but its a banner at the mo that simply links back to the main site. I would like that banner to be dynamic - i.e. change as the content (info feed) on our site changes) problem is HTML does not speak to mysql (so I am told). I have seen simmilar feeds using JSP (Java server pages) - obviously with the HTML only calling the JSP page. which has the dynamic content. Any suggestions as to how to tacle this problem? We do have a great programmer on the team, but this is new to him.
View Replies !
Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP. I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects Does anyone know a tool like the one I just described in my dream
View Replies !
MySQL Database - Adding New Data Source 'Access Denied For User'
I am trying to install MySQL on my machine at the moment. I have downloaded the file mysql-essential-5.0.21-win32 from the MySQL website and installed it. I then downloaded MySQL Control Center, which came zipped in a folder called mysqlcc-0.9.2-win32. I have installed both applications and I have a MySQL database which I have acquired from elsewhere. I copy/pasted it into my C:Program FilesMySQLMySQL Server 5.0data directory, but when I try to add a new database in MySQL CC it doesnt allow me. I have also installed the ODBC for MySQL (called mysql-connector-odbc-3.51.12-win32). However, when I try to add a new data source in the Control Panel I get this error: [MySQL][ODBC 3.51 Driver]Access denied for user 'versiontwo'@'localhost' (using password: YES) versiontwo is the name of the database. the database has a password.
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
Open MySQL Files
Is there a danger limit to how many often used files (tables) mysql can have open. I currently run mysql and it has about 3000 tables total, thats 9000 open files in total if you cound 3 files for each table.
View Replies !
Mysql On Open SUSE 10.2
I installed open SUSE 10.2 and it works fine. I tried to look at Mysql. No it didn't work. --------------------------------------------------- niss@linux-flei:~> mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) niss@linux-flei:~> show databases; bash: show: command not found niss@linux-flei:~>
View Replies !
How Do You Open Mysql To Outside Connections?
I have a DB server and an APP server. I am trying to open MySQL on the DB server so the APP server can connect to it. I did the command: GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PW' WITH GRANT OPTION; However, it still won't connect.
View Replies !
Can't Open Mysql Table
I can no longer open one of my tables. I get this error: Can't open file: 'top_horses.MYD'. (errno: 144) When I view all my tables, this particular tables says "in use". I think I inadvertently clicked on "repair" table.
View Replies !
Mysql.exe Will Not Stay Open
I'm trying to install MySQL and PHP on my Windows XP computer. I have followed Kevin Yank's book, followed another tutorial, reinstalled Windows XP twice on this machine, installed MySQL and PHP many times (after uninstalling). I've tried installing on an other machine. "Dr. John" and "Mainlink" suggested that I "use xampplite to install apache, mysql, php etc" - I tried this, after a reinstalling Windows XP. All works well, including the PHP test ("today.php"), till I try to open "mysql.exe". The "command prompt/dos" window flashes up, then disappears immediately. Can anyone please point me in the right direction?
View Replies !
Window With The Mysql> Stay Open
I have installed PHP MySQL and Apache on my system with the intention of using it to run my website with a database. I have managed to get PHP and Apache working fine but to date have not been able to get MySQL to work. When entering a command in the Windows XP prompt I get a window flash on the screen for a second and then it is lost. How do I get this window with the mysql> prompt to stay open on the screen. Look forward to help with this as I am now contemplating abandoning the whole setup and reverting to using the Windows IIS instead.
View Replies !
Can't Open Pdf Link Created In PHP/MySQL
I created a MySQL database with all the pdf papers on my HD. The path to a pdf file is stored e.g. D:DocsPapersBerg2003a.pdf In php I do the query and output the link: echo "<a href='file://" $row->pdf ."'>pdf</a>"; But when the page is generated and I click on it nothing happens. If I do right click, copy link and paste it in the browser field, the pdf file opens though! Looking at the html code, it reads in Firefox: <a href="file://D:%5CDocs%5CPapers%5Cwind03%5Cpdfs%5Berg2003a.pdf">pdf</a> and in IE6 <a href='file://D:DocsPaperswind03pdfsBerg2003a.pdf'>pdf</a> I have also tried .str_replace('','/',$row->pdf) but with the same result.
View Replies !
How To Open Exisiting Files In Mysql
I am learning mysql. I have installed and try to practice some of the commands in the manual. I have many files (very big in size) which I am trying to open as tables in mysql and manipulate the data (for example, I want to open multiple files and merge then based on dates (as a primary key) (bring all fields which have the same time stamp ... for example. We have thousands of files for which I want to create database.
View Replies !
Cannot Open MySQL Manual (Downloaded Version)
I have just download the complete MySQL package for Windows (I am running on XP Professional), and I am unable to open the user documentation included with the package. It seemed to have installed ok, but when I click on the application I get this message: Cannot open the file: mk:@MSITStore:C:Program FilesMySQLMySQL Server 4.1Docsmanual.chm
View Replies !
Open Email Client From Mysql And Php Database Without Using Mailto:
I've made a mysql database with php front end which, in part, contains mailing lists. I've used a mailto: link to create a new email with their names in the bcc: field. Unfortunatley their is a limit on the size of a mailto: field that outlook can accept, and so it can't be used to mail more than about 80 people at a time. Our lists go up to 200. Can anyone suggest a workaround that will enable people to follow a link to a new email populated with addresses? PS I would like to keep the whole interface web-based PPS DO I sound like a spammer?!!
View Replies !
C# Console (exe) Application Crashes On Open Command (MySql)
I have problem opening an MySql connection from an win console application. I am using SharpDevelop as IDE. Previously I've been working with MySql through C# aspx and am new to writing exe programs in C#, so I assume that I might be missing something in the IDE / project configuration. I am successfully opening a connection and reading data from the table using adapter (window panel application binding to a grid), but when trying the code below in an console application the program crashes when calling the MyConn.Open(); function. The error message being: Exception MySql.Data.MySqlClient.MySqlException was thrown in debuggee: Unable to connect to any of the specified MySQL hosts. Open() If I break before the MyConn.Open(); function is called, the MyConn variable is filled with lot's of info looking ok to me, though I am not capable of knowing if any of it can tell me what leads to the crash in the next function call. Ive added the MySql.Data.dll to the project from the GAC list in the add reference panel. Further, in addition to the references, I only have an AssemblyInfo.cs file and the Main.cs file with the code below in the project I've reinstalled the MySql database trying different configurations etc, but whatever I have tried does not work. Has anybody else encountered this problem and or know the solution?
View Replies !
Failed To Open Stream Errors (using Php Script With MySQL)
I keep getting these errors: Warning: main(../../_scripts/PromoCodeScript/includes/config.php): failed to open stream: No such file or directory I'm trying to install a new script. I am hosted with GoDaddy on a Linux OS. An install.php script is to install the whole thing and then I should be able to access an admin area to use it. But that's just not working. The install.php does go through the installation, creates the config file and tells me the Installation went okay. As soon as I head over to the admin area, I get messages like the one above or more specifically like this: Warning: main(../../_scripts/PromoCodeScript/includes/config.php): failed to open stream: No such file or directory in /home/content/r/o/b/robtoth27/html/DearEmployee/admin/index.php on line 4 But the errors reference lines 4, 5, 6 and 28. Line 4 of the .php file (when I open it in Dreamweaver) is: include ("../includes/config.php"); Line 5 is... mysql_connect($db_host,$db_user,$db_pass); Line 6 is... mysql_select_db($db_name); Line 28 is... include("./includes/inc_index.php"); Is the above information of any use? Does anyone have even a suspesion of what the error could be?......
View Replies !
Source For SQL
Is there a freely available source for a table populated with auto makes and models by year? (Circa 1970 to present) Such a table would be useful for databases used by car dealers, auto parts stores, repair shops, etc.
View Replies !
Source Duplicate
I created a database from a CSV file. Later, I recieve an updated CSV file. The second file contains most of the data from the first file, however some records have been removed and some have been added. Resourcing the database from the new CSV file is not an option because the unique key id column is shared with other tables. So my dilema is, how can I source in the new CSV file and exclude any rows that already exist? Also, how can I identify rows that no longer exist? I have made a php script that fscanfs my CSV file then runs a seperate query for each row to see if each seperate record is there or not and generates a new sql script for removing and adding records. But, that means 1 query on the database per record, I have around 200,000 records. So this method is not worthwhile, I gave up after an hour of waiting on it. I also tried using diff, but every time a new record is present it throws off the list and then im removing and adding records back and forth.
View Replies !
SQL Source For A View
How do you obtain the SQL source that created a View? I can Describe the view, but that doesn't give me the SQL that created it. . . . I should have searched the forums a little longer. The answer lies in the SHOW CREATE VIEW viewName statement.
View Replies !
Source Command?
I have a users.sql file that I want to import into mysql. When I tried this source F:gusers.sql It gives me an error like this: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n ear 'source F:' at line 1 ERROR 1102 (42000): Incorrect database name 'sers.sql' but if I copy this file into F:data and use the command source F:datausers.sql it worked fine.
View Replies !
Source Command
I am developing a local language website using XAMPP on Windows. I am using MySQL for the database, and I need a small help. I have to rebuild the database a number of times. The database is pretty huge, and its (I guess) in UTF. When I use the source command in the command line to rebuild from the dump, the build completes successfully, but the contents of the tables are all look like As. However, when I use phpmyadmin to import the dump, everything works fine. Does anyone know what exactly is the command used by the import from SQL feature of phpmyadmin? Is there any way by which I can get the same effect from the MySQL console (which is much faster)?
View Replies !
Using Source Command
I'm using mysql 5.0 on a WinXP system. I thought I could use the source command from the mysql> prompt to read text files containing sql statements to do things like create tables, but no matter what way I type my file name the source command says it can't open the file. ERROR: Failed to open file'"foo.txt"', error: 22 I've tried quotes, no-quotes, full path, 's, /'s.
View Replies !
|
TRACKER
