MYSQL :: Source Control

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.

Control Flow
I am having a hard time with Control Flows which is what i think I need to solve my current problem.

Below is a sample query dynamically built based on user screen selections. Notice that it attempts to JOIN 5 tables to fscenario.

My problem is that fscenario.`fsce_comp` may or may not be NULL.
Either way I need the record retrieved if all other criteria is met.

If fscenario.`fsce_comp` is not NULL I want to display the corresponding fcomponent.`fcom_name`.

If fscenario.`fsce_comp` is NULL, I still want to retrieve the record displaying nothing for the name.

Bad explanation, so I hope you follow?

Using the manual (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html) I have tried several IF, CASE, IFNULL structures. They all return records where fscenario.`fsce_comp` is populated and exclude the records where fscenario.`fsce_comp` is NULL.

I guess I am not understanding how to implement the syntax......

MySQL DB Control
How can i manage my mysql db? Example: How can i learn db size? Phpmyadmin is not installed on my hosting company.

Remote Control
I have MySQL running on a desktop computer that I log into through logmein.com and this is not the best solution. How can I connect remotely to use the MySQL Command Line Client on my desktop so I don't have to wait so long for each line to appear? I should also point out that this computer is on my LAN, so I shouldn't have to configure the router.

One problem I am running into right now is that when I try to make a new table, I keep getting error 1064 (42000) and I'm not sure why because everything looks correct. Code:

Control Center
I started using Control Center as a GUI for MySQL. Making progress but I could do better if I had the help file. It is grayed out. Is there a place to locate this?

Transaction Control
I am a recent user in mysql and I'd like to know if I need control the transactions in java when I am using mysql. I am asking it because I have read the mysql already control the transactions automatically, that is, it automatically control the commit and roolback commands.

Revision Control
I've been searching the mysql forums and documentation for anwers to this
to no avail..Is there any facility for revision control within mysql? I need to be able to have
snapshots of a mysql database that users can modify, later merging those
modifications in with the main database, similar to branching in cvs.
Does something like this exist already? Is it doable by copying the database
and then logging edit transactions on the copy? What about using the storage
engine plugin for tracking modifications?

Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.

Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.
Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

Control Panel
i'm having some problems with my MySQL install. Firstlty when I installed MySQL I never got an icon of any kind within the control panel. I've been looking at tutorials of how to create a database and many of them use the control panel option as a starting point but I can't because MySQL is not present within the cPanel. Also when I click on the MySQLadmin.exe in the bin it does not open probably. It opens briefly- shows a black screen with decending text. It then dissappears completely after several seconds. It cannot be seen or opened in the tray

Control Max Time
Does anyone know of any parameters that can be set to control the maximum time limit mysql will allow a single query to run before timing out etc?
Rather than let badly written queries run for long periods I would like to just abort them if they exceed a set amount of time.
I know the php calling script should/could handle this with defensive coding etc. However, I'm not always in control of how other users write their scripts that interact with mysql.

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.

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.

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.

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.

Execute Source
Is there anybody that knows as to run a query from DOS (I tried with --execute source filename.sql and the error meassege is ERROR1102: incorrect database name filename. When I enter mysql and use directly source filename.sql the query runs).

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?

MySql Control Center
I am new to using the Control Center-0.9.2-beta. My problem is that I
cannot seem to display more than 1000 rows in my result set when I know that
there is 1534 rows. I know that it is a setting somewhere, but is it in
MySql or in the Control Center somewhere. I am running this on a Windows
2000 machine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=...sie.nctu.edu.tw

Mysql Control Center
I'm trying to get the GUI to connect to a remote mysql database from my
client machine. What is the proper syntax for this in the GUI? I have
tried everything with no luck: using the ip of the host, using the complete
dns hostname of the host, using root as the user, using root@hostname as the
user. I keep getting access denied for every attempt. I'm sure I am using
the correct password.

MySQL Control Center
I can access my MySQL database with MySQL Control Center from a computer with a direct connection to the internet, but I can't do it from my other computer on a network. Is there a way to use MySQL Command Center through a network/router? I'm unable to find any connection settings options in the program.

Start Control Center
Getting the following message when I click on the MySQL shortcut on my desk
top:

Error Starting Program
The msvcrt.dll file is linked to missing export ntdll.dll:Rtlgetntversion
numbers.

A device attached to the system is not functioning.

Have gotten both Dll's and stuck em in the system and program directory...
nothing happening there.
Would like to find out what "Rtlgetntversion numbers" is all about.

