Programming Bulls

Hi,

My mysql periodically restarts, and crash myisam tables.

I think that the tables are crashing because of the restart, but when i look in the mysql log there is no error message, only a record informing that the service restarted.

Is this normal?

What are the most common causes that lead the mysql restart?

Thanks

I have this script I made but I keep getting this error when i load the page:

Query failed: 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 'AND `new_topic` = 1 ORDER BY `post_date`' at line 1

My code for that part:

mysql_connect ($databaseip, $username, $password)

or die ("Couldn't connect to server");

mysql_select_db ($databasename)

or die ("Couldn't Select DB");

The documentation says to restart mysql, do this #/bin/mysqld_safe &

But when I do that, it says "A process already exists". Am I running it in the wrong place? What am I'm doing wrong? I'm running Fedora Core/CentOS.

I realize that I can run these commands:

# /etc/init.d/mysqld start

# /etc/init.d/mysqld stop

# /etc/init.d/mysqld restart

However, I want to restart using 'mysqld_safe &' because it restarts as a background process.

Any info is appreciated.

Hi all!

I am trying to connect to a remote MySQL database using VB.NET. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection. It is installed on my computer and on the IP I am trying to connect to.

The connection string that I am using is the following-

Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.2;Database=mydb;User=root; Password=;Option=3;

The error message that I get in VB not too intuitive - System.EventArgs

I am very much a newbie to mysql with php and I am having some difficulty figuring out how to do what I will describe below:

I am trying to do the following:

List the availability of a product in different states around the US by showing the state and then listing below it all the rows from the database that are in that state, then moving down to the next state and repeating the same procedure until everything has been exausted.

I can select a unique list of states by doing the following:

Hi all,

Can anyone help me with this error. Some how my privileges are being denied.

This is all new too me and I don't understand, please help!

Thank you,

David

The following returns a syntax error.

select cast(0 as double);

I need to work with scientific numbers, so conversion to a fixed-point decimal won't do.

Hi

im new user to mysql can anyone told me how could i activate InnoDB in mysql

i have tried a few examples in other posts but not working

sql generates error message :

#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

can anyone send me their my.cnf file so that i replace it with mine to activate InnoDB

plz help

i can provide my id if some wiling to help

thanks regards

kimi

I am trying to perform a left join on two tables ('hymnText' and 'subjectToEntry') using indexes, but the results are not what I'm expecting. I have added indexes to the 'number' field of both tables, yet according to the explain query below, all of the rows of 'subjectToEntry' are being scanned for each row in 'hymnText'. What I think I'm looking for is a type of 'ref' and a ref of 'hymnText.number' in the 'subjectToEntry' row in the explain query. Any suggestions on what to do would be appreciated. Thanks!

- Jon