MySQL Forums

Error in taking backup (no replies)

swapan paul — Mon, 23 Nov 2009 05:44:31 +0000

Hi,
While running /var/lib/mysql: mysqldump -u root -p dbname > dbname.sql

i am getting an error as follows :mysqldump: Got error: 23: Out of resources when opening file './dbname/11112007.MYD' (Errcode: 24) when using LOCK TABLES

Kindly help....

problem Installing 5.1.41 win32 msi (1 reply)

ethereal1m -- — Mon, 23 Nov 2009 06:00:28 +0000

Dear experts,
I have problem starting mysql service when it got freshly installed. It got stalled when it try to start the service during configuration process. What I did, I killed the process and repaired the installation and started the service manually using mysqld" --install command.

Then I started the service mannually from Windows XP service tool, which resulting a complain from windows that the service cannot be started.

What's going on here? what did I do wrong? Also I notice the data folder is not installed so I cannot see error log. I installed the data folder not in the default location though.

I saw recent bug list under installation category and seems that there are some existing bugs regarding this issue.

I also checked that Path env is correctly set. Also I installed it in admin account, so this should be a permission problem. I did integrity check, it was all ok.

Am I running into a bug or I miss something?
regards,
Joe

have problem in use mysql-proxy admin (no replies)

h ch — Mon, 23 Nov 2009 03:31:28 +0000

i installed lua ，and download mysql-proxy-0.7.2-linux-rhel5-x86-32bit.tar.gz
cp mysql-proxy to /usr/local,and i start mysql-proxy with follow command

mysql-proxy --proxy-read-only-backend-addresses=172.16.20.210:3306 --proxy-backend-addresses=172.16.1.19:3306 --admin-username=root --admin-password=12345 --admin-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua --proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua > /var/log/mysql-proxy/mysql-proxy.log &

and /usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua is the lua script that i download from http://forge.mysql.com/tools/tool.php?id=198 and when i login in the admin port use

mysql -uroot -p -h172.16.1.19 -P4041
Enter password: 12345
and still have problem in query

Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from backends;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT

why?,seems lack something

Do I need two diffrent db? (no replies)

Kenny Dee — Mon, 23 Nov 2009 01:52:29 +0000

I am a newbie and need to know how I should set-up my datbase. I have an exel database that I will be exporting to mysql, but do I combine my current database with a user db, Is it safe or can I do to seperate db to work with with each other?

My databse will consits of users with access to the db, and the other db is information about offenders currently in custody in a county jail assigned to the users...

Shifting select fields to columns in temporary table (3 replies)

Daniel Stolzberg — Mon, 23 Nov 2009 01:32:08 +0000

Hello,

I am trying to find a faster way to do the following.

I have a table which, for all intents and purposes, includes two fields: param_type and param_value.

There are several possible values for param_type and each one has a corresponding param_value. I would like to create a temporary table to insert a selection of the param_value in its own field.

for example:

param_table
---------------------------
|param_type |param_value |
---------------------------
|1 | 42 |
|3 | 0.24 |
|2 | 993 |
|1 | 86 |
|3 | 0.03 |
|2 | 1002 |
---------------------------

I would like to make a temporary table like the following

tmptbl
----------------------------------------
|field1 |field2 |field3 |
----------------------------------------
|42 |993 |0.24 |
|86 |1002 |0.03 |
----------------------------------------

Is this possible? I have tried using variables and insert them during the create temporary table definition, but I only retrieved one value for each variable.

Any help is greatly appreciated!

Thanks in advance,
-Dan

Build from source on OpenSolaris (no replies)

Tom Hanlon — Sun, 22 Nov 2009 22:54:25 +0000

I am trying to build on OpenSolaris, I need to compile a custom storage engine so using the prebuilt binary is not an option.

Questions:
Is the output I see in mysqlbug for the solaris binary the actual commands that where used to build the binary ?

So when I see for 5.1.41

/configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Server (GPL)' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--build=x86_64-pc-solaris2.10' '--with-mysqld-libs=-lmtmalloc' '--with-named-curses=-lcurses' '--with-pic' '--with-client-ldflags=-static' '--wi
th-mysqld-ldflags=-static' '--with-zlib-dir=bundled' '--with-big-tables' '--with-ssl' '--with-readline' '--with-embedded-server' '--with-partition' '--with-innodb' '--without-ndbcluster' '--wit
h-archive-storage-engine' '--with-blackhole-storage-engine' '--with-csv-storage-engine' '--without-example-storage-engine' '--with-federated-storage-engine' '--with-extra-charsets=complex' 'bui
ld_alias=x86_64-pc-solaris2.10' 'CC=/opt/studio12/SUNWspro/bin/cc' 'CFLAGS=-g -m64 -xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=generic' 'LDFLAGS=-R/usr
/lib/64 -R/lib/64 -L/usr/sfw/lib/64 -L/usr/lib/64 -L/lib/64' 'CXX=/opt/studio1 /SUNWspro/bin/CC' 'CXXFLAGS=-g -m64 -xO3 -mt -fsimple=1 -ftrap=%none -nofstore-xbuiltin=%all -features=no%except-xlibmil -xlibmopt -xtarget=generic'

That translates into:
LDFLAGS...., CXXFLAGS..... ./configure.....

Because when I try I get some errors regarding --with-innodb and others.

--
Tom

getConnection errors with "Can't load resource bundle" (no replies)

Christopher Fry — Sun, 22 Nov 2009 21:36:05 +0000

I've tried hard to follow the example for connecting to a db from Java on this website.
When I call getConnection, I get the error:
java.lang.ExceptionInInitializerError
cause: java.lang.RuntimeException: Can't load resource bundle due to underlying exception java.util.MissingResourceException: Can't find bundle for base name com.mysql.jdbc.LocalizedErrorMessages, locale en_US

I am Running Windows XP, mysql 5.1, using mysql-java-connector-5.1.10.
I can bring up the mysql console with username of "root" and password "".
I have the process running: mysqld.exe

Here's the Java code:
import java.sql.*;
public class LoadDriver {
private static Connection conn = null;
public static void main(String[] args){
try { Class.forName("com.mysql.jdbc.Driver").newInstance(); }
catch (Throwable lv_e) { System.out.println( "Problem with driver class: "); }
/*System.out.println("before getBundle");
java.util.Locale locale = new java.util.Locale("en", "US");
java.util.ResourceBundle.getBundle("com.mysql.jdbc.LocalizedErrorMessages", locale);
System.out.println("about to connect to server address:" + server_address);
*/
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" +
"user=root&password=");
}
catch (Throwable lv_e) {
System.out.println("In catch with lv_e:" + lv_e);
System.out.println("cause: " + lv_e.getCause());
System.out.println(lv_e.getMessage());
}
System.out.println("getConnection made:" + conn);
}
}
which results in the printout:

In catch with lv_e:java.lang.ExceptionInInitializerError
cause: java.lang.RuntimeException: Can't load resource bundle due to underlying exception java.util.MissingResourceException: Can't find bundle for base name com.mysql.jdbc.LocalizedErrorMessages, locale en_US
null
getConnection made:null

so its geting past the newInstance() call and erroring on the getConnection call.

You can see in the commented out region that I tried to do a getBundle()
but that didn't help matters. My computer has always been in the US so
I assume my default locale is en_US.

I am curious why the result of calling newInstance() isn't used in the
main example on this website.

{PS this website could be helped by having a working "search" function and
an entry typein that was wide enough to contain code about 50% wider than now.}

Thanks for any help!

MySQL Display Query Problem (no replies)

D A — Sun, 22 Nov 2009 21:02:36 +0000

I am having problems with displaying rows in php.. the script that i am using shows each row separately...(below is the script i am using)

//connect
mysql_connect("","","") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

//query the db
$getnews = mysql_query("SELECT * FROM shows ORDER BY id DESC") or die(mysql_error());

while ($row = mysql_fetch_assoc($getnews))
{

//get data
$id = $row['id'];
$venue = $row['venue'];
$date = date("m/d/Y", strtotime($row[date]));
$city = $row['city'];
$state = $row['state'];
$exceptions = $row['exceptions'];
$countries = $row['countries'];

echo "&theDates=$date|&theStates=$state|&theCities=$city|&theExceptions=$exceptions|&theClubs=$venue|&theIDs=$id|&theCountries=$countries|

";

}
?>

I am trying to get the result to show like for example

for $date to show just every date entered into the table and then $state to show every show entered into the table and so on...

no $date for only one date then on another line shows the another date...

if anyone could help me with this problem much thanks....

global transaction is not shared among branches!? (no replies)

Alexander Efremov — Sun, 22 Nov 2009 20:13:26 +0000

Hello,

Table1 is a master table.

Table2 has a foreign key on Table1.

