MYSQL :: Setup Program

Mysqlimport Program
I have been using load data in file command until recently on a windows machine - works fine.

we are now using a Netware 6.5 box and are trying to use mysqlimport from the command line.

I am using:

mysqlimport --password=123456789 --fields-optionally-enclosed-by="" --fields-terminated-by="," 0608c sys:mysqlinstirling.txt

to import a CSV text file into the database 0608c.

the data looks like this

"2007-06-28 16:07:00",0,13.58,15.77,-13.35,-12.69,-13.36,-6.61,-3.821,......

when the program executes it seems to give the desired results except the timedate is all zeros...

Extraction Program
I am looking for a simple extraction/load program to load data daily from a
Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not
necessarily need to do any data-type transforms. It need to run on Windows
2000 and be able to run it as a service, or as a cron task if running under
Unix.

DB Modelling Program
Is there a database (ERM) modelling program for Mac OS X that can handle MySQL? Maybe a freeware one?

Php Email Program
Does anyone know of a php or even cold fusion based script out there for
accessing email that can be customized? Right now I use SquirrelMail
which is great, however, you can't really customize it to tie in with
your web site. Is there something out there that is very flexible that
I could make fit right into my site which is pretty reliable in terms of
web email?

C- Program To Write To Myi , Myd File
is it possible to create a myi, myd file for mysql using a C program. I
am using Stata that is written in C API, and I want to write the data
out to MYSQL database. Using ODBC and loading the data in MYSQL from
STATA takes forever. Can anyone please tell me if I can create the myd
files by using the data in memory thru C programming.

Using MySQL To Input Into Another Program
I have been working on a workaround to see if I can figure out how to get DATA from MySQL into another program. The other program is built on MS SQL server. The problem is that it is so bloated that a remote and my computer at the plant cannot correspond back and forwards. It takes approximately 10 minutes to key an order in to the remote plant.

I was working on a much smaller database through MySQL and using OpenOffice.org as the front end. I just wanted to go a step further and see if there was a way to use a triggering mechanism of some sort to input the data from OOo/MySQL to the actual program the company uses.

Trigger To Run An External Program
Can I trigger an external program to run when a new record is added to
the mysql table?

The external program is in C and instead of scanning the table
continuously for new insertions, it will be better if an external
program could be triggered.

Good Program For Mysql
Do you now a good program for mysql admin like phpMyAdmin, than better!!

Can't Update A Field From VB Program
I've just setup MySQL on a Linux machine and I'm using Visual Basic in
Windows to connect to it (using MySQL ODBC 3.51 driver). Everything works
fine for browsing the database (used for stock control), but some parts of
the VB program refuse to update the database. It was using an Access
database (which worked ok) and I'm using the same SQL statement and table
structure.

Here's the SQL statement that VB runs:

SELECT Stock.GJGStockCode, Stock.PartName, Stock.Discontinued,
Stock.UnitsInStock, Stock.UnitsOnOrder, Stock.ReorderLevel,
Stock.ReorderQty, StockSuppliers.SupplierID,
StockSuppliers.OrderCode, StockSuppliers.PackQty,
StockSuppliers.Price, Stock.PartsToOrder
FROM Stock, StockSuppliers
WHERE Stock.CurrentSupplier = StockSuppliers.Position AND
Stock.GJGStockCode = StockSuppliers.GJGStockCode AND
((Stock.UnitsInStock + Stock.UnitsOnOrder <= Stock.ReorderLevel)
OR
(Stock.PartsToOrder > 0))
ORDER BY StockSuppliers.SupplierID, Stock.GJGStockCode

....which works ok for browsing the database. If I change the
Stock.PartsToOrder field in the VB program, when VB trys to update it I get
the error message "Insufficient key column information for updating or
refreshing". The Stock table has a primary key (GJGStockCode), and the
StockSuppliers table has a primary key (UniqueID) which is an auto_increment
bigint.

Does anybody know what I need to do to allow VB to update the database? Or
is this a VB question!?? - Although the same SQL statement works with an
Access database.

Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with
this command:

linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl

But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and
try again, then I got the messages like

/tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress'

My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files
from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries
are installed at /usr/lib/mysql, and include files are at /usr/include/mysql.
Can anybody tell me how I can configure my system to make it work?

Program MySQL With Apache
I don't even know what this is called, but I'm looking for a free tool that allows me to code MySQL and will work with Apache and PHP.

Program Refusing To DROP DB
I am getting this problem over phpmyadmin and also over a preprogrammed php script.
When there are more than 30 or 40 selected DBs the programs refuse to carry out any command when I click on the drop button.
They would just take as if there is no command issued at all.....

Anyone know how to make it delete more DBs at one time?
I looked at trhe my.cnf file but don't see any options to do this...
It however runs on small batches but I need it to drop a lot more databases at one time.

Program To Optimise Mysql Queries
Basically im looking for a program that will take input (my query) and produce an output with a much nicer, more efficient query. I have seen sql programs that do this sort of thing, but nothing for mysql.
Just wonder if there is any programs that i have missed? Tryed Toad for mysql, but that wasnt what i wanted, i dont want a program to admin a mysql database, simply to produce a more efficient query.

PROGRAM TO UPDATE DATA TABLES
I need to be able to DELETE selected record & LOAD DATA from a text file or Foxpro table, from a program that can run continuously.

I've tried Foxpro, but FoxPro views are too slow. I have also tried issuing these command from Foxpro with an ODBC connection established, but that does not work at all.

The object is to remove all records for a member and replace these records with records from a new file.

Each transaction will be up to 50,000 records.

I need to execute 2 commands:
DELETE FROM parts WHERE parts.member_id="xxx"
and
LOAD DATA INFILE 'd:/xxx.txt' INTO TABLE parts

Packaging A MySQL Database With A Program
In writing a visaul basic database program with Access as the database you simply copy the database file into the packager and it is installed with your program on the target machine. I am guessing that with mysql, since it is a 'server' program, it is not that easy. Am I wrong? And where would I find information on this.

I have been working on a business accounting program and am a long way from finished, but I wanted something more robust than access as the database. I just need to know how to get the database to the target machine with my program.

How To Access MYSql From External Program
I have a Mysql database on a webserver and would like to access order information automatically from my home computer. I have the ecommerce software send me an email of the order and I wrote a VB program to extract the information from the email and populate an Access database. There must be a better way. Can I somehow have MS Access backup that database on my home computer?

Displaying TEXT Datatype With C Program
I'm currently trying to display the contents of a field which datatype
is set to TEXT, I'm trying to output this through a C program.
the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s
crashes the program and %c produces a smiley face.

Displaying TEXT Datatype With C Program
I'm currently trying to display the contents of a field which datatype
is set to TEXT, I'm trying to output this through a C program.

the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s
crashes the program and %c produces a smiley face.

Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through.

I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file.

When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets."

I have no idea what a dynaset is or why it is an error???
Is there a way around this?

I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.

MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so:
I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns.
After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit.
Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.

Redirect Out Of Mysql Client Program To A File
I have mysql on MS Windows2000.

I like to redirect the output/error messages of MySQL client programs to a file.
For example, when I execute:

"mysql --user=root --password=[wrongpaswd] --silent --database=mysql > errfile"

The following error message is coming in the screen, not in 'errfile'

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

I also need to capture the same for utility "mysqlimport".

How capture the output of these client programs in a file?

Create A C++ Based Program Using Mysql Odbc.
I want my software to be independant of operation system and databases.

That's why I want to use odbc, and don't want to use MFC.
Here I have some questions to ask:
1. On unix (like sun solaris), does there exists any kind of midware
like odbc?
2. I search on the internet, and find most of the examples are based on

PHP. Is there any c++ examples?
3.Once I chose odbc, does that mean that whatever kind of database I
would use later, I don't have to change my source code?
4. now I program on window xp platform. If I use odbc, when impliment
my program to a unix platform, do i have to rewrite my code?

I just started this project, and I'm a newbie. The problems may be a
little bit of stupid.
Can you guys give me some information about this topic?

