Downloading The Open Source Version
Can't download the opensource version.
Anybody have this problem?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Downloading Mysql
I'm trying to download MySql onto my computer which is a Mac 0S 10.3 (Panther) G4 I have been trying to download the installer package standard version from http://www.mysql.com/downloads/mysql-4.0.html. From what I understand I'm suppose to download and unpack the mysql version.pkg.tar.gz file to obtain the mysql version.pkg.tar.gz installation file and then double click to install mysql. Well the problem is that I have done that but I cant find the mysql version.pkg.tar.gz file to un pack. I have done this twice but arent having any luck.
View Replies !
View Related
Rolling Back A DB From Version 5 To Version 4
I've got a local MySQL DB with my MediaWiki data that was created in version 5.0.17, but I recently discovered that my webhost is running version 4.0.27, and when I tried to import the database as-is, I received an error. I'm looking for suggestions as to how I could roll my database back to the older version of MySQL, in case my webhost decides not to let me upgrade. I've considered using an intermediary, such as converting to MDB or CSV, but so far I haven't had much luck with finding a tool to do so without spending a pile o' cash.
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Errors With Source File
The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is corrupt. Is there a mirror with a compiled windows xp compatible version somewhere?
View Replies !
View Related
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 !
View Related
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 !
View Related
Stored Procedures And Source
I'm trying to script a stored procedure using a .sql file. Having no problems writing the same thing from the command line but I need to have all sp's under source control. This is the syntax in the file I'm using: USE db_1; DROP PROCEDURE IF EXISTS test; CREATE PROCEDURE test() BEGIN SELECT * FROM note; END
View Replies !
View Related
Wrapping Database Source
Is there a wrap putility available for MySQL to wrap or obfuscate database source code? The reason for this being if I place a database off-site people who have access to the DB cannot steal your source.
View Replies !
View Related
How To Connect To An ODBC Source
I need help connecting mysql to an Oracle database. The Oracle database is set as an ODBC driver on my PC. I currently use MS access, connect via the ODBC connection and it runs great. I now want to connect to this ODBC connection using mysql, but I don't know how. Can anyone get me connected?
View Replies !
View Related
Running MySQL's 'source' Command
I am having failures processing the following command and I wonder if you can tell me what I must do in order to have success. When I try to run source mysql_dump.sql.txt ==> it is a problem for me. 1) I put the file in /home/mlh/public_html/credifree/sql_script/. 2) I made that directory my current directory 3) I typed mysql and pressed ENTER 4) I then typed source mysql_dump.sql.txt and pressed ENTER A bunch of error messages saying ERROR 1046: No Database Selected filled up the screen. Well, of course there was no database selected. I do not yet have a database. I thought the whole point of running source mysql_dump.sql.txt was to CREATE a set of database files on my linux box. Is that incorrect? What must I do to avoid this error 1046? And now, the last question... Can you tell me where the database files will be placed when running source mysql_dump.sql.txt as I described above from the same current directory as described above? I do wish to KNOW in advance where the files will be created.
View Replies !
View Related
Creating .out Files When Using The Source /filename?
I cant get this work but Iv done it before and it was so simple. If I am loading a script like so at the mysql command prompt: source/scritps/copy.sql how do I get the results of the script copied into a .out file? This is the example in the ref manual but how to I actually put this into practice I cant get it to work shell> mysql < batch-file > mysql.out
View Replies !
View Related
Connect To Database From A Remote Source
I own a website and plan on running multiple message boards on it...the problem is that I would like a database per board...however my host only gives 1 database....unless I want to pay an extaordinary amount of money for more. So I have used my PC as a webserver before without any problems and in fact ran a pretty big board off it with php, mysql, phpmyadmin installed. So my thought was to use a couple of databases off my PC to help run the new boards. I have created the database...but I'm having trouble with the board connecting. I'm sure that it's some kind of permission that needs to be inserted for the remote host to connect to my databases.
View Replies !
View Related
Echo SQL Commands From A Source File
Running mySQL under Windows XP. Trying to debug a long input file of SQL statements (building tables and loading data from tab delimited text files) I want to be able to see the SQL commands that are executing in the output printed to the SQL command window so I know which error messages apply to which command. I have show warnings statements after each SQL statement at the moment so I see the errors/warnings, just not the command that generated the errors/warnings. Is there an ECHO command or a flag when calling the script to get commands echoed as they are executed?
View Replies !
View Related
Good Source Of Information Re Design
I was involved in software development back in the 1980's and I now want to design a system for use based on a database (probably MySQL). Can anyone suggest a good site to vist where the rudiments of querying the database are explained in an accessible manner? Basically, I want to understand what can be done and what cannot if I put a front end on to access the database.
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Lock Wait Timeout Exceeded How To Find The Source ?
I am running an application using Innodb. My application is based on transaction concepts. So sometimes I do get this error of "lock wait timeout exceeded" ? I know this is due to some deadlock. But how and where can I analyse to see what is the cause to my this locking problem and how can I overcome this ? Thanks.
View Replies !
View Related
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 !
View Related
Open Db
When I open Mysql, I see the command line, although I see no commands for opening a db. Likewise, I cannot find anything in the help file..... Double clicking on the file does nothing...
View Replies !
View Related
MAX OPEN CONNECTIONS
My site has available by default 15 connections to MYSQL. Many connections remain open for much time, so when a new user enter the page it shows a message UNABLE TO CONNECT TO DB. How do I avoid this, without need change the number of connections of the server?
View Replies !
View Related
|
TRACKER