The test inserts a row into Table1,
Then it tries to add a row into Table2 with foreign key to the row from Table1. But it gets blocked on a lock.

if instead of inserting a row into Table2 we tried to make a select from Table1 xaConn1 doesn't find the row inserted by xaConn0.

It seems that the transaction is not propagated to xaConn1. They are different branches with the same global transaction id.

Could someone explain me why?

I look for a way to share Transaction from different threads.
XAResource supports only one Active transaction branch. Obvious way to go with different resources.

sincerely,
alexander

MysqlXADataSource ds=new MysqlXADataSource();
ds.setUrl("jdbc:mysql://localhost:3306/test");
ds.setRollbackOnPooledClose(true);

Xid xid0 = new MysqlXid(XATest.class.getSimpleName().getBytes(),new byte[]{0},XATest.class.hashCode());
XAConnection xaConn0 = ((XADataSource)ds).getXAConnection("root","root");
XAResource res0=xaConn0.getXAResource();
res0.start(xid0,XAResource.TMNOFLAGS);
insertIntoTable1(xaConn0);
res0.end(xid0, XAResource.TMSUCCESS);

Xid xid1 = new MysqlXid(xid0.getGlobalTransactionId(),new byte[]{1},xid0.getFormatId());
XAConnection xaConn1 = ((XADataSource)ds).getXAConnection("root","root");
XAResource res1=xaConn1.getXAResource();
res1.start(xid1,XAResource.TMNOFLAGS);
insertInToTabel2(xaConn1);// BLOCKED HERE
res1.end(xid1, XAResource.TMSUCCESS);

res0.prepare(xid0);
res1.prepare(xid1);

res0.commit(xid0,false);
res1.commit(xid1,false);

xaConn0.close();
xaConn1.close();

Mysql Display (no replies)

D A — Sun, 22 Nov 2009 19:50:15 +0000

im having a problem displaying information from my column the way i want it displayed.( i justed started php three days ago so be patient with me)... here is my script im currently using then ill explain how i need it displayed

//connect
mysql_connect("","","") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

//query the db
$getnews = mysql_query("SELECT * FROM shows ORDER BY") or die(mysql_error());

while ($row = mysql_fetch_assoc($getnews))
{

//get data
$id = $row['id'];
$venue = $row['venue'];
$date = date("m/d/Y", strtotime($row[date]));
$city = $row['city'];
$state = $row['state'];
$exceptions = $row['exceptions'];
$countries = $row['countries'];

echo "&theDates=$date|&theStates=$state|&theCities=$city|&theExceptions=$exceptions|&theClubs=$venue|&theIDs=$id|&theCountries=$countries|
";

}
?>

i need to figure out how to have the rows displayed like this

&theDates=Datefirstrow|Datesecondrow|&theStates=statesfirstrow|statessecondrow|&theCities=citiesfirstrow|citessecondrow|&theExceptions=Exceptionsfirstrow|Exceptionssecondrow|&theClubs=Clubsfirstrow|Clubssecondrow|&theIDs=idfirstrow|idsecondrow|&theCountries=Countriesfirstrow|Countriessecondrow|

hopefully it is simple to due but i have been looking al over to figure it out and i cant..

Mysql Display (-1 replies)

D A — Sun, 22 Nov 2009 19:50:15 +0000

-- moved topic --

displaying mysql_fetch_array data in a html table (no replies)

Matthew Batt — Sun, 22 Nov 2009 17:42:29 +0000

hi

i want to display a picture gallery by using a html table. the image id's are located in a mysql database so i need to call them and display them in multiple rows of the table. i want to display 5 pictures per row but the code i've written (shown below) is showing only 1 picture per row.