Developing Database Program Using Delphi And MySQL
how I can use MySQL with Delphi? What I'm really looking for is a header file which can be used in each project which will allow me to use MySQL.

Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype
is set to TEXT, I'm trying to output this through a C program.

the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s
crashes the program and %c produces a smiley face.

Making Connection To Mysql From A C Program On Windows
can any one please tell me "how to make a conncetion to mysql database
from a C program on windows " .
Please help me by giving possible code for making a
conncection,selecting data etc.
i.e. what library files i need to include,what are the functions needed
to be called.

Create My Own VB Backup Program For A Remote MySQL DB
I understand that the basic principles to create a TCP/IP backup program for

a remote MySQL DB are:

a) Query/retrieve the schema.

b) Query/retrieve each table and create inserts for each row of data.

The way I want to do it is even more basic, as I know what my schema is so I

only need to reterieve and create the insert rows to put into my backup text

file, which is basically a large DDL.

The problems that I am experiencing are I want to keep the schema in an

external text file so that I'm not storing it in the actual app and I

thought I would also have another external file to store each 'select * from

tablex' query.

Is this a good way of doing it?

How would I merge the results together to make a new (and 3rd) external text

file backup?

Data On Separate Drive From Program Files
I have a server that I want to run MySQL on. The server has a 6.4gb hard drive for the OS and applications and a raid array for data that is shared via samba.

What I want to do is install MySQL on the 6.4gb hard drive but have all the DATA saved to the raid array.

Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program.

the line is as follows:

while((row = mysql_fetch_row(result)) != NULL)
{
printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL"));
}

I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.

Sql Server Not Showing In The Program Files Of Start Menu
I installed sql server in december 2005 and when I look at the control pannel, its there. But its not showing on the desk top or even in the start > program files menu. So how can I start it?

Setup.exe Xp Pro
how to sort this out everytime i try to uninstall a progarm it comes up with setup.exe has a problem and as to close,it is just on 1 program it is a ebay toolbar im trying to get rid off any help might help.

New Db Setup
Does anyone know of a good web site that I can look at that will show me how to set up a MySQL instance?

DB Setup
I'm trying to figure out how I should layout a database table(s). What I would like to do is be able to keep track of how many times several pages are viewed each day.

For example, I'd like to know how many times the index.php was hit on Sept 8. and how times on Sept 9. How many times article.php was hit on the 8th and on the the 9th etc.

Mysql Setup
I am working on setting up a postfix email server with Currier IMAP and Mysql with a squirl mail front end. I am currently having difficulties with the mysql end of the process.

I am installing using the source, not the rpm package since i want to get a feel for how to do this way, and I have been unsuccessful at running:

./mysql start

the error i get is

Can't connet to local MySQL server through socke '/tmp/mysql.sock' (111)

Also, according to the install readme, I need the client access libraries. I have been out to mysql's website and I have been unable to locate these files. I have found a tag that will setup only the client access files,

--without-server

but i'm not sure if this will not allow me to setup both the libraries and the server with an additional tag.

Perl Setup
i have installed Mysql 3.23.49 and Perl 5.6.1.629 on a Win XP Pro..but i can't seem to get my cgi (perl script) to open or use "use DBI" or any perl modules... ...my main proble is that my cgi can't locate perl modules used for Mysql and Perl..i have already tested perl and Mysql individually and have run perfectly.

I CAN'T RUN SETUP.EXE OF MYSQL
I downloaded mysql-4.1.22-win32.zip and I run the setup.exe of mysql but the install stopped because it show to me the windows installer with parameters and do nothing.

Database Setup
I would like to get some suggestions on how to setup my database. I am reading thousands of different tags from a field device. I am reading each tag values at different intervels. I will have a column for each Tag name containing the read value and a column for the date/time stamp. If I put all these tags in the same table I will have rows with one value and the rest null values

time stamp | test1 | test2 | test3 |
------------------------------------------
02/16/05 9:44:44 | 2.45 | null | null |
02/16/05 9:44:45 | null | 3.22 | null |
02/16/05 9:44:46 | null | null | 212 |
02/16/05 9:44:44 | 3234 | null | null |
02/16/05 9:44:45 | null | 3434| null |
02/16/05 9:44:46 | null | null | 2333 |
02/16/05 9:44:44 | 2 | null | null |
02/16/05 9:44:45 | null | 4444 | null |
02/16/05 9:44:46 | null | null | 2121 |

