MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking
of an MS-Access sort of approach for basic database configuration
and maintenance. Maybe there's a back door way to ODBC myself from
MS-access to mysql on a Windows system ? Does Mysql have an ODBC
front end I can get in through ? Any pointers to some directions ?
I plan to use perl/my-sql for web work. But, it seems like a _lot_
of work to build the databases and populate them via mysql commands.
I'd like to be able to work them _locally_ through a basic data
maintenance program and then move it to the (web) server when ready.
View Complete Forum Thread with Replies
Related Forum Messages:
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back. Has anyone heard of anything like this?
View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
View Replies !
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
View Replies !
Front End
I currently use Access but I am planning on switching to MySql. I have uch a great setup using Access as a front end and I don't want to loose everything that has been established. I may keep Access as a front end to MySql,anyone has good alternate options?
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.
View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
View Replies !
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db. Example: I have a table with {id, url, desc} The program must generate a page with text fields to enter this information.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...). Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
View Replies !
Mysql-front
I'm trying to connect to a remote database with mysql-front over port forwarded SSH. i have local-host(mycomputer) port 3306 forwarded to local-host(remote) port 3306. I am able to connect but I get Lost connection error? "2013 - Lost connection to MySQL server during query" i was able to connect a few days before but not now? i am wondering whether i should be looking for changes on the server end or my end?
View Replies !
Front End Of MySql
I am very new to MySql and a novice at programming databases. I had MySql open source installed on my Linex server as I want to build my own database. Could any one tell me if there is a software available that will allow me to design / program the front end of MySql as I have someone who can program the backend, or if there is a software that will allow me to programme MySql like a window base software where I can drag and drop, create drop down window and format field which can then be converted to MySql?
View Replies !
MYSQL - FRONT
I need some help with MySQL_FRONT I've already installed mysql-front 3.2 When a try to work whit this message appear: ERROR "the evaluation time of this program has expired! the program will run in lite mode with limitations" I don't have any licenses for this program
View Replies !
Web Front End Tutorial
I know plenty of HTML, but I've never worked with a database before (total database newbie). Can someone recommend a tutorial or other option where I can RTFM? I'm looking to create a very simple web front end to a database so that I can store input and form data.
View Replies !
Mysql Front
Alright so its my 1st time ive manged to connect to my DB but i need to add this : DROP TABLE IF EXISTS `shoutbox`; CREATE TABLE IF NOT EXISTS `shoutbox` ( `id` int(111) NOT NULL auto_increment, `name` text NOT NULL, `message` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=0 ; dont have a clue were to start so the tutorial say's We are using 3 fields for our shoutbox (id, name, message) you can expand this to whatever you want, I'm just showing you the basic principles of it. So let's create a table in our database, for that you can use this sqlscript and enter it your mysql console or you can create it by your own.
View Replies !
Front Page
I am currently working on a site with SMF boards, i have downloaded TP (tinyportal) and i am trying to do a php code so all the threads from a certain board will go on the front page,help me with this code?
View Replies !
Front End And Database Help
Can someone recommend a good front end for mysql. I want something like a switchboard from microsoft access,to make a interface to meet HCI needs(user friendly interface) I would also like some feedback on the work I have carried out so far on my first database. I want to create a database using mysql that can be used at a after school computing class. The database should be able to be used at the class. The tables that I have so far are student: all student details teacher: for the 2 different teacher group: Each student will be allocated a group ie beginner ,inter ,advanced class location: the locations and times the classes take place. attendance table: Need help on this The databse should have the basic featire like add ,edit, view ,search for students and also be able to monitor attendace for classes. for example on saturday a class will take place. Students arrive for class, the teacher is able to search for specified date and then get the group list for that day. He can then take a register to monitor attendance. Can someone help me with the details needed in that table. Am I missing any tables and can someone help with the field required in the attendance table.If someone has some time can they create a basic mysql database to monitor attendance. ie member , attendance table.
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
Using MS Access As A Front End And Trying To Run A Script
Does anyone know how I can use vba in access to run a script that is stored as a file. I can make a connection to mysql database and run sql statements but this sql statement is very long (creates many tables with hundreds of fields). I can run the script in the mysql interface but I want to do this from my access front end to make it easy for the user to set up the tables. I need something like myconnection.execute ("c:myfilesmyscript.sql) but obviously this does not work.
View Replies !
Inserts Slow From Web Front End
I know little about MySQL but I am helping out a local charity and wanted to ask for some pointers. We have a membership database which is updated via a website. You enter name, email, postcode and hit update and details are put in the database. This has become slow. It can take 5 seconds, it can take 2-3 minutes from clicking update till the ok is returned and you can continue. This is no good if there are a queue of people! Sometimes it times out and goes to the no page found in firefox. So just wondering what I should generally look at to troubleshoot. The machine is Ubuntu linux, the web browser is firefox, the MySQL server is on a remote machine on the local intranet, the web server is also on a the local intranet but on a seperate server. - Could it be a locking issue in the database? There shouldn't be any concurrent access...although it seems to work ok the first two or three times and slows down more as you put more names in. How can I detect and troubleshoot locking? I believe I could change the insert statement in some way to prevent this. I don't have access to the code right now so not sure how the insert statement has been written? - Does it sound more like a network issue? It is a local intranet with the servers in the next room. Any way to easily monitor this on Ubuntu?
View Replies !
Replacing Access As A Front End.
We have a large number of Access MDBs floating around in our company. Our owner has decided that he will not be purchasing into the Microsoft scam, so we have a need to replace Access with an open source or otherwise free solution. I would like to use MySQL since I've just spent the past year becoming familiar with it. However, we need an easy-to-use user interface that is simple enough for people who are not familiar with SQL statements to understand. Ideally, we need something that operates like Access where you can build queries and reports in a graphical manner instead of using SQL statements. Now there are two solutions that I know will be brought up that I need to address now so that everyone knows it is not feasible: 1. Code forms, reports in PHP, etc: The problem is that we do not have a dedicated PHP programmer. In fact, I am the only person in the company that codes PHP. However, coding PHP is by no means my primary task. 2. Education: The problem is that our IT department is too small to educate the entire company about SQL statements. There wouldn't be anyone available from our department that could step away from their normal duties even for a day to train employees.
View Replies !
Programmable Front End To MySQL?
For example, in DBase or FoxPRO, the .dbf file is the database and the development environment itself provides means to code programs and make them into executables and distribute them as an application. Is there any thing like that for MySQL? Of course, one can write application based on PHP-MySQL and ship them together with Apache server to make the complete application work. Are there any other alternatives?
View Replies !
Win98 Compatible Front-end
i just upgraded from 4.0 to 4.1 and my old version of SQLyog (which I kept from when it was free) doesn't work with v4.1 :( so i'm in need of a front-end. what I mean by standalone is basicly NOT phpmyadmin. It's not that i don't like the tool (i do, and i use it) but alot of the time i don't want to start apache and firefox up just to go have a look at something in a table. any ideas?
View Replies !
A Replacement For Mysql-front
I am coldfusion user on windows boxes that has used access databases. I want to upgrade to using mysql. I have set a mysql database on my test machine and now want to upload it to my production server which is in a shared hosting environment. Please do advise if there is currently a tool available similar to mysql-front that was mentioned near the end of this thread. As a follow up question - I am basically using the database as a tool to store related information in tables and having coldfusion do all the heavy lifting in terms of data manipulation, so I guess it would not make a difference if I have the 5 version of MySQL and the host and 4?
View Replies !
Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine. These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet. What I've Tried So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand. Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN. The VPN Dilemma I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server? Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Replies !
Front End For Updating Several Related Tables
Is there a simple front-end that would let me select records from multiple related tables and edit their field data? Right now, I am opening each table individually in mysql control center, entering the new record, or editing the existing one, then moving on to the next table. I know there’s got to be something better, and I am to busy (spelled overloaded) to create my own from scratch. I use python now for most of my sql scripts, and PHP on occasion, but could figure out and modify something simple if necessary.
View Replies !
What Front End For Office Database / Web System
I would like to replace our current MS Access database with a linux based system. Our needs are as follows : A database to store our pertinent data A means of accessing the data from within our office (forms, reports, etc) A method for our clients to access our data from their offices ( ex..a web based access to our database) I am currently in the research phase, soon to be followed by the "learn a new language(s) phase." So I am a blank slate at this time, any recommendation is possible. How would you recommend I proceed? What structure, what languages, etc.. I have started reading about PHP with MySQL, would that fit the bill?
View Replies !
Graphical Interface Hangs When I Try To View Conents Of Table
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Different Result From Query Made In Mysql-front And From ASP
I have a strange problem with a mysql database and ASP. I try to retrieve a value from a table I have just created with a very simple sql statement. Ex. SELECT myValue FROM myTable WHERE userID = 'myName' If I type the query in mysql-front it works fine but if I execute it from and ASP page I get no value. I have tried something similar with other tables in my database without this problem. My ASP script looks like this: <% sql = "SELECT * FROM t_organisation_salg WHERE brugerID = '10025'" set objRS = objConn.execute(sql) IF NOT objRS.EOF THEN response.write objRS("omsaetning_gruppe") objRS.close set objRS=nothing objConn.close set objConn = nothing %> My database connection is included from another file.
View Replies !
Help! Trouble Loading .txt Files Into MySQL Front
spent all night entering data into my 1st DB via "mySQL front" and this morning had to reinstall everything, so i lost the whole DB but i did export it as a .txt & html table file last night.. but now i can't seem to get it back :mad: here is what the exported .txt file looks like: id,artist,title,label,price,sound 1,Niko Bellotto ,Slam mode,La colecion,21.50,slam_mode.mp3 2,Oliver Ho,Listening to the voice inside,Meta,40.50,oliver.mp3 3,Numero Deux,The dinning rooms,Conesa,32.50,numero.mp3 4,Photek,Solaris,Omni,32.50,photek.mp3 5,Gianni Ferrio,Spring themes,Garden,32.50,spring.mp3 ..... more of the same.. (its for an online cd store (fake one) i created a table with the same fields and tried to "import .txt file" but all i get is the id field filled up? the other fields stay blank?
View Replies !
|
TRACKER
