MYSQL :: Mysqld-nt Crashes When Executing Batch File In 5.03 Beta

Mysqld Crashes Unexpectedly
The mysqld process keeps crashing unexpectely on my server. No error messages, etc. appear when it happens, however, I have checked the error log file for the server and found the following entry at the end of the file associated with the last time it failed (the same message appears throughout the file relating to period of time for which it has been installed - i.e., this may be an installation issue?): Code:

4.0.14 Install Problem: Mysqld Crashes
I've recently compiled mysql 4.0.14 on redhat 8.0.
The installation fails, however, when running mysql_install_db.
I've attached a transcript below.

I gather from searching the 'net that this isn't an entirely
unusual thing to happen, and is likely the result of some
misconfiguration on my part, or perhaps a version incompatability
with my libc. Unfortunately, I haven't seen any concrete suggestions
on how to get past it.

I've studied the installation instructions pretty closely,
experimented with various compilation flags. I just keep getting
the same results. Code:

Executing .sql File
I purchased some software to add to my OSX 10.4.4 server. When I get to Step 3, it tells me to go to my administrative control panel. From the looks of it, this is something web hosting companies provide to their customers, but since I'm using my own server, I don't have one.
I am being told to find a .sql file and execute it, but I don't know how to do it based on the information given to me.
I am using MySQL tools, but there doesn't seem to be anything to help me execute the .sql file.Anyone know what I'm supposed to do?

Batch File
I am new to running batch files. Is there a way to loop through a results set in a batch file? I want to be able to create tables using table names that are stored in a table. I had hoped that I could query the table to retrieve all tablenames, then loop through this result set, creating a table with each tablename returned. (Table definitions will be the same for all tables created. Only the tablenames are different.)

Error With Executing A Script File
I have been trying to execute this sql code from a file called script.txt. Here is the code that I created in Notepad.

CREATE DATABASE library;
USE library;

CREATE TABLE author
(
name VARCHAR(20) NOT NULL,
authorID INTEGER NOT NULL,
PRIMARY KEY (authorID),
)

When it starts to run, it keeps on producing this error but I dont know what to change in the code.

Check the manual that corresponds to your SQL server version for the right syntax to use near ')' at line 6.

Executing SQL Statements From A Text File
In earlier versions of MySql I used to execute SQL statements from a text file like this..

mysql nuke < nuke.sql

but for some reason since I have upgraded to MySQL version 5.0, whenever I try this command from the Window command prompt I get this error...

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost'

any ideas?

Cant Execute Batch File
Hi new to this but pulled out nearly all my hair with this.
I got the test database open and I want to automate creating the menagerie table ( as in the tutorial ) so I download the textfile save it to c:/ and execute the command source c:/cr_pets_tbl.txt all I get is unable to open file error 22.
I have tried creating my own text file ( windows, notepad ) just containing the following
use test;
create table pets(name varchar(10),species varchar(8),born date);

simple as that then type in the consoe source c:/pets.txt;
unable to open file error 22 or sometimes error 2
tried enclosing filename in " and ' tried source= filename
tried . instead of source but nothing works.
using manual insert command or load data local infile works but not this, HELP.
Malcolm K.

Batch File For Backup
Can I make complete Backup of a database (same as from MySQL Administrator) using batch file?

Problems Executing .sql File From Command Prompt
I am having problems executing a .sql batch file from the mysql command prompt. I can run this file through SQLYog and i have no errors/problems but if i try and run the batch file through the windows command prompt (after connecting to the mysql database) i get a problem as soon as i try to change the delimiter back to ;

Has anyone else had problems with this?

Batch FIle To Create Database
I am trying to create a batch file to create a database and populate it with create table statements. I can't figure out why it will not create the database and load the tables. I have the following in my batch file

/mysql/bin/mysql.exe -vvv -u root -pcs3911 < C:mySql est.txt

and the following is my test.txt file

CREATE DATABASE 'lovettsite';

