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 Complete Forum Thread with Replies
Related Forum Messages:
Database Back Up Through A Client
We are actually working on a project that uses MYSQL as the database server. Now, we would like to back up and restore the database through executing mysqldump in a client without the need of installing another mysql server on the client. So, what I want to achieve is to be able to back up the application's database simply without the need of logging in to the server computer. So just by logging on a client, you can be able to back up the database.
View Replies !
Client Can't Connect To Database Anymore
I am experiencing some difficulties on a computer on which a mysql 4.1 server is running. I myself, am an complete newbie to the mysql-world. I know practically nothing about it. All I want to achieve is fixing the following problem: A couple of days ago I installed a test server to run drupal (a CMS) on this computer (using the following tutorial: http://drupal.org/node/161975). Unfortunately, the other client used on this computer, can't connect to its database anymore. The server doesn't seem to be online. I suppose I also did something wrong with the user-settings. When I start up the program, I get the following error message: -2147467259 [MySQL][ODBC 3.51 Driver] Access denied for user '....'@'localhost' (using password: YES) Retry? (... being the username). When i try to connect to the server in the windows shell, I get error 2003: Can't connect to MySQL server on 'localhost' (10061).
View Replies !
Client App Connecting To A Hosting Database
I have installed this webapp http://www.webhelpdesk.com/ on my 2 computers. I want to setup both computer to pull data from my hosting database. I'm with dreamhost.com and when I created my database with the name webhelpdesk. When I checked the database its show as webhelpdesk.domain.com. When I try to change the database on the webapp I get the following: Could not connect to MySQL database 'webhelpdesk' on host 'webhelpdesk.domain.com'. Please confirm the connection settings.
View Replies !
Client To Access An SQL Database By Visual C++
I have several problems. I am trying to communicate with a sql database(local) by Visual C++ 6.0 (MFC based aplication). Well i think i am able now to connect to the local sql-server, but i cannot send commands to the sql-server, as create table... or things like that. I searched the Internet but only found source code for C. Well, but i need some for C++ .
View Replies !
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error. Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?
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 !
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 !
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 !
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 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 !
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 !
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 !
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 !
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Replies !
CLIENT
I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but that's the stuff I have to work with). Yesterday, a script that ran without problems for months suddenly stopped working on my server. I identified the problem: Suddenly, MySQL has decided that CLIENT is a reserved word. The same script is still working fine on my local machine (also IIS on a Wín 2000 Server). Anyone have any idea what could be wrong - and how to fix it?
View Replies !
SQL Client
I've got an SQL script (fred.sql) saved which I want to run from the sql client command line - how do I load the script into memory - basically I want to see what errors I get from the "load data" statement and I don't want to have to keep typing long statements in.
View Replies !
Client Only For Win98
I have a small LAN with my workstation (Win98SE), a Win/2000 system and a Linux system. I have MySQL servers running on the last two systems and I want to put the client software on the workstation. Is there a separate package for just client or do I need to install the whole client/server setup?
View Replies !
Server-Client
I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center.
View Replies !
Fw: Server-Client
I think that I should ask the question like that. I want to run MySQL on 14 client. What am I do. I try but There is a problem that i can't find.
View Replies !
Client Ran Out Of Memory
i got an error while my site gets loaded Warning: mysql_query() [function.mysql-query]: Unable to save result set in /path../includes/mysql.class.php on line 39 Error in Selection MySQL client ran out of memory My site didnt get loaded and was stuck by displaying this error .,
View Replies !
Client To Connect To A 4.1 Db
I'm trying to migrate my website to a new server and I wanted to point the old servers at the new database. The old servers have a 3.23 client and db and the new server is running the latest stable of mysql.
View Replies !
Into Outfile In Client PC
I'm Using Mysql V3.22+ And Im Trying This Query Select ... Into Outfile... In the Mysql Control Center But It Cant Work! Does Any 1 Can Tell Me How To Write The Data In The Database Into A File In Client Pc
View Replies !
Start The Client
and I log-in :..... Type 'help;' or 'h' for help. Type 'c' to clear the buffer. I thought I done, but not yet.... to start creating DB; in the same command prompt I right > create database database01; c:program filesmysql50in>create database database01; 'create' is not recognized as an internal or external command, operable program or batch file.
View Replies !
VB And Mysql:client
i wanna conn VB 6 to a mysql 4.1 database using mysql odbc driver 3.51 on windows XP. this conn is done usin ADODB. however on executing i get the following error: "client does not recognise authentication protocol requested by server, please consider upgradin mysql." upgradin to 5.0 is senseless. it is a godown of bugs
View Replies !
Client Access
I need to run client programs which access a database over the internet (or . Has anyone any experience with this. In particular I'm interested in the performance as compared with access within the local network.
View Replies !
Client Does Not Suport
Whenever i try to connect to my database through php, it keep saying: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:... on line 6 I'm using Apache 2.0.52, Mysql 4.1.8 and Php 4.3.10... and win 98.
View Replies !
Resizing Client?
I'm working on a project with someone and we want to get the MySQL 5.0 Command Line Client to resize and become bigger in Windows XP. Right now when we query it is really hard to read because lack of space. If the Client cannot be resized, maybe someone could recommend a client that will?
View Replies !
Client For Bash
I would like to know, where I can obtain a MySQL client for bash? I'm running Ubuntu and Fedora Core 10. I would like to create some bash script and run query into my SQL db.
View Replies !
Upgrade Client API
How do I upgrade MySQL client API from 3.23 to 4.x for PHP? I've got the following: MySQL 4.11standard Centos 4.1 PHP 4.3.11 MySQL API Client 3.23 (this is what I need to up to 4.0) Cpanel 10.x Methods tried: WHM (cPanel's web host manager) Update Apache /scripts/easyapache /scripts/mysqlup --force
View Replies !
|
TRACKER