But if I make one table per tag I will have thousands of tables. Does anyone have a sugestion?

MAC OS X Setup With PhpMyAdmin
I am having a problem setting up the config.inc.php file in phpMyAdmin.

I have amended the mysql user account in Mac OSX in NetInfo and given it a password.

I have amended the config.inc.php file control user to the same settings, but I keep getting the messsage 'Access denied for user mysql@localhost using Password: Yes)

I have tried all sorts of combinations of user names and passwords for control user and user and the only one I can get to work is user = root with a blank password and controluser name and password of blank, which gives me a warning that MySQL is running with the default privileged account which is a security risk.

How To Setup A Rolodex?
If im creating a rolodex to contain unique id#, names(first, last), adresses(street1, Street2,city,state,zip), phone numbers(home, work, cell) e-mail adresses(home, work), Comments How would this be organized?

Would i only use one table or multiple tables? How would i set up each column. (Name, Type, Null,Key, Default,Extra)?

Could someone organize this for me. I am trying to learn PHP and MySQL but i just havent figured out the database design part yet and i want to create a rolodex for my site.

MySQL Setup
I have a Windows 2000 Server preinstalled with mySql, and have tried to run a basic connection test though the ODBC manager for the mySql Server Driver, and it continues to say it can not find mySQL.

When setting up a standard database through the ODBC Manager, here is the basic info it provides. Code:

Table / DB Setup
I will potentially have 1-3 tables that may be written too 1,000's of times per second. Eventually becoming very very large tables. What methods and suggestions would you make on how to properly handle a task of this nature? I need to be conscerned about performance on pulling many records back as well for statistics.

Setup Under Windows Xp Sp1
I need to upgrade my current mysql installation . But now there is a problem
to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The
program hung after few seconds. In the memory remain active woexec, ntvdm
and setup, but the process is freezed. It is possibile to convert the
current setup mode of mysql4.014 in other install system, as for in
mysqlcc092 ?

Database Setup
I'm trying to install a PHP and MYSQL web app which needs me to setup the correct fields.

Server Name localhost
Database Name mysql
Database User Nameroot
Database Password MyRootPassword

I enter all of this information and I get an error back that says:

'unable to connect to the database server - verify settings and ensure database is running.' Does anyone know what I'm doing wrong??

Table Setup
I have one database with two tables. One is named users, and other is named posts.

User table contains this fields

UserId(key) Username

When user writes a post it is stored in Posts table with this fields
Post Table contains this fields
PostID(key) UserId Post

Now, this is really simple question, but is that a proper way to store posts made by user, so that userId gets stored as well as PostId?

I read a bunch of stuff, and this is how i figured it goes, so if you have experience with creating more tables and on a way how to join them together,

MySQL Setup
I've downloaded the mySQL files from the http://www.mysql.com website, and have unzipped them into my c: drive, although, i wish to be able to use this in addition in my PHP programming with my Apache Server. How would I do somthing like this?

Table Setup
I need to track settings on my system on a per directory and per user basis. In this case,I am refering to directories that all users can see and sort.

I would like user A to be able to sort the same directory as user B and have their sort choices be independent.

So my table needs to have at a minimum:
userid: varchar
directory: varchar
sortmethod: int

What table type should I choose? What Indexes should I have?

My.ini File Setup
I want to make sure my ini file is set up right. I have now"
#This File was made using the WinMySQLAdmin 1.4 Tool
#1/14/2004 11:13:21 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/APPS/MySQL
#bind-address=192.168.0.100
datadir=C:/APPS/MySQL/data
#language=C:/APPS/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/APPS/MySQL/bin/mysqld-nt.exe
user=X3Graphics
password=xtreme"

What I want to be able to do is update my database locally and on my hosting server.
Is this possible.

Setup Program

I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands. How can I do it ?

I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands.
How can I do it ?