$query = "SELECT id FROM dynamicImages ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());
while($input = mysql_fetch_array($result))
if(count($input)) { ?>

.jpg" border="0" alt=""/>

please can somebody help???!!!

ORDER BY LIMIT IS SLOW (no replies)

Mohamed el Maslouhi — Sun, 22 Nov 2009 16:32:33 +0000

Do you want more date time functions in reporting tool? (no replies)

David Becklery — Sun, 22 Nov 2009 16:19:10 +0000

Background
When designing a report, users often need a lot of date time functions. However, most reporting tools only provide some common functions as follows: functions today(), now() which are used to get current date or time, and functions year(), month(), day(), hour(), minute() or second() which are used to get corresponding year, month, day, hour, minute or second from a date time. In addition, there are some data type conversion functions, which are used to convert date time to string or convert string to date time.

However, that’s far from enough, as users may often have complex requirements like the ones below:
1. Calculate age accurately. Many reporting tools have no specialized function to do this. Some provide, but as the accuracy is only year or month, the result may be not exactly right. Take a child born in May 23, 2000 for example. He is only 7 years old, not 8 in May 20, 2008. It is easy to find that users can get the exactly right age only through a function with day accuracy.
2. Calculate the beginning or the end of a time period. With functions like weekbegin(), weekend(), monthbegin(), monthend(), yearbegin and yearend(), users can calculate the beginning or the ending of a week, a month or a year. Besides, calculating the beginning or the ending of a quarter is also very common. However, almost no reporting tool provides corresponding quarter functions.
3. Calculate the difference between two dates or two time points. For dates, users sometimes need to calculate the number of days between two dates, the date which is N days away from a specific date, or just last day, last month, last year and so on. The case for time point is similar. Requirements for these functions are common. However, most reporting tools neglect them. As a result, users have to write functions by themselves.

Solution
RAQ report is the best choice to solve these problems. For users’ convenience, RAQ Report provides much more date time functions specifically to meet users’ needs and wants.

stop duplicates with auto increment (no replies)

ana muslimon — Sun, 22 Nov 2009 15:26:58 +0000

I have simple mysql table : id [auto increment] - name - details

I want to stop duplicates records, but i can't do that

because when i insert new recrod (even with same old record), it takes new id , and then it become unique record

I wish i could explain my problem well

ex.
id name details
10 a abc
11 a abc

Thanks in advance

Select random rows, grouped by field (1 reply)

Dmitry Piramidin — Sun, 22 Nov 2009 15:04:08 +0000

If we have photoes in the table with the following structure:

| id | user_id | filename |

user_id - id of user, who this photo belongs to
filename - name of the photo

And the data is, for example,

1, 1, first.jpg
2, 3, img_356.jpg
3, 1, land.jpg
4, 2, fire.jpg
5, 3, cool.jpg
6, 3, img_018.jpg

Question: how can I retrieve a random photo for every user?
For example, the result is:
3, 1, land.jpg
4, 2, fire.jpg
5, 3, cool.jpg

Thanks in advance

Advice request - Migration from Access 2003 (no replies)

Paul Stephen — Sun, 22 Nov 2009 14:41:48 +0000

Hi,

We have an Access 2003 db at work which I have developed over the last 4 years but has grown to such a size that it's starting to develop problems; lockouts, crashes, corruption, vanishing records etc.

My thoughts are that we should change the backend to mySQL and keep the Access runtime front ends.

Now, knowing nothing about mySQL (yet) I'm a bit worried about messing the whole thing up. So I had a few questions:

1 - Can I migrate the backend access db to the mySQL server without damaging the original access backend? I'd like to do a trial period of the Access frontend with the mySQL backend on a test system without affecting the way the users are working just now i.e. allow them to keep using the Access backend for the moment.

2 - Does the Access db need to be unsplit first?

3 - Is it simple enough to link the tables from the Access FE to the mySQL BE after the migration is complete?

Thanks

Paul

external symbol error (no replies)

John Ken — Sun, 22 Nov 2009 12:27:34 +0000

Hello,

For the past few hour's, a friend and I have been messing around with a SQL databases. At this time I'm trying to connect to his database using the connector/C library provided here. But for the life of me can not figure out how to fix these external error's while I build my program in Visual Studio 08. Here are some of the error's that I am getting.

Main.obj : error LNK2019: unresolved external symbol _mysql_close@4 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_free_result@4 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_use_result@4 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_query@8 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_error@4 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function _main
Main.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _main

Thanks,
-John

Need help with SP (2 replies)

David Rippel — Sun, 22 Nov 2009 15:22:05 +0000

Hi,

I'm trying to create the following SP to fill a table with numbers from 1 to max_num:

DELIMITER $$

DROP PROCEDURE IF EXISTS `FILL_NUMBERS_TABLE` $$
CREATE PROCEDURE `FILL_NUMBERS_TABLE` (max_num INT)
BEGIN

# Delete existing content
DELETE FROM `numbers`;

# Fill with numbers
DECLARE counter INT DEFAULT 1;
WHILE counter <= max_num DO
INSERT INTO `numbers` (`number`) VALUES (counter);
SET counter = counter + 1;
END WHILE;

END $$

DELIMITER ;

The problem is that when I run this the SP doesn't get created. When I comment out the "delete" statement at the beginning the SP gets created fine.

Can someone tell me what's wrong with this SP? DO I have a syntax problem?

Thanks.

nach 2 werten sortieren (no replies)

kihoih nklnl — Sun, 22 Nov 2009 11:48:46 +0000

hallo

ich habe artikel die in kategorien eingeteilt sind und mit tags versehen wurden.

nun wollte ich diese metainformationen nutzen, um ähnliche artikel anzuzeigen
bei der sortierung soll die kategorie eine höhere priorität haben wie tags

d.h. zum beispiel als erstes sollen artikel angezeigt werden die
die selbe kategorie haben, 3 gleiche tags haben
die selbe kategorie haben, 2 gleiche tags haben
nicht die selbe kategorie haben, 3 gleiche tags haben
nicht die selbe kategorie haben, 2 gleiche tags haben

es sollen jedoch nicht artikel angezeigt werden die die selbe kategorie aber keine übereinstimmende tags haben

bei dem jetztigen script ist dies aber der fall. weiß einer wie ich das ändern kann?

SELECT
title_de,
tags.tag,
tags.uid,
archive.uid,
count(archive.uid) AS count,
archive.category
FROM
archive2tag AS a2t
RIGHT JOIN
archive ON archive.uid = a2t.archive_uid
LEFT JOIN
tags ON tags.uid = a2t.tag_uid
WHERE
archive.category = '" . $category . "' OR tags.uid IN ( '" . implode("', '", $tag_uid) . "' )
AND
archive.uid <> '" . $aid . "'
GROUP BY
archive.uid
ORDER BY
archive.category DESC, count DESC
LIMIT 10

Data Types (3 replies)

Arj Banner — Sun, 22 Nov 2009 16:26:48 +0000

What would be the correct data types for the following types of data (I have put what I think would be best)...

* A transaction date (e.g. 2009-10-29) = DATE
* A transaction number (e.g. 1, 2 or 10988) = INT w/ Auto Increment
* An accounting code (e.g. 1099) = CHAR(4)
* A transaction amount (e.g. $1000) = DECIMAL

Do these look like the right choices for the date to go in them, and the queries that would be asked of them, (e.g. accounting and bookkeeping type queries)?

Thanks in advance.

Urgent Requirement Of MYSQL DBA Professionals for Multinational Based out of Pune (no replies)

Anupreet Kaur — Sun, 22 Nov 2009 10:06:09 +0000

Hi,

We have an urgent requirement of MYSQL DBA Professionals having experience between 3-15 years in MYSQL Database administration .Requirement is for Fortify Infrastructure Services, Please go through website http://www.fortifyis.com/ and send across your resumes ASAP at anupreet@elitepractices.com

Person will require to join within 15 days and will have to travel to USA for 6 weeks.

Regards,

Anupreet

9810700440

anupreet@elitepractices.com

Urgent Requirement Of MYSQL DBA Professionals for Multinational Based out of Pune (-1 replies)

Anupreet Kaur — Sun, 22 Nov 2009 10:06:09 +0000

-- moved topic --

Search for the true master-master MySQL synchronization solution ... (no replies)

Pervasync Software — Sun, 22 Nov 2009 06:58:44 +0000

Following is a true story. For more information, visit www.pervasync.com.

“... is a cutting edge manufacturer of titanium products. At the center of our operation are MySQL databases that house the images, CAD files and other data for the 13,000+ products we produce.

Connected to the Internet is a high speed MySQL server that allows our sales reps, managers, factories and customers to both add and retrieve data via web browsers. Obviously, the data on this server is in a continuous state of flux.

For our home office, another MySQL server is connected to a local Intranet where the hi-resolution images, CAD files and other data created during product development are entered. The data on this server is accessed via both web browsers and Microsoft Access. The data is only in a state of flux during normal local office hours.

Some of our customers around the globe also operate Microsoft SQL servers and MySQL servers that connect via the internet to our 24/7 high speed server in order to continuously keep their data up to date.

As you can imagine, traditional database replication will not work in our business model because we are spread around the globe and there isn't a point in time where the data alterations can be halted. In effect, all of the servers in our architecture are masters because new data is being added and existing data is being updated at multiple locations simultaneously, so this precludes database replication as well.

Until we found Pervasync, synchronizing all of these servers was a phenomenal task fraught with both error and fear. We talked to provider after provider and all said the same thing, "Master - Master synchronization isn't feasible or practical." They recommended that we change our entire business structure to enable either the implementation of database replication or switch to using a single server.

Faced with a horrendous synchronization task every morning and night, we took a hard look at toning down our aggressive business model, but held our ground for three reasons:

First, speed. Trying to build a single database server at one location that can serve up to the entire world is expensive and no matter how fast or big it is, the data still has to flow around the globe, which means access to the system will be slow for some users, no matter what you do.

The second reason is redundancy, knowing that the data our entire company relies upon is duplicated securely at multiple locations with the sync frequency controlled by us allows me to sleep peacefully at night.

The final reason is customer service. Many of our customers already have database servers and for us to tell them that in order to do business with us they must create and maintain a new replicated MySQL database on their site (which they can't even enter data into) is totally unacceptable.

Many of the other synchronization software providers claim that their software will do Master - Master synchronization. Upon digging deeper (In some cases buying their software!), their idea of master - master synchronization was to compare rows and rows of changed data manually, choosing the data from the server that we wanted to sync to the other server in table-like forms.

One of the areas that is unusual in our system, compared to many others, is that we are storing hi-resolution images in our MySQL database that must be synced across the globe as well. This means that any synchronization software that relies on reading the data storage size in every column in order to determine what has changed will be incredibly slow, something we found out the hard way.

As far as we know at this time, Pervasync is the only true Master - Master synchronization system available for MySQL. Once set up and initially synced, it is blazingly fast. ..."

Words that start from A to M (3 replies)

Raymond Gonzalez — Sun, 22 Nov 2009 19:08:54 +0000

Hello, Im trying to create a query that will give me all the words that start from A to M. In my head this is what I think:

SELECT * FROM table
WHERE name BETWEEN LIKE 'A%' AND LIKE 'D%'
ORDER BY name ASC

But of course! it doesnt work! can somebody tell me what am I doing wrong?!

Could not create entity:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException (no replies)

thinh phan — Sun, 22 Nov 2009 02:09:31 +0000

Hello everybody,

Iam using MySQL 5.1, Jboss 4.2, MySQL connector/J 5.1.10, EJB 2.x(use CMP),
I have method:

public interface DoSomeThingHome extends EJBHome{

public DoSomeThing create(int shareDocId, String shareEmpId,
String shareByEmpId, boolean isDelete) throws CreateException,RemoteException;
}

When I call create method, I received error:
Could not create entity:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'SELECT SCOPE_IDENTITY()' at line 1

Why is SQL syntax ?

However, when I use SQL Server 2000, my create method executed very good.

Please help me.
Thank you very much.

Cannot edit My.ini File (2 replies)

Becky Laney — Sun, 22 Nov 2009 17:44:53 +0000

I am trying to edit the datadir in the mysqld section of the my.ini file. but When I try to save the file It says "access denied". I just need to change the directory to be set to a different folder any ideas?

Help to Create Trigger (1 reply)

Brett Allen — Sun, 22 Nov 2009 01:01:38 +0000

I need a MYSQL Trigger that will execute automatically, when a value is inserted into a specific table column a different table column is updated.

When a username and password are inserted into table "Users" i want a trigger to automatically add the same username and password to table "Users2"

Help to Create Trigger (-1 replies)

Brett Allen — Sun, 22 Nov 2009 01:01:38 +0000

-- moved topic --

How to debug rare MySQL crashes (1 reply)

Guillaume Boissiere — Mon, 23 Nov 2009 00:46:21 +0000

We are running MySQL 5.0.86 (RPM install) on our RHEL4 production server, and in the last couple of months, we have been experiencing a couple of crashes, where basically the server comes to a crawl and our website is no longer available. We connect to MySQL through PHP using ext/mysql with mysql_connect().

This is a dedicated MySQL server with 16GB of RAM, and pretty much nothing else runs on that box. When the crash happens, top output shows a high load average (10 vs. 0.1 in normal usage), the number of MySQL processes is very high, and the CPU utilization is high.

Because this is a production server and the crash happens rarely (once every few weeks), running MySQL in debug mode is not an option.

I have run mk-query-digest on the slow log, but did not notice anything out of the ordinary. show processlist does not show anything unusual either.

For reference, we run about 150 queries/s on that server, 80% selects, 20% updates, and the table sizes on our most used tables vary between 50,000 and 5 million.

My question is: next time we experience this problem, what commands should I run to try and narrow down the issue?
Thanks,

Guillaume