Retaining Control From MyODBC
I'm developing a system with an Excel front-end that uses ADODB and MyODBC to fire off instructions to a (local machine) MySQL server. As I step through my VBA code, it sends an instruction to MySQL (e.g. gconMySQL.Execute "DROP TABLE IF EXISTS MyData;" ), waits for the instruction to be executed, before returning control to the code and moving on to the next VBA statement. All well and good; this works fine for the majority of the processing.

However there is some initialisation of the MySQL database, particularly loading some data tables into MEMORY, that takes up to half a minute to complete. I'd rather fire off the instruction(s) to MySQL to do this so that MySQL initialises invisibly in the background, whilst the user continues playing around with the front-end themselves.

MySQL Control Center
I have installed MySQL Database Server 4.0 and MySQL Control Center, but i can't still use MySQL CC to create new database or other feature.

MySQL Control Center
I am trying to install MySQL Control Center for the first time (the latest
version). I am using Windows XP. When I try running the setup routine, I
get through all the prompts and when it starts to install, it gets stuck at
the 'Initializing... ' screen. And it does not go any further. I cannot
even cancel. the operation.

Mysql Control Center
Quote: ERROR 1109: Unknown table '1' in information_schema
Quote: [stuff] ERROR 1146: Table 'cdcol.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'mysql.1' doesn't exist
Quote: [stuff] ERROR 1146: Table 'webauth.1' doesn't exist

I get that error when ever i try to access any tables in mysql control centre. The error is almost the same, except for the database name. It does this even on a clean install.
Im using xampp

MySQL Control Center
how can i declare a Vendor-Specific
attribute in MySQL Control center. In the regular radius i declare it
well.
I check the radtest and its write : radclient:WARNING: Malformed
RADIUS packet from host 10.0.1.16: Vendor specific attributes do not
exactly fill Vendor-Specific

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.

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?

Creating Data Source For My-SQL DB!
How can i create a data source for a My-SQL Database?

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

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 )?

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.

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.

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?

How To Control Mysql In Hosting Server
I am a ASP programmer. I use MS Access for quite some time, and I am to switch to MySQL.

The way I use Access is create tables in my computer and upload it. When I want to do backup, I will download it and make another copy locally.

1. How to create a MySQL DB and Upload it?
2. How to modify the DB structure? For example, create index for certain field? do I have to download it and change it locally?
2. How to download and make backup?

Varables In Control Flow Statements
Is it possible to assign values to variables in a 'SELECT IF ' statement:
when I execute a statement like,

SELECT IF(col1> col, @x:=3, @x:=4) AS ,@x/2

I get a blob for @x/2

Solution For 'repetition Control' (slideshow App. For Web)
Im currently developing a web portal wich will serve, as part, as a customizable slideshow presentation.

The user will have the option to select multiple galleries of images of different subjects, each gallery containing several images.

The slideshow's 'playlist' function plays a certain number of images from one gallery then moves on to the next on. I.e., the playlist have 200 galleries, and will display 5 images per gallery.

Its imperative to the system to have a 'image repetition free environment', to assure that, when a gallery that was previously displayed shows up again in the playlist, the next 5 images of that gallery wont be the same as the ones previously played.

Code:

Could Not Connect To The Service Control Manager
I'm trying to run MySQL Server 4.1 on Windows Vista Beta 2. I was able to install the server before. But when I uninstalled and tried reinstalling, I got the following message at the end of the Instance Configuration Wizard:

Could not connect to the Service Control Manager

I got this message once before when I first tried to install MySQL on Vista Beta 1. Can anyone help me diagnose the problem?

Current Version Of Control Center
What's the current version of the CC? I have only 0.9.4 beta, and I would like to use a release.

Control Center Confusing Hosts
I've got control center installed on my localhost machine where I piddle around with db's on my machine. Today I attempted to connect to another server to assist others in their db work. I inserted xxx.xxx.x.xx for my IP address (obviously I'm susbstituting my actual IP) and when I selected "text", I was echoed back the string:

ERROR 1045: Access denied for user: 'xxxx@ooo.ooo.o.ooo' (using password: YES)

The complex issue is this, I inserted xxx.xxx.x.xx as my host IP, but instead of using my host IP to test the connection, control center used my localhost IP.

Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).

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.

Making A .bat File For The SOURCE Command
i have a sql script file that i normally
run from the mysql prompt using the command SOURCE

so i first i do
mysql> use tms;
then i do
mysql> source /path/to/file/script.sql;

how can i create a batch file for this process

my database username is root
and no password

Databases Removed With Source Re-compile?
If I have rpm's of mysql already installed on Linux Mandrake 9.1, and I need to remove these, install the source and re-complile, will I lose the database amd data already created? Also, webmin , will it be affected at all by this action?

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.

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.

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.

Source Control

Does anyone know if there is a program (for windows) that can help us catalog our sprocs and table setups into source control?