CREATE TABLE `applications` (
`username` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`middlename` varchar(255) NOT NULL default '',
`lastname` varchar(255) NOT NULL default '',
`current_address_line_1` varchar(255) NOT NULL default '',
`current_address_line_2` varchar(255) NOT NULL default '',
`current_city_town` varchar(255) NOT NULL default '',
`current_state_province` varchar(255) NOT NULL default '',
`current_zip_code` varchar(16) NOT NULL default '',
`p.........................................................................

Running MySQL Using A Dos Batch File
I am used to use MySQL on Unix, now I have to do some development for MySQL running on Windows machine. The following script works well in Unix but I am unable to run it on Windows. "MY_FLAG" is the one which is causing issue. Due to certain restriction in my framework, I can use the normal batch by supplying the .sql file while opening the mysql connection ( infact i need to run multiple source files) Code:

Using Batch-/cmd-file For Dumping Data
i want to build in data in my database that are written in single table dumps like [tablename].sql.

Each time it is nececery to use several files. And it is also nececary to do this using the command line because of the files are bigger than 1,5 gb
But i didnt find a way to transfere the needed commands into the mysql command line.

How To Execute A Batch Sql File Under Windows?
I have installed MySQL 5 in c:Program FilesMysql. I have a sql file named "books.sql" which is put in the subfolder in,it contains many statements that like "INSERT ... value ...".

my question is how to execute it? I try it, but failed.

One more question is how can I return from "->" to "sql>" promopt?

Running Mysql Commands In A Batch File
I am trying to automate a mysql command to upload data everymorning on a windows server. I have created a .bat file and entered the commands to login to mysql but when it gets to the mysql prompt it fails to complete the rest of the commands.

cd
c:
cdmysqlin
mysql
TRUNCATE TABLE blah
LOAD DATA INFILE 'blah.txt' INTO blah
QUIT
exit

Is this possible?

Mysqld Ingnores Ini File
i set the datapath in my my.ini file and restarted mysqld but databases continue to get created in the old directory - is there a way to fix this?

Can't Create/write To File /var/run/mysqlid/mysqld.pid
I have installed mysql(mysql-standard-4.1.14-unknown-linux-gnux86_64-glibc23.tar) on linux.but when i tried to start mysql i am getting an error
can't create/write to file /var/run/mysqlid/mysqld.pid
can't start server can't create PID file :No such file or directory.

4.1 Beta
Does anybody know when 4.1 beta is likely to be available?

DBDesigner 4.0.5.4 Beta
I worked a lot with DBDesigner 4 under Windows, but now I want to move to Linux. On my computer I've installed Suse 9.3, with Mysql 4.1.12 and DBDesigner 4. The problem apear when I want to connect to Mysql server from DBDesigner.

It Gives me the following error:"Connection to database failed. Unable to Load libmysqlclient.so". I've checked in /usr/lib, and there is libmysqlclient.so.

Using 5.0.11 Beta To Learn
I've just started using MYSQL so  these questions are rather basic but important.
I have only one computer to test this on.  Is it possible to have a client on the same computer as the server (Kind of like MS SQL server)?
I installed MySQL when logged on to my computer (which is running Windows 2000 server) as the local administrator.  I went into a command prompt and entered the following command:

mysqlshow (within the bin subdirectory)

and received this message

MYSQLSHOW:Access denied for user 'ODBC'@' localhost' <using password: NO>

So the big question is can I access the server on the same machine on which it is installed, and if so, what do I have to do? create new users?

MySQL 5.0.3 BETA Released
Was this version released today? Or was it released before? What is the exact release date for it..becuase the last one I remember was MySQL 5.0.1 Alpha, so I know this happened not too long ago.

Mysql Import Version 4.0.4-beta
I have inheireted a mysql server running version 4.0.4-beta,
which I am obviously keen to update to something stable.

However the mysqldump's for this version don't seem import into mysql 4 or 5,
and stick at the line *
...snip...

PRIMARY KEY (event_id),
UNIQUE KEY secondary index (title,venue,time_date) *
) TYPE=MyISAM;
...snip...

Has the export syntax for this early version been orphaned?

Downloading Problem Beta Version Of MySQL 4
whenever I try to down load the MySQL Beta version 4.+, I am redirected to SourceForge.net (Viralator Page). and that page has a button "Start DownLoad". After clicking on this button a new pop up window comes displaying page not found error.

5.0.22 Crashes
just upgraded my MySQL to 5.0.22 and found that the following statement:

select DATE_ADD(made,INTERVAL payment_terms DAY) from processitem,document_files,processes,companies WHERE ref_no=pr_process_no AND pr_process_no=process_no AND processes.customer=companies.cust_no AND made>="2006-6-01" AND made<"2006-7-01" AND dtype="Invoice" GROUP by processitem.pr_invoice ORDER BY DATE_ADD(made,INTERVAL payment_terms DAY);
will crash the database server. If I remove the order by statement it works.
This has been working well since version 3.x and the previous 5.0.8 also handled it fine.

MySQL Crashes
I am running on a win2003 machine 2 gaming servers and phpbb from the one mysql server. To do all this I have 4 seperate databases. I also use a backup program to backup the gaming servers every 5 hours or so.

I get a complete MySql crash 50% of the time I update one of the gaming server databases and I get a Mysql crash just about every day whilst running the gaming servers and the bulletin board. I do not know what is causing the crash or how to fix it. Code:

MYSQL Crashes
I have had mysql running for a few months now with no problems after it was set up. Now the service refuses to start and gives the error 1067 : the process terminated unexpectedly. The only thing i can think of that changed recently was that I was rconfiguring my server to see if I could get VPN connections working for fun and I set it up as a NAT, vpn, and DHCP, DNS, and WINS server. The server runs Server 2003 Enterprise and I am a noob to sql, i can do simple commands and things like backups in the mysql administrator and query browser, otherwise I am a complete noob. I have restarted the server, but that didnt fix it.

5.0.2 Engine Crashes Always On W2K
I have an application supports ORACLE and MSSQL, and now I have to extend database support for MySQL.

I need VIEW, STORED PROCEDURE. so I start my work with 5.0.2, but I can not use it, because the engine generates Window exceptions (MySQL installed on W2K).
Engine crashes using all MySQL tools (Administrator, Query Browser, Control Center) too.

I made some test with 4.x.x, and this was stable, but I need VIEW, STORED PROCEDURE. If they are not, I have to re-write my modules - I don't want if it is possible -.

My question:
I have to wait for next release? (I find that, 5.0.3 is fixed. Can I test it now?)

SQL Quesry Crashes DB
SELECT id,log_date,log_date_count,log_email,log_email_count,email,fname FROM app_track WHERE type = 'fed' ORDER BY log_date_count DESC LIMIT 0, 30

This crashes mysql. (win2000).

MySQL Crashes During Request
I'm working on MySQL 5.0 on Windows XP. I've tested a request on MSAccess and it's working. But if I launch it under MySQL, the PC crashes and I have to restart server.
this is the request :

SELECT * From bd_resultat.Valeurs_Entree Where Ve_Pa_Id = 147 and
Ve_Val ='NO_OUTIL' and Ve_Groupe
IN (SELECT Ve_Groupe From bd_resultat.Valeurs_Entree Where Ve_Pa_Id =
148 and Ve_Val ='FIB' and Ve_Groupe
IN (SELECT Ve_Groupe From bd_resultat.Valeurs_Entree Where Ve_Pa_Id =
149 and Ve_Val ='1.4732'));

There are 3 requests. If I put 2 requests, it's running. But If I put
more than 2 requests, it crashes.

Have you an an idea about this problem ?

SQLConnect Crashes Internally
Configuration:

C code
XCode 1.5
(IDE 389.0, Core 387.0, ToolSupport 372.0)
MacOSX 10.3.9

Program description:
The program connects to ODBC driver and then to whatever database is described by the DSN. From there it does many simple tasks such as creating a table or inserting data. I connect to MySQL database and PostgreSQL database (I separately choose the one I will use before I compile and run the program).

Problem:
The program I am working on continually crashes inside the guts of SQLConnect. I haven't modified any MySQL code. I bring this issue to the MySQL forum because when I connect to a PostgreSQL server I NEVER have crashes/problems with connecting but the SQLConnect statement only fails when I connect to MySQL server. Also note that it doesn't crash on every call of SQLConnect, but rather only the 2nd time called or later being called. Code:

Query Crashes Database
The following query sometimes gives problems, can you see something that could upset the mysql database?

SELECT DISTINCT t1 . *
FROM cdb_producten AS t1, cdb_stijlen AS t2
WHERE (
(
t1.p_brutoprijs * 1.19
) <=750
)

MySQL Crashes On Simple Query
I am setting up MYSQL/ MS 2000 server on a p4 2.6 w/ 512 RAM/80gb server.

I was testing my server, i tried to insert 7million + rows in a table, then simply try to double it by "insert into .... select * from 'same table'". I understand it could take a while to double the 1.3 gb table. howver, the MYSQL crashes after several minutes and I can't even connect back again. the error msg is 'localhost connection lost'

it happens a few times , and everytime i need to reboot the machine to get it working.
How come? BTW, i am using 4.1 alpha.

Another question, i tried to be patient and delete 5millions rows from the same table, it took about 4 mins to do it. BUt after the console told me it is done, I tried to look at the table status from the Mysql CC, i found that there are still a large number of rows in the table, and the "select count(*) "statement stills take a while to do it.

If i refresh in the mysql CC, the number of row keeps decreasing and after a while, it finally go to 1000 row(which is what I expected). But how can this happens?

I didn't experience such stuff in Oracle and MySQL. As the console told me it is done, it is done.

FYI, I tried the run the same select count(*) statement, it takes less and less time to run until the table is back to 1000 rows. It looks like that mysql is still deleting the rows after it tells me it is done...

MySQL Crashes When 98% Load On Server
When mysql load reaches 98% it's totaly hanged. MySQL is not sending any error messages to php and all website is down.

When i disconnect php from mysql it's not helping, all the time mysql is 98% and i need to kill the mysql process to get my website to work again.

Executing SQL Commands
I have just downloaded a php script which lists the last ten referrals to my site.

In the instructions there's two lines that reads...

1. -- Open sql.txt in the main Simple Referer folder.

2.-- Paste the contents into a tool that can execute SQL commands for your MySQL DB.

The problem i have is with #2. In the sense that i have no idea what to do! - Can anyone shed any light on this.

I do have phpMyAdmin if i can use that, but never having used it before.

Scheduling Executing
I'm looking for a GUI that is able to schedule executing batch files.
I have a .sql file that inserts records in the database. This should be done every day.
For instance Navicat is able of executing this sql-file, but it can't be scheduled to execute this (I think).

Executing Queries
I am pretty new to MySql so please bear with me. I was wondering if it is possible to format your queries as a url which can then be run through a web browser.
For example, lets say I have a string stored in a table is it possible to do something like this:

http://myHost/myDatabase/Select myColum from myTable

If that can be done will the result display on the screen?

CREATE INDEX Crashes Server (Lost Connection...)
I'm having trouble with a table I created quite a while ago and now want to add an index to. Here's what I get if I try to add an index on the host field of my table:

mysql> create index Index_host on uselog(host);
ERROR 2013 (HY000): Lost connection to MySQL server during query

Connection was lost because the server crashed. The Windows event log has an event that says "Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0017dc06."

I've also tried the allegedly identical "ALTER TABLE uselog ADD INDEX Index_host(host)", as well as trying to index a different column, all with the same outcome (server crash).

Thing is, I had no trouble adding an index to the same table a week or so ago. The table was smaller then (and had only one index), but even now, it's not very big by DB standards, so I can't imagine that's the problem.

(My table had ~900K rows earlier today, which I pruned down to 140K rows after my first failed attempt to add the index. Puny! Only 55MB data length, according to MySQL administrator.)

Error During Query Executing
Here's my QueryString

Quote:

SQL query:

UPDATE `modules` SET `module_title` = 'Diễn đÃ n' WHERE `module_id` =7

And received error message

Quote:

MySQL said: Documentation
#1406 - Data too long for column 'module_title' at row 1

My modules Table is using latin1_bin collation
and before time, it's work well with mySQL 4.

Executing Sql Scripts In Windows
I'm trying to run a simple sql script in the mysql command line client (batch mode will come later) for MySQL for Windows (version 5.0.17a-pro-nt).

I have my script (called test.sql) in a directory named "C:myscripts".

When i am at the command prompt, i type in the following
. 'C:/myscripts/test.sql';

I get the following error:
"Failed to open file ''C:/myscripts/test.sql';', error: 22

If I remove the quote marks and type:
. C:/myscripts/test.sql;

I get the same thing, except it says "error: 2".

So, my question is, how do i execute a sql script in the command line client, where I can specify the exact path of the script? Or do I have to place the script in a certain directory in order for the client to find it?

Executing Consecutive Multiple Statements
I'd like to execute 4 INSERT statements as a single query to the database, constructing a single string (in php), and executing a mysql_query with sql like this...

INSERT INTO users VALUES(NULL, 'steve', ...);
INSERT INTO users_groups VALUES((SELECT LAST_INSERT_ID()), 1);
INSERT INTO users_groups VALUES((SELECT LAST_INSERT_ID()), 2);
INSERT INTO users_groups VALUES((SELECT LAST_INSERT_ID()), 3);

In the final 3 statements (inserts into users_groups), the first field value must be the auto-increment value of the first insert statement (insert into users).

However, the users_groups table also uses an auto_increment value, and so will the final two calls to LAST_INSERT_ID() return the id of the last insert to the users_groups table? I can see this could be a problem.

If so, is there anyway to achieve what i'm trying to do without resorting to multiple queries? Something like setting a variable with the value of LAST_INSERT_ID() and then using that variable in the subsequent inserts?

Executing External Function In A Query?
I got the following task:

1. There is a column "country", containing country codes (like "uk", "us", etc.)
2. I need to sort the table according to FULL NAMES of countries, based on those country codes,

Example.

Table contains: ....

MyODBC 3.51 Executing Multiple SQL Statements
I am using MyODBC from VB and I want to submit a batch of insert statements
in one call from my App. This is more efficient than making multiple calls
from code because of the communication overhead.

If I send a batch multiple statements separated by ; or ; + newline I get
syntax errors pointing at the start of the next statement..
If I fire each statement one at a time with the ; at the end there's no
problem.

I cannot be the first person with this problem. Is it common practice to
make multiple calls from you application or is there a magic trick I am
missing? Code:

Executing Script From Command Line
I am trying to execute a script from the command line as follows;

c:program filesmysqlin>mysql -u root newsman < servers3.mysql

But this gives me the following error;

ERROR 1064 at line 3: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax
to use near '' at line 1

The script I am trying to use is as follows;

update servers;
set MaxConnections = 3 where ServerName = 'EasyNews';

update servers;
set MaxConnections = 3 where ServerName = 'UsenetServer';

update settings;
set SettingValue = 'Yes' where SettingName = 'UseProxy';

"Servers" is a valid field name, and "MaxCommections", "ServerName",
"SettingValue" and "SettingName" are all valid fieldnames.

What am I doing wrong?

Executing Script On Mysql Browser
I execute a script on the mysql browser by doing a file -> new script tab and pasting my script on the tab. Then I execute the script. Each line get executed twice.

Executing Java Methods From Database
I want to store particular algorithms written in Java into a database
(preferably MySQL) and then be able to accept values such as algorithm
type and parameters from a user (via JDBC) which will select the
algorithm from the database, excecute it and return the result. I
understand that MySQL does not support Java object types, so does
anybody have any suggestions on how I could implement this? Will I
need to compile the code and then store this into my database?

Beta Testers Wanted For New "blueshell Data Guy Professional"
We are seeking beta testers for our upcoming "blueshell Data Guy
Professional". This new application is an extension to our
award-winning universal database editor "blueshell Data Guy" (bDg)
valuable for database professionals like DBA's, developers etc.

Although bDg serves almost all databases, we're planning to focus the
beta on MS SQL Server, Oracle, MySQL, Sybase Anywhere, Advantage DB
Server, DB2 and Jet. Nevertheless, if you want to test it against any
other DBMS, please let us know.

These are the main features of bDg Professional:

- All features of bDg Standard like schema browsing using a tree view,
table view and edit, table design, import, export, desktop
connectivity etc. (See http://www.blueshell.com/Product.asp?Prod=bDg
for product details)

- "SQL Cook" to assist you in entering valid SQL statements (something
between Intellisense and a wizard)

- Design (edit) objects like stored procedures, functions, packages,
triggers and sequences

- Easy design of table relationship (foreign keys).

Batch Mode
I understand that to use batch mode it is necessary to put the commands you want to run into a file before telling MySQL to read its input from the file, but how do I create the file and what do I create it in? Also, I'm not really sure how you would then tell MySQL to